Quiz  /  MS Excel Gate & PSU MCQ Questions With Answers

  • 1. 
    In Excel, the name of the bar where information appears as you input data in called ?

  • File Bar
  • Help Bar
  • Formula Bar
  • Window Bar

  • 2. 
    In a worksheet, the vertical spaces with the headings A, B, C and so on

  • Cell
  • Column
  • Row
  • Data

  • 3. 
    The function that lets you add up a range of cells or values

  • AVERAGE
  • SUM
  • MIN
  • MAX

  • 4. 
    What function was used to find the lowest data ?

  • AVERAGE
  • MIN
  • MAX
  • SUM

  • 5. 
    The function COUNTA is specific for _________________

  • Counting text
  • Counting cells
  • Counting number
  • Counting tables

  • 6. 
    In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on

  • Column
  • Label
  • Row
  • Cell Address

  • 7. 
    Microsoft Excel is categorize as ?

  • Word Processing Software
  • Database Software
  • Spreadsheet Software
  • Presentation Software

  • 8. 
    To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

  • &
  • #
  • =
  • *

  • 9. 
    The function COUNT is specific for _________________

  • Counting cells
  • Counting text
  • Counting number
  • Counting tables

  • 10. 
    What function was used to find the highest data ?

  • AVERAGE
  • MIN
  • SUM
  • MAX
Report Question
warning
access_time
  Time