Question 1

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

Accepted Answer

Multiplication and division have a higher precedence than addition and subtraction, so 25 multiplied by 2 is calculated first, resulting in 50, and then 50 is divided by 5 to give a final result of 10.

Question 2

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

Accepted Answer

Both the Insert Function button and the AutoSum list arrow automatically insert the equal sign at the beginning of the formula. Therefore, it is not necessary to type the equal sign manually.

Question 3

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 can have either a relative column reference and an absolute row reference or an absolute column reference and a relative row reference.

Question 4

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

Accepted Answer

This is correct. When using the Cut command, the selected data is removed from its original location and placed in a new location, while the original location is left empty. On the other hand, when using the Copy command, the selected data is duplicated and placed in a new location while still remaining in its original location.

Question 5

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

Accepted Answer

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

Question 6

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?
A) =C12+(C13*F4)
B) =(C12+C13)*F4
C) =$C12+$C13*F4
D) =C12*F4+C13

Accepted Answer

The answer of How can the order of precedence in...

Question 7

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 8

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 open the Clipboard pane. To close it, you can click the X button on the top right corner of the pane or press the Esc key on your keyboard.

Question 9

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

This statement is not completely accurate. To insert the AVERAGE function into a cell, first click on the cell where you want the function to appear. Then, click on the Formulas tab, click on the More Functions button in the Function Library group, select Statistical, and then click on AVERAGE. Alternatively, you can type "=AVERAGE(" into the cell and then input the data range that you want to calculate the average of.

Question 10

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

Accepted Answer

This statement is true. Excel's Formula AutoComplete feature suggests functions based on the letters typed by the user.

Question 11

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

The answer of When pasting an item from the Office...

Question 12

In the formula =D1+C1/F3, which calculation will be performed first?
A) C1/F3
B) D1+C1
C) D1/F3
D) D1+F3

Accepted Answer

Since the formula follows the standard order of operations (parentheses, exponentiation, multiplication and division from left to right, and finally addition and subtraction from left to right), the division calculation must be performed first.

Question 13

After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish. _________________________

Accepted Answer

The answer of After you use the fill handle to...

Question 14

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 15

Which of the following is a complex formula?
A) =SUM(B4:B8)
B) =(B4/B8)*10
C) =AVERAGE(C6:D6)
D) =MIN(D5:D7)

Accepted Answer

This formula contains both multiplication and division, making it a complex formula. The other formulas only contain a single function.

Question 16

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.

Question 17

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 18

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

Accepted Answer

A6 and A8 are not preceded by a "$" symbol, which makes them relative cell references. This means that when the formula is copied to other cells, the cell references will change based on their relative position to the new cell.

Question 19

All functions begin with the formula prefix ____.
A) @ (at symbol)
B) = (equals sign)
C) # (number symbol)
D) + (plus sign)

Accepted Answer

All functions in Excel begin with the formula prefix of the equals sign (=).

Question 20

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?
A) $M$3/4
B) (G15-G14)*$M$3
C) (G15-G14)
D) (G15-G14)/4

Accepted Answer

The first operation performed is the subtraction of G14 from G15. This is because operations inside parentheses are performed before multiplication. Then the result is multiplied by the value in cell M3. Finally, the product is divided by 4. Since there are no parentheses or division signs that could change the order of operations, the result is (G15-G14)*$M$3/4.

Quiz 11: Excel 2013 Getting Started With Excel 2013