MS Excel MCQ

Test your knowledge with important MS Excel MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more MS Excel MCQs at Bissoy

• Excel uniquely identifies cells within a worksheet with a cell name
  ক

  Cell names

  খ

  Column numbers and row letters

  গ

  Column letters and row numbers

  ঘ

  Cell locator coordinates
• The auto calculate feature
  ক

  Can only add values in a range of cells

  খ

  Provides a quick way to view the result of an arithmetic operation on a range of cells

  গ

  Automatically creates formulas and adds them to a worksheet

  ঘ

  A and C
• You can use drag-and-drop to embed excel worksheet data in a word document
  ক

  By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

  খ

  By dragging a range of excel data to the word button on the taskbar while pressing Shift key

  গ

  By dragging a range of excel data to the word button on the taskbar while pressing Alt key

  ঘ

  None of above
• Data can be arranged in a worksheet in a easy to understand manner using
  ক

  Auto formatting

  খ

  Applying styles

  গ

  Changing fonts

  ঘ

  all of above
• A numeric value can be treated as a label value if it precedes with
  ক

  Apostrophe (')

  খ

  Exclamation (!)

  গ

  Hash (#)

  ঘ

  Ampersand (&)
• Tab scrolling button
  ক

  Allow you to view a different worksheet

  খ

  Allow you to view additional worksheet rows down

  গ

  Allow you to view additional worksheet columns to the right

  ঘ

  Allow you to view additional sheets tabs
• The Chart wizard term data categories refers to;
  ক

  A chart plot area

  খ

  A horizontal axis

  গ

  The organization of individual values with a chart’s data series

  ঘ

  The data range that supply chart data
• The chart wizard term data series refers to
  ক

  A chart legend

  খ

  A collection of chart data markers

  গ

  A set of values you plot in a chart

  ঘ

  A data label
• Which of the following is not an example of a value?
  ক

  350

  খ

  May 10, 2001

  গ

  0.57

  ঘ

  Serial Number 50771
• A worksheet can have a maximum of ________ number of rows.
  ক

  256

  খ

  1024

  গ

  65535

  ঘ

  1048576
• How many characters can be typed in a single cell in Excel?
  ক

  256

  খ

  1024

  গ

  32767

  ঘ

  65535
• A typical worksheet has ________ number of columns.
  ক

  128

  খ

  256

  গ

  1024

  ঘ

  16384
• Which of the following formulas will Excel not be able to calculate?
  ক

  =SUM(Sales)-A3

  খ

  =SUM(A1:A5)*.5

  গ

  =SUM(A1:A5)/(10-10)

  ঘ

  =SUM(A1:A5)-10
• Which of the following formulas is not entered correctly?
  ক

  =10+50

  খ

  =B7*B1

  গ

  =B7+14

  ঘ

  10+50
• Which symbol must all formula begin with?
  ক

  =

  খ

  +

  গ

  (

  ঘ

  @
• What symbol is used before a number to make it a label?
  ক

  ” ( quote )

  খ

  = ( equal )

  গ

  _ ( underscore )

  ঘ

  ‘ ( apostrophe )
• Which of the following is an absolute cell reference?
  ক

  !A!1

  খ

  $A$1

  গ

  #a#1

  ঘ

  A1
• Which menu option can be used to split windows into two
  ক

  Format > window

  খ

  View > window > split

  গ

  Window > split

  ঘ

  View > split
• The autofill feature
  ক

  Extends a sequential series of data

  খ

  Automatically adds range of cell values

  গ

  Applies a boarder around the selected cells

  ঘ

  All of the above
• When you copy a formula
  ক

  Excel erases the original copy of the formula

  খ

  Excel edits cell references in the newly copied formula

  গ

  Excel adjusts absolute cell references

  ঘ

  Excel doesn’t adjust relative cell references
• Which of the following is the latest version of Excel
  ক

  Excel 2007

  খ

  Excel 2016

  গ

  Excel 365

  ঘ

  Excel XP
• Which of the following is not a worksheet design criterion?
  ক

  Efficiency

  খ

  Aditibility

  গ

  Description

  ঘ

  Clarity
• To delete an embedded objects, first
  ক

  Double click the object

  খ

  Select the object by clicking it

  গ

  Press the Shift + Delete keys

  ঘ

  Select it and then press the delete key
• Files created with Lotus 1-2-3 have an extension
  ক

  DOC

  খ

  XLS

  গ

  123

  ঘ

  WK1
• Documentation should include
  ক

  Destination and users of the output data

  খ

  Source of input data

  গ

  Information on the purpose of the workbook

  ঘ

  All of the above
• Right clicking something in Excel:
  ক

  Deletes the object

  খ

  Nothing the right mouse button is there for left handed people

  গ

  Opens a shortcut menu listing everything you can do to the object

  ঘ

  Selects the object
• How can you delete a record?
  ক

  Delete the column from the worksheet

  খ

  Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

  গ

  Select Data > Delete Record from the menu

  ঘ

  Click the Delete button on the Standard toolbar
• You can use the drag and drop method to
  ক

  Copy cell contents

  খ

  Move cell contents

  গ

  Add cell contents

  ঘ

  A and B both
• Which elements of worksheet can be protected from accidental modification
  ক

  Contents

  খ

  Objects

  গ

  Scenarios

  ঘ

  All of above
• You can select a single range of cells by
  ক

  Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

  খ

  Pressing the Ctrl key while dragging over the desired cells

  গ

  Pressing the Shift key and an arrow key

  ঘ

  Dragging over the desired cells