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 31

Multiple Choice

Review LaterAdd Note

Review Later

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

A) Print Active Sheets
B) Print Selection
C) Print Entire Workbook
D) none of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

All of the following are valid Excel arithmetic operators EXCEPT ____.

A) ^
B) *
C) %
D) >

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

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.

A ____ is text and graphics that print at the top of each page.

In the order of operations, the last operation Excel performs is ____________________.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

The ____ function displays the highest value in a range.

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.

The Accounting number format assigns a floating dollar sign. _________________________

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

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

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

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

Which of the following are valid formulas?

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.

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

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

The range automatically selected by Excel is always correct.