Excel Chapter 2

True or False: The equal sign (=) precedes a formula.

True

To start a new line in a cell, press the ______keys.

ALT+ENTER

True or False: An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

False

True or False: As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.

False

True or False: Best fit means that the width of the column will be increased or decreased by a percentage you specify.

False

True or False: The range automatically selected by Excel is always correct.

False

True or False: You cannot format an entire column at once.

False

True or False: The Accounting number format assigns a floating dollar sign.

False (fixed)

Which of the following is the path to the Comma Style button?

HOME tab/ Numbers Group

Which of the following is the path to the Conditional formatting button?

HOME tab/ Styles Group

Clicking the ______ opens the Insert Function Dialog Box.

Insert Function box in the formula bar

______ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Margins

________views shows the worksheet divide into pages as well as the header/ footer information.

PageLayout

______view allows you to create or worksheet while viewing how it will look in printed format.

PageLayout

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

average

An _______ reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

indirect

All of following are valid Excel arithmetic operators EXCEPT

side arrow

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

theme

A______ is a pre-written formula that is built into Excel

function

A______is text and graphics that print at the top of each page.

header

When Excel follows the order of operations, the formula, 8*3+2,equals_____?

26

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

8.43

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

Accounting number format

_____, means that the width of a column will be increased or decreased so the widest entry will fit in the column.

Best fit

______colors jump out of a dark background and are easiest to see.

Bright

The default view in Excel is called_______ view

Normal

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

True or False: Cooler colors tend to pull away from the reader.

True

True or False: Excel has more than 400 functions that perform just about every type of calculation you can imagine.

True

True or False: Moving from left to right, the first calculation in order of operations is negation(-).

True

True or False: Point mode allows you to select cells for use in a formula by using your finger or the pointer.

True

True or False: The AVERAGE function requires that the argument be included within parentheses following the function name.

True

True or False: The most common error when entering a formula is to reference the wrong cell in the formula.

True

True or False: To sum button menu allows you to enter one of five often-used functions easily into a cell.

True

A formula in a cell that contains a reference back to its self is called a

circular reference

The / arithmetic operator indicates____

division

The____is the small black square located in the lower-right corner of the heavy border around the active cell.

fill handle

A____ is text and graphics that print at the bottom of every page.

footer

One of the reasons Excel is such a valuable tool is that you can assign a(n) _____ to a cell, and Excel will calculate the result.

formula

The_____ function displays the highest value in the range.

max

The____ function determines the lowest number in a range.

min.

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

operations

Of warmer and cooler colors, the kind that tend to reach toward the reader are_____colors.

warmer