Name:     ID: 
 
Email: 

Excel Test 3 - 65 Questions - Spring 2018

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 1. 

An Excel ____ allows data to be summarized and charted easily.
a.
worksheet
c.
document
b.
workflow
d.
presentation
 

 2. 

The first step in creating an effective worksheet is to make sure you ____.
a.
apply font formatting
c.
insert a chart
b.
understand what is required
d.
enter the data
 

 3. 

To enter data in a cell, you must first select the ____.
a.
row
c.
column
b.
worksheet
d.
cell
 

 4. 

____ is/are used to place worksheet, column, and row titles on a worksheet.
a.
Color
c.
Links
b.
Text
d.
Tabs
 

 5. 

Clicking the ____ box completes an entry.
a.
Cancel
c.
Enter
b.
Formula
d.
Tab
 

 6. 

The ____ is a blinking vertical line that indicates where the next typed character will appear.
a.
scroll box
c.
insertion point
b.
sheet tab
d.
split bar
 

 7. 

Pressing the ____ key to complete an entry activates the adjacent cell to the right.
a.
RIGHT ARROW
c.
UP ARROW
b.
LEFT ARROW
d.
DOWN ARROW
 

 8. 

By default, text is ____ in a cell.
a.
left-aligned
c.
justified
b.
centered
d.
right-aligned
 

 9. 

In Excel, a number can contain the characters ____.
a.
0 1 2 3 4 5 6 7 8 9
c.
. $ % E e
b.
+ - ( ) , /
d.
all of the above
 

 10. 

The range of cells receiving copied content is called the ____ area.
a.
fill
c.
location
b.
range
d.
paste
 
 
nar001-1.jpg
 

 11. 

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
a.
range
c.
nearby cell
b.
bunch
d.
neighbor
 

 12. 

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
a.
semi-colon (;)
c.
period (.)
b.
colon (:)
d.
none of the above
 

 13. 

A ____ reference is an adjusted cell reference in a copied and pasted formula.
a.
revised
c.
recycled
b.
relative
d.
retained
 

 14. 

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
a.
quotation mark (“)
c.
plus (+)
b.
colon (:)
d.
equal sign (=)
 

 15. 

Combining two or more selected cells into one cell is called ____ cells.
a.
merging
c.
combining
b.
mixing
d.
spanning
 

 16. 

What effect does the Accounting Number Format have on the selected cells?
a.
Converts alphabetic characters to numbers
b.
Displays cell contents with two decimal places that align vertically
c.
Performs tax calculations
d.
Copies the numbers of one cell to another
 

 17. 

What effect does the Comma Style format have on the selected cells?
a.
Converts decimals to commas within a cell
b.
Converts decimals to commas within merged cells
c.
Displays cell contents with two decimal places and commas as thousands separators
d.
Allows for substitution of selected characters
 

 18. 

Pressing the ____ keyboard shortcut key(s) selects cell A1.
a.
CTRL+HOME
c.
HOME
b.
CTRL+END
d.
END
 

 19. 

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
a.
exploded
c.
offset
b.
outer
d.
rasterized
 

 20. 

Which of the following keys moves the insertion point to the beginning of data in a cell?
a.
HOME
c.
INSERT
b.
ENTER
d.
TAB
 

 21. 

Press ____ to select the entire worksheet.
a.
F1
c.
ALT+A
b.
CTRL+A
d.
F4
 

 22. 

A ____ is a prewritten formula that is built into Excel.
a.
function
c.
task
b.
feature
d.
calculation
 

 23. 

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
c.
positioning
b.
operations
d.
selections
 

 24. 

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
a.
40
c.
48
b.
26
d.
13
 
 
nar004-1.jpg
 

 25. 

Point mode allows you to ____, as shown in the accompanying figure.
a.
select cells for use in a formula using the keyboard
b.
select a function from the Sum button list
c.
select cells for use in a formula using the mouse pointer
d.
edit cell contents directly in the cell
 

 26. 

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
a.
left parenthesis
c.
right parenthesis
b.
right bracket
d.
left bracket
 

 27. 

When you decrease the row height to ____, the row is hidden.
a.
0
c.
2
b.
1
d.
3
 

 28. 

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.
a.
45
c.
0
b.
90
d.
125
 

 29. 

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
a.
Quarter 1
c.
Qtr2
b.
Qtr1
d.
Quarter4
 

 30. 

Which of the following patterns extends the fill series to 575, 550, 525?
a.
650, 600
c.
560, 580
b.
625, 600
d.
500, 475
 

 31. 

Which of the following formulas contains an absolute cell reference?
a.
=$B4
c.
=$B$4
b.
=B$4
d.
=B4
 

 32. 

____ refers to cells not wide enough to display the entire entry.
a.
#####
c.
$$$$$
b.
&&&&&
d.
+++++
 

True/False
Indicate whether the statement is true or false.
 

 1. 

Worksheet titles and subtitles should be as wordy as possible.
 

 2. 

A thin red border indicates the active cell.
 

 3. 

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.
 

 4. 

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.
 

 5. 

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
 

 6. 

The equal sign (=) precedes a formula.
 

 7. 

The most common error when entering a formula is to reference the wrong cell in the formula.
 

 8. 

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
 

 9. 

Moving from left to right, the first calculation in the order of operations is negation (-).
 

 10. 

The range automatically selected by Excel is always correct.
 

 11. 

You cannot format an entire column at once.
 

 12. 

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.
 

 13. 

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.
 

 14. 

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.
 

 15. 

The <= comparison operator means less than or equal to.
 

Completion
Complete each statement.
 

 1. 

A(n) ____________________ conveys a visual representation of data.
 

 

 2. 

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.
 

 

 3. 

The active cell reference appears in the ____________________ on the left side of the formula bar.
 

 
 
nar002-1.jpg
 

 4. 

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the accompanying figure.
 

 

 5. 

Excel’s ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
 

 

 6. 

The default font for a new workbook is ____________________ 11-point regular black.
 

 

 7. 

____________________ cells involves creating a single cell by combining two or more selected cells.
 

 

 8. 

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.
 

 

 9. 

The / arithmetic operator indicates ____________________.
 

 

 10. 

The ____________________ is a small black square in the lower-right corner of the active cell or active range.
 

 

 11. 

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.
 

 

Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.
 

 1. 

The opposite of merging cells is splitting a merged cell. _________________________

 

 2. 

If you accidentally undo an action, you can use the Redo button to redo it. _________________________

 

 3. 

The Accounting number format assigns a floating dollar sign. _________________________

 

Multiple Response
Identify one or more choices that best complete the statement or answer the question.
 
 
Modified Multiple Choice
 

 1. 

The characters that Excel displays on the screen are a specific ____.
 a.
font
 c.
size
 b.
style
 d.
color
 

 2. 

A ____ is information that exists on a physical medium such as paper.
 a.
hard copy
 c.
validation
 b.
column
 d.
printout
 

 3. 

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?
 a.
Wednesday
 c.
Saturday
 b.
Thursday
 d.
Monday
 

 4. 

Which of the following are formatting symbols?
 a.
Dollar sign ($)
 c.
Pound sign (#)
 b.
Comma (,)
 d.
Percent sign (%)
 



 
         Start Over