How Much Do You Know About Excel?

12 Questions | Total Attempts: 546

SettingsSettingsSettings
Please wait...
How Much Do You Know About Excel?

Excel Tips


Questions and Answers
  • 1. 
    What series of keys do you use to see all of your forumlas in a worksheet at once?
    • A. 

      Ctrl+ a

    • B. 

      Shift+F3

    • C. 

      Alt+F8

    • D. 

      Ctrl+~

  • 2. 
    What key Stroke(s) create an excel chart from selected data?
    • A. 

      F10

    • B. 

      F11

    • C. 

      Shift+F10

    • D. 

      Alt+C

  • 3. 
    If you have a file with filtered data and just want to copy selected visible fields, what would you do before pasting?
    • A. 

      Ctrl+G, Special and Select Visible cells only

    • B. 

      F5, Special and Select Visible cells only

    • C. 

      A or B

    • D. 

      None of the above

  • 4. 
    What is the shortcut to add current date in a cell?
    • A. 

      Ctrl +

    • B. 

      Ctrl + D

    • C. 

      Ctrl + :

    • D. 

      Ctrl + ;

  • 5. 
    What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?
    • A. 

      F11

    • B. 

      F5

    • C. 

      F7

    • D. 

      F4

  • 6. 
    What Function key will repeat the last step you did on the current area?
  • 7. 
    If you have cells selected, it is possible to see the sum of the cells in the status bar.
    • A. 

      True

    • B. 

      False

  • 8. 
    How do you copy the cell above without using copy paste or drag and drop?
    • A. 

      Ctrl + C + P

    • B. 

      Ctrl + '

    • C. 

      Alt + P

    • D. 

      None of the above

  • 9. 
    How do you select the column of the cell you are in ?
    • A. 

      Alt + C

    • B. 

      Alt + R

    • C. 

      Ctrl + Spacebar

    • D. 

      Shift + S

  • 10. 
    What 2 Keys do you to get a a second line in a cell?
  • 11. 
    Ctrl + 0 Hides the selected column.
    • A. 

      True

    • B. 

      False

  • 12. 
    What Feature in excel allows you to seperate data in one cell into multiple cells?
Back to Top Back to top