Practice Test
Project 2
INSTRUCTIONS:
Answer each question below. Enter your name and click the 'Grade Test' button to receive a graded study guide. You will not get a grade until all questions are answered.
1.
The ____ button gives options for how to fill cells following a fill operation.
A:
Insert Options
B:
Auto Fill Options
C:
Auto Sum
D:
Format Fill
2.
Use the ____ function to determine the lowest number in a range.
A:
Range Finder
B:
SEARCH
C:
MIN
D:
FIND
3.
____ allows you to create or modify a worksheet while viewing how it will look in printed format.
A:
Normal View
B:
Page Layout View
C:
Print Preview
D:
Review
4.
To display additional decimal places in a cell, click the ____ button on the Ribbon.
A:
Increase Decimal
B:
Decrease Decimal
C:
Increase Indent
D:
Decrease Indent
5.
A ____ is made up of two values and a relational operator.
A:
formula
B:
condition
C:
function
D:
command
6.
____ cells is a technique you can use to hide data that might be sensitive or not relevant to a report.
A:
Securing
B:
Formatting
C:
Hiding
D:
Shadowing
7.
Worksheet names can be up to ____ characters.
A:
15
B:
31
C:
52
D:
256
8.
You can assign a ____ to a cell and Excel will calculate the result.
A:
formula
B:
reference
C:
value
D:
micro
9.
Every time you enter a value into a cell in the worksheet, Excel ____ all formulas.
A:
recalculates
B:
cancels
C:
highlights
D:
displays
10.
In the formula: = A4 / B4 + C5 - D5 * E6 the ____ operation is performed first.
A:
multiplication
B:
division
C:
addition
D:
exponentiation
11.
The ____ button lists formatting options following an insert of cells, rows, or columns.
A:
Insert Options
B:
Format Options
C:
Formatting
D:
Add Cell
12.
The ____ function displays the highest value in a range.
A:
AVERAGE
B:
MAX
C:
MIN
D:
SUM
13.
____ colors tend to reach towards your worksheet's reader.
A:
Cooler
B:
Darker
C:
Warmer
D:
Brighter
14.
To center data in a cell, click the ____ button on the Ribbon.
A:
Move
B:
Align
C:
Center
D:
Best Fit
15.
The Percent style button on the Formatting toolbar is used to display a value determined by multiplying the cell entry by ____, rounding the result to the nearest percent, and adding a percent sign.
A:
2
B:
100
C:
10
D:
.10
16.
A dot on the screen that contains color is called a ____.
A:
font
B:
pixel
C:
character
D:
point
17.
The ____ version of a worksheet shows the actual formulas.
A:
results
B:
values
C:
formulas
D:
working
18.
A(n) ____ takes a value or values, performs an operation, and returns a result to the cell.
A:
operation
B:
cell
C:
function
D:
argument
19.
The arithmetic operator for multiplication is ____.
A:
%
B:
*
C:
x
D:
^
20.
A ____ is a predefined set of colors, fonts, cell styles, and fill effects that can be applied to an entire workbook.
A:
theme
B:
function
C:
condition
D:
definition
Enter your name and click the 'Grade Test' button.