How can we help?

You can also find more resources in our Help Center.

38 terms

Excel Test

STUDY
PLAY
To cancel an entire entry before entering it into the cell, press the ______ key
ESC
To enter a number as text, precede it with a(n)
Apostrophe (')
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Which of the following is the Ribbon path to the Cell Styles button?
(Home tab| Styles group)
What keyboard shortcut key(s) selects cell A1?
Control Home
How many chart types does Excel offer?
11
A(n) ____ chart is drawn on the same worksheet as the data.
Embedded
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
AutoCalculate
Which of the following keys is an alternative to double-clciking the cell to edit?
F2
Excel remembers the last ___ actions you have completed.
100
A ___ is a prewritten formula that is built into Excel.
function
When you enter a two-digit year that is less than 30, Excel changes the year to ___.
20xx
All of the following are valid Excel arithmetic operators except ___.
>
The ___ Options button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
You can select a range using the keyboard by pressing the ___ key and then an ARROW key.
F8
Excell automatically appends the ___ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
Right Parenthesis
Which of the following is the path to the Sum button?
(Home tab| Editing group)
You should ___ a function name in the Formula AutoComplete list to select the function.
double-click
Clicking the ___ opens the Insert Function dialog box.
Insert Function box on the formula bar
You can use the ___ to check which cells are referenced in the formula assignement to the active cell.
Range Finder
You can open the Format Cells dialog box by pressing the ___ keys.
CTRL + 1
The most popular background color is ___.
Blue
Which of the following is the path to the Conditional Formatting button?
(Home tab| Styles group)
If you do not assign a format to a cell or cells in a column, the column width will remain___ characters.
8.43
Cell references in a formula are called ___.
Assumptions
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ___ values.
constant
You can ensure correctness in your formulas by carefully checking them using ___.
Range Finder
___ test often provides a strong visual appeal.
Rotated
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ___.
Dialog box launcher
The ____ Auto Fill Options that fills the destination area using the format of the sourse area; no content is filled
Fill Formatting Only
Which of the following cell contents is extended to Qtr 3, Qtr 4 and Qtr1 by dragging the fill handle?
Qtr 2
The split double arrow mouse pointer ___.
is the result of moving the mouse pointer to the boundry between the column heading A and column heading B.
The Increase indent button indents the contents of a cell to the right by ___ spaces each time you click it.
3
An alternative to clicking the Paste button is to press the ___ key.
Enter
Which of the following path to the insert button?
(Home Tab| Cells Group)
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.
#REF!
You can press the ___ keys to open the Format Cells dialog box.
CRTL +1
___ the Format Painter button and then drag through the nonadjacent ranges to paing the formats to the ranges.
Double-click