# ASSOC 2022 20Q Excel Quiz

## Quiz by Esan Hasan

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet

- Q1
**What error will appear when we try to take the 4th root of a negative number?****####****#VALUE!****#DIV/0!****#NUM!**30s - Q2
**Which ribbon should be used to assign colour scale to a set of data?****Theme****Conditional Formatting****Home****View**30s - Q3
**Which of the following is not an excel function?****=MID****=MODE****=MEAN****=MEDIAN**30s - Q4
**If the contents of ‘C2’ were transferred to cell ‘C9’ what will be the result****#NUM!****#DIV/0!****15.983684****29.768186**30s - Q5
**Who created Microsoft Excel?****Bill Gates****Marshall Bruce Mathers III****Charles Simonyi****Dan Bricklin**30s - Q6
**What is the result of the formula “=RIGHT(“Actuarial Studies”,6)” ?****“t”****“udies”****“Actuar”****“tudies”**30s - Q7
**What is the name of the next column after column “Z”?****“AA”****“Z2”****“A1”****“2A”**30s - Q8
**RAND is a function in excel that generates an evenly distributed random real number. What is the range of this function?****0 to π****0 to 1****0 to 100****-100 to 100**30s - Q9
**How many rows are in a spreadsheet?****3327908****1048576****2376861720****255**30s - Q10
**What does the function VLOOKUP mean?****Venue Lookup****Value Lookup****Velocity Lookup**Vertical Lookup

30s - Q11
**Which option changes the styles of the cells?****A****C****D****B**30s - Q12
**How many columns are there in a spreadsheet?****26****52****16384****1048576**30s - Q13
What type of file is

**a MS excel spreadsheet?****Article****Presentation****Document****Workbook**30s - Q14
**What is the intersection of a column and row?****Content****Cell****Block****Chamber**30s - Q15
**To use a function in Excel, use the symbol****=****<****=>****?**30s