ITS Excel 2

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

to start a new line in a cell press the ____ keys

ALT+enter

the ___ autocomplete list contains those functions that alphabetically match the letters you type following the equal sign

Formula

which of the following is path to the comma style button

Home tab/ Number group

the ______ function displays the highest value in a range

Max

a company or department may standardize with a specific _____ so that all of their documents have a similar appearance

Theme

When you decrease the row height to____ the row is hidden

0

The_____ button lists error-checking options following the assignment of an invalid formula to a cell

Trace Error

You can click the _____ button to undo an automatic correction

Trace Error

which of the following is the path to the sum arrow

home tab/editing group

if you do not assign a format to a cell in a column, the column width will remain ______ characters

8.43

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

AVERAGE

the ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with the spaces between it and the first digit in the cell

Accounting number format

to copy cell contents you can select the cell and then press the ______ keys

CRTL+C

the default view in excel is called____ view

Normal

_____ views allows you to create or modify a worksheet while viewing how it will look in printed format

PAge Layout

you can use the ___ to check which cells are referenced in the formula assigned to the active cell

Range finder

the adjusted cell references in a copied and pasted formula are called _____ cell references

Relative

excel automatically appends the _____ to complete the average function when you click the enter box or press the enter key

Right Parenthesis

A _____ is a text and graphics that print at the bottom of every page

footer

which of the following is the path to the spelling button

review tab/proofing group


Ensembles d'études connexes

CH. 17 Maternal Newborn Transitioning PREP U

View Set

цивілочка модуль 2

View Set

Chapter 9 - Other Health Insurance Concepts

View Set

Finance Final (old exam questions)

View Set

Simulation Exam - Health Insurance

View Set