Microsoft Excel Review

QuizÂ by Sheryl Avery

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

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

35 questions
• Q1
A formula that has at least two different mathematical operators is called what?
simple formula
function
complex formula
complex function
20s
• Q2
Multiple worksheets within one file are collectively called what?
excel
PDF
workbook
text
20s
• Q3
A formula that has just one mathematical operation is called what?
simple formula
operator
complex formula
function
20s
• Q4
A single sheet within a workbook that contains data
table
workbook
cell
worksheet
20s
• Q5
Cells labeled with numbers going down a worksheet are called what?
columns
charts
tables
rows
20s
• Q6
Cells labeled with letters that go across a worksheet are called what?
tables
charts
columns
rows
20s
• Q7
The location or name of the cell is called it's what? Example A2
column
row
workbook
20s
• Q8
This action allows you to temporarily hide data.
sparkline
sort
filter
cell range
20s
• Q9
A reference that used a particular cell over and over again as opposed to changing the cells relative to the position of the formula is what type of reference?
Absolute reference
relative reference
simple reference
cell reference
20s
• Q10
Organizing data is called what?
functions
filtering
sorting
sparklines
20s
• Q11
A group of cells represented by a colon : is called what? Ex: A5:A8
function
absolute reference
cell range
sorting
20s
• Q12
Changing the formula based on a cell's relative position within the worksheet when copying a formula across cells is what type of reference?
absolute reference
sparklines
relative reference
cell ranges
20s
• Q13
Miniature charts inserted within just one cell are called what?
Sparklines
sortings
cell ranges
functions
20s
• Q14
A predefined formula used to calculate data where you don't need to use any mathematical operator signs.
cell ranges
simple formula
Function
complex formula
20s
• Q15
Cells can only contain numbers
False
True
20s

Teachers give this quiz to your class