Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
|
A ____ is made up of two values and a relational operator.
|
condition
|
|
|
____ colors tend to pull away from your worksheet's reader.
|
Brighter
|
|
|
The ____ button lists formatting options following an insert of cells, rows, or columns.
|
Insert Options
|
|
|
To ensure that Excel interprets year values the way you intend, use ____.
|
four-digit years
|
|
|
The process of finding and correcting errors in a worksheet is called ____.
|
editing
|
|
|
To display additional decimal places in a cell, click the ____ button on the Ribbon
|
Increase Decimal
|
|
|
To determine the highest number in a range of numbers, click Insert Function box in the formula bar to display the Insert Function dialog box, then select ____.
|
MAX
|
|
|
In the formula: = A4 / B4 + C5 - D5 * E6 the ____ operation is performed first.
|
division
|
|
|
____ allows you to select cells for use in a formula by using the mouse.
|
Point mode
|
|
|
When Excel starts and the blank workbook displays on the screen, all of the columns have a default width of ____ characters in 11-point Calibri font
|
8.43
|
|
|
____ allows you to create or modify a worksheet while viewing how it will look in printed format.
|
Page Layout View
|
|
|
A blank cell in Excel has a numerical value of ____.
|
zero
|
|
|
zero
Every time you enter a value into a cell in the worksheet, Excel ____ all formulas. |
recalculates
|
|
|
The ____ version of a worksheet shows the results of formulas.
|
formulas
|
|
|
The ____ dollar sign displays to the far left in a cell
|
fixed
|
|
|
Use the ____ function to determine the lowest number in a range.
|
MIN
|
|
|
The formula ____ multiples the contents of cell B4 by 18.5.
|
18.5*B4
|
|
|
You can assign a ____ to a cell and Excel will calculate the result.
|
formula
|
|
|
Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?
|
Greater than
|
|
|
The default view for a worksheet is ____.
|
Normal View
|
