Question 1

Clicking the Create Function box opens the Function Arguments dialog box.

Accepted Answer

Clicking the "Insert Function" button or choosing a function from the formula bar opens the Function Arguments dialog box, not the "Create Function" box.

Question 2

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.

Accepted Answer

This is an accurate statement about selecting a number format in Excel.

Question 3

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

Accepted Answer

The Sum button menu allows you to quickly enter one of five often-used functions: SUM, AVERAGE, COUNT, MAX, and MIN into a cell.

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 can use the arrow keys to complete an entry in Point mode.

Accepted Answer

The answer of You can use the arrow keys to...

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

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 8

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 9

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

Accepted Answer

Excel has over 400 built-in functions that can be used for a variety of calculations and tasks.

Question 10

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

Accepted Answer

Clicking the Format Cells Dialog Box Launcher in Excel opens the Format Cells dialog box.

Question 11

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

In the accounting number style, the dollar sign is fixed at the left edge of the cell, not floating immediately next to the first digit of the dollar value.

Question 12

The range automatically selected by Excel is always correct.

Accepted Answer

While Excel's automatic range selection is usually accurate, it can sometimes select an incorrect range depending on the data and formatting. It is always best to double-check the selected range before performing any calculations or analysis.

Question 13

The AVERAGE function requires that the argument be included within parentheses following the function name.

Accepted Answer

The argument for the AVERAGE function should be included within parentheses following the function name.

Question 14

You cannot format an entire column at once.

Accepted Answer

You can format an entire column by selecting the entire column before applying the formatting.

Question 15

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 16

The / arithmetic operator indicates ____________________.

Accepted Answer

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

Question 17

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 18

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 19

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Accepted Answer

Excel's default behavior is to look for adjacent cells with numeric data when selecting a cell to apply a function to.

Question 20

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. The Percent Style button in Excel does exactly what is described in the statement.

Quiz 9: Excel_Module_2