GCC-TBC Computer Typing English 40 OBJECTIVE QUESTION (MS Excel)

                               English 40 Speed (GCC-TBC) 

July 2023 Exam - Selected Question 

MS Excel (25-Question)

1.   Aver() function in MS Excel 2010 will find average of the numbers from given cells ?

 

A.  TRUE

B.   FALSE

 

 

B

 

2.   Which function will add two numbers in cells A1 and A2 in MS Excel 2010?

 

A.  =A1 and A2

B.   =A1 add A2

C.   =sum(A1,A2)

D.  =add(A1,A2)

 

 

C

 

3.   In MS-Excel, sort command has ________ types.

 

A.  3

B.   2

C.   5

D.  7

 

 

A

 

4.   We cannot use ____ in Formula while Typing Formula in cell

 

A.  Special Characters

B.   Characters

C.   Spaces

D.  Numbers

 

 

C

 

5.   Z-A sequence indicates _______ sorting of the text

 

A.  Descending

B.   Ascending

C.   Vertical

D.  Numeric

 

A

 

6.   In MS-Excel Arranging data in specific order is called as ________

 

A.  Data Manipulation

B.   Data Abstraction

C.   Data Certification

D.  Data Sorting

 

 

D

 

7.   Which cell will become active if we press ctrl + home key in MS Excel 2010?

 

A.  a1

B.   b1

C.   c1

D.  d1

 

 

A

 

8.   ............ is Date and Time Function

 

A.  =HOUR()

B.   =AND()

C.   =IF()

D.  =FIND()

 

 

A

 

9.   Sort and Filter Commands in Home Tab are also available in _____Tab

 

A.  View

B.   Data

C.   Page Layout

D.  Insert

 

 

B

 

10.                     The formula bar in MS Excel 2010 shows contents of cell and formula entered in cell.

 

A.  TRUE

B.   FALSE

 

 

A

 

11.                     In MS Excel How to insert Hyperlink

 

A.  Ctrl+L

B.   Ctrl+k

C.   Ctrl+R

D.  Ctrl+1

 

 

B

 

12.                     "Pie" is types of .....................

 

A.  Page

B.   Page Layout

C.   Picture

D.  Chart

 

 

D

 

13.                     __________Function converts the number into nearest integer.

 

A.  Round()

B.   Min()

C.   if()

D.  int()

 

 

D

 

14.                     = SUM(E8:E11) this function rearrange the values in cells range between E8 to E11.

 

A.  TRUE

B.   FALSE

 

 

B

 

15.                     In Excel Vlookup is used to search data by reference vertically

 

A.  TRUE

B.   FALSE

 

 

A

 

16.                     Which is called to square formed by the intersection of rows and columns in MS Excel 2010?

 

A.  cell

B.   column

C.   borders

D.  rows

 

 

A

 

17.                     We can set password for protecting worksheet/workbook.

 

A.  TRUE

B.   FALSE

 

 

A

 

18.                     File in excel 2010 has __________ extension.

 

A.  .doc

B.   .xls

C.   .xlsx

D.  .xlx

 

 

C

 

19.                     In Worksheet 'C' column and Row 7th that particular Cell will be recognized as ____________

 

A.  C7

B.   7c

C.   c*7

D.  c+7

 

 

A

 

20.                     Which function can be used to calculate average in MS Excel 2010?

 

A.  avg()

B.   aver()

C.   percent()

D.  average()

 

 

D

 

21.                     In MS Excel 2010 which group contains the sort & filter, find and select options?

 

A.  Alignment group

B.   font group

C.   cells group

D.  editing group

 

 

D

 

22.                     The checkboxes for which protection is to be given are set to be ________

 

A.  OFF

B.   ON

C.   Group

D.  ungrouped

 

 

B

 

23.                     Row are label as _____________

 

A.  1,2,3,4,...........

B.   I,II,III,............

C.   A,B,C,D,..........

D.  a,b,c,d,.........

 

 

A

 

24.                     Using = Min(B2:b10) Formula, we get the smallest number in Cell B2 to B 10.

 

A.  TRUE

B.   FALSE

 

 

A

 

25.                     With ______Option Current System Date get inserted in cell

 

A.  Date()

B.   Set Date()

C.   Current Date ()

D.  Today()

 

 

D