Excel - Online Assessment

45 Questions | Total Attempts: 57

SettingsSettingsSettings
Excel - Online Assessment

Questions and Answers
  • 1. 
    The symbol for division is...
    • A. 

      $

    • B. 

      \

    • C. 

      *

  • 2. 
    What is a pivot table?
    • A. 

      A report

    • B. 

      An advanced filter

    • C. 

      A filter

    • D. 

      Vlookup

  • 3. 
    An nested if statement only allows for one argument?
    • A. 

      True

    • B. 

      False

  • 4. 
    If the range lookup is false in a vlookup what does it mean?
    • A. 

      The result will return an exact match

    • B. 

      The result will return the nearest match

    • C. 

      It will return a negative

    • D. 

      None of the above

  • 5. 
    By default how many worksheets are in a workbook?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 6. 
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 7. 
    A macro is a part of a conditional format?
    • A. 

      True

    • B. 

      False

  • 8. 
    A template is a worksheet which has all the necessary features you require?
    • A. 

      True

    • B. 

      False

  • 9. 
    What is a scenario?
    • A. 

      Figures which switch between varying amounts

    • B. 

      A conditional format

    • C. 

      A macro

    • D. 

      An IF statement

  • 10. 
    The sumif function has the...... range, criteria, sum_range?
    • A. 

      True

    • B. 

      False

  • 11. 
    A lookup table counts the columns in the Col_index_No and not the cell reference?
    • A. 

      True

    • B. 

      False

  • 12. 
    The feature that enables you to automatically complete a list of 12 months after you key one month is
    • A. 

      Cell style

    • B. 

      Fill handle or Autofill

    • C. 

      Page layout

    • D. 

      Find

    • E. 

      Replace

  • 13. 
    • A. 

      Merge and Center

    • B. 

      Align

    • C. 

      Freeze columns

    • D. 

      Indent

    • E. 

      Split

  • 14. 
    • A. 

      Mixed reference

    • B. 

      Absolute reference

    • C. 

      Relative reference

    • D. 

      Additional reference

    • E. 

      Money reference

  • 15. 
    What type of operation is being preformed in the formula =A4*B5
    • A. 

      Addition

    • B. 

      Subtraction

    • C. 

      Division

    • D. 

      Percentage

    • E. 

      Multiplication

  • 16. 
    Which orientation is taller than it is wide?
    • A. 

      Landscape

    • B. 

      Portrait

  • 17. 
    What term describes a model workbook used as the basis for other workbooks?
    • A. 

      Form

    • B. 

      Demonstration

    • C. 

      Template

    • D. 

      Cell styles

    • E. 

      Page Layout

  • 18. 
    How can you start Edit mode to edit a formula?
    • A. 

      Tools

    • B. 

      Format

    • C. 

      F4

    • D. 

      F2 or double-click cell

    • E. 

      Find and replace

  • 19. 
    Three types of data visualation are:
    • A. 

      Tools, Columns, Styles

    • B. 

      Data bars, Color scales, Icon sets

    • C. 

      Cell styles, Bold, Italics

    • D. 

      Home, Edit, Fill

    • E. 

      Shapes, Arrows, Clip art

  • 20. 
    Name the function that adds cell values only if they meet your criteria.
    • A. 

      Average()

    • B. 

      Count()

    • C. 

      Mean()

    • D. 

      SumIF()

    • E. 

      Round

  • 21. 
    What function would display the highest sales amount in a column?
    • A. 

      Min()

    • B. 

      Avg()

    • C. 

      Max()

    • D. 

      Most()

    • E. 

      Sum()

  • 22. 
    Which logical function shows the opposite of the condition?
    • A. 

      NOT function

    • B. 

      False function

    • C. 

      Nper function

    • D. 

      Sum function

    • E. 

      PMT function

  • 23. 
    What is the term used to describe a function inside a function?
    • A. 

      Conditional

    • B. 

      Argument

    • C. 

      Nested

    • D. 

      Double

    • E. 

      Hyperlink

  • 24. 
    What does a hyperlink do?
    • A. 

      Adds another argument

    • B. 

      Displays a website

    • C. 

      Formats worksheet

    • D. 

      Hides worksheets

  • 25. 
    Which function enters the current date?
    • A. 

      Now()

    • B. 

      Days()

    • C. 

      DDYYMM

    • D. 

      TODAY()