Intermediate To Advanced Excel

7 Questions | Total Attempts: 2655

SettingsSettingsSettings
Please wait...
Intermediate To Advanced Excel

This is just a little experiment for me to try out the site and for you to check out your Excell skills.


Questions and Answers
  • 1. 
    You can use text in a formula.
    • A. 

      True

    • B. 

      False

  • 2. 
    Conditional formatting allows you to restrict what data the user enters into a cell.
    • A. 

      True

    • B. 

      False

  • 3. 
    How many data series can be used in a pie chart?
    • A. 

      0

    • B. 

      As many as you want.

    • C. 

      1

    • D. 

      7

  • 4. 
    To set up subtotals the data must first be formatted as a table.
    • A. 

      True

    • B. 

      False

  • 5. 
    When creating a chart, you should never include total of the data.
    • A. 

      True

    • B. 

      False

  • 6. 
    When sorting, you must highlight the entire column of the column you wish to sort by.
    • A. 

      True

    • B. 

      False

  • 7. 
    A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.
    • A. 

      True

    • B. 

      False

Back to Top Back to top