Simplified guide of MCQs for Exams, Interviews

Sub Topic: Excel

1 .  In Excel which key is used for format number in percentage format?

  • A. Ctrl+Shift+6
  • B. Ctrl+Shift+3
  • C. Ctrl+Shift+5
  • D. Ctrl+1

Correct Answer:

Ctrl+Shift+5


2 .  In Excel which key is used for format number in scientific format?

  • A. Ctrl+Shift+6
  • B. Ctrl+Shift+3
  • C. Ctrl+Shift+5
  • D. Ctrl+Shift+4

Correct Answer:

Ctrl+Shift+6


3 .  In Excel which key is used for format number in time format?

  • A. Ctrl+Shift+6
  • B. Ctrl+Shift+3
  • C. Ctrl+Shift+5
  • D. Ctrl+Shift+2

Correct Answer:

Ctrl+Shift+2


4 .  A Worksheet is made of

  • A. Rows ans Columns
  • B. Rows Only
  • C. Columns only
  • D. none

Correct Answer:

Rows ans Columns


5 .  In Excel worksheet contains columns

  • A. 255
  • B. 256
  • C. 257
  • D. 258

Correct Answer:

256


6 .  You can edit existing Excel data by pressing the:________ key?

  • A. F1 Key
  • B. F2 Key
  • C. F3 Key
  • D. F4 Key

Correct Answer:

F2 Key


7 .  In MS Excel, Conditional Formatting is in ______ tab?

  • A. Home
  • B. View
  • C. Page Layout
  • D. Insert

Correct Answer:

Home


8 .  Excel displays the current cells address in the __________?

  • A. Formula bar
  • B. Status bar
  • C. Name box
  • D. Title bar

Correct Answer:

Name box


9 .  You can set page border in excel from: __________?

  • A. From Border tab in Format Cells dialog box
  • B. From Border tool in Formatting toolbar
  • C. From Line Style tool in Drawing toolbar
  • D. You can not set page border in Excel

Correct Answer:

You can not set page border in Excel