NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets Quiz Prep
Total questions: 16
Worksheet time: 8mins
Name
Class
Date
1.
What symbol would I use to turn a cell reference into an "Absolute Cell Reference"?
a)
#
b)
@
c)
!
d)
$
2.
What symbol would I use to multiply (times) in a spreadsheet?
a)
/
b)
*
c)
x
d)
+
3.
What symbol would I use to get a SUM in a spreadsheet?
a)
/
b)
*
c)
x
d)
+
4.
What symbol would I use to divide in a spreadsheet?
a)
/
b)
*
c)
x
d)
+
5.
What symbol would I use to tell the computer that I want to start a formula (calculator mode) in a spreadsheet?
a)
%
b)
#
c)
=
d)
&
6.
This contains drop-down menus. Its primary function is to show window-specific menus. What am I?
a)
Formula Bar
b)
Spacing Bar
c)
Tool Bar
d)
Menu Bar
7.
For the contents of the active cell...this is where the formula is shown...the answer (value) is displayed on the spreadsheet
a)
Formula Bar
b)
Menu Bar
c)
Space Bar
d)
Tool Bar
8.
This runs horizontally on a spreadsheet (labeled with Numbers): _____________
a)
Columns
b)
Rows
c)
Tables
d)
Cells
9.
This runs Vertically on a spreadsheet (labeled with Letters): _____________
a)
Columns
b)
Rows
c)
Tables
d)
Cells
10.
If the active cell is Z99, what is the quickest way to get back to cell A1?
a)
Press CTRL+Home
b)
Use any shortcut
c)
Use the mouse and scroll bars
d)
Use the Arrow Key on the Keyboard
11.
What is a worksheet?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
12.
What is a Data?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
13.
What is a Spreadsheet?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
14.
I can use scroll bars to move
a)
Up and down, but NOT left or Right
b)
Up and down, AND Left or Right
c)
Left or Right, but NOT Up or Down
d)
None of these
15.
How can you make a cell the "Active Cell"
a)
Click on it
b)
Use the arrow keys to move to it
c)
Use PageUp or scroll bars with the arrow keys and/or click on it to select a cell
d)
All of these could work
16.
What bar would I use to change the formatting (color, fill, borders) of a cell with the fewest clicks?
a)
Formula Bar
b)
Tool Bar
c)
Menu Bar
d)
Tab Bar
Reset
