Exam 3: Performing Calculations With Formulas and Functions

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Where can you see a brief description of a selected function?

A student wants to round the number 24.7835 entered in cell A2 to two decimal places. Which of these formulas can she use to do so?

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Which formula can be applied for the given data in a cell A2: 01/01/2017 to get the serial number of the date as text?

Rohan wants to create a column containing dates and want to display days beside each date in the next column. He can use the formula '=CHOOSE(WEEKDAY(B5),"Mon", "Tue", "Wed", "Thur", "Fri", "Sat")'.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Which of the following is true about entering a function using the Insert Function dialog box?

Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek... from the drop down menu. What is X in the procedure?

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

A student inserts the formula =TIMEVALUE("10:30 AM") in a cell. On pressing ENTER, it will return the value 10:30.

Ian needs to extract the day from the date 5/31/2017 entered in cell A1. Which formula can he use to do this?

To find the largest value in a cell range, use the MIN function.

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed?