ICF 9 LESSON 3 Using Formulas

What should you enter in a cell to find the difference between 9 and 5?

• DIFF(9,5)

• VAL(9-5)

• =9-5

• 9-5

Which of the following is the correct order of precedence for standard math operators?

• Division, subtraction, multiplication, addition

• Multiplication, division, addition, subtraction

• Addition, subtraction, multiplication, division

• Division, subtraction, addition, multiplication

Which of the following correctly identifies the different parts of the following reference: Tours!B4

• Tours is the name of the worksheet and B4 is the cell reference.

• Tours is the name of the workbook file and B4 is the cell reference.

• Tours is a named range in the worksheet, and B4 is the cell reference.

• Tours is the name of the column and B4 is the name of the row.

Which of the following is not a valid formula for calculating a total value using the data in several cells?

• =SUM(C6:C18)

• =SUM(C6:C18,D6:D18,F6:F18)

• =SUM(C6:C18,C20)

• None – all are valid formulas

Which of the following formulas says: if the value in cell B6 is greater than 500, then display a value equal to B6*20; otherwise, display a zero?

• =(B6>500,B6*20,0)

• =SUM(B6>500,B6*20,0)

• =MULT(B6>500,B6*20,0)

• =IF(B6>500,B6*20,0)

Cell H7 contains the text John Jacob Jingleheimer Schmidt. Which of the following functions will extract the word "Jingle"?

• =LEFT(H7,12)

• =MID(H7,12,6)

• =RIGHT((H7)/2,6)

• =EXTRACT("Jingle",H7,12)

Which type of cell address will be adjusted in the new location based on the relative position of the original formula’s input cells?

• A revolving cell address

• A relative cell address

• A fixed cell address

• An absolute cell address

Before submitting a worksheet full of accounting formulas to his boss, Ken wants to make sure that he has entered all the formulas correctly. There are a lot of them. What is the easiest way to perform this check?

• Set the options for the worksheet to show the formula in every cell instead of the calculated results.

• Click on each formula in the worksheet in succession and read the formula input in the formula bar.

• Print the worksheet, then perform each mathematical operation in the worksheet on a calculator and compare the answers.

• Set the options for the worksheet to check each formula as it is entered.

Monty needs to count the number of empty cells in a 35,000-cell range. Which function should he use?

• COUNTBLANK

• COUNT

• COUNTA

• COUNTNULL

Cell A3 contains the text mAgicaL MR. missToffelees. Edgar enters the function =LEN(UPPER(A3)) in cell A8. Which of the following values will display in cell A8?

• MAGICAL MR. MISSTOFFELEES

• Magical Mr. Misstoffelees

• magical mr. misstoffelees

• 25