Question 1

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

Accepted Answer

A) 28 
B) 29 
C) 30 
D) 31 
A) 28 
B) 29 
C) 30 
D) 31 C

Question 2

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

Accepted Answer

A) sort 
B) filter 
C) goal seek 
D) solver 
A) sort 
B) filter 
C) goal seek 
D) solver B

Question 3

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

Accepted Answer

A) mumbai 
B) mumbai. 
C) b1 
D) b 
A) mumbai 
B) mumbai. 
C) b1 
D) b B

Question 4

With Text Filters _____ operation is not allowed.

Accepted Answer

A) begins with 
B) ends with 
C) above average 
D) contains 
A) begins with 
B) ends with 
C) above average 
D) contains

Question 5

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

Accepted Answer

A) graphs 
B) filter 
C) scenario 
D) solver 
A) graphs 
B) filter 
C) scenario 
D) solver

Question 6

With Numeric Filters ______ operation is not allowed.

Accepted Answer

A) top 10 
B) above average 
C) greater than 
D) begins with 
A) top 10 
B) above average 
C) greater than 
D) begins with

Question 7

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

Accepted Answer

A) 1932 
B) 2032 
C) 1990 
D) 1900 
A) 1932 
B) 2032 
C) 1990 
D) 1900

Question 8

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

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4 
A) 1 
B) 2 
C) 3 
D) 4

Question 9

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

Accepted Answer

A) 90 
B) 110 
C) 190 
D) 210 
A) 90 
B) 110 
C) 190 
D) 210

Question 10

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

Accepted Answer

A) 12.00 
B) 12 
C) 0.5 
D) 0.25 
A) 12.00 
B) 12 
C) 0.5 
D) 0.25

Question 11

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

Accepted Answer

A) 2 
B) 3 
C) 8 
D) 9 
A) 2 
B) 3 
C) 8 
D) 9

Question 12

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

Accepted Answer

A) verus d'sa 
B) verus d'sa, 
C) verus d'sa. 
D) verus d'sa.. 
A) verus d'sa 
B) verus d'sa, 
C) verus d'sa. 
D) verus d'sa..

Question 13

_____ graph allows only one range of values.

Accepted Answer

A) bar 
B) line 
C) column 
D) pie 
A) bar 
B) line 
C) column 
D) pie

Question 14

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

Accepted Answer

A) 1 
B) 32 
C) 30 
D) one 
A) 1 
B) 32 
C) 30 
D) one

Question 15

Which of the following function is invalid.

Accepted Answer

A) sumif( ) 
B) avgif( ) 
C) countif( ) 
D) if( ) 
A) sumif( ) 
B) avgif( ) 
C) countif( ) 
D) if( )

Question 16

Excel macros can be edited using _______ editor.

Accepted Answer

A) visual basic 
B) excel 
C) c 
D) java 
A) visual basic 
B) excel 
C) c 
D) java

Question 17

Gridlines are not allowed for ___ type of graphs.

Accepted Answer

A) bar 
B) line 
C) column 
D) pie 
A) bar 
B) line 
C) column 
D) pie

Question 18

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

Accepted Answer

A) omm 
B) mme 
C) mm 
D) er 
A) omm 
B) mme 
C) mm 
D) er

Question 19

Excel formula cannot start with ____

Accepted Answer

A) + 
B) - 
C) * 
D) = 
A) + 
B) - 
C) * 
D) =

Question 20

We can add constraints while using __________ command.

Accepted Answer

A) goal seek 
B) solver 
C) scenario manager 
D) data table 
A) goal seek 
B) solver 
C) scenario manager 
D) data table

Exam 2: Excel Formulas and Functions