Exam 3: Performing Calculations With Formulas and Functions

Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5. Now she wants to add 30 workdays to the start date. She can do this using the following formula: = WORKDAY (E2, 30, F2:F5).

In the formula =B6*$B$2, which of the following describes $B$2?

Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?

Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, 2/2/2000 will appear in AI5.

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?

To insert an equation, click on the Object in the Text group on the Insert tab, then click Microsoft Equation 3.0 in the Object type box, and then click OK.

To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value. In order to do so, he will type the formula =A1-B1 in an empty cell.

Nathan wants TRUE to be elicited if either of the statements are true, and FALSE if both are true. Which of the following formula can he use to ensure that?

Which of the following lets you fill a cell with only specific elements of a copied cell?

To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval, the formula: =MROUND(A4,0:30) can be used.

In which of the following boxes under Define target value will you type a numerical value while creating a key performance indicator (KPI)?

What is the correct formula to insert the date January 12, 1998 into a cell?

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12.

A jewelry designer creates an excel sheet to list different items he sold on the previous day. Cells A1, B1, C1, and D1 contain headings-Order ID, Unit price, and Quantity, respectively. Cells A2 to A6 list the order ID for items sold-10001,10002,10003,10004, and 10005, respectively. Cells B2 to B6 list their respective unit price-$15, $18.5, $12, $9.5, and $6. Cells C2 to C6 list their respective quantities-20, 32, 16, 15, and 10. If he enters the formula in cell D1 as: =VLOOKUP (10005, A1: H3, 3, FALSE), what will the formula return?

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59. Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B?

Which of the following functions would you use to calculate the arithmetic mean of a price list?

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 0.

Which formula can you use to extract the month from the date in cell F5: 2016 July 8th?