WorksheetsFall Semester Review Part 2
Total questions: 25
Worksheet time: 13mins
The default view in Excel is called ____ view.
Normal
Standard
Basic
Values
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Ribbon
Clipboard
Folder
File
Using the mouse to move or copy cells is called ____.
Drop and Drag
Drag and Drop
Drag and Copy
Drag and Paste
Which of the following formulas contains an absolute cell reference?
=$B4
=B$4
=$B$4
=B4
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
Section
Sparkline
Special
Sparkle
You should use a ____ chart to compare values side by side, broken down by category.
Column
Bar
Line
Clustered Column
Charts can either be embedded in a worksheet or placed in a separate ____
Worksheet
Dialog Box
Chart Sheet
Range
A character with a point size of 10 is about 10/72 of one inch in height.
True
False
Live preview is available on a touch screen
True
False
The most common error when entering a formula is to reference the wrong cell in the formula.
True
False
Excel has more than 400 functions that perform just about every type of calculation you can imagine.
True
False
You cannot format an entire column at once.
True
False
A date stamp shows the date a workbook, report, or other document was created or the time period it represents.
True
False
The underline format underlines the entire cell, not just the characters in the cell.
True
False
Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.
True
False
Clicking the ____ box completes an entry.
Cancel
Formulas
Enter
Tab
Combining two or more selected cells into one cell is called ____ cells.
Merging
Mixing
Combining
Spanning
The date you change a file is an example of a(n) ____ property.
Automatically Updated
Baseline
Standard
Indexed
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
ALT
ESC
CTRL
TAB
The ____ button allows you to erase recent cell entries.
Undo
Cell Style
Bold
Increase Decimal
All of the following are valid Excel arithmetic operators EXCEPT ____.
^
*
%
>
Which of the following calculations multiplies 23 by 0.01?
=23%
23
23+.01
=24-.01
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Function
Formula
Equal
Calculate
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
40
26
48
13
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
7.52
11.65
9.43
