Computer Literacy Test - Part 3
Spreadsheets
1. What is a spreadsheet?
Accounting
Format
Budget
A large piece of paper
2. What is the format of a spreadsheet?
Square
Rows and Columns
Round
Wide
3. Where a row and a column meet, what do we call that?
Cell
Formula
Intersection
Joint
4. How do we tell one cell from another?
Looks
Address
Sign
Code
5. Which one is a spreadsheet address?
10700 - 104 Ave.
6A
B3
None of the above
6. If this, ( March ) were in cell "A1", what might we call it?
Month
Date
Label
none of the above
7. If this, ( 256 ) were in cell "B1", what might we call it?
Byte
FF
Number
Value
8. If this, ( =G6*H6 ) were in cell "A1", what might we call it?
Basic
Programming
Formula
Code
9. If this, ( SUM(B2:B5 ) were in cell "A1", what might we call it?
Label
Value
Function
Formula
10. How big can a spreadsheet be?
100 by 1000
10 by 50
1000 by 1000
All of the above
11. Which is an absolute address?
$C$4
C4
10700 - 105 Ave.
None of the above
12. Which one is a relative address?
$C$4
C4
256
None of the above