MS Excel 2007 - Pretest

25 Questions | Total Attempts: 223

SettingsSettingsSettings
Please wait...
MS Excel 2007 - Pretest

This is a pre-requisite to the MS Excel Intermediate Course training. You can have EXCEL open while taking this pretest


Questions and Answers
  • 1. 
    Your name
  • 2. 
    A cell is a
    • A. 

      Verticle space that goes up and down

    • B. 

      Horizontal space going across

    • C. 

      Grid made of columns and rows

    • D. 

      Area where columns and rows intersect

  • 3. 
    A row is 
    • A. 

      Horizontal and designated by a letter

    • B. 

      Horizontal and designated by a number

    • C. 

      Vertical and designated by a number

    • D. 

      Vertical and designated by a letter

  • 4. 
    A column is 
    • A. 

      Horizontal and designated by a number

    • B. 

      Horizontal and designated by a letter

    • C. 

      Vertical and designated by a letter

    • D. 

      Vertical and designated by a number

  • 5. 
    A formula in the spreadsheet should always start with
    • A. 

      &

    • B. 

      [

    • C. 

      =

    • D. 

      +

  • 6. 
    In a spreadsheet formula which symbol is used to divide?
    • A. 

      =

    • B. 

      ^

    • C. 

      \

    • D. 

      /

  • 7. 
    In a spreadsheet formula which symbol is used to multiply ?
    • A. 

      @

    • B. 

      X

    • C. 

      *

    • D. 

      &

  • 8. 
    I want to add cells value from C5 to C70, and show output of this addition in cell A3.Which formula should I use?
    • A. 

      Write in Cell A3, =SUM(C5:C70)

    • B. 

      Write in Cell A3, C5+C6+C7+C8+C9.....

    • C. 

      Write in Cell A3, =Add C5:C70

    • D. 

      Write in Cell A3, =add C5 to C70

  • 9. 
    Which of these would add up the numbers from A3 to A6 
    • A. 

      =+(A3:A6)

    • B. 

      =(A3:A6)

    • C. 

      =Sum(a3+a6)

    • D. 

      =Sum(A3:A6)

  • 10. 
    Which shortcut could you use to save a workbook under a different name (save as)?
    • A. 

      F2

    • B. 

      F12

    • C. 

      Ctrl+S

    • D. 

      Shift+S

  • 11. 
    Which shortcut could you use to repeat the last formatting action you performed in a worksheet?
    • A. 

      F1

    • B. 

      F4

    • C. 

      F9

    • D. 

      F12

  • 12. 
    Can’t find a number or word in Excel?  Use the Find box to help you.  Which of the following is the shortcut for launching the Find Dialogue box?
    • A. 

      Ctrl+H

    • B. 

      Ctrl+G

    • C. 

      Ctrl+F

    • D. 

      Ctrl+A

  • 13. 
    What happens when you press Ctrl+9 when a row is selected?
    • A. 

      This inserts a new row above the selected row

    • B. 

      This deletes the row

    • C. 

      This hides the selected row(s)

    • D. 

      This copies the content of the selected row to the clipboard

  • 14. 
    Which shortcut can you use to quickly sum the values of cells using the AutoSum function? 
    • A. 

      Ctrl+S

    • B. 

      Shift+A

    • C. 

      Alt+=

    • D. 

      Shift+S+=

  • 15. 
    Let’s face it, the Ribbon can get in the way but when it’s gone, we miss it.  Which shortcut can you use to hide and display the Ribbon?
    • A. 

      Ctrl+F1

    • B. 

      Ctrl+H

    • C. 

      Ctrl+Shift+R

    • D. 

      Ctrl+R

  • 16. 
    To quickly move back to the first cell of your worksheet (usually A1), which shortcut combination would you use?
    • A. 

      Ctrl+Space

    • B. 

      Ctrl+Home

    • C. 

      Ctrl+Page Up

    • D. 

      Ctrl+Up Arrow Key

  • 17. 
    If you quickly want to undo or redo an action in Excel, which shortcut keys would you use? 
    • A. 

      Ctrl+u and Ctrl+r

    • B. 

      Ctrl+z and Ctrl+y

    • C. 

      Ctrl+un and Ctrl+re

    • D. 

      All of the above shortcut keys will work.

  • 18. 
    If you wanted to reformat your entire worksheet, for example to change the font, which shortcut key combination could you use to quickly select the whole worksheet?
    • A. 

      Ctrl+Alt+Delete

    • B. 

      Ctrl+a

    • C. 

      Shift+a

    • D. 

      Alt+a

  • 19. 
    Which shortcut key combination allows you to quickly select multiple adjacent groups of cells?  
    • A. 

      Alt+Arrow Keys

    • B. 

      Ctrl+a

    • C. 

      Ctrl+Shift+Arrow Keys

    • D. 

      Ctrl+Arrow Keys

  • 20. 
    What is the keyboard shortcut to select a row of active cells?
    • A. 

      Ctrl + Spacebar

    • B. 

      Ctrl + End

    • C. 

      Shift + End

    • D. 

      Shift + Spacebar

  • 21. 
    Which shortcut key combination can be used to insert the current date into a cell?
    • A. 

      Ctrl+D

    • B. 

      Ctrl+; (semicolon)

    • C. 

      Ctrl+Shift+; (semicolon)

    • D. 

      Ctrl+Shift+D

  • 22. 
    What does the shortcut Ctrl+d achieve?
    • A. 

      It formats the selected cell.

    • B. 

      It repeats the last action (redo).

    • C. 

      It inserts the current date.

    • D. 

      It creates a copy of the cell contents from the above

  • 23. 
    To quickly repeat your last number formatting action to a selected cell or cells, you could use which of the following shortcut key combinations?
    • A. 

      Select the cell or cells to repeat the formatting on and press Ctrl+Shift+v

    • B. 

      Select the cell or cells to repeat the formatting on and press Ctrl+Shift+r

    • C. 

      Select the cell or cells to repeat the formatting on and press Ctrl+Shift+F4

    • D. 

      Select the cell or cells to repeat the formatting on and press F4

  • 24. 
    To ensure a cell reference becomes absolute and does not change when more rows or columns are added or if the cell containing the referenced value is moved, you need to: 
    • A. 

      Type the cell reference and press Ctrl+Shift+F4 to make the reference absolute.

    • B. 

      Type the cell reference and press Ctrl+a to make the reference absolute.

    • C. 

      Type the cell reference and press Ctrl+Shift+Enter to make the reference absolute.

    • D. 

      Type the cell reference and press F4 to make the reference absolute.

  • 25. 
    What will happen to all your worksheets in your current open workbook when you press F9?
    • A. 

      The workbook will automatically be saved.

    • B. 

      All formulas will automatically be calculated.

    • C. 

      All cell references will become absolute.

    • D. 

      None of the above options are correct.