Question 1

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 ROUND function is the best choice for rounding a number to a specific number of decimal places. It takes two arguments: the first is the number to be rounded, and the second is the number of decimal places to round to. In this case, Ariane wants to round to two decimal places, so the formula =ROUND(A5,2) will do the trick. MROUND, on the other hand, rounds a number to a specified multiple, which is not what Ariane needs in this case. Option C is incorrect syntax because the second argument of the ROUND function should be an integer, not a decimal. Option D is also incorrect because MROUND requires the second argument to be an integer.

Question 2

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

To extract the hour from a cell containing a time value, the HOUR function should be used. The correct syntax is =HOUR(A1), where A1 is the cell containing the time value. Therefore, the correct choice is B. Choice A is incorrect because it is missing the equal sign. Choice C is incorrect because it uses the HOUR function with a string value instead of a cell reference. Choice D is incorrect because it uses the HOUR function with a string value instead of a cell reference and is missing the equal sign.

Question 3

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 serial number. Therefore, =DAY(A1) is the correct formula to use.

Question 4

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 to insert the date January 12, 1998 into a cell is =DATE(1998,1,12). This is because the DATE function takes three arguments, in the order of year, month, and day, separated by commas. Therefore, we input 1998 as the year, 1 as the month (which corresponds to January), and 12 as the day.

Question 5

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

Accepted Answer

When Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12, an error will appear because the syntax of the formula is incorrect. If Stuart wants to display the year of the given date, he should use the formula '=YEAR(A1)' and enter the date in cell A1.

Question 6

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

Question 7

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.

Accepted Answer

The formula accurately calculates the age of a person born in 2005 by subtracting the year of birth from the current year obtained from the TODAY function. Therefore, the answer is true.

Question 8

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

By selecting the Automatic Except for Data Tables option, Laura can update the formulas without also updating the data tables on the worksheet. This is the most efficient option as it allows for automatic updating of formulas without the need to manually recalculate each cell or retype each formula. Creating custom number formats is not relevant to the issue of formula updating.

Question 9

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

Accepted Answer

The result of the formula =TIMEVALUE("10:30 AM") in Excel is 0.4375, which represents the fraction of a 24-hour day that 10:30 AM constitutes.

Question 10

Rohan can display the current date in a cell using the TODAY() function.

Accepted Answer

The TODAY() function can be used in a cell to display the current date.

Question 11

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.

Accepted Answer

The function =SECOND(B1) will extract the seconds from the time entered in cell B1.

Question 12

Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Accepted Answer

The correct formula to round a time to the nearest 30-minute interval is =MROUND(A4,"0:30") or =MROUND(A4, TIME(0,30,0)). The time interval should be specified as a time value, not a text string.

Question 13

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 14

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

Automatic calculation will update all formulas as you edit the worksheet in real-time. This ensures that all calculations are always up to date without the need for manual intervention.

Question 15

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

Accepted Answer

The formula =ROUNDDOWN(G5,0) will remove any decimal portion of the number entered in cell G5, effectively rounding it down to the nearest whole number. Therefore, when used on the number 46.734, the result will be 46.

Question 16

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

Selecting "Manual" calculation mode allows formulas to be calculated only when the user explicitly chooses to do so, such as when saving or opening the workbook.

Question 18

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?
A) =MONTH(F5)
B) =MONTH("F5")
C) =MONTH(TODAY(2016,7,0))
D) =MONTH(DAY(2016,7,0))

Accepted Answer

The answer of Which formula can you use to extract...

Question 19

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.

Accepted Answer

This formula will subtract the value in cell B1 from the value in cell A1, giving the difference between the two values.

Question 20

The WORKDAY function calculates the day of the week starting from a specified date.

Accepted Answer

The WORKDAY function calculates the end date after a specified number of working days from a starting date. It does not calculate the day of the week.

Quiz 7: Excel

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?

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

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?

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

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

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

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.

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?

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

Rohan can display the current date in a cell using the TODAY() function.

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.

Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

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

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

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

Which of the following statements is true about COUNT functions?

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

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

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.

The WORKDAY function calculates the day of the week starting from a specified date.