Question 1

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 setting is to look for adjacent ranges containing numeric data to include in a function.

Question 2

Moving from left to right, the first calculation in the order of operations is negation (-).

Accepted Answer

In the order of operations, negation (-) is performed first, followed by parentheses, exponents, multiplication and division (performed from left to right), and finally addition and subtraction (also performed from left to right).

Question 3

Which of the following is a method of entering functions?
A) keyboard, touch gesture, or pointer
B) the Sum menu
C) the Insert Function box in the formula bar
D) the Name box area in the formula bar
E) None of the above

Accepted Answer

The answer of Which of the following is a method...

Question 4

The most common error when entering a formula is to reference the wrong cell in the formula.

Accepted Answer

This is a common mistake particularly for beginners when entering a formula in Excel. It is important to check and double-check the formula to ensure that the correct cells or ranges are referenced.

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

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Accepted Answer

Using Point mode allows for easier and more precise selection of cells, making entering formulas quicker and more accurate.

Question 7

The range automatically selected by Excel is always correct.

Accepted Answer

The range automatically selected by Excel may not always be correct due to various factors such as cells being merged, hidden cells, or incomplete data. It is always important to double-check and adjust the selected range if needed.

Question 8

The arithmetic operator, ^, directs Excel to perform the division operation.

Accepted Answer

The arithmetic operator ^ directs Excel to perform the exponentiation operation, not division. The correct operator for division is the forward slash (/).

Question 9

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Accepted Answer

Point mode is a feature in Excel that allows users to select cells for use in a formula by using their finger or the pointer.

Question 10

The equal sign (=) precedes a formula.

Accepted Answer

This is true. The equal sign is used to indicate that what follows is a formula or equation that represents an equivalent relationship between two expressions.

Question 11

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Accepted Answer

An asterisk (*) in Excel is the arithmetic operator for multiplication, not division. The operator for division is the forward slash (/).

Question 12

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

Accepted Answer

The answer of As in algebra, you can use brackets...

Question 13

The Insert Options button lists formatting options.

Accepted Answer

The Insert Options button appears when you insert a table or a content control in Microsoft Word. It provides formatting options such as table styles, text wrapping, and more.

Question 14

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

Accepted Answer

The Sum button menu provides quick access to commonly used functions such as SUM, AVERAGE, COUNT, MAX, and MIN.

Question 15

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

Accepted Answer

Excel has over 400 functions that can perform various types of calculations, including statistical, financial, text, and logical functions.

Question 16

Which of the following actions are provided by the Paste Options button?
A) Pastes an exact copy of what you copied including contents and formatting
B) Pastes synonyms or acronyms
C) Copy just formulas
D) Copy just formatting

Accepted Answer

The answer of Which of the following actions are provided...

Question 17

Which of the following are valid formulas?
A) =3 ^ 4
B) =H3/H11
C) =11+9
D) =22-F15
E) None of the above

Accepted Answer

A) =3^4 is a valid formula as it raises 3 to the power of 4
B) =H3/H11 is a valid formula as it divides the value in cell H3 by the value in cell H11
C) =11+9 is a valid formula as it adds 11 and 9 together
D) =22-F15 is a valid formula as it subtracts the value in cell F15 from 22.

Question 18

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 19

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 enclosed within parentheses following the function name.

Question 20

Using the Excel spell checker, you can ____.
A) check the spelling in a single cell
B) check the spelling of words in a selected range
C) add words to the dictionary
D) add words to the AutoCorrect list
E) None of the above

Accepted Answer

The answer of Using the Excel spell checker, you can...

Quiz 3: Formulas, Functions, and Formatting