Simplified guide of MCQs for Exams, Interviews

Sub Topic: Excel

1 .  The Greater Than sign (>) is an example of _____ operator.

  • A. Arithmatic
  • B. Logical
  • C. Greater
  • D. Conditional

Correct Answer:

Logical


2 .  The process of arrenging the items of a column in some sequence or order is known as :

  • A. Autofill
  • B. Filtering
  • C. Arrengin
  • D. Sorting

Correct Answer:

Sorting


3 .  The ____ feature of MS Excel quickly completes a series of data

  • A. Auto Complete
  • B. Auto Fill
  • C. Fill Handle
  • D. Sorting

Correct Answer:

Auto Fill


4 .  In Excel, Rows are labelled as ______

  • A. A, B, C, etc
  • B. 1,2,3 etc
  • C. A1, A2, etc.
  • D. $A$1, $A$2, etc.

Correct Answer:

1,2,3 etc


5 .  The basic unit of a worksheet into which you enter data in Excel is called a

  • A. cell
  • B. table
  • C. column
  • D. box

Correct Answer:

cell


6 .  The basic unit of a worksheet into which you enter data in Excel is called a

  • A. cell
  • B. table
  • C. column
  • D. box

Correct Answer:

cell


7 .  How many sheets are there, by default, when we create a new Excel file ?

  • A. 2
  • B. 3
  • C. 4
  • D. 5

Correct Answer:

3


8 .  How many sheets are there, by default, when we create a new Excel file ?

  • A. 2
  • B. 3
  • C. 4
  • D. 5

Correct Answer:

3


9 .  In Excel, which one denoted a range from B1 through E5

  • A. B1 - E5
  • B. B1:E5
  • C. B1 to E5
  • D. B1$E5

Correct Answer:

B1:E5


10 .  An Excel file is generally called a / an

  • A. E-Spreadsheet
  • B. Woorksheet
  • C. Workbook
  • D. Sheet

Correct Answer:

Workbook