WorksheetsUnit 3: Post Test: Working with Spreadsheets
Total questions: 25
Worksheet time: 13mins
Name
Class
Date
1.
The vertical divisions in a spreadsheet is called a _______________.
a)
workbook
b)
column
c)
row
d)
cell
2.
Identify this type of chart.
a)
pie
b)
line
c)
scatter plot
d)
column
3.
True or False
Page orientation refers to wide and narrow.
a)
True
b)
False
4.
After highlighting and copying information, which of the following are ways to paste information from one location to another? Mark all that apply.
a)
Right click, select paste
b)
Press Ctrl and V keys at the same time
c)
Press Ctrl and C keys at the same time
5.
Which symbol should you use to enter a formula in a cell?
a)
+
b)
=
c)
*
d)
/
6.
Identify this type of chart.
a)
pie
b)
line
c)
scatter plot
d)
column
7.
True or False
Scale to fit refers to width and height.
a)
True
b)
False
8.
Sally needs to copy data from the first worksheet to the fifth worksheet in her workbook. Which combination of keys will she use to navigate between the worksheets?
a)
Alt and Page Down or Page Up keys
b)
Shift and Page Down or Page Up keys
c)
Ctrl and Page Up or Page Down keys
9.
Which formula shows an absolute value cell address?
a)
$E$4 + $E$5
b)
E4
c)
#G#7 + #G#8
d)
G7 + G8
10.
Which formula is the same as the function =SUM(B1:B5)?
a)
=B1+B5
b)
=B1+B2+B3+B4+B5
c)
=$B$1+$B$5
d)
=$B1+$B2+$B3+$B4+$B5
11.
Identify this type of chart.
a)
pie
b)
line
c)
scatter plot
d)
column
12.
Which function returns a valid value without any arguments? Mark all that apply.
a)
TODAY
b)
SQRT
c)
ROUND
d)
NOW
e)
COUNT
13.
True or False
Rows run left to right.
a)
True
b)
False
14.
You try to enter your name into a cell that accepts a numeric value. What error would you receive?
a)
#NAME
b)
#REF
c)
#####
d)
#VALUE
15.
Which spreadsheet function category uses Boolean operators?
a)
mathematical
b)
logical
c)
financial
d)
statistical
16.
True or False
Lily needs to arrange data in a spreadsheet in reverse chronological order. The sorting option will allow Lily to perform this task.
a)
True
b)
False
17.
Peter works on a huge database of numerical figures in a worksheet ranging from cell A1 to cell I50. He has to print the worksheet and carry it to a client meeting. Which options should he select to fit the page to a standard A4 page for printing?
a)
landscape and portrait page orientation
b)
left or right page orientation
c)
top and bottom page orientation
d)
horizontal or vertical page orientation
18.
Which columns and rows should Maria select to unhide or show the hidden column C and hidden row 6?
a)
E and F, 4 and 5
b)
B and D, 5 and 7
c)
C and E, 4 and 5
19.
True or False
The rank function will help to identify where each executive's score stands with respect to others.
a)
True
b)
False
20.
Nancy needs to find the average of two numbers in the middle from an even count of numbers arranged in descending order. Which statistical function should she use in the spreadsheet?
a)
Mode
b)
Rank
c)
Min
d)
Average
e)
Median
21.
Which type of graph or chart measures immediate or minute changes of an event and plots the points using two axis (x and y)?
a)
scatter plot graph
b)
column chart
c)
pie chart
22.
This function returns the current date.
a)
TODAY
b)
ROUND
c)
COUNT
23.
True or False
Columns run left to right.
a)
True
b)
False
24.
A _______________is the smallest unit of a spreadsheet, and it is formed by the intersection of a row and a column.
a)
now
b)
cell
c)
data
25.
A _________________ is a collection of two or more worksheets.
a)
column
b)
row
c)
cell
d)
workbook
100 %
