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

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) MAX function
B) COUNT function
C) MIN function
D) COUNTA function

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

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 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?

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

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

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?

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

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 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?

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?

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?

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?

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

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.