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

Question 4

With Text Filters _____ operation is not allowed.

Accepted Answer

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

Question 6

With Numeric Filters ______ operation is not allowed.

Accepted Answer

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

Question 8

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

Accepted Answer

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

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

Question 11

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

Accepted Answer

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

Question 13

_____ graph allows only one range of values.

Accepted Answer

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

Question 15

Which of the following function is invalid.

Accepted Answer

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

Question 17

Gridlines are not allowed for ___ type of graphs.

Accepted Answer

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

Question 19

Excel formula cannot start with ____

Accepted Answer

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

Exam 2: Excel Formulas and Functions

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

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

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

With Text Filters _____ operation is not allowed.

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

With Numeric Filters ______ operation is not allowed.

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

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

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

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

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

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