NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets
Total questions: 27
Worksheet time: 40mins
Name
Class
Date
1.
What spreadsheet techniques allows us to update values in other worksheets automatically?
a)
Linking cells / worksheets
b)
Conditional formatting
c)
correct formatting of data types
2.
What value will this function produce if cell B3 = 62
=ROUNDUP(B3/40, 0)
=ROUNDUP(B3/40, 0)
a)
2
b)
1.5
c)
1.6
d)
1
3.
What function would allow us to display a message on the screen if a particular value was entered in a cell and a different message if that value was not entered
a)
IF
b)
SUM
c)
AVERAGE
d)
ROUNDUP
4.
A location on a spreadsheet that accepts a single item of data
a)
Chart
b)
row
c)
cell
d)
column
5.
A group of selected cells is called a
a)
field
b)
range
c)
row
d)
group
6.
A number format that adds a monetary symbol and decimal places. Appropriate when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
7.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
8.
Putting cells in order based on their contents is called..
a)
Sorting
b)
Filtering
c)
Numbering
d)
Identifying
9.
What function should be entered to calculate the total budget?
a)
=AVERAGE(B3:B6)
b)
=SUM(B3:B6)
c)
=SUM(B3-B6)
d)
=TOTAL(B3:B6)
10.
What is the operator symbol for in this formula? =E5*A2
a)
adding
b)
subtracting
c)
multiplying
d)
dividing
11.
An absolute reference is designated in the formula by
a)
( )
b)
{ }
c)
$
d)
[ ]
12.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
13.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
14.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
15.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
16.
Select ______________ from the functions drop-down menu to ADD a set of numbers.
a)
average
b)
count
c)
max
d)
sum
17.
This operator symbol is for what type of operation? /
a)
addition
b)
subtraction
c)
multiplication
d)
division
18.
Which of the following formulas includes an absolute cell reference?
a)
=B1/$B$25
b)
=B1/B25
c)
=B1*#B#25
d)
=AVERAGE(B1:B25)
19.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
20.
Which of the following is an INCORRECTLY typed formula?
a)
=A1/A6
b)
=8*4
c)
A1/A2=
d)
=SUM(A1:A4)
21.
$b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
22.
Which type of chart do we use if we want to display the contribution of each item to the total
a)
Line graph
b)
Pie chart
c)
Column chart
d)
Bar graph
23.
Which type of chart do we use if we want to display changes to values over a period of time
a)
Pie chart
b)
Bar graph
c)
Line graph
d)
Column chart
24.
Part of a pie chart that represents one value from the series.
a)
axis
b)
data
c)
slice
d)
chart
25.
This describes what is charted. It can be placed above or below the chart.
a)
Chart title
b)
chart area
c)
bar chart
d)
pie chart
26.
A visual representation of worksheet data.
a)
Column
b)
Data
c)
Chart
d)
Legend
27.
Type of graph that compares item quantities.
a)
pie graph
b)
table
c)
bar and column graph
d)
line graph
Reset
