Deck 2: Excel Formulas and Functions

Question 1

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

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

Answer 1

30

Question 2

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

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

Answer 2

32

Question 3

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

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

Answer 3

0.5

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 9

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

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

Question 10

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

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

Question 13

We can add constraints while using __________ command.

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

Question 14

Excel macros can be edited using _______ editor.

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

Question 15

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

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

Question 16

_____ graph allows only one range of values.

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

Question 17

Gridlines are not allowed for ___ type of graphs.

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

Question 18

With Numeric Filters ______ operation is not allowed.

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

Question 19

With Text Filters _____ operation is not allowed.

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

Question 20

Which of the following function is invalid.

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