Excel - Online Assessment

45 Questions

Settings
Online Assessment Quizzes & Trivia

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

      $

    • B. 

      \

    • C. 

      *

  • 2. 
    • 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. 
    • 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. 
    • A. 

      Addition

    • B. 

      Subtraction

    • C. 

      Division

    • D. 

      Percentage

    • E. 

      Multiplication

  • 16. 
    • A. 

      Landscape

    • B. 

      Portrait

  • 17. 
    • A. 

      Form

    • B. 

      Demonstration

    • C. 

      Template

    • D. 

      Cell styles

    • E. 

      Page Layout

  • 18. 
    • 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. 
    • A. 

      Min()

    • B. 

      Avg()

    • C. 

      Max()

    • D. 

      Most()

    • E. 

      Sum()

  • 22. 
    • 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. 
    • A. 

      Adds another argument

    • B. 

      Displays a website

    • C. 

      Formats worksheet

    • D. 

      Hides worksheets

  • 25. 
    • A. 

      Now()

    • B. 

      Days()

    • C. 

      DDYYMM

    • D. 

      TODAY()

  • 26. 
    • A. 

      Divide days by 365.25

    • B. 

      Multiply days by 360

    • C. 

      Add Number of years

    • D. 

      Format days

  • 27. 
    • A. 

      Formats data

    • B. 

      Indents data

    • C. 

      Adds numbers

    • D. 

      Removes the decimal part of the number

  • 28. 
    • A. 

      A worksheet tab is used to move from one cell to the next cell in a worksheet

    • B. 

      A worksheet tab is used to activate a worksheet by click on its sheet tab found at the bottom of the Worksheet.

    • C. 

      A worksheet tab is used to access tools associated with the worksheet

    • D. 

      A worksheet tab is used to get help when working with Microsoft Excel 2010

  • 29. 
    • A. 

      Formulas tab provides help in writing a formula in Excel Formulas tab automatically checks the formula in your workbook.

    • B. 

      Formulas tab is used for writing the formula for you.

    • C. 

      Formulas tab contains all the formulas supported by Excel

    • D. 

      Formula Tab contains formula related functionalities such as function Library,Formula Auditing, Defining Names and Calculations.

  • 30. 
    • A. 

      =A1-A2

    • B. 

      =B2-B1

    • C. 

      =B1-B2

    • D. 

      None of the above

  • 31. 
    The location of a cell in a worksheet indicated by the column and a row
    • A. 

      Formula

    • B. 

      Operator

    • C. 

      Cell address

  • 32. 
    In the example C5, the "C" represents the cell's
    • A. 

      Column

    • B. 

      Row

    • C. 

      Absolute reference

  • 33. 
    A row is... 
    • A. 

      A vertical range of cells referred to by a number

    • B. 

      A horizontal range of cells referred to by a number

    • C. 

      A vertical range of cells referred to by a letter

  • 34. 
    A sheet tab is located at the bottom of the worksheet window and is used to display the...
    • A. 

      Active cell

    • B. 

      Formula bar

    • C. 

      Worksheet name

  • 35. 
    This is a built-in formula that enables you to perform common calculations in a workbook
    • A. 

      Function

    • B. 

      Value

    • C. 

      Sort

  • 36. 
    All formulas begin with this symbol
    • A. 

      * (asterisk)

    • B. 

      \ (forward slash)

    • C. 

      = (equal sign)

  • 37. 
    In the formula =SUM(A10:A15), which part is the cell reference?
    • A. 

      =

    • B. 

      (A10:A15)

    • C. 

      SUM

  • 38. 
    • A. 

      (D4:D9)

    • B. 

      (D4,D9)

    • C. 

      (D4+D9)

  • 39. 
    If you enter a formula and #### shows in the cell, what does that mean?
    • A. 

      The formula is missing the math operator

    • B. 

      The column width is not wide enough to display the results

    • C. 

      You entered an invalid cell reference

  • 40. 
    If you entered in the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you have to delete the formula and start again.
    • A. 

      True

    • B. 

      False

  • 41. 
    When entering data across a row, you should use the TAB key to move the cursor to the next cell.
    • A. 

      True

    • B. 

      False

  • 42. 
    The only way to view a formula you entered in a cell is to look at the formula bar.
    • A. 

      True

    • B. 

      False

  • 43. 
    To easily add a header or footer to your worksheet you should be in page layout view.
    • A. 

      True

    • B. 

      False

  • 44. 
    In the cell reference $F9, the column is fixed, but the row will change when copied.
    • A. 

      True

    • B. 

      False

  • 45. 
    The shortcut to show formulas in your worksheet is...
    • A. 

      Ctrl + ~

    • B. 

      Ctrl + F5

    • C. 

      Ctrl + $