FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Excel_Module_2

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) scheme
B) gallery
C) theme
D) style

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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

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.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

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

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

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

You cannot format an entire column at once.

Which of the following calculations multiplies 23 by 0.01?

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.

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

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

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

You can use the arrow keys to complete an entry in Point mode.

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

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

The / arithmetic operator indicates ____________________.

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