Question 1

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
A) Find Error
B) Explain Error
C) Fix Error
D) Trace Error

Accepted Answer

The Trace Error button is used to evaluate the cause of an error in a formula, while the Find Error, Explain Error, and Fix Error buttons are not specific to identifying and correcting formula errors.

Question 2

The adjusted cell references in a copied and pasted formula are called ____ cell references.
A) related
B) relative
C) pasted
D) alternative

Accepted Answer

The adjusted cell references in a copied and pasted formula are called relative cell references. Relative references change based on their new location when the formula is copied and pasted to a different cell.

Question 3

All of the following are valid Excel arithmetic operators EXCEPT ____.
A) ^
B) *
C) %
D) >

Accepted Answer

"^", "*", and "%" are all valid Excel arithmetic operators, but ">" is a comparison operator and not an arithmetic operator.

Question 4

A ____ is a prewritten formula that is built into Excel.
A) function
B) feature
C) task
D) calculation

Accepted Answer

A function is a prewritten formula that is built into Excel, which can be used to perform calculations and manipulate data.

Question 5

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.
A) AutoCorrect
B) Insert
C) Auto Fill
D) Paste

Accepted Answer

The Insert option button lists formatting options following an insertion of cells, rows, or columns. AutoCorrect, Auto Fill, and Paste do not provide formatting options related to insertion of cells, rows, or columns.

Question 6

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
A) Function
B) Formula
C) Equal
D) Calculate

Accepted Answer

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

Question 7

The ____ function determines the lowest number in a range.
A)LOW
B)BASE
C)LEAST
D)MIN

Accepted Answer

The MIN function (short for "minimum") is specifically designed to find the lowest number in a range. Options A, B, and C are not actual Excel functions for finding the minimum value.

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.
A) DIVSUM
B) RANGEAVG
C) AVERAGE
D) MAX

Accepted Answer

The AVERAGE function calculates the average of the numbers in a specified range, and this is what is described in the question prompt.

Question 9

Which of the following happens when you enter the formula =G15 into a cell?
A) Excel recalculates all formulas in the worksheet
B) Excel assigns the sum of the values in the previous 15 cells to the active cell
C) Excel assigns the value in cell G15 to the active cell
D) Nothing; =G15 is an invalid formula

Accepted Answer

The formula assigns the value in cell G15 to the active cell. The formula simply refers to a single cell and does not involve any calculation. Therefore, Excel does not need to recalculate any formulas in the worksheet.

Question 10

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
A) contiguous
B) indexed
C) direct
D) indirect

Accepted Answer

The answer of A(n)____ circular reference occurs when a formula...

Question 11

Which of the following calculations multiplies 23 by 0.01?
A) =23%
B) =23
C) =23+.01
D) =24-.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 12

To start a new line in a cell,press the ____ keys.
A) CTRL+ENTER
B) TAB+ENTER
C) ALT+ENTER
D) SHIFT+ENTER

Accepted Answer

To start a new line within a cell in Microsoft Excel, press the ALT+ENTER keys. This allows you to insert a line break within a cell without moving to the next cell. The other key combinations do not serve the same purpose.

Question 13

The ____ function displays the highest value in a range.
A) MIN
B) SUM
C) MAX
D) AVERAGE

Accepted Answer

MAX function displays the highest value in a range.

Question 14

-Point mode allows you to ____,as shown in the accompanying figure.
A) select cells for use in a formula using the keyboard
B) select a function from the Sum button list
C) select cells for use in a formula using the mouse pointer
D) edit cell contents directly in the cell

Accepted Answer

Point mode facilitates the selection of cells to be used in a formula by allowing the user to click on them with the mouse pointer, rather than typing their cell references manually.

Question 15

You can click the ____ button to undo an automatic correction.
A) Auto Fill Options
B) AutoCorrect Options
C) Paste Options
D) Trace Error

Accepted Answer

The AutoCorrect Options button provides options for correcting and undoing automatic corrections made by Microsoft Word.

Question 16

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.
A) 40
B) 26
C) 48
D) 13

Accepted Answer

According to the order of operations, we need to perform the multiplication first, then the addition. Therefore, 8 * 3 = 24 and 24 + 2 = 26.

Question 17

Which of the following Option buttons gives options for filling cells following a fill operation?
A) Auto Fill Options
B) AutoCorrect Options
C) Insert Options
D) Paste Options

Accepted Answer

Auto Fill Options give options for filling cells following a fill operation, such as copying formatting, copying values, or continuing series patterns. AutoCorrect Options are for correcting spelling and grammar mistakes. Insert Options are for choosing how to insert cells, rows, or columns into a worksheet. Paste Options allow you to choose how to paste copied or cut cells, such as values only, formatting only, or both.

Question 18

When you enter a two-digit year that is less than 30,Excel changes the year to ____.
A) 20xx
B) 30xx
C) 18xx
D) 19xx

Accepted Answer

Excel interprets two-digit years that are less than 30 as belonging to the 21st century, hence it changes them to 20xx.

Question 19

Clicking the ____ opens the Insert Function dialog box.
A) Insert Function box in the formula bar
B) Function dialog box launcher (HOME tab | Calculations group)
C) Function button (HOME tab | Function group)
D) Functions & Formulas button on the status bar

Accepted Answer

The Insert Function box in the formula bar is clicked to open the Insert Function dialog box, allowing users to search for and insert functions into their Excel formulas.

Question 20

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.
A) placement
B) operations
C) positioning
D) selections

Accepted Answer

Excel follows the same basic order of operations, also known as PEMDAS (Parentheses, Exponents, Multiplication and Division, Addition and Subtraction), that you use in algebra. This means that Excel will perform calculations inside parentheses first, then any exponentiation, then multiplication and division from left to right, and finally addition and subtraction from left to right.

Quiz 2: Formulas,Functions,and Formatting

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

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

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

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

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

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

The ____ function determines the lowest number in a range.

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.

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

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Which of the following calculations multiplies 23 by 0.01?

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

The ____ function displays the highest value in a range.

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

You can click the ____ button to undo an automatic correction.

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

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

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

Clicking the ____ opens the Insert Function dialog box.

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