NEW
Font size
S
M
L
XL
WorksheetsReview for Spreadsheet Test
Total questions: 23
Worksheet time: 27mins
Name
Class
Date
1.
How do you widen a COLUMN?
a)
Place your mouse between the 1 and 3 until you get the crosshairs, and drag your mouse
b)
Place your mouse between the 3 and 4 until you get the crosshairs, and drag your mouse
c)
Place your mouse between A and B until you get the crosshairs, and drag your mouse
d)
Place your mouse between the Title and the formula until you get the crosshairs, and drag your mouse
2.
Text in cells aligns at the left margin by default.
a)
True
b)
False
3.
One big advantage of spreadsheet software is that when a number is changed in the spreadsheet, all related "answers" are automatically recalculated
a)
True
b)
False
4.
You can copy a range of cells, but you cannot cut a range of cells.
a)
True
b)
False
5.
Spreadsheet data that is to be used in calculations must be entered as a
a)
Heading
b)
Label
c)
Range
d)
Value
6.
A group of related worksheets for a file called
a)
Worksheet tab
b)
Spreadsheet
c)
Workbook
d)
Cell
7.
The application and current worksheet name are displayed in the
a)
Bottom of the screen in the "Sheet" tab
b)
Title bar
c)
Status bar
d)
Cell reference box
8.
Which of the following type of chart always appears as an object within a worksheet?
a)
Pie chart
b)
Chart sheet
c)
Embedded chart
d)
Both b and c, but not A
9.
To multiply two cells, begin the formula with a
a)
Equal sign
b)
Parenthesis sign
c)
Apostrophe sign
d)
A comma
10.
Values that are to be used in formulas are aligned at the
a)
Left
b)
Right
c)
Center
d)
Anywhere
11.
If you were calculating the total sales at the concession stand from Friday nights ballgame, you would
a)
Add the number of hours by rate of pay
b)
Add the number of hours by number of hours
c)
Multiply the number of "Taco's in a Bag" sold by the price of each bag
d)
Multiply the number of "Taco's in a Bag" sold by the cost of each bag
12.
The ______ cell of a worksheet is the cell with the thick border around it; this is the cell in which information is entered.
a)
inactive
b)
data
c)
value
d)
active
13.
Remember to include _______ labels on a chart and _______ titles.
a)
axis; value
b)
value; axis
c)
data; axis
d)
value; data
14.
In a worksheet, you can create or edit text in the formula bar.
a)
True
b)
False
15.
In a worksheet, rows run vertically and are labeled with a letter, columns run horizontally and are labeled with a number.
a)
True
b)
False
16.
The cells on a spreadsheet are arranged in columns and rows in a ______ which is several sheets
a)
worksheet
b)
workbook
c)
data table
d)
chart
17.
Gridlines and row/column headings may or may not be printed on a spreadsheet.
a)
True
b)
False
18.
Which of the following best describes the GENERAL Format for numbers when entered in a spreadsheet
a)
Displays numbers with $, two decimall places, and a comma
b)
Displays numbers as keyed
c)
Displays numbers with a fixed number of places
d)
Multiplies numbers keyed by 100
19.
Always include the following on a chart:
a)
Title, color, values
b)
Title, data, labels, and charts
c)
Title, data labels rotated to fit the chart, axis titles
d)
Title, data labels, titles and totals
20.
I really like to use the spreadsheet because
a)
The answer will always be the same even if I change numbers
b)
The answer will change when I change numbers
c)
Nothing changes
21.
In the formula =AVG (B9:L25) - the range is
a)
B9 and L25
b)
B9 = L25
c)
B9 through L25
d)
AVG
22.
SUM is the
a)
range
b)
function
c)
label
d)
value
23.
It is not possible to rotate column headings or include links in your sheets.
a)
True
b)
False
Reset
