Exam 3: Performing Calculations With Formulas and Functions

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.

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

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?

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

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

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.

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?

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.

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?

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

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

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?

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")'.

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?

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

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?

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

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

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

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