View MCQ Question

(Q) How many sheets are there in Excel Workbook by default?

  1. 4
  2. 3
  3. 6
  4. 7

Ans : 3

(Q) By default column width of Excel

  1. 9.43
  2. 8.43
  3. 5.34
  4. 7.34

Ans : 8.43

(Q) Excel files have a default extension of

  1. Xls
  2. Xlw
  3. Wkl
  4. 123

Ans : Xls

(Q) The number of columns in a worksheet is

  1. 36500
  2. 16384
  3. 256
  4. 64536

Ans : 16384

(Q) How many characters can be typed in a single cell in Excel?

  1. 1024
  2. 32000
  3. 256
  4. 65535

Ans : 65535

(Q) In Microsoft Office 2007 version, an Excel sheet contain ________ no of rows.

  1. 65565
  2. 255
  3. undetermined
  4. 1048576

Ans : 1048576

(Q) By Formatting a cell in Currency format, you can specify?

  1. Currency Symbol
  2. Decimal Places
  3. Both 1 and 2 Options
  4. None of above

Ans : Both 1 and 2 Options

(Q) The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is..

  1. G1-G10
  2. B1.G10
  3. B1.G10
  4. B1:G10

Ans : B1:G10

(Q) You can open the Sort dialog box by choosing Sort from the .......... menu

  1. View
  2. Format
  3. Tools
  4. Data

Ans : Data

(Q) A Worksheet Range is a

  1. A Group of Worksheets
  2. Command used for Data Modeling
  3. A Group of Cells
  4. A Range of Values such as from 23 to 234

Ans : A Group of Cells

(Q) Which of the following is an absolute cell reference?

  1. !A!1
  2. $A$1
  3. #a#1
  4. A1

Ans : $A$1

(Q) Which Chart can be created in Excel?

  1. Area
  2. Line
  3. Pie
  4. All of 1,2 and 3 Options

Ans : All of 1,2 and 3 Options

(Q) How do you change column width to fit the contents?

  1. Single-click the boundary to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in column
  4. All of above

Ans : Double click the boundary to the right of the column heading

(Q) How should you print a selected area of a worksheet, if you'll want to print a different area next time?

  1. On the file menu, point to print area, and then click set print area.
  2. On the file menu, click print, and then click selection under print what
  3. On the view menu, click custom views, then click add
  4. All of above

Ans : On the file menu, click print, and then click selection under print what

(Q) What does SUMIF function do?

  1. Adds up cell values based on a condition
  2. Adds all the numbers in a range of cells
  3. Returns a subtotal in a list or database
  4. All of above

Ans : Adds up cell values based on a condition

(Q) Extension of Excel 2007 file

  1. .exl
  2. .xlsx
  3. .xls
  4. All of the above

Ans : .xlsx

(Q) A quick way to return to a specific area of a worksheet is to type in the _____.

  1. Zoom Box
  2. Formula Bar
  3. Name Box
  4. All of these

Ans : Name Box

(Q) What key is used to select multiple ranges of cells?

  1. Shift
  2. Ctrl
  3. Alt
  4. AltCar or AltGr

Ans : Ctrl

(Q) Worksheet can be renamed by

  1. Click on Worksheet tab by Holding CTRL Key and type new name
  2. Double Click on the Worksheet tab and type new name
  3. Worksheet cannot renamed
  4. At The Time

Ans : Double Click on the Worksheet tab and type new name

(Q) Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

  1. data sheet
  2. work sheet
  3. module sheet
  4. chart sheet

Ans : chart sheet

(Q) Which of the following is not the correct method of editing the cell content?

  1. Press the Alt key
  2. Double click the cell
  3. Press the F2 key
  4. Click the formula bar

Ans : Press the Alt key

(Q) What is the shortcut key to hide entire row?

  1. CTRL + H
  2. CTRL + R
  3. CTRL + 9
  4. CTRL + D

Ans : CTRL + 9

(Q) What is the short cut key to replace a data with another in sheet?

  1. Ctrl + R
  2. Ctrl +Shift+R
  3. Ctrl + H
  4. Ctrl + F

Ans : Ctrl + F

(Q) To move to the previous worksheet press

  1. Shift + Tab
  2. Ctrl + Pgdown
  3. Ctrl + PgUp
  4. ctrl + Tab

Ans : Ctrl + PgUp

(Q) Pivot table comes in _____ Tab

  1. Home
  2. Page Layout
  3. Insert
  4. Data

Ans : Insert

(Q) Month Function is used to

  1. pick up the month from a date
  2. create a date
  3. pick up the minute from a date
  4. display current month

Ans : pick up the month from a date

(Q) Red triangle at the top right corner of cell indicates

  1. comment
  2. syntax
  3. text in cell is red
  4. error entry

Ans : comment

(Q) If we want to fix a cell address, one should press

  1. F5
  2. F6
  3. F4
  4. F3

Ans : F4

(Q) MAX Function is used for

  1. Find the maximum value from a number series
  2. Find the minimum value from a number series
  3. add numbers
  4. for calculate average

Ans : Find the maximum value from a number series

(Q) Excel probably considers the cell entry January 1, 2000 to be a

  1. Text string
  2. Value
  3. Label
  4. Formula

Ans : Value