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?

(Multiple Choice)

4.9/5

(43)

Question 21

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

(True/False)

4.8/5

(29)

Question 22

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

(Multiple Choice)

4.8/5

(30)

Question 23

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

(Multiple Choice)

4.9/5

(26)

Question 24

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?

(Multiple Choice)

4.8/5

(33)

Question 25

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

(Multiple Choice)

4.9/5

(40)

Question 26

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?

(Multiple Choice)

4.7/5

(35)

Question 27

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.

(True/False)

4.8/5

(34)

Question 28

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

(Multiple Choice)

4.9/5

(37)

Question 29

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

(Multiple Choice)

4.9/5

(36)

Question 30

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?

(Multiple Choice)

4.7/5

(28)

Question 31

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

(Multiple Choice)

4.9/5

(41)

Question 32

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

(True/False)

4.8/5

(40)

Question 33

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

(Multiple Choice)

4.9/5

(31)

Question 34

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.

(True/False)

4.9/5

(37)

Question 35

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

(Multiple Choice)

4.9/5

(34)

Question 36

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

(True/False)

4.8/5

(38)

Question 37

Showing 21 - 37 of 37

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 insert the current date in cell B1,type CURRENT DATE in cell A1 and NOW()in cell B1 and press ENTER.

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

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

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?

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

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 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 have Excel enter the lowest price from a range of prices,which of the following would you use?

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

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

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

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

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.

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.

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters