Microsoft Excel Basic Test Of Knowlege

17 Questions | Total Attempts: 158

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    Each cell in a spreadsheet can be referred to using an address consisting of a column letter and row number.
    • A. 

      True

    • B. 

      False

  • 2. 
    Which of the following is (are) Excel functions?
    • A. 

      MEAN

    • B. 

      AVERAGE

    • C. 

      MEDIAN

  • 3. 
    What would be the result of the following formula? =(5+(3*2))-1
    • A. 

      15

    • B. 

      10

    • C. 

      9

    • D. 

      12

  • 4. 
    _______, ________ and _______ are what you see when you open Excel
    • A. 

      Columns, rows, and charts

    • B. 

      Columns, rows, and formulas

    • C. 

      Columns, rows, and cells

    • D. 

      Non of the above

  • 5. 
    Ribbon is MS Excel is
    • A. 

      Commands organized in small related groups is called Ribbon

    • B. 

      The band at the top of the Excel 2007 window is the Ribbon

    • C. 

      All of the above

    • D. 

      Non of the above

  • 6. 
    When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Four

  • 7. 
    ___________ are where you get down to business and enter data in a worksheet.
    • A. 

      Cells

    • B. 

      Fields

    • C. 

      Tables

    • D. 

      None of the above

  • 8. 
    In a new worksheet, you must start by typing in cell A1.
    • A. 

      True

    • B. 

      False

  • 9. 
    You can use Excel to create budgets, to work with taxes, or to record student grades
    • A. 

      True

    • B. 

      False

  • 10. 
    You can enter two basic kinds of data into worksheet cells:
    • A. 

      Numbers and text

    • B. 

      Numbers and figures

    • C. 

      Text and charts

    • D. 

      None of the above

  • 11. 
    To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text
    • A. 

      True

    • B. 

      False

  • 12. 
    You learned in the practice that ###### means:
    • A. 

      You've entered a number wrong

    • B. 

      You've misspelled something

    • C. 

      The cell is not wide enough

  • 13. 
    What do you type into an empty cell to start a formula?
    • A. 

      An equal sign (=)

    • B. 

      A plus sign (+)

    • C. 

      Number

    • D. 

      Fx

  • 14. 
    A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
    • A. 

      Click in cell C6, and then press CTRL+SHIFT.

    • B. 

      Click in cell C6, and then press CTRL+SHIFT.

    • C. 

      Click in cell C6.

    • D. 

      Non of the above

  • 15. 
    To divide 853 by 16 in a formula in Excel, you would use what math operator?
    • A. 

      +

    • B. 

      =

    • C. 

      %

    • D. 

      /

  • 16. 
    Cell Reference:A10,A20Refer to values in
    • A. 

      The cell in column A and row 10

    • B. 

      Cell A10 and cell A20

    • C. 

      The range of cells in column A and rows 10 through 20

    • D. 

      The range of cells in row 15 and columns B through E

  • 17. 
    A10:A20Refer to values in
    • A. 

      The cell in column A and row 10

    • B. 

      Cell A10 and cell A20

    • C. 

      The range of cells in column A and rows 10 through 20

    • D. 

      The range of cells in row 15 and columns B through E