    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
• view complete results in the Gradebook and Mastery Dashboards
• automatically assign follow-up activities based on students’ scores
• assign as homework
• share a link with colleagues
• print as a bubble sheet
35 questions
• Q1
A formula that has at least two different mathematical operators is called what?
simple formula
function
complex formula
complex function
20s
Edit
Delete
• Q2
Multiple worksheets within one file are collectively called what?
excel
PDF
workbook
text
20s
Edit
Delete
• Q3
A formula that has just one mathematical operation is called what?
simple formula
operator
complex formula
function
20s
Edit
Delete
• Q4
A single sheet within a workbook that contains data
table
workbook
cell
worksheet
20s
Edit
Delete
• Q5
Cells labeled with numbers going down a worksheet are called what?
columns
charts
tables
rows
20s
Edit
Delete
• Q6
Cells labeled with letters that go across a worksheet are called what?
tables
charts
columns
rows
20s
Edit
Delete
• Q7
The location or name of the cell is called it's what? Example A2
column
row
workbook
20s
Edit
Delete
• Q8
This action allows you to temporarily hide data.
sparkline
sort
filter
cell range
20s
Edit
Delete
• 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
Edit
Delete
• Q10
Organizing data is called what?
functions
filtering
sorting
sparklines
20s
Edit
Delete
• Q11
A group of cells represented by a colon : is called what? Ex: A5:A8
function
absolute reference
cell range
sorting
20s
Edit
Delete
• 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
Edit
Delete
• Q13
Miniature charts inserted within just one cell are called what?
Sparklines
sortings
cell ranges
functions
20s
Edit
Delete
• 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
Edit
Delete
• Q15
Cells can only contain numbers
False
True
20s
Edit
Delete
• Q16
To select a group of cells, my cursor should look like a thin, back plus sign.
False
True
20s
Edit
Delete
• Q17
If #### appear in your cell after inserting a formula, your formula is incorrect.
True
False
20s
Edit
Delete
• Q18
Grouping worksheets allows a change on one sheet to appear on the other sheet.
False
True
20s
Edit
Delete
• Q19
False
True
20s
Edit
Delete
• Q20
I can only sort data alphabetically or numerically.
True
False
20s
Edit
Delete

Teachers give this quiz to your class