Excel Ch. 2

¡Supera tus tareas y exámenes ahora con Quizwiz!

MIN

The ________ function determines the lowest number in a range.

>

________ is not a valid arithmetic operator.

blank

A ________ cell in Excel has a numerical value of zero.

theme

A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

function

A ________ is a prewritten formula that is built into Excel.

Auto Fill Options

Gives options for filling cells following a fill operation

=23%

Multiplies 23 by 0.01

(Home tab | Number group)

Path to the Comma Style button

(Home tab | Styles group)

Path to the Conditional Formatting button

(Review tab | Proofing group)

Path to the Spelling button

(Home tab | Editing group)

Path to the Sum button

(Home tab | Clipboard group)

Path to the copy and paste buttons

select cells for use in a formula using the mouse pointer

Point mode allows you to ________.

26

When Excel follows the order of operations, for formula, 8*3+2, equals ________.

operations

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ________ that you use in algebra.

CTRL+C

To copy cell contents, you can select the cell and the press the ________ keys.

Insert Function box on the formula bar

Clicking the ________ opens the Insert Function dialog box shown in the accompanying figure.

=G15

Excel assigns the value in cell G15 to the active cell.

right parenthesis

Excel automatically appends the ________ to complete the AVERAGE function with you click the Enter box or press the ENTER key.

CTRL+V

To paste copied cell contents, you can press the ________ keys.

Print Selection

To print a range of cells in the active worksheet, click ________ in the Settings area in the Print gallery, as shown in the accompanying figure.

ALT+ENTER

To start a new line in a cell, press the ________ keys.

AutoCorrect Options

You can click the ________ button to undo an automatic correction.

CTRL+1

You can open the Format Cells dialog box by pressing the ________ keys.

F8

You can select a range using the keyboard by pressing the ________ key and then an ARROW key.

Range Finder

You can use the ________ to check which cells are referenced in the formula assigned to the active cell.

double-click

You should ________ a function name in the Formula AutoComplete list to select the function.

Page Layout

________ view allows you to create or modify a worksheet while viewing how it will look in printed format.

8.43

If you do not assign a format to a cell or cells in a column, the column width will remain ________ characters.

fixed

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ________ dollar sign.

Formula

The ________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Insert

The ________ Option button lists formatting options following an insertion of cells, rows, or columns.

Trace Error

The ________ Options button lists error-checking options following the assignment of an invalid formula to a cell.

Accounting number format

The ________ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

MAX

The ________ function displays the highest value in a range.

AVERAGE

The ________ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

relative

The adjusted cell references in a copied and pasted formula are called ________ references.

blue

The most popular background color is ________.

0

When you decrease the row height to ________, the row is hidden.

20xx

When you enter a two-digit year that is less than 30, Excel changes the year to ________.


Conjuntos de estudio relacionados

g/r exam 3 - stages of pregnancy & fetal development

View Set

NASM - Chapter 5; End of Chapter Quiz

View Set

Chapter 18- Assessing mouth throat nose and sinuses

View Set

Finance 301 Module 2 Questions (OWL QUIZ 3+4 + Definitions)

View Set

AP Euro Final Exam Ch 20-25 McKay

View Set

18 -19. Overview of the Literary Prophets: Five Main Themes

View Set