Trivia Quiz: Could You Answer These Questions On Microsoft Excel Worksheet?

29 Questions | Total Attempts: 334

SettingsSettingsSettings
Please wait...
Trivia Quiz: Could You Answer These Questions On Microsoft Excel Worksheet?

Could You Answer These Questions On Microsoft Excel Worksheet? There are a lot of people who think they know all there is when it comes to using Microsoft excess, while a very high percentage don’t know how to use most of its features. Which of the two groups do you belong to? Take up this quiz and get to find out!


Questions and Answers
  • 1. 
    The first cell in EXCEL worksheet is labeled as
    • A. 

      AA

    • B. 

      A1

    • C. 

      Aa

    • D. 

      A0

  • 2. 
    What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
    • A. 

      An absolute cell address is created.

    • B. 

      Cell address will change when it is copied to another cell.

    • C. 

      The sheet tab is changed.

    • D. 

      The status bar does not display the cell address.

  • 3. 
    What are the tabs that appear at the bottom of each workbook called?
    • A. 

      Reference tabs

    • B. 

      Position tabs

    • C. 

      Location tabs

    • D. 

      Sheet tabs

  • 4. 
    What is represented by the small, black square in the lower-right corner of an active cell or range?
    • A. 

      Copy handle

    • B. 

      Fill handle

    • C. 

      Insert handle

    • D. 

      Border

  • 5. 
    In Excel, a Data Series is defined as what?
    • A. 

      A type of chart

    • B. 

      A cell reference

    • C. 

      A collection of related data

    • D. 

      A division of results

  • 6. 
    B7:B9 indicates:
    • A. 

      Cells B7 and cell B9 only

    • B. 

      Cells B7 through B9

    • C. 

      Cell B8 only

    • D. 

      None of the above

  • 7. 
    The Cancel and Enter buttons appear in the:
    • A. 

      Title bar

    • B. 

      Formula bar

    • C. 

      Menu bar

    • D. 

      Sheet tabs

  • 8. 
    MS-EXCEL can be used to automate
    • A. 

      Financial statements, Business forecasting

    • B. 

      Transaction registers, inventory control

    • C. 

      Accounts receivable, accounts payable

    • D. 

      Any of the above

  • 9. 
    NOT, AND, OR and XOR are
    • A. 

      Logical Operators

    • B. 

      Arithmetic operators

    • C. 

      Relational operators

    • D. 

      None of the above

  • 10. 
    In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
    • A. 

      Calendar

    • B. 

      Photograph of rainfall

    • C. 

      Chart showing rainfall amounts

    • D. 

      Database of rainfall

  • 11. 
    You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:
    • A. 

      Word processing

    • B. 

      Spreadsheet

    • C. 

      Database

    • D. 

      Graphics

  • 12. 
    You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?
    • A. 

      New

    • B. 

      Save As

    • C. 

      Edit

    • D. 

      Save

  • 13. 
    If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
    • A. 

      Re-format the spreadsheet

    • B. 

      Insert a row

    • C. 

      Increase the column width

    • D. 

      Use the spacebar

  • 14. 
    In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in _____________
    • A. 

      Ascending order

    • B. 

      Descending order

    • C. 

      Alphabetical order

    • D. 

      Random order

  • 15. 
    In order to perform a calculation in a spreadsheet, you need to use a:
    • A. 

      Table

    • B. 

      Formula

    • C. 

      Field

    • D. 

      Variable

  • 16. 
    A fast way to add up this column of numbers is to click in the cell below the numbers and then:
    • A. 

      Click Subtotals on the Data menu.

    • B. 

      View the sum in the formula bar.

    • C. 

      Click the AutoSum button on the Standard toolbar, then press ENTER.

  • 17. 
    Say that you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
    • A. 

      Click the Paste button on the Standard toolbar.

    • B. 

      Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

    • C. 

      Click the arrow on the Paste button on the Standard toolbar, then click Values.

  • 18. 
    How do you change column width to fit the contents?
    • A. 

      Single-click the boundary to the left of 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.

  • 19. 
    There are three worksheets with every new workbook. You can change that automatic number if you want to.
    • A. 

      True

    • B. 

      False

  • 20. 
    ###### means:
    • A. 

      You've entered a number wrong.

    • B. 

      You've misspelled something.

    • C. 

      The cell is not wide enough.

  • 21. 
    To add a new row, click a cell in the row immediately above where you want the new row.
    • A. 

      True

    • B. 

      False

  • 22. 
    Which key do you press to group two or more nonadjacent worksheets?
    • A. 

      CTRL.

    • B. 

      SHIFT

    • C. 

      ALT

  • 23. 
    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
    • A. 

      True

    • B. 

      False

  • 24. 
    A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
    • A. 

      Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

    • B. 

      Right click on the spreadsheet tab and select DELETE

    • C. 

      Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

  • 25. 
    How many sheets are there in a workbook by default?  
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Four

Back to Top Back to top