NEW
Font size
S
M
L
XL
WorksheetsG5 Final 2 MS Excel Review
Total questions: 56
Worksheet time: 45mins
Name
Class
Date
1.
Columns go
a)
across
b)
diagonally
c)
up and down
2.
A column in a spreadsheet is designated by a
a)
picture
b)
letter
c)
number
3.
These go from side to side (horizontally)
a)
rows
b)
columns
c)
tables
4.
If something is in column B and row 5, what would it's cell address be?
a)
5B
b)
B5
c)
CBR5
5.
True of false: Spreadsheet columns may have titles to show what type of data they contain
a)
true
b)
false
6.
The small boxes on a spreadsheet are called
a)
cells
b)
boxes
c)
rows
d)
columns
7.
What is the cell address of fish?
a)
A3
b)
3D
c)
5C
d)
C5
8.
Which of these is a spreadsheet?
a)
b)
c)
9.
In what cell would you find the cost of the phone bill in February?
a)
C2
b)
C5
c)
1C
d)
A2
10.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
11.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
12.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
13.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
14.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
15.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
16.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
17.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
18.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
19.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
20.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
21.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
22.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
23.
You can present your data graphically, using a
a)
chart
b)
print
c)
font
d)
sort
24.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
25.
What Excel feature did we use to quickly apply this formatting feature?
a)
Data scenario formatting
b)
What-if analysis
c)
Conditional formatting
d)
PivotTables
26.
Changing the appearance of a cell based on a rule is called?
a)
Conditional Formatting
b)
Validation Formatting
c)
Filter Formatting
d)
Sort Formatting
27.
What is the name of a computer program used for organising information in rows and columns?
a)
Spreadsheet
b)
Presentation
c)
Publisher
d)
Browser
28.
Columns are identified using _______?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
29.
Rows are identified using ________?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
30.
In Excel, what do all formula begin with?
a)
!
b)
-
c)
+
d)
=
31.
Which formula is the correct for adding a column of values?
a)
SUM(E4:E10)
b)
=SUM(E4:E10)
c)
=AVG(E4:E10)
d)
=MAX(E4:E10)
32.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
33.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
34.
What do you call the box where a row and column intersect?
a)
Jail
b)
Gaol
c)
Cell
d)
Box
35.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
36.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
37.
What do all formulas begin with?
a)
%
b)
[ ]
c)
=
d)
:
38.
What symbol do we use for multiplication in a Spreadsheet program?
a)
/
b)
=
c)
^
d)
*
39.
What symbol do we use for addition in a Spreadsheet program?
a)
/
b)
+
c)
=
d)
*
40.
What symbol do we use for subtraction in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
-
41.
What symbol do we use for division in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
=
42.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
43.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
44.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
45.
Which of the following is a formula that will add cells C9 and C10?
a)
=C9+C10
b)
C9+C10
c)
=C9:C10
d)
=C9*C10
46.
Which of the following is a formula that will multiply cells A1 and A2?
a)
A1*A2
b)
=A1:A2
c)
=A1*A2
d)
=Multiply(A1:A2)
47.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
48.
Which of the following is a formula that will subtract cell B4 from cell B3?
a)
=3-4
b)
=B3-B4
c)
=B3*B4
d)
B3-B4
49.
Which of the following is a formula that will divide cell A10 by cell A1?
a)
=A10/A1
b)
=A1/A10
c)
=A10*A1
d)
=Divide(A10:A1)
50.
Which of the following is a correct example using the AUTOSUM function?
a)
sum(D14:D19)
b)
=D14:d19
c)
=sum(D14:D19)
d)
=D14+D15+D16+D17+D18+D19
51.
Which of the following is a correct example using the AUTOSUM function?
a)
=Sum(A1-A10)
b)
=Sum(A1:A10)
c)
=A1+A2+A3+...+A10
d)
=Sum(A1+A2+A3+...+A10)
52.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
53.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
54.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
55.
To show the quantities in particular categories use a?
a)
Column Chart
b)
Line Graph
c)
Scatter Graph
d)
Sort Chart
56.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
Reset
