Question 1

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

Accepted Answer

A)  Identification of how to format various elements of the worksheet
B)  Avoiding the temptation to use flashy or confusing visual elements within the worksheetC) A) and B)
D) undefined

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The answer of The ____________________ is a small black square...

Question 4

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

Accepted Answer

A)  Print Active Sheets
B)  Print Selection
C)  Print Entire Workbook
D)  none of the aboveE) A) and D)
F) A) and C)

Question 5

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

Accepted Answer

A)  header
B)  topper
C)  margin
D)  crownE) None of the above
F) A) and D)

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  8.43
B)  7.52
C)  11.65
D)  9.43E) A) and B)
F) A) and C)

Question 8

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

Accepted Answer

A)  0
B)  1
C)  2
D)  3E) C) and D)
F) None of the above

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following are valid formulas?

Accepted Answer

A)  =3 ^ 4
B)  =H3/H11
C)  =11+9
D)  =22-F15E) All of the above
F) A) and C)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  Auto Fill Options
B)  AutoCorrect Options
C)  Insert Options
D)  Paste OptionsE) C) and D)
F) A) and C)

Question 13

The range automatically selected by Excel is always correct.

Accepted Answer

A) True 
 B)False

Question 14

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.

Accepted Answer

The answer of One of the reasons Excel is such...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The ____ function displays the highest value in a range.

Accepted Answer

A)  MIN
B)  SUM
C)  MAX
D)  AVERAGEE) C) and D)
F) A) and B)

Question 17

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

Accepted Answer

subtractio...

Question 18

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

Accepted Answer

A)  Formula Finder
B)  Range Finder
C)  Calculation Finder
D)  Function FinderE) A) and B)
F) All of the above

Question 19

The Accounting number format assigns a floating dollar sign. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  ^
B)  *
C)  %
D)  >E) A) and D)
F) C) and D)

Exam 9: Excel_Module_2

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The range automatically selected by Excel is always correct.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____ function displays the highest value in a range.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedsubtractio...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following are valid formulas?

Correct AnswerverifiedShow Answer

The Accounting number format assigns a floating dollar sign. _________________________

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
subtractio...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified