FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Performing Calculations With Formulas and Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) =DATEVALUE(1-Jan-2017)
B) =DATEVALUE(01/01/2017)
C) =DATEVALUE(1st Jan, 2017)
D) =DATEVALUE(''01/01/2017'')

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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) =ROUND(A5,2)
B) =MROUND(A5,2)
C) =ROUND(A5,2.0)
D) =MROUND(A5,0.2)

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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.

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?

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

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

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

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

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?

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?

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

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?

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

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.

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

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 find the largest value in a cell range, use the MIN function.

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