Question 1

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Accepted Answer

False

Question 2

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

Accepted Answer

This statement is true. When you cut data, it is removed from its original location and placed on the clipboard. When you copy data, a duplicate is placed on the clipboard while the original remains in its place.

Question 3

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

Accepted Answer

A cell reference that does not change when it is copied is called an absolute cell reference, not a relative cell reference.

Question 4

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10 . _________________________

Accepted Answer

The order of precedence for mathematical operations is to perform multiplication and division before addition and subtraction. Therefore, the formula (25*2)/5 would first multiply 25 and 2, resulting in 50, and then divide that by 5, resulting in 10.

Question 5

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________

Accepted Answer

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. This feature can be very useful in saving time and preventing errors in formula creation.

Question 6

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

Accepted Answer

The answer of The COUNT function in Excel returns the...

Question 7

The COUNTA function returns the number of cells in a range that contain numeric data.​

Accepted Answer

The COUNTA function returns the number of cells in a range that are not empty, including cells containing text or other non-numeric values. It counts all cells with data, not just numeric data.

Question 8

An absolute cell reference changes the cell references when the formula is copied to a new location.

Accepted Answer

An absolute cell reference remains the same even when the formula is copied to a new location. It is denoted by adding a $ symbol in front of the column and row reference, such as $A$1. This ensures that the formula references a specific cell and not a relative location.

Question 9

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

Accepted Answer

A mixed reference means that either the row or column reference in the formula is absolute, but not both. For example, $A1 or A$1 are both examples of mixed references.

Question 10

In this formula,  =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references. _________________________

Accepted Answer

A6 and A8 are not fixed with dollar signs, so they will change based on the position of the formula when it is copied or dragged to another cell. This makes them relative cell references.

Question 11

=D8+E8*0.5 is a complex formula.

Accepted Answer

This formula contains two variables (D8 and E8), multiplication, and addition, making it a complex formula.

Question 12

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Accepted Answer

The statement is true. When Auto Fill is enabled, dragging the fill handle on a cell will either copy the cell's contents or continue a series of data into adjacent cells, depending on the pattern detected by Excel.

Question 13

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

Accepted Answer

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

Question 14

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

Accepted Answer

When pasting an item, you typically specify the upper-left cell of the range where you want to paste the selection, not the lower-right cell.

Question 15

To insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the Home tab, and then click Average. _________________________

Accepted Answer

The AVERAGE function is typically inserted by clicking the "Formulas" tab, then "Insert Function," or by typing "=AVERAGE()" directly into the cell. The described method is not standard for inserting the AVERAGE function.

Question 16

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result:  =22/2*5  =22/(2*5).

Accepted Answer

According to the order of precedence for arithmetic operators, multiplication and division have the same precedence, and they are performed from left to right. Therefore, 22/2*5 is calculated as (22/2)*5 which gives us 55, while 22/(2*5) is calculated as 22/10 which gives us 2.2.

Question 17

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet. _________________________

Accepted Answer

The answer of Clicking the Minimize button minimizes the Function...

Question 18

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

Accepted Answer

When using the Insert Function button or the AutoSum list arrow, Excel will automatically place the equal sign for you.

Question 19

You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________

Accepted Answer

Clicking the dialog box launcher in the Clipboard group will expand the Office Clipboard pane, but you can close it by clicking the X button at the top right of the pane or by pressing the "Ctrl + C" keys on your keyboard twice.

Question 20

An Excel complex formula uses more than one arithmetic operator.

Accepted Answer

A complex formula can use addition, subtraction, multiplication, and division operators together in one formula.

Quiz 7: Excel 2: Working With Formulas and Functions

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10 . _________________________

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

The COUNTA function returns the number of cells in a range that contain numeric data.

An absolute cell reference changes the cell references when the formula is copied to a new location.

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

In this formula, =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references. _________________________

=D8+E8*0.5 is a complex formula.

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

To insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the Home tab, and then click Average. _________________________

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/25 =22/(25).

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet. _________________________

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________

An Excel complex formula uses more than one arithmetic operator.

Quiz 7: Excel 2: Working With Formulas and Functions

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10 . _________________________

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

The COUNTA function returns the number of cells in a range that contain numeric data.​

An absolute cell reference changes the cell references when the formula is copied to a new location.

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

In this formula, =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references. _________________________

=D8+E8*0.5 is a complex formula.

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

To insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the Home tab, and then click Average. _________________________

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet. _________________________

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________

An Excel complex formula uses more than one arithmetic operator.

The COUNTA function returns the number of cells in a range that contain numeric data.

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/25 =22/(25).