Question 1

Which of the following calculations multiplies 23 by 0.01?

Accepted Answer

Multiplying a number by 0.01 is equivalent to finding 1% of that number, which is what option A (=23%) represents.

Question 2

All of the following are automatic features that Excel displays as option buttons in a workbook while you are working on it EXCEPT ____.

Accepted Answer

Entry validation is not an automatic feature that displays option buttons; it is a feature that requires manual setup to restrict data entry.

Question 3

Which of the following is the toolbar that contains the Copy and Paste buttons?

Accepted Answer

The Standard toolbar typically contains common functions like Copy and Paste, along with other frequently used commands.

Question 4

The ____ Options button lists formatting options following an insertion of cells, rows, or columns.

Accepted Answer

The Insert Options button appears after inserting cells, rows, or columns, providing formatting options for the newly inserted elements.

Question 5

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

The formula =G15 simply assigns the value in cell G15 to the active cell, it does not trigger a recalculation of other formulas in the worksheet.

Question 6

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

Accepted Answer

The caret (^) is the valid Excel arithmetic operator for exponentiation, the asterisk (*) is the valid operator for multiplication, and the percent sign (%) is the valid operator for percentage calculations. The greater than symbol (>) is not a valid arithmetic operator in Excel.

Question 7

A ____ is a prewritten formula that is built into Excel.

Accepted Answer

A function is a prewritten formula that is built into Excel. It is a predefined formula that performs calculations and returns a result. Examples of functions in Excel include SUM, AVERAGE, MAX, and MIN.

Question 8

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Accepted Answer

The AVERAGE function is designed to calculate the average (also known as the mean) of a range of cells. It does this by summing the numbers in the range and then dividing by the count of cells with numeric values in the range. Therefore, this function is the best choice for this task.

Question 9

A ____ cell in Excel has a numerical value of zero.

Accepted Answer

A blank cell in Excel is a cell that has no value or formula in it. It appears empty on the screen and has a numerical value of zero. This is different from a formatted cell, which may contain a value but is displayed in a certain way (e.g. currency format). Copied and filled cells may contain numerical values other than zero.

Question 10

To start a new line in a cell, press the ____ keys.

Accepted Answer

The answer of To start a new line in a...

Question 11

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Accepted Answer

The answer of The ____ AutoComplete list contains those functions...

Question 12

You can click the ____ button to determine how moved items should appear, for example.

Accepted Answer

The "Paste Options" button allows you to determine how moved or pasted items should appear in applications like Microsoft Excel or Word.

Question 13

Point mode allows you to ____, as shown in the accompanying figure.

Accepted Answer

The answer of  Point mode allows you to ____,...

Question 14

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

Accepted Answer

The Auto Fill Options button gives options for how to fill cells after a fill operation, such as filling with series, copying cells, or filling formatting only. AutoCorrect Options, Insert Options, and Paste Options do not provide such options.

Question 15

What is the value when Excel calculate the average of three cells with values of 10, blank, and 8?

Accepted Answer

Excel calculates the average by ignoring blank cells, so the average of 10 and 8 is (10+8)/2 = 9.

Question 16

By default, Excel for Mac uses a ____ year value.

Accepted Answer

The answer of By default, Excel for Mac uses a...

Question 17

The adjusted cell references in a copied and pasted formula are called ____ references.

Accepted Answer

The adjusted cell references in a copied and pasted formula are called relative references. This means that the references change based on their relative position to the new location of the formula. For example, if a formula in cell A1 references cell B1, when that formula is copied and pasted in cell C2, the reference to B1 in the pasted formula will automatically adjust to C2.

Question 18

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Accepted Answer

Excel follows the same basic order of operations (also known as BODMAS or PEMDAS) as you use in algebra, which means calculations inside parentheses are done first, followed by any exponents, then multiplication or division from left to right, and finally addition or subtraction from left to right.

Question 19

The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

The answer of The ____ Options button lists error-checking options...

Question 20

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Accepted Answer

Applying the order of operations (PEMDAS), first multiply 8 and 3, then add 2. Thus, the formula equals 26.

Quiz 4: Excel: Formulas, Functions, and Formatting