NEW
Font size
WorksheetsSpreadsheet Basics Post-test
Total questions: 20
Worksheet time: 8mins
A spreadsheet is also known as what?
A graph
Excel
A worksheet
A workbook contains one or more spreadsheets.
True
False
Why would you or your family use spreadsheets?
Balancing a checkbook
Calculating car loans
Household budgets
All of the above
A business would use a spreadsheet for payroll.
True
False
An individual location on a spreadsheet is known as what?
Column
Cell
Row
Columns are all of the content in a ___ range of cells.
Vertical
Horizontal
Vertical and horizontal
Columns are identified by what?
Letters of the alphabet
Numbers
Roman numerals
Rows are all of the content in a ___ range of cells.
Vertical
Horizontal
Vertical AND horizontal
Rows are identified by what?
Letters of the alphabet
Numbers
Roman numerals
The cell that is selected is known as what?
The active cell
The cell range
The row
The cell address is the combination of what two things?
column number and row number
column letter and row number
column number and row letter
What symbol do we use when writing a cell range?
Period .
Hyphen –
Colon :
What is written in cell D4?
4376
Doz
PDA
What is written in cell B3?
Ea
Quantity
Flash Drive
What is written in cell range E4:E7?
The item numbers
The quantities
The unit prices
What is written in row 1?
The title
The descriptions
The unit prices
What cell would I find the column heading Unit Price in?
B2
D3
E3
What cell would I find the description Scanner in?
A5
D6
E3
What is the cell range of the item numbers?
A4:A7
A4-A7
C3:C7
Which column will the amounts be typed in?
A
D
F
