Deck 1: Excel Functions and Features

Question 1

15-August-2020 was Saturday. Answer of =WEEKDAY("15-August-2020") will be_____

A)saturday
B)sat
C)7
D)6

Answer 1

7

Question 2

15-August-2020 was Saturday. Answer of =MONTH("15-August-2020") will be ________

A)august
B)aug
C)8
D)7

Answer 2

8

Question 3

15-August-2020 was Saturday. Answer of =YEAR("15-August-2020") will be ________

A)2020
B)1920
C)20
D)2200

Answer 3

2020

Question 4

Answer of =DAYS360("1-Jan-2020", "31-Dec-2020") will be ________

A)365
B)366
C)360
D)364

Question 5

Answer of =YEAR("15-Aug-20") will be

A)20
B)2020
C)1920
D)2200

Question 6

Answer of =TIMEVALUE("6:00 PM") will be ________

A)6:00
B)6:00 am
C)18:00
D)0.75

Question 7

TODAY( ) returns current ______

A)date
B)time
C)day
D)date & time

Question 8

Answer of =DAYS360("31-Dec-2020", "1-Jan-2020") will be ________

A)365
B)366
C)360
D)-360

Question 9

To convert uppercase alphabets to lowercase we use _____

A)lcase( )
B)lower( )
C)upper( )
D)ucase( )

Question 10

To find number of characters in a string we use _____

A)count( )
B)len( )
C)length( )
D)sum( )

Question 11

To search a value in the first row of a given range, we use _______.

A)vllokup( )
B)hlookup( )
C)search( )
D)locate( )

Question 12

To count non blank cells, we use _____.

A)count( )
B)counta( )
C)countblank( )
D)countnonblank( )

Question 13

To count number of cells that contains numbers, we use _____.

A)count( )
B)counta( )
C)sum( )
D)countif( )

Question 14

Which of the following is not a valid chart type in Excel.

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

Question 15

Axis Title is not allowed in this type of graphs.

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

Question 16

Select odd man out from the following graph types.

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

Question 17

Charts are available under _______ Ribbon/Menu.

A)home
B)insert
C)data
D)view

Question 18

Goal Seek Option is available under ____ Ribbon/Menu.

A)home
B)insert
C)data
D)view

Question 19

Number of changing cells for a Scenario is limited to ____

A)16
B)32
C)1
D)2

Question 20

Number of changing cells for a Goal Seek is limited to ______

A)16
B)32
C)1
D)2

Question 21

Solver Option is available under ____ Ribbon/Menu.

A)developer
B)data
C)insert
D)home

Question 22

Record Macro option is available under ____ Ribbon/Menu.

A)developer
B)data
C)insert
D)home

Question 23

Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?

A)a2
B)a
C)co
D)c

Question 24

Cell A2 contains a text COMPUTER. What will be the answer of =LEFT("A2")?

A)a2
B)a
C)co
D)c

Question 25

Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?

A)a2
B)er
C)co
D)com