WorksheetsComputer Apps 2 Block 1 Exam Review
Total questions: 35
Worksheet time: 13mins
Name
Class
Date
1.
An Excel ____ allows data to be summarized and charted easily.
a)
worksheet
b)
workflow
c)
document
d)
presentation
2.
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
a)
exploded
b)
outer
c)
offset
d)
rasterized
3.
How many chart types does Excel offer?
a)
5
b)
15
c)
30
d)
50
4.
Combining two or more selected cells into one cell is called ____ cells.
a)
merging
b)
mixing
c)
combining
d)
spanning
5.
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
a)
AutoFormat
b)
AutoComplete
c)
AutoFunction
d)
AutoCalculate
6.
The person or persons requesting the worksheet should supply their requirements in a ____ document.
a)
blank
b)
test issues
c)
requirements
d)
certified
7.
The range of cells receiving copied content is called the ____ area.
a)
fill
b)
range
c)
location
d)
paste
8.
A thin red border indicates the active cell.
a)
true
b)
false
9.
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.
a)
true
b)
false
10.
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
a)
save
b)
print
c)
format
d)
clear
11.
A ____ is a prewritten formula that is built into Excel.
a)
function
b)
feature
c)
task
d)
calculation
12.
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
a)
placement
b)
operations
c)
positioning
d)
selections
13.
Which of the following happens when you enter the formula =G15 into a cell?
a)
Excel recalculates all formulas in the worksheet
b)
Excel assigns the sum of the values in the previous 15 cells to the active cell
c)
Excel assigns the value in cell G15 to the active cell
d)
Nothing; =G15 is an invalid formula
14.
The adjusted cell references in a copied and pasted formula are called ____ cell references.
a)
related
b)
relative
c)
pasted
d)
alternative
15.
The ____ function displays the highest value in a range.
a)
MIN
b)
SUM
c)
MAX
d)
AVERAGE
16.
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
a)
DIVSUM
b)
RANGEAVG
c)
AVERAGE
d)
MAX
17.
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
a)
Comma style format
b)
Accounting number format
c)
Percent style format
d)
Currency style format
18.
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
a)
Normal
b)
Page Layout
c)
Page Break Preview
d)
Full Screen
19.
The equal sign (=) precedes a formula.
a)
true
b)
false
20.
The most common error when entering a formula is to reference the wrong cell in the formula.
a)
true
b)
false
21.
The range automatically selected by Excel is always correct.
a)
true
b)
false
22.
Cell references in a formula are called ____.
a)
assumptions
b)
comments
c)
numbers
d)
content
23.
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer’s memory.
a)
Ribbon
b)
Clipboard
c)
Folder
d)
File
24.
Using the mouse to move or copy cells is called ____.
a)
drop and drag
b)
drag and drop
c)
drag and copy
d)
drag and paste
25.
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
a)
#NULL!
b)
#DIV/0!
c)
#N/A
d)
#REF!
26.
Which of the following formulas contains an absolute cell reference?
a)
=$B4
b)
=B$4
c)
=$B$4
d)
=B4
27.
The ____ function is useful when you want to assign a value to a cell based on a logical test.
a)
IF
b)
NOW
c)
AND
d)
OR
28.
Charts can either be embedded in a worksheet or placed in a separate ____.
a)
worksheet
b)
dialog box
c)
chart sheet
d)
range
29.
Excel includes four types of sparkline charts: line, column, win/loss, and stock.
a)
true
b)
false
30.
A date stamp shows the date a workbook, report, or other document was created or the time period it represents.
a)
true
b)
false
31.
A(n) ___ shows the beginning and ending balances and the amount of payment that is applied to the principal & interest during each payment period.
a)
dialog box
b)
amortization schedule
c)
formula checker
d)
data table
32.
___ ensures that users do not change values inadvertently that are critical to the worksheet.
a)
Cell protection
b)
Range Finder
c)
The formula checker
d)
A data table
33.
___ examines the formulas in a workbook in a manner similar to how spell checker looks for misspelled words.
a)
The Range Finder
b)
The formula checker
c)
A data table
d)
An amortization schedule
34.
Which of the following is the maximum number of active data tables per worksheet?
a)
5
b)
20
c)
50
d)
As many as you want
35.
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ___.
a)
locked
b)
indexed
c)
unprotected
d)
hybrid
100 %
