Question 1

What will be the answer of =DAYS360("1-Feb-2020", "1-Mar-2020")?
A)28
B)29
C)30
D)31

Accepted Answer

The DAYS360 function calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which results in 30 days between February 1, 2020, and March 1, 2020.

Question 2

What will be the answer of =DATEVALUE("1-Feb-1900")?
A)1
B)32
C)30
D)one

Accepted Answer

The DATEVALUE function in Excel converts a date in the form of text to a serial number that Excel recognizes as a date. The serial number for the date "1-Feb-1900" is 32, because Excel's date system starts on January 1, 1900, which is serial number 1. Therefore, February 1, 1900, is 32 days after January 1, 1900.

Question 3

What will be the answer of =TIMEVALUE("12:00 PM")?
A)12.00
B)12
C)0.5
D)0.25

Accepted Answer

TIMEVALUE("12:00 PM") converts a time in the form of text to a decimal number between 0 and 1, representing the fraction of a 24-hour day. "12:00 PM" is halfway through the day, so the correct answer is 0.5.

Question 4

What will be the answer of =MONTH(32)?
A)2
B)3
C)8
D)9

Accepted Answer

The function =MONTH(32) interprets the number 32 as the 32nd day starting from December 31, 1899, which falls in February (the second month), hence the correct answer is 2.

Question 5

What will be the answer of =DAY(32)?
A)1
B)2
C)3
D)4

Accepted Answer

The DAY function in Excel converts a serial number to a day of the month. Since Excel's date system starts on January 1, 1900, which is serial number 1, a serial number of 32 corresponds to February 1, 1900. Therefore, the DAY(32) function returns 1, as February 1 is the first day of the month.

Question 6

What will be the answer of =YEAR(32)?
A)1932
B)2032
C)1990
D)1900

Accepted Answer

The answer of What will be the answer of =YEAR(32)?
A)1932
B)2032
C)1990
D)1900...

Question 7

If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
A)mumbai
B)mumbai.
C)b1
D)b

Accepted Answer

The answer of If cell B1 contains text MUMBAI then...

Question 8

What will be the answer of =PROPER("verus d'sa")?
A)verus d'sa
B)verus d'sa,
C)verus d'sa.
D)verus d'sa..

Accepted Answer

The PROPER function capitalizes the first letter of each word in a text string, and leaves the rest of the characters unchanged.

Question 9

What will be the answer of =MID("COMMERCE",3,2)?
A)omm
B)mme
C)mm
D)er

Accepted Answer

The MID function in Excel extracts a given number of characters from the middle of a provided text string, starting at a position you specify. In this case, =MID("COMMERCE",3,2) starts at the third character of "COMMERCE" and extracts 2 characters, which are "MM".

Question 10

Excel formula cannot start with ____
A)+
B)-
C)*
D)=

Accepted Answer

The answer of Excel formula cannot start with ____
A)+
B)-
C)*
D)=...

Question 11

If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?
A)90
B)110
C)190
D)210

Accepted Answer

Since A1 contains 100 which is less than 200, the condition A1<200 is true, so the formula will add 10 to A1, resulting in 110.

Question 12

When we want to hide the records which are not satisfying a given condition, then we use ________ command.
A)sort
B)filter
C)goal seek
D)solver

Accepted Answer

The filter command is used to hide records that do not meet a specified condition, allowing users to focus on the data that is relevant to their needs.

Question 13

We can add constraints while using __________ command.
A)goal seek
B)solver
C)scenario manager
D)data table

Accepted Answer

Solver allows for the addition of constraints to specify the limits within which a solution must be found, making it a powerful tool for optimization problems.

Question 14

Excel macros can be edited using _______ editor.
A)visual basic
B)excel
C)c
D)java

Accepted Answer

Excel macros are edited using the Visual Basic for Applications (VBA) editor, which is integrated into Microsoft Excel.

Question 15

To make data interesting, attractive and easy to read and evaluate, we use ______
A)graphs
B)filter
C)scenario
D)solver

Accepted Answer

Graphs are used to make data interesting, attractive, and easy to read and evaluate by visually representing the data.

Question 16

_____ graph allows only one range of values.
A)bar
B)line
C)column
D)pie

Accepted Answer

A pie chart is designed to show parts of a whole, so it only allows for one range of values to be represented, typically as percentages of a total.

Question 17

Gridlines are not allowed for ___ type of graphs.
A)bar
B)line
C)column
D)pie

Accepted Answer

Gridlines are typically not used for pie charts because they are designed to show parts of a whole without the need for axis-based numerical precision, making gridlines irrelevant and potentially cluttering the visual presentation.

Question 18

With Numeric Filters ______ operation is not allowed.
A)top 10
B)above average
C)greater than
D)begins with

Accepted Answer

The "begins with" operation is not applicable to numeric filters because it is used for filtering text data based on the beginning characters, not for numeric comparisons.

Question 19

With Text Filters _____ operation is not allowed.
A)begins with
B)ends with
C)above average
D)contains

Accepted Answer

Text Filters are designed to work with textual data, allowing operations like "begins with," "ends with," and "contains." The "above average" operation is typically used with numerical data to filter values that are above the average of a dataset, not with text data.

Question 20

Which of the following function is invalid.
A)sumif( )
B)avgif( )
C)countif( )
D)if( )

Accepted Answer

The correct function name for calculating an average based on a condition is AVERAGEIF(), not avgif(). SUMIF() and COUNTIF() are valid functions for summing and counting based on a condition, respectively, and IF() is a basic conditional function.

Quiz 2: Excel Formulas and Functions

What will be the answer of =DAYS360("1-Feb-2020", "1-Mar-2020") ?

What will be the answer of =DATEVALUE("1-Feb-1900") ?

What will be the answer of =TIMEVALUE("12:00 PM") ?

What will be the answer of =MONTH(32) ?

What will be the answer of =DAY(32) ?

What will be the answer of =YEAR(32) ?

If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1) ?

What will be the answer of =PROPER("verus d'sa") ?

What will be the answer of =MID("COMMERCE",3,2) ?

Excel formula cannot start with ____

If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10) ?

When we want to hide the records which are not satisfying a given condition, then we use ________ command.

We can add constraints while using __________ command.

Excel macros can be edited using _______ editor.

To make data interesting, attractive and easy to read and evaluate, we use ______

_____ graph allows only one range of values.

Gridlines are not allowed for ___ type of graphs.

With Numeric Filters ______ operation is not allowed.

With Text Filters _____ operation is not allowed.

Which of the following function is invalid.