Question 1

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

Accepted Answer

The formula should be '=YEAR(23-Aug-2012)'. However, even with the correct formula, the result in cell B12 would only show '2012', not the full date.

Question 2

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?

Accepted Answer

To add the numbers entered in a range of selected cells, Kathy should click on the Sum option in the menu that appears after clicking on Totals in the Quick Analysis option. This will give her the sum of all the numbers in the selected range. The other options, such as Count, Average, and %Total, will not give the sum of the numbers.

Question 3

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 is the correct formula to find the difference between A1 and B1, where A1 is the greater value and B1 is the lesser value.

Question 4

In which of the following boxes under Define target value will you type a numerical value while creating a key performance indicator (KPI)?

Accepted Answer

Absolute value is where you would type a numerical value when setting a target for a KPI, as it directly specifies the goal or target number you aim to achieve.

Question 5

Which of the following lets you fill a cell with only specific elements of a copied cell?

Accepted Answer

The Auto Fill Options button allows you to choose specific elements of a copied cell to fill into a new cell, rather than just copying the entire contents of the cell. It provides options such as formatting only, formulas only, or values only, among others.

Question 6

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

Accepted Answer

The WORKDAY function in the given formula adds 30 workdays to the start date in cell E2 while excluding holidays listed in cells F2:F5.

Question 7

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

This is true as the =SECOND() function in Excel extracts the seconds from a time value.

Question 8

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

Accepted Answer

The formula '=CHOOSE(WEEKDAY(B5),"Mon","Tue","Wed","Thur","Fri","Sat")' will display the corresponding day for the date in cell B5. So, this formula can be used to display days beside each date in the next column.

Question 9

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

Accepted Answer

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

Question 10

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 their birth year (2005) from the current year obtained from the TODAY function.

Question 11

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

Accepted Answer

The formula will round up the number in cell G5 to the nearest whole number (0 decimal places). Therefore, 59.425 will be rounded up to 60.

Question 12

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

Accepted Answer

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

Question 13

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?

Accepted Answer

The formula is incorrectly set up to search within the range A1:H3, which does not include the row where the order ID 10005 is located. However, since the question asks what the formula returns, given the setup, it will return an error or not the intended result. The correct answer choice based on the options provided and the likely intent behind the question is "A) 10", assuming the question meant to reference the correct range that includes the order ID 10005 and its corresponding quantity. However, given the provided formula and range, it wouldn't actually return "10" due to the incorrect range specified in the formula. The explanation is based on understanding how VLOOKUP works and the provided setup, but there seems to be a discrepancy in the question's details.

Question 14

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

Accepted Answer

The formula =HOUR(A1) will extract the hour from the time in cell A1. Option A is close, but it is missing the equal sign (=) needed to create a formula. Options C and D are incorrect because they are trying to use the HOUR function on a string of text instead of a cell reference.

Question 15

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

Accepted Answer

The TIMEVALUE function converts a time in the form of text to a decimal number representing the time in Excel's date-time code. The result for "10:30 AM" would be 0.4375, not "10:30".

Question 16

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) rounds the number in G5 down to the nearest whole number, which for 46.734 is 46.

Question 17

To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval,the formula: =MROUND(A4,0:30)can be used.

Accepted Answer

The correct formula to round time to the nearest 30-minute interval in Excel should use the TIME function for the interval part, like =MROUND(A4, TIME(0,30,0)). The format 0:30 is not recognized by Excel in formulas.

Quiz 3: Performing Calculations With Formulas and Functions