Computer Science Basic

Microsoft Excel

⛪ Science > Computer Science Basic

Test your knowledge of Microsoft Excel with our comprehensive MCQ questions. Designed specifically for computer science students, our Excel MCQ questions cover key features and functions of the popular spreadsheet software. From creating and editing worksheets to using formulas and functions, our MCQ questions will help you master the basics of Excel. With detailed explanations for each question, you can learn from your mistakes and track your progress as you go. Try our Excel MCQ questions today and see how much you know about this essential computer science tool!

➲ Microsoft Excel - Quiz

Q 1: If you press ___, the cell accepts your typing as its contents ?

  • A Tab
  • B Ctrl+Enter
  • C Enter
  • D Alt+Enter

Q 2: The default style for new data keyed in a new workbook is?

  • A Comma
  • B Normal
  • C Currency
  • D Percent

Q 3: Which of these will not select all the cells in a document?

  • A Using the Edit
  • B Pressing Ctrl + A on the keyboard
  • C Clicking three times with the right mouse button in the spreadsheet
  • D None of above

Q 4: How can we view a cell comment?

  • A Position the mouse pointer over the cell
  • B Click the comment command on the view menu
  • C Click the edit comment commands on the Insert menu
  • D Click the Display comment command on the window menu

Q 5: What term describes explanatory text attached to a cell?

  • A Context
  • B Callout
  • C Comment
  • D Dialog

Q 6: On an excel sheet the active cell in indicated by ?

  • A A dotted border
  • B A dark wide border
  • C A blinking border
  • D By italic text

Q 7: With which of the following all formulas in excel starts?

  • A /
  • B *
  • C $
  • D =

Q 8: Which of the following keyboard shortcut can be used for creating a chart from the selected cells?

  • A F11
  • B F10
  • C F4
  • D F2

Q 9: Formula palette is used to?

  • A format cells containing numbers
  • B create and edit formulas containing functions
  • C entered assumptions data
  • D copy all cells

Q 10: A value used in a formula that does not change is called a?

  • A Constant
  • B Cell address
  • C Varaible
  • D Static

Q 11: A Spreadsheet contains?

  • A columns
  • B rows
  • C rows and columns
  • D None of above

Q 12: To open an existing workbook, click the Open button on the ___ toolbar?

  • A Form
  • B Standard
  • C Drawing
  • D Formatting

Q 13: Which among following is not associated with spelling dialogue box?

  • A Edit
  • B Ignore
  • C Ignore All
  • D Change

Q 14: What term describes a background that appears as a grainy, non-smooth surface?

  • A Pattern
  • B Gradient
  • C Texture
  • D Velvet

Q 15: Macros can be executed from the which of the following menu?

  • A Format
  • B Home
  • C Insert
  • D Tools

Q 16: Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result?

  • A NOT
  • B OR
  • C IF
  • D AND

Q 17: What function displays row data in a column or column data in a row?

  • A Transpose
  • B Index
  • C Rows
  • D Hyperlinks

Q 18: To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

  • A HTML
  • B Pivot Table Field List
  • C Pivot Table Report
  • D Pivot Table List

Q 19: You can convert existing Excel worksheet data and charts to HTML document by using the?

  • A Internet Assistant Wizard
  • B Intranet Wizard
  • C Import Wizard
  • D Export Wizard

Q 20: The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?

  • A C1:10H
  • B C1:H10
  • C C1:H-10
  • D C1:H:10

Q 21: Which among following is associated with excel?

  • A Graphic program
  • B Word Processor
  • C Presentation
  • D Spreadsheet

Q 22: How is data organized in a spreadsheet?

  • A Rows and columns
  • B Layers and planes
  • C Lines and spaces
  • D Height and width

Q 23: Which types of charts can excel produce?

  • A Line graphs and pie charts only
  • B Bar charts, line graphs and pie charts
  • C Bar charts and line graphs only
  • D Only line graphs

Q 24: Which function calculates your monthly mortage payment?

  • A PV
  • B NPER
  • C PMT
  • D All of above

