Have an account?
Skip to Content
Build your own quiz
30 questions
Show Answers
See Preview
- 1. Multiple Choice
An Excel ____ allows data to be summarized and charted easily.
worksheet
workflow
document
presentation
- 2. Multiple Choice
The first step in creating an effective worksheet is to make sure you ____.
apply font formatting
understand what is required
insert a chart
enter the data
- 3. Multiple Choice
____ is/are used to place worksheet, column, and row titles on a worksheet.
color
text
links
tabs
- 4. Multiple Choice
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoComplete
AutoCorrect
AutoFormat
AutoTyping
- 5. Multiple Choice
The range of cells receiving copied content is called the ____ area.
fill
range
location
paste
- 6. Multiple Choice
A ____ is a pre-written formula that is built into Excel.
function
feature
task
calculation
- 7. Multiple Choice
All of the following are valid Excel arithmetic operators EXCEPT ____.
^
*
%
>
- 8. Multiple Choice
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
placement
positioning
selection
- 9. Multiple Choice
Which of the following happens when you enter the formula =G15 into a cell?
Excel recalculates all formulas in the worksheet
Excel assigns the sum of the values in the previous 15 cells to the active cell
Excel assigns the value in cell G15 to the active cell
Nothing; =G15 is an invalid formula
- 10. Multiple Choice
You can click the ____ button to undo an automatic correction.
AutoFill Options
AutoCorrect Options
Paste Options
Trace Error
- 11. Multiple Choice
The ____ button lists error-checking options following the assignment of an invalid formula to a cell
Find Error
Explain Error
Fix Error
Trace Error
- 12. Multiple Choice
Cell references in a formula are called____?
assumptions
comments
numbers
content
- 13. Multiple Choice
The _________Auto Fill optionfills the destination area using the format of the source area; no content is filled.
Copy Cells
Fill Formatting Only
Fill Without Formatting
none of the above.
- 14. Multiple Choice
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Quarter 1
Qrt1
Qrt2
Quarter4
- 15. Multiple Choice
The Increase Indent button indents the contents of a cell to the right by ____ spaced each time you click it.
two
three
four
five
- 16. Multiple Choice
In the context of copy a range of cell to a nonadjacent location, an alternative to clicking the Paste button is the press the ____ key.
ENTER
ALT
CTRL
SHIFT
- 17. Multiple Choice
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.
#NULL!
#DIV/0!
#N/A
#REF!
- 18. Multiple Choice
You use a(n) ___ to automate data analysis.
data table
formula checker
amortization table
IF function
- 19. Multiple Choice
____ ensures that users do not change values inadvertently that are critical to the worksheet.
Cell protection
Range Finder
The formula checker
A data table
- 20. Multiple Choice
You can deselect multiple selected sheets beginning with Sheet 1 tab by pressing the ___ key and clicking the Sheet 1 tab.
ALT
CTRL
TAB
SHIFT
- 21. Multiple Choice
Which of the following is the path to the Name Manager button?
(FORMULAS TAB|Function Library group)
(FORMULAS TAB|Defined Names group)
(FORMULAS TAB|Names group)
(FORMULAS TAB| Calculation group)
- 22. Multiple Choice
The range of cells receiving the content of copied cells is called the ___.
receiver cell
final cell
receiving range
destination area
- 23. Multiple Choice
Names are ______ cell references.
absolute
mixed
relative
formatted
- 24. Multiple Choice
Which of the following is the path to the Financial button and the PMT function?
(FORMULAS tab | Function Library group)
(HOME tab | Formulas group)
(FORMULAS tab | Defined Names group)
(DATA tab | Function Library group)
- 25. Multiple Choice
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
summarization
consolidation
encapsulation
recapitulation
- 26. Multiple Choice
Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?
ALT+SHIFT+ASTERISK (*)
CTRL+SHIFT+ASTERISK (*)
TAB+SHIFT+ASTERISK (*)
SHIFT+HOME+ASTERISK (*)
- 27. Multiple Choice
The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.
linear
date
growth
fill
- 28. Multiple Choice
The following sequence, 2, 4, 6, etc., is an example of a ____ series.
linear
growth
fill
date
- 29. Multiple Choice
Which of the following is the path to the Fill button?
(FORMULAS tab | Fill group)
(HOME tab | Editing group)
(INSERT tab | Editing group)
(DATA tab | Fill group)
- 30. Multiple Choice
The path to the Sum button is ____.
Question options:
(Insert tab | Editing group)
(Home tab | Editing group)
(Data tab | Functions group)
(Editing tab | Calculations group)
- Answer choicesTagsAnswer choicesTags