FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

The equal sign (=)precedes a formula.

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

Clicking the Create Function box opens the Function Arguments dialog box.

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

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

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

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

A(n) ____ circular 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.

Which of the following happens when you enter the formula =G15 into a cell?

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

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

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

The Percent Style button instructs Excel to display a value as a percentage,determined by multiplying the cell entry by 100,rounding the result to the nearest percent,and adding a percent sign.

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

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

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

Which of the following Option buttons gives options for filling cells following a fill operation?

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

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

With the accounting number style,a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.