Q 25: How can we set Page Border in Excel?

  • A From Edit menu
  • B From Home
  • C You can not set page border in Excel
  • D From Tools menu

Q 26: You can check the conditions against ____ when applying conditional formatting?

  • A Cell Value
  • B Formula
  • C Both of above
  • D None of above

Q 27: Which of the following is not a valid Zoom percentage in Excel?

  • A 10
  • B 100
  • C 300
  • D 500

Q 28: Protection and the Protect Sheet options can be selected from?

  • A Data
  • B Tools
  • C Edit
  • D Format

Q 29: VLOOKUP function used to?

  • A Finds related records
  • B Looks up text that contain "v"
  • C Check if two cells are identical
  • D None of above

Q 30: Gridlines may be turned off for display but turned on for printing.

  • A True
  • B False
  • C .....
  • D .....

Q 31: How do you change column width to fit the contents?

  • A Single-click the boundary to the left to the column heading
  • B Double click the boundary to the right of the column heading
  • C Press Alt and single click anywhere in the column
  • D All of above

Q 32: To insert three columns between columns A and B you would

  • A Select column A
  • B Select A and B
  • C Select B
  • D All of above

Q 33: To drag a selected range of data to another worksheet in the same workbook, use the ?

  • A Ctrl key
  • B Shift key
  • C Alt key
  • D Tab key

Q 34: You can activate a cell by?

  • A Pressing the Tab key
  • B Clicking the cell
  • C Pressing an arrow key
  • D All of above

Q 35: A function inside another function is known as?

  • A Round function
  • B Sandwich function
  • C Switch function
  • D Nested function

Q 36: What excel feature can you use if you want to work with one record at a time?

  • A Auto Complete
  • B Data Form
  • C Set Form
  • D Auto Text

Q 37: Which function is used for creating a data table?

  • A Sum
  • B Table
  • C Add
  • D Count

Q 38: The accounting style shows negative numbers in?

  • A Bold
  • B Italics
  • C Parentheses
  • D Quotes

Q 39: 3-D reference in a formula?

  • A Spans worksheets
  • B Can not be modified
  • C Only appears on summary worksheets
  • D Limits the formatting options

Q 40: Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  • A True
  • B False

Q 41: Which among following wildcard characters are recognized by excel ?

  • A + and -
  • B ! and ^
  • C * and ?
  • D < and >

Q 42: Which of the following is divide symbol in excel?

  • A /
  • B D
  • C Div
  • D \

Q 43: Shortcut to delete the selected column?

  • A Ctrl + -
  • B Alt + -
  • C Shift + -
  • D Insert + -

Q 44: Which shortcut can be used to Switch between open workbooks?

  • A Ctrl + F2
  • B Ctrl + F6
  • C Ctrl + F8
  • D Ctrl + F10

Q 45: Each excel can contain many sheets including worksheets and chart sheets.

  • A True
  • B False

Q 46: Shortcut to edit the selected cell?

  • A F3
  • B F8
  • C F4
  • D F2

Q 47: What is shortcut to enter current date in cell in excel?

  • A Ctrl + ;
  • B Alt + ;
  • C Shift + &
  • D Ctrl + $

Q 48: Which function converts miles to kilometers ?

  • A Change
  • B Covnert
  • C Shift
  • D Conv

Q 49: Which function in excel counts the numbers of characters in a cell?

  • A LENGHT
  • B LGT
  • C LT
  • D LEN

Q 50: Shortcut to enter current date?

  • A Home + ;
  • B Shift + ;
  • C Alt + ;
  • D Ctrl + ;

Q 51: When the formula bar is activated, you can see

  • A The Edit Formula button
  • B The Cancel button
  • C The Enter button
  • D All of above

Q 52: Style sheet formats can be applied from?

  • A Table >> Autoformat
  • B Format >> Autoformat
  • C Table >> Cells
  • D Fromat >> Cells

Q 53: Which function will you use to enter current time in a woksheet cell?

  • A =time()
  • B =nowtime()
  • C =now()
  • D =currentTime()

