Question 1

After you finish typing a formula in a cell, you must enter it by pressing the ____.

Accepted Answer

After typing a formula in a cell in most spreadsheet applications like Microsoft Excel or Google Sheets, you can complete and enter the formula by pressing the Enter key, the Tab key, or by clicking the Enter button on the formula bar. Each of these actions will enter the formula into the cell.

Question 2

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

Accepted Answer

Excel only checks for the syntax and structure of the formula, but does not verify if the values or cell references used in the formula are correct. It is the responsibility of the user to ensure the accuracy of the formula inputs.

Question 3

When using the Sum button, the active cell displays the sum.

Accepted Answer

When the Sum button is clicked, the active cell displays the sum of the selected range of cells.

Question 4

The formula = B3^3 is an example of a(n) ____ operation.

Accepted Answer

The "^" symbol in Excel is the symbol for exponentiation, also known as raising a number to a power. B3^3 means "B3 raised to the 3rd power," or B3 cubed. Therefore, the formula B3^3 is an example of an exponentiation operation.

Question 5

The equation used to calculate values in a cell is called a command .

Accepted Answer

The equation used to calculate values in a cell is called a formula, not a command.

Question 6

Each formula begins with a quotation mark (").

Accepted Answer

Formulas in spreadsheet applications like Microsoft Excel or Google Sheets do not begin with a quotation mark ("). They usually start with an equal sign (=) to indicate that the cell contains a formula.

Question 7

The Calculations tab on the Ribbon contains all the buttons you need when working with manual calculations.

Accepted Answer

The Calculations group is actually found under the Formulas tab on the Ribbon, not a separate Calculations tab. This is where you can find all the functions and tools for working with formulas and calculations in Excel.

Question 8

The formula =B5+C5 is an example of a multiplication operation.

Accepted Answer

The formula =B5+C5 is an example of an addition operation, not a multiplication operation.

Question 9

Formulas can include more than one operator.

Accepted Answer

Formulas can include more than one operator, such as "3+4*2" where "+" and "*" are both operators.

Question 10

The results of the calculation appear in the cell in which the formula is entered.

Accepted Answer

When a formula is entered in a cell, the result of the calculation appears in that same cell.

Question 11

The formulas replace the formula results in the worksheet. If a cell does not contain a formula, the cell appears shaded out.

Accepted Answer

If a cell does not contain a formula, it will simply display the value entered in the cell without any shading. The formulas only replace the values in the cells that actually contain formulas.

Question 12

Whenever you select a range, the Ribbon shows the results of common calculations for the selected cells.

Accepted Answer

The Ribbon does not automatically show the results of common calculations for selected cells; instead, the Status Bar at the bottom of the Excel window shows common calculations like Average, Count, and Sum for selected cells.

Question 13

Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are operands .

Accepted Answer

This is true. In the formula, =B3+5, both B3 and 5 are operands, as they are the values that are being operated on by the + symbol.

Question 14

The formula =C8-232 is an example of a division operation.

Accepted Answer

The formula =C8-232 is an example of a subtraction operation, not a division operation.

Question 15

When formulas with mixed cell references are copied or moved, the row or column references preceded by a question mark do not change.

Accepted Answer

In Excel formulas, mixed cell references use a dollar sign ($) to lock either the row or column reference, not a question mark. When copied or moved, the part of the reference without a dollar sign can change, while the part with the dollar sign remains fixed.

Question 16

The sequence used to calculate the value of a formula is called the ____.

Accepted Answer

The sequence used to calculate the value of a formula is called the order of evaluation, which refers to the order in which the different parts of the formula are processed. For example, in the formula 3 + 4 * 2, the order of evaluation would dictate that the multiplication (4*2) is done before the addition (3+8), resulting in a final value of 11. Understanding the order of evaluation is important in programming and mathematical contexts.

Question 17

COUNT CELLS determine how many entries are included in the range.

Accepted Answer

COUNTA function is used to determine how many entries are included in a range, while COUNT function counts only numeric values.

Question 18

You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references.

Accepted Answer

This is true. You can click on each cell in the formula bar and Excel will input the cell reference for you, making it quicker than typing it out manually.

Question 19

The formula = E6/4 is an example of a(n) ____ operation.

Accepted Answer

The "/" symbol represents division.

Question 20

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

Accepted Answer

You can change which cells are included in a reference by dragging any corner of the colored outline to resize the selected range. This is a feature in spreadsheet programs like Microsoft Excel, where a colored outline appears around cells that are being referenced, and users can adjust the range by dragging its corners.

Quiz 10: Excel Lesson 4: Entering Worksheet Formulas