Excel Test Spread Sheeting And Graphing

16 Questions

Settings
Please wait...
Excel Quizzes & Trivia

Spread sheeting and graphing


Questions and Answers
  • 1. 
    When calculating cells what does a colon allow you to do?
    • A. 

      Find the mean median and mode of a series of numbers

    • B. 

      Calculate multiple cells by typing them in

    • C. 

      Calculate multiple cells by highlighting them

    • D. 

      Produce conditional statements like if and or not

  • 2. 
    What is the correct answer given the formula ROUNDUP (A4,3), when A4 is equal to 12.34912?
    • A. 

      12.349

    • B. 

      12.35

    • C. 

      12

    • D. 

      12.348

  • 3. 
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 4. 
    What is the correct answer given the formula MEDIAN(A2-A7) for the following  table.   1 2 3 4 5 6 7 8 9 A 2 5 7 9 13 23 4 16 1    
    • A. 

      9

    • B. 

      10.5

    • C. 

      9.5

    • D. 

      11.5

  • 5. 
    All formulas in Excel must be begin with what symbol  
    • A. 

      =

    • B. 

      SUM

    • C. 

      ,

    • D. 

      (

  • 6. 
    What is the correct formula to solve for the Interest of following graph? A B C D E Year Opening Balance($) Interest Rate (%) Annual investment($) Closing Balance ($) 1 1000.00 6 1000.00 2060  
    • A. 

      =B3*0.06+D3

    • B. 

      =B3*0.06

    • C. 

      =B3*6+D3

    • D. 

      =B3*6

  • 7. 
    The graphing functions in Microsoft Excel can be found in what tab.  
    • A. 

      Graphing

    • B. 

      Insert

    • C. 

      Formulas

    • D. 

      Home

  • 8. 
    When is the best situation to use a pie graph?
    • A. 

      When observing trends in a population

    • B. 

      When observing changes over time

    • C. 

      When comparing one category to the group

    • D. 

      When comparing one category to another

  • 9. 
    The "Formula" in excel is...          
    • A. 

      A tab you see at the bottom of your workbook file.

    • B. 

      A combination of numbers and symbols used to express a calculation.

    • C. 

      To enter text or numbers at the position of the cursor or cell pointer.

    • D. 

      The lines on your worksheet that separate the columns and rows.

    • E. 

      A place in a Microsfoft Excel window where you type information, such as a file name.

  • 10. 
    What is Microsoft Excel?          
    • A. 

      A program that creates and edits newsletters, brochures, flyers, and web sites.

    • B. 

      A program that creates spreadsheets that combines worksheets, graphics, and data management into a single program.

    • C. 

      A program that creates databases and programs to track and manage information.

    • D. 

      A program designed to create notes and presentations.

    • E. 

      A word processing program designed to create letters, documents, or reports.

  • 11. 
    • A. 

      Error

    • B. 

      Number

    • C. 

      Value

    • D. 

      False

    • E. 

      True

  • 12. 
    Based on the graph #1 in the assignments and hand out section of our website, in what year did the CIS girl’s volleyball achieve more wins than the boys?  
    • A. 

      2011

    • B. 

      2009

    • C. 

      2013

    • D. 

      2012

  • 13. 
    Based on the graph #1 in the assignments and hand out section of our website, what two years did the CIS boys volleyball team achieve the same amount of wins?  
    • A. 

      2010 and 2012

    • B. 

      2009 and 2010

    • C. 

      2010 and 2011

    • D. 

      2011 and 2012

  • 14. 
    Explain the difference between AND and OR statements.
  • 15. 
    Explain what recursively means?  Give an example relating to Excel.
  • 16. 
    Why will the following formula not work.   =IF(A1>A2,”true”,Not true) when A1 is equal to 25 000 and A2 is equal to 23000