Question 1

Which of the following statements is true about COUNT functions?
A) The COUNT function returns the number of calls in a range that are not blank.
B) The COUNT function returns the number of calls in a range that contain any data at all.
C) Using the COUNT function is useful for computing the average of a cell range.
D) The COUNT function returns the number of cells in a range that contain numeric data.

Accepted Answer

The COUNT function specifically counts the number of cells in a range that contain numeric data, making it useful for numerical analysis but not for counting non-numeric data or blank cells.

Question 2

What is the correct formula to insert the date January 12, 1998 into a cell?
A) =DATE(1998,1,12)
B) =DATE(1998,12,1)
C) =DATE(12-1-1998)
D) =DATE(1/12/1998)

Accepted Answer

The correct formula for inserting the date January 12, 1998 into a cell is =DATE(1998,1,12). This formula specifies the year, month, and day in that order, separated by commas. Option B is incorrect because it swaps the month and day values. Option C is incorrect because it uses dashes instead of commas and lists the day first instead of the month. Option D is incorrect because it uses slashes instead of commas and lists the month first instead of the day.

Question 3

Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?
A) HOUR(A1)
B) =HOUR(A1)
C) =HOUR("12:00:56")
D) HOUR("12:00:56")

Accepted Answer

The correct formula to extract the hour from the time in cell A1 is =HOUR(A1), which will return the value 12. Option A is close but does not include the equal sign necessary to activate the function. Option C and D will not work because HOUR function only accepts a cell reference or a valid time value recognized by Excel.

Question 4

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

Accepted Answer

Excel has a built-in function for calculating the area of a circle, which can be inserted using the equation tools. The formula is =PI()*(radius^2), where PI() is the pi constant and radius is the radius of the circle.

Question 5

Which of the following options should you select to have Excel update all formulas as you edit a worksheet?
A) Manual calculation
B) Automatic calculation
C) Control calculations
D) Calculate later

Accepted Answer

By selecting Automatic calculation, Excel will automatically update all formulas as you edit the worksheet. This saves time and reduces the risk of errors that can occur if formulas are not updated correctly.

Question 6

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data. How can he work more efficiently?
A) Select the Manual Calculation option.
B) Use the Quick Analysis tool to control calculations.
C) Round all the decimal values.
D) Remove any Date functions.

Accepted Answer

Selecting the Manual Calculation option will allow Patrick to control when the worksheet updates and prevent it from slowing down every time he makes a change. This will allow him to work more efficiently.

Question 7

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?
A) IF(A3 > 50, "Good", =IF(A3 < 25, "Poor", "Good")
B) =IF(A3 < 25, "Poor"), IF(A3 < 50, "Average")
C) =IF(A3 < 25, "Poor", "Average", "Good")
D. =IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good"))

Accepted Answer

The answer of Jason wants to display the text "Poor"...

Question 8

To insert only the current date in cell B1, use the NOW function in cell B1 .

Accepted Answer

To insert only the current date in cell B1, you should use the TODAY function, not the NOW function. The NOW function inserts both the current date and time.

Question 9

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded 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)

Accepted Answer

The formula =ROUND(A5,2) will round the number in cell A5 to two decimal places. The other options are not appropriate for this task.

Question 10

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

Accepted Answer

The formula =DATE(2021, 2, 15) will return the date 2/15/2021, which will appear in cell A15.

Question 11

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?
A) MINUTE(G5)
B) =MINUTE(G5)
C) =MINUTE("10:00:56")
D) MINUTE("10:00:56")

Accepted Answer

The answer of Which of the following formulas can you...

Question 12

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?
A) '=COUNT(B1:B20)
B) =COUNTA(B1:B20)
C) =SUM(B1:B20)
D) =CALCULATE(B1:B20)

Accepted Answer

The COUNTA function counts all cells in the specified range that are not empty. This includes cells that contain numbers, dates, and text. Therefore, Liam should use the formula =COUNTA(B1:B20) to count the cells in range B1:B20 that contain numbers, dates, or text.

Question 13

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?
A) =DAY(A1)
B) =DAY("A1'')
C) =DATE(DAY(A1))
D) =DATE("DAY"(A1))

Accepted Answer

The =DAY() function extracts the day of the month from a given date, so =DAY(A1) will work to extract the day of the month from the date in cell A1.

Question 14

Which of the following keys should you press to have Excel calculate all open workbooks manually?
A) F5
B) F9
C) F10
D) F12

Accepted Answer

Pressing F9 will calculate all open workbooks manually. F5 is used to go to a specific cell, F10 opens the "Format Cells" dialog box, and F12 opens the "Save As" dialog box.

Question 15

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?
A) '=IF(B2>=60, "Pass", "Fail")
B) =IF(B2
C) =IF(B2 = 60, "Pass", "Fail")
D) =IFERROR(IF((B2 >= 60, "Pass", "Fail"))

Accepted Answer

Option A uses the IF function correctly to check if the score in cell B2 is greater than or equal to 60. If it is, the function returns "Pass". If it is not, the function returns "Fail". This is the appropriate function to use to determine whether a student has passed or failed a subject based on their score. Option B is incomplete, and options C and D do not use the IF function correctly.

Question 16

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Accepted Answer

This is correct. By clicking on the Show Formulas option, Excel will display the formulas used in each cell instead of their resulting values.

Question 17

Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?
A) Calculate Now
B) Manual
C) On Save
D) Recalculate

Accepted Answer

The answer of Amanda wants to calculate formulas only when...

Question 18

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?
A) '=COUNT(B1:B20)
B) =COUNTA(B1:B20)
C) =SUM(B1:B20)
D) =CALCULATE(B1:B20)

Accepted Answer

The COUNT function is specifically designed to count the number of cells in a range that contain numbers, making it the correct choice for Sam's requirement.

Question 19

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas. She does not want to update the data tables on the worksheet, but she does want to update the other formulas. Which of the following is the most efficient way for her to do so?
A) Select the Automatic Except for Data Tables option.
B) Select the Manual Calculation option and recalculate each cell.
C) Retype each formula.
D) Create custom number formats for the cells with formulas.

Accepted Answer

Selecting the "Automatic Except for Data Tables" option will allow the worksheet to update formulas automatically but will not update the data tables. This is the most efficient way for Laura to update the formulas without affecting the data tables. Option B would be time-consuming as it requires manually recalculating each cell. Option C would also be time-consuming and could lead to errors if formulas are not retyped correctly. Option D is not relevant to the issue of updating formulas.

Question 20

Which of the following formulas can you use to find the serial number of the date January 1, 2017?
A) '=DATEVALUE(1-Jan-2017)
B) =DATEVALUE(01/1/2017)
C) =DATEVALUE(1st Jan, 2017)
D) =DATEVALUE(''01/1/2017'')

Accepted Answer

The answer of Which of the following formulas can you...

Quiz 2: Excel-2019

Which of the following statements is true about COUNT functions?

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

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

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

Which of the following options should you select to have Excel update all formulas as you edit a worksheet?

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data. How can he work more efficiently?

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

To insert only the current date in cell B1, use the NOW function in cell B1 .

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

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

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

Which of the following keys should you press to have Excel calculate all open workbooks manually?

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas. She does not want to update the data tables on the worksheet, but she does want to update the other formulas. Which of the following is the most efficient way for her to do so?

Which of the following formulas can you use to find the serial number of the date January 1, 2017?