Hh MS Excel 2007 Knowledge Test

40 Questions | Total Attempts: 111

SettingsSettingsSettings
Please wait...
MS Excel 2007 Quizzes & Trivia

Let's see how well you know Excel. Good luck!


Questions and Answers
  • 1. 
    You'd see three worksheets every time you create a new workbook. You can change that default number if you want to. 
    • A. 

      True that!

    • B. 

      Impossible! That's why it's called a default setting! Duh!

    • C. 

      Err, so what? Does it even matter?

  • 2. 
    The first cell in an Excel worksheet is labeled as:
    • A. 

      A

    • B. 

      1A

    • C. 

      AA

    • D. 

      A1

  • 3. 
    On an Excel spreadsheet, the active cell is indicated by:
    • A. 

      A dotted border

    • B. 

      A bold border

    • C. 

      A blinking border

    • D. 

      A dancing border

  • 4. 
    The name of the active cell appears in the...
    • A. 

      Name Box

    • B. 

      Formula Bar

    • C. 

      Status Bar

    • D. 

      Ribbon

  • 5. 
    By default, pressing ENTER moves your current selection one cell to the right.
    • A. 

      Yep, it sure does!

    • B. 

      No, it does not!

    • C. 

      Um, is it supposed to move?

    • D. 

      I don't know. My Excel is not fast enough to do that.

  • 6. 
    Getting data from a cell located on a different sheet is called...
    • A. 

      Accessing

    • B. 

      Referencing

    • C. 

      Borrowing

    • D. 

      Stealing

  • 7. 
    Formatting only changes the appearance of the data. It does not affect the data itself.
    • A. 

      Wrong! Formatting changes everything!

    • B. 

      Right!

    • C. 

      I don't know what it does...

  • 8. 
    The icon below allows you to change the color of your text. 
    • A. 

      True

    • B. 

      False

    • C. 

      I have never seen that icon before!

  • 9. 
    Which function allows you to copy cell formats from one cell to another?
    • A. 

      Enter

    • B. 

      Format Painter

    • C. 

      Esc

    • D. 

      Paste

  • 10. 
    Excel recognizes similar entries in a column and displays an existing text that matches the characters you type. To accept the suggested entry, press ________.
    • A. 

      ALT

    • B. 

      CTRL + ALT + DEL

    • C. 

      ENTER

    • D. 

      ESC

  • 11. 
    The easiest way to select an entire column is to...
    • A. 

      Click the first cell and drag your selection all the way down to the last cell of the column.

    • B. 

      Double-click any cell in the column.

    • C. 

      Click the column heading.

    • D. 

      Press CTRL + A.

  • 12. 
    All formulas begin with...
    • A. 

      A question mark (?)

    • B. 

      An equal sign (=)

    • C. 

      A forward slash (/)

    • D. 

      A semicolon (;)

  • 13. 
    Characters such as +, -, * and / are examples of...
    • A. 

      Formulas.

    • B. 

      Values.

    • C. 

      Arithmetic operators.

    • D. 

      Symbols with special meanings.

  • 14. 
    You can display all formulas in an active worksheet by pressing...
    • A. 

      ALT + ~

    • B. 

      CTRL + ~

    • C. 

      CTRL + F4

    • D. 

      Nothing... It simply can't be done. Excel always displays cell values and not formulas.

  • 15. 
    What does ###### mean?
    • A. 

      You've misspelled something.

    • B. 

      You've entered the wrong formula.

    • C. 

      The cell is not wide enough.

    • D. 

      A lot of hashtags...

  • 16. 
    What happens when dollar signs ($) are correctly entered in a formula? Check all that apply.
    • A. 

      It locks the cell range.

    • B. 

      An error message will appear.

    • C. 

      The array won't change even if the formula gets dragged or copied to a different cell.

    • D. 

      It changes the number format to currency.

  • 17. 
    If a number with too many decimal places creates a distraction in your report, make your data appear much cleaner by...
    • A. 

      Re-entering the number without the decimals this time.

    • B. 

      Decreasing the font size or the column width.

    • C. 

      Adjusting the number format to display lesser decimal places.

    • D. 

      Deleting the numbers after the decimal point.

  • 18. 
    The Paste Special function allows you to do a lot of things, such as ________________. Check all that apply. 
    • A. 

      Paste values without any formatting

    • B. 

      Paste cell formulas instead of values

    • C. 

      Keep source formatting

    • D. 

      Skip blanks and transpose copied text

  • 19. 
    Conditional Formatting is used to _____________. Choose the best answer.
    • A. 

      Add values together. 

    • B. 

      Change font sizes and colors.

    • C. 

      Highlight cells if conditions are met.

    • D. 

      Make your worksheet look pretty.

  • 20. 
    What is an absolute cell reference?
    • A. 

      A cell reference without any special formatting.

    • B. 

      A fixed cell reference.

    • C. 

      A reference that automatically changes when a formula gets dragged down a column or across a row.

  • 21. 
    Which of the following characters CANNOT be used in an Excel formula?
    • A. 

      An equal sign (=)

    • B. 

      A comma (,)

    • C. 

      An ampersand (&)

    • D. 

      None of the above

  • 22. 
    If your mouse suddenly stopped working and you needed to change the contents of the highlighted cell, which key should you press?
    • A. 

      F1

    • B. 

      F2

    • C. 

      F3

    • D. 

      None. I'd get another mouse!

  • 23. 
    You are editing a worksheet that has been previously saved. If you want to save the edited worksheet without losing the original one, which command in the Office Menu should you click?
    • A. 

      Save

    • B. 

      Save As

    • C. 

      Prepare

    • D. 

      Publish

  • 24. 
    If you wish to show the current date in your worksheet without having to update it every time you access the file, what formula would you use?
    • A. 

      =DATETODAY()

    • B. 

      =TODAY()

    • C. 

      =[systemdate]

    • D. 

      =[datevalue]

  • 25. 
    You can select multiple non-adjacent ranges by holding the __________ while selecting the cells.
    • A. 

      ALT key

    • B. 

      CTRL key

    • C. 

      SHIFT key

    • D. 

      ESC key

Back to Top Back to top