Quiz  /  MS Excel Class 11 MCQ Questions With Answers

  • 1. 
    Average is an example of a ___________ in excel.

  • Function
  • Formula
  • Word
  • work-out

  • 2. 
    Ms Excel is an example of a _______________ software.

  • Database
  • Web authoring
  • Spreadsheet
  • Desktop Publishing

  • 3. 
    A Vlookup formula does not require one of the following. Which one?

  • Row Number
  • Lookup value
  • Column number
  • Table Array

  • 4. 
    Which of the following is not a conceptual tab relevant to a chart in an Excel worksheet.

  • Design
  • Format
  • Data
  • Layout

  • 5. 
    A single page in Ms. Excel is known as:

  • a workbook
  • a worksheet
  • a cell address
  • a formula

  • 6. 
    The _____________ shows the formula and data of the currently selected cell.

  • Current worksheet
  • Formula Bar
  • Name Box
  • Range of cells

  • 7. 
    Formulas in Excel always begin with a/an ___________________

  • +
  • =
  • :
  • /

  • 8. 
    When your cell is not wide enough for the result of a formula, one of the following options appear. Which one?

  • N/A
  • ########
  • ++++++++
  • Error

  • 9. 
    The correct IF statement for cell B2 if pass mark is 50 will be?

  • =if(B2>=50, "fail", "pass")
  • =if(B2>=50, "pass, fail")
  • =if(B2<=50, "pass", "fail")
  • =if(B2>=50, "pass", "fail")
Report Question
warning
access_time
  Time