Q 54: Merge cells option can be applied from?

  • A Formatting toolbar
  • B Format Cells dialog box Alignment Tab
  • C Both of above
  • D None of above

Q 55: How many recent files you can display on File menu at maximum?

  • A 3
  • B 7
  • C 9
  • D 15

Q 56: The name box appears at the?

  • A left of the formula bar
  • B right of the formula bar
  • C below the status bar
  • D below the menu bar

Q 57: When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors

  • A True
  • B False

Q 58: Which of the following methods cannot be used to edit the content of cell?

  • A Pressing F2
  • B Clicking the formula bar
  • C Pressing the Alt key
  • D Double clicking the cell

Q 59: We can cancel marquee by pressing?

  • A Ctrl + Esc
  • B Alt + Esc
  • C Shift + Esc
  • D Esc

Q 60: What term refers to a specific set of values saved with the workbook?

  • A Range
  • B File set
  • C Data set
  • D Scenario

Q 61: Insert picture option is in which of the following toolbars?

  • A Standard
  • B Formatting
  • C Drawing
  • D Picture

Q 62: Where are the status indicators located?

  • A Horizontal Scroll
  • B Vertical Scroll
  • C Formula bar
  • D Address bar

Q 63: Entire worksheet can not be selected in one time.

  • A True
  • B False
  • C False

Q 64: Which among following can't be considered as worksheet criterion?

  • A Efficiency
  • B Auditability
  • C Clarity
  • D Description

Q 65: When creating a vertical page break?

  • A The active cell must be in row 1
  • B The active cell must be A1
  • C The active cell must be in row 10
  • D The active cell must be in column A

Q 66: The intersection of row and column is called a ?

  • A dataset
  • B cell
  • C data
  • D set

Q 67: You will use which feature in excel, if you want to work with one record at a time?

  • A Auto Complete
  • B Auto Filter
  • C Sub Totals
  • D Data Form

Q 68: Which dialogue box we can use to name a constant?

  • A Create Name
  • B Define Name
  • C Get Name
  • D Create Constant

Q 69: One cell format can be copied to another cell by using?

  • A Format Painter
  • B Format Setting
  • C Format Showing
  • D Format Checking

Q 70: Which among following is types of excel data types?

  • A Numbers, Formulas, Labels
  • B Data, Words, Numbers
  • C Words, Number, Labels
  • D Equations, Data, Numbers

Q 71: To convert a column of data into the row, which command will you choose

  • A Edit -> Paste Special -> Transpose
  • B Cut and Paste
  • C Both of above
  • D None of above

Q 72: In Paste Special dialog box, which of the following option is not available?

  • A Divide
  • B Add
  • C Subtract
  • D Square root

Q 73: When you press Ctrl + X after selecting some cells in Excel, what will happen then

  • A The cell content of selected cells disappear from cell and stored in clipboard
  • B The selected cells are deleted and cells are shifted up
  • C The selected cells are deleted and the cells are shifted left
  • D The cells selected are marked for cutting

Q 74: In Excel Worksheet how can you show or hide the gridlines?

  • A Click Gridline tool on Forms toolbar
  • B Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • C Both of above
  • D None of above

Q 75: Choose from the following, which is not the correct method of editing the cell content?

  • A Press the Alt key
  • B Press the F2 key
  • C Double click the cell
  • D Click the formula bar

Q 76: On Excel screen, Tab scroll buttons are

  • A towards the top left corner
  • B towards the top right corner
  • C towards the bottom right corner
  • D towards the bottom left corner

Q 77: To join some cells and place the content in the middle of the joined cell, which tool you will use?

  • A From Format Cells dialog box choose Merge and Center check box
  • B Click on Merge and Center tool on formatting toolbar
  • C From Format Cells dialog box select the Centered alignment
  • D From Format Cells dialog box click on Merge Cells check box

Q 78: Using Paste Special command which of the following you can paste selectively

  • A Formulas
  • B Validation
  • C Formats
  • D All of above