NEW
Font size
WorksheetsExcel Unit
Total questions: 14
Worksheet time: 7mins
Which of the following is NOT a spreadsheet program?
OpenOffice Calc
Google Sheets
Microsoft Excel
Google Slides
Which of the following file extensions is NOT commonly used for spreadsheets?
xls
xlsx
ods
What kind of character is found above each column and forms part of the address in Excel:
a shape
a letter
a comma
a number
Which spreadsheet feature will let you rapidly fill many cells with the same or automatically adjusted data?
Quick Fill
Auto-pour
Auto-type
Parallel Processing
How do you select multiple rows in a worksheet?
By selecting the rows while the Shift or Control key is pressed.
By selecting rows while the Enter button is pressed.
You cannot select multiple rows.
By selecting rows while the Esc button is pressed.
What does it mean to "freeze" a row or column?
This means you cannot change any information in that row or column.
This means you cannot delete this row or column.
You cannot freeze anything in a spreadsheet.
This makes sure that that column or row is always visible in the spread sheet.
What justification will place your data up against the right side of the cell?
Edge-Justified
Center-Justified
Left-Justified
Right-Justified
If you enter a monetary value in a cell, why might you want to apply the Currency format to that cell?
So the value will appear with a dollar sign or other national symbol
So you can use the value in calculations
To make the monetary value more accurate
To increase the value of the money
What feature would you use to locate and replace all occurrences of one value with another?
Find and Replace
Filtering
Lookup Tables
Sorting
If you wanted to sort data in reverse alphabetical order, which option would you choose?
Search Z to A
Filter A to Z
Sort Z to A
Sort A to Z
A cell in the third column and second row would have what address?
A3
C3
C2
B2
Which math operator is used to show multiplication in a spreadsheet formula?
Plus sign (+)
Slash (/)
Dash (-)
Asterisk (*)
Which of the following is a pre-built function that will perform a mathematical task or analyze data in most spreadsheets?
AVERAGE()
All of these are true
SUM()
COUNT()
When writing your own formula, what symbol do you use at the beginning of the formula?
Every formula starts with a different symbol
Plus sign (+)
Asterisk (*)
Equals sign (=)
