Question 1

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,...

Question 2

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

Fill color in a cell or range of cells enhances visual distinction and draws attention, making it easier for users to identify important data or sections in a worksheet.

Question 3

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

Accepted Answer

Conditional formatting is a feature in spreadsheet applications that changes the appearance of cells based on specific conditions or criteria.

Question 4

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 5

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 description correctly explains how Excel's Percent Style button works.

Question 6

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

Accepted Answer

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

Question 7

Typing =av in a cell displays the _________________________.

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

The / arithmetic operator indicates _________________________.

Accepted Answer

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

Question 10

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

Accepted Answer

The answer of When Excel recognizes that you entered a...

Question 11

You can learn more about Excel's functions with options in the _________________________ dialog box.

Accepted Answer

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

Question 12

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 13

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

Accepted Answer

Using a two-digit year format can lead to ambiguity, especially with dates around the year 2000, known as the Y2K problem. A four-digit year format is recommended for clarity.

Question 14

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

Accepted Answer

Clicking on the Format Cells Dialog Box Launcher in Excel opens the Format Cells dialog box, which allows you to format cells in a variety of ways.

Question 15

You cannot format an entire column at once.

Accepted Answer

You can format an entire column at once by selecting the column header and then applying the desired formatting options.

Question 16

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

Accepted Answer

A floating dollar sign is formatted to appear directly next to the first digit of a number, without any intervening spaces.

Question 17

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 18

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 19

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 Number tab in the Format Cells dialog box in spreadsheet applications like Microsoft Excel allows users to customize the appearance of numbers, including decimal places, currency symbols, and the format for negative numbers.

Question 20

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...

Quiz 11: Excel : Formulas, Functions, and Formatting