Question 1

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.

Accepted Answer

The statement is correct.

Question 2

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

Accepted Answer

Best fit means that the width of the column will be automatically adjusted to fit the content of the widest cell in the column.

Question 3

Typing =av in a cell displays the ____________________.

Accepted Answer

The answer of Typing =av in a cell displays the...

Question 4

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 5

You cannot format an entire column at once.

Accepted Answer

You can format an entire column by clicking on the column letter at the top of the worksheet to select the entire column, and then applying the desired formatting.

Question 6

You can learn more about Excel's functions with options in the ____________________.

Accepted Answer

The answer of You can learn more about Excel's functions...

Question 7

Cooler colors (red and orange)tend to pull away from the reader.

Accepted Answer

Cooler colors are typically blues and greens, which tend to recede or pull away from the viewer, while warmer colors like red and orange tend to advance or come forward.

Question 8

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

Accepted Answer

The answer of In the order of operations, the last...

Question 9

Dates that include years both before and after the year 2000 should be formatted with a two-digit year.

Accepted Answer

Dates that include years both before and after the year 2000 should be formatted with a four-digit year to avoid confusion and ensure accuracy.

Question 10

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

The statement is true.

Question 11

You change the ____________________ when you cannot see clearly the content on which you are working.

Accepted Answer

The answer of You change the ____________________ when you cannot...

Question 12

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Accepted Answer

This statement is true. Using a fill color can help emphasize important information in a worksheet and make it easier for the user to quickly identify key data.

Question 13

The / arithmetic operator indicates ____________________.

Accepted Answer

The answer of The / arithmetic operator indicates ____________________....

Question 14

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

Accepted Answer

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

Question 15

The function, or ____________________, of a worksheet is to provide a user with direct ways to accomplish tasks.

Accepted Answer

The answer of The function, or ____________________, of a worksheet...

Question 16

A formula in a cell that contains a reference back to itself is called a(n)____________________.

Accepted Answer

The answer of A formula in a cell that contains...

Question 17

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Accepted Answer

This is true. In most currency settings, the dollar sign appears to the left of the first digit without any spaces.

Question 18

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

Accepted Answer

This statement is true.

Question 19

Worksheet ____________________ typically contain items analogous to items in a list.

Accepted Answer

The answer of Worksheet ____________________ typically contain items analogous to...

Question 20

If you have a long text entry, such as a paragraph, you can instruct Excel to ____________________ text in the cell.

Accepted Answer

The answer of If you have a long text entry,...

Quiz 4: Excel: Formulas, Functions, and Formatting