Excel Solved MCQs

Take a Test Download as PDF
1.

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

A. saturday
B. sat
C. 7
D. 6
Answer» C. 7
discuss
2.

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

A. august
B. aug
C. 8
D. 7
Answer» C. 8
discuss
3.

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

A. 2020
B. 1920
C. 20
D. 2200
Answer» A. 2020
discuss
4.

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

A. 365
B. 366
C. 360
D. 364
Answer» C. 360
discuss
5.

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

A. 20
B. 2020
C. 1920
D. 2200
Answer» B. 2020
discuss
6.

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

A. 6:00
B. 6:00 am
C. 18:00
D. 0.75
Answer» D. 0.75
discuss
7.

TODAY( ) returns current ______

A. date
B. time
C. day
D. date & time
Answer» A. date
discuss
8.

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

A. 365
B. 366
C. 360
D. -360
Answer» D. -360
discuss
9.

To convert uppercase alphabets to lowercase we use _____

A. lcase( )
B. lower( )
C. upper( )
D. ucase( )
Answer» B. lower( )
discuss
10.

To find number of characters in a string we use _____

A. count( )
B. len( )
C. length( )
D. sum( )
Answer» B. len( )
discuss
11.

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

A. vllokup( )
B. hlookup( )
C. search( )
D. locate( )
Answer» B. hlookup( )
discuss
12.

To count non blank cells, we use _____.

A. count( )
B. counta( )
C. countblank( )
D. countnonblank( )
Answer» B. counta( )
discuss
13.

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

A. count( )
B. counta( )
C. sum( )
D. countif( )
Answer» A. count( )
discuss
14.

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

A. line
B. bar
C. pie
D. graph
Answer» D. graph
discuss
15.

Axis Title is not allowed in this type of graphs.

A. line
B. bar
C. column
D. pie
Answer» D. pie
discuss
16.

Select odd man out from the following graph types.

A. line
B. bar
C. column
D. pie
Answer» D. pie
discuss
17.

Charts are available under _______ Ribbon/Menu.

A. home
B. insert
C. data
D. view
Answer» B. insert
discuss
18.

Goal Seek Option is available under ____ Ribbon/Menu.

A. home
B. insert
C. data
D. view
Answer» C. data
discuss
19.

Number of changing cells for a Scenario is limited to ____

A. 16
B. 32
C. 1
D. 2
Answer» B. 32
discuss
20.

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

A. 16
B. 32
C. 1
D. 2
Answer» C. 1
discuss
21.

Solver Option is available under ____ Ribbon/Menu.

A. developer
B. data
C. insert
D. home
Answer» B. data
discuss
22.

Record Macro option is available under ____ Ribbon/Menu.

A. developer
B. data
C. insert
D. home
Answer» A. developer
discuss
23.

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

A. a2
B. a
C. co
D. c
Answer» D. c
discuss
24.

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

A. a2
B. a
C. co
D. c
Answer» B. a
discuss
25.

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

A. a2
B. er
C. co
D. com
Answer» D. com
discuss
26.

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

A. 28
B. 29
C. 30
D. 31
Answer» C. 30
discuss
27.

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

A. 1
B. 32
C. 30
D. one
Answer» B. 32
discuss
28.

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

A. 12.00
B. 12
C. 0.5
D. 0.25
Answer» C. 0.5
discuss
29.

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

A. 2
B. 3
C. 8
D. 9
Answer» A. 2
discuss
30.

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

A. 1
B. 2
C. 3
D. 4
Answer» A. 1
discuss
31.

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

A. 1932
B. 2032
C. 1990
D. 1900
Answer» D. 1900
discuss
32.

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

A. mumbai
B. mumbai
C. b1
D. b
Answer» B. mumbai
discuss
33.

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
Answer» C. verus d’sa
discuss
34.

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

A. omm
B. mme
C. mm
D. er
Answer» C. mm
discuss
35.

Excel formula cannot start with ____

A. +
B. -
C. *
D. =
Answer» C. *
discuss
36.

Which of the following is an invalid arithmetic operator?

A. +
B. -
C.
D. ^
Answer» C. 
discuss
37.

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
Answer» B. 110
discuss
38.

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
Answer» B. filter
discuss
39.

We can add constraints while using __________ command.

A. goal seek
B. solver
C. scenario manager
D. data table
Answer» B. solver
discuss
40.

By default extension for template file is _______

A. .temp
B. .xltx
C. .tem
D. . xlsx
Answer» B. .xltx
discuss
41.

Excel macros can be edited using _______ editor.

A. visual basic
B. excel
C. c
D. java
Answer» A. visual basic
discuss
42.

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

A. graphs
B. filter
C. scenario
D. solver
Answer» A. graphs
discuss
43.

_____ graph allows only one range of values.

A. bar
B. line
C. column
D. pie
Answer» D. pie
discuss
44.

Gridlines are not allowed for ___ type of graphs.

A. bar
B. line
C. column
D. pie
Answer» D. pie
discuss
45.

With Numeric Filters ______ operation is not allowed.

A. top 10
B. above average
C. greater than
D. begins with
Answer» D. begins with
discuss
46.

With Text Filters _____ operation is not allowed.

A. begins with
B. ends with
C. above average
D. contains
Answer» C. above average
discuss
47.

Which of the following function is invalid.

A. sumif( )
B. avgif( )
C. countif( )
D. if( )
Answer» B. avgif( )
discuss

Done Reading?

Take a Test Download as PDF
Tags
Question and answers in Excel, Excel multiple choice questions and answers, Excel Important MCQs, Solved MCQs for Excel, Excel MCQs with answers PDF download