WorksheetsBasic Excel Review
Total questions: 15
Worksheet time: 8mins
Every worksheet is made up of boxes called?
spaces
cells
shapes
boxes
Columns are labeled with _____.
letters
numbers
If you wanted to add a chart or picture to your spreadsheet, what tab do you select on the ribbon?
Home
Insert
Formulas
Data
All formulas must start with what?
Function
Minus symbol (-)
Equals Sign (=)
Parentheses ( )
What function do you use to add values in cells together?
TOTAL
SUM
ADD
CONCAT
What is the name of a cursor that looks like this?
Select Handle
Pointer
Fill Handle
When an object (table, picture, chart) is selected, what happens?
A contextual tab appears.
It lights up.
The cursor turns red.
All of the above
How do you adjust the column width in Excel?
Right-click on the column and select Column Width
Use the contextual tab.
Select the column and press the Enter key
What is this icon called and what does it do?
Font Brush - changes the color of the selected font
Autosum - totals the selection.
Format Painter - formats the cell based on a selection.
All of the above
How do you view formulas in a worksheet?
Press CTRL + \
Press CTRL + `
Press ALT + ENTER
Press CTRL + F
=D5*E5
What does this formula do?
Multiplies 5 times 5
Adds the value in D5 to the value in E5.
Multiplies the value in D5 by the value in E5.
Sums the cells
What does the colon (:) mean?
And
Or
Through
Divide
These cells have what type of formatting applied?
background fill
cell style
conditional
number
What is the benefit of changing ranges to tables in excel?
Easily sort columns
Easily filter data
Easily remove duplicates
All of the above
Bonus: How many rows of data can you have in Excel?
1,048
10,048
1,048,576
infinite number
