NEW
Font size
S
M
L
XL
WorksheetsComputer Apps- Excel Review
Total questions: 30
Worksheet time: 47mins
Name
Class
Date
1.
A prewritten formula built into Excel
a)
Function
b)
Formula
c)
Operation
d)
Cell
2.
The start of any formula or function
a)
=
b)
*
c)
cell reference
d)
/
3.
$b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
4.
b17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
5.
$b17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
6.
b$17 is what type of reference?
a)
absolute
b)
relative
c)
mixed varying column
d)
mixed varying row
7.
A1:G5 is a
a)
range
b)
formula
c)
chart
d)
function
8.
A predefined set of colors, fonts, fills, etc. for an entire workbook
a)
theme
b)
cell style
c)
conditional formatting
d)
font
9.
Press this when you are done entering a function or formula
a)
enter
b)
backspace
c)
tab
d)
shift
10.
Excel displays this when the cell is not wide enough
a)
ERROR
b)
!INVALID!
c)
######
d)
#REF!
11.
This allows me to quickly copy functions/formulas.
a)
Tab
b)
Fill Handler
c)
Auto Sum
d)
NOW( )
12.
The first order of operation
a)
( )
b)
/
c)
^
d)
+
13.
This function finds the lowest number
a)
=MAX( )
b)
=MIN ( )
c)
=LOW ( )
d)
=SUM ( )
14.
Double-clicking between rows or columns will
a)
Autofit cells
b)
Highlight cells
c)
Fill cells
d)
Do nothing
15.
In the formula =A4*B2^3-F14, which operation is done first?
a)
*
b)
^
c)
-
d)
+
16.
Formatting that appears only when the cell value meets certain terms you specify.
a)
style
b)
conditional
c)
specific
d)
custom
17.
The formula that multiplies the contents of cell B4 by 18.5
a)
18.5*b4
b)
=18.5*b4
c)
18.5*b4=
d)
18.5(b4)
18.
12 + B5= ?
a)
5
b)
10
c)
22
d)
19
19.
B2*B4=?
a)
10
b)
12
c)
20
d)
79
20.
B2+B3+B4+B5=
a)
5
b)
11
c)
55
d)
22
21.
=Sum(A5:A10)
a)
Formula
b)
Function
22.
What is it called when you combine two or more cells in to one?
a)
Merge
b)
Combine
c)
Join
d)
Union
23.
This formatting option changes the way data appears in a cell. (Often used for dates, percentages, time, etc.)
a)
Number formats
b)
Cell Style
c)
Cell Shading
d)
Borders
24.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
25.
The horizontal placement of cells in a table or worksheet.
a)
range
b)
row
c)
column
d)
cell
26.
What function adds all of the numbers in a range of cells?
a)
Difference
b)
Sum
c)
Average
27.
Can be used to move from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
28.
Which letter on the image is a Column?
a)
A
b)
B
c)
C
d)
D
29.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
30.
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
Reset
