Explore topic-wise MCQs in Bachelor of Commerce (B.Com).

This section includes 61 Mcqs, each offering curated multiple-choice questions to sharpen your Bachelor of Commerce (B.Com) knowledge and support exam preparation. Choose a topic below to get started.

1.

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» C. goal seek
Discussion
2.

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

A. omm
B. mme
C. mm
D. er
Answer» D. er
Discussion
3.

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» D. verus d’sa
Discussion
4.

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

A. 12.00
B. 12
C. 0.5
D. 0.25
Answer» D. 0.25
Discussion
5.

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

A. 1
B. 32
C. 30
D. one
Answer» C. 30
Discussion
6.

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

A. 28
B. 29
C. 30
D. 31
Answer» D. 31
Discussion
7.

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

A. a2
B. a
C. co
D. c
Answer» C. co
Discussion
8.

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

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

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

A. 6:00
B. 6:00 am
C. 18:00
D. 0.75
Answer» E.
Discussion
10.

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

A. 20
B. 2020
C. 1920
D. 2200
Answer» C. 1920
Discussion
11.

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

A. 365
B. 366
C. 360
D. 364
Answer» D. 364
Discussion
12.

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

A. 2020
B. 1920
C. 20
D. 2200
Answer» B. 1920
Discussion
13.

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

A. august
B. aug
C. 8
D. 7
Answer» D. 7
Discussion
14.

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

A. saturday
B. sat
C. 7
D. 6
Answer» D. 6
Discussion
15.

Which of the following function is invalid.

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

With Text Filters _____ operation is not allowed.

A. begins with
B. ends with
C. above average
D. contains
Answer» D. contains
Discussion
17.

With Numeric Filters ______ operation is not allowed.

A. top 10
B. above average
C. greater than
D. begins with
Answer» E.
Discussion
18.

Gridlines are not allowed for ___ type of graphs.

A. bar
B. line
C. column
D. pie
Answer» E.
Discussion
19.

_____ graph allows only one range of values.

A. bar
B. line
C. column
D. pie
Answer» E.
Discussion
20.

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

A. graphs
B. filter
C. scenario
D. solver
Answer» B. filter
Discussion
21.

Excel macros can be edited using _______ editor.

A. visual basic
B. excel
C. c
D. java
Answer» B. excel
Discussion
22.

By default extension for template file is _______

A. .temp
B. .xltx
C. .tem
D. . xlsx
Answer» C. .tem
Discussion
23.

We can add constraints while using __________ command.

A. goal seek
B. solver
C. scenario manager
D. data table
Answer» C. scenario manager
Discussion
24.

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» C. goal seek
Discussion
25.

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» C. 190
Discussion
26.

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

A. omm
B. mme
C. mm
D. er
Answer» D. er
Discussion
27.

Which of the following is an invalid arithmetic operator?

A. +
B. -
C. 
D. ^
Answer» D. ^
Discussion
28.

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» D. verus d’sa
Discussion
29.

Excel formula cannot start with ____

A. +
B. -
C. *
D. =
Answer» D. =
Discussion
30.

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

A. 1932
B. 2032
C. 1990
D. 1900
Answer» E.
Discussion
31.

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

A. 1
B. 2
C. 3
D. 4
Answer» B. 2
Discussion
32.

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

A. 2
B. 3
C. 8
D. 9
Answer» B. 3
Discussion
33.

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

A. mumbai
B. mumbai
C. b1
D. b
Answer» C. b1
Discussion
34.

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

A. 12.00
B. 12
C. 0.5
D. 0.25
Answer» D. 0.25
Discussion
35.

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

A. 1
B. 32
C. 30
D. one
Answer» C. 30
Discussion
36.

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

A. 28
B. 29
C. 30
D. 31
Answer» D. 31
Discussion
37.

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

A. a2
B. er
C. co
D. com
Answer» E.
Discussion
38.

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

A. a2
B. a
C. co
D. c
Answer» C. co
Discussion
39.

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

A. a2
B. a
C. co
D. c
Answer» E.
Discussion
40.

Record Macro option is available under ____ Ribbon/Menu.

A. developer
B. data
C. insert
D. home
Answer» B. data
Discussion
41.

Solver Option is available under ____ Ribbon/Menu.

A. developer
B. data
C. insert
D. home
Answer» C. insert
Discussion
42.

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

A. 16
B. 32
C. 1
D. 2
Answer» D. 2
Discussion
43.

Number of changing cells for a Scenario is limited to ____

A. 16
B. 32
C. 1
D. 2
Answer» C. 1
Discussion
44.

Goal Seek Option is available under ____ Ribbon/Menu.

A. home
B. insert
C. data
D. view
Answer» D. view
Discussion
45.

Charts are available under _______ Ribbon/Menu.

A. home
B. insert
C. data
D. view
Answer» C. data
Discussion
46.

Select odd man out from the following graph types.

A. line
B. bar
C. column
D. pie
Answer» E.
Discussion
47.

Axis Title is not allowed in this type of graphs.

A. line
B. bar
C. column
D. pie
Answer» E.
Discussion
48.

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

A. line
B. bar
C. pie
D. graph
Answer» E.
Discussion
49.

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

A. count( )
B. counta( )
C. sum( )
D. countif( )
Answer» B. counta( )
Discussion
50.

To count non blank cells, we use _____.

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