Yaahub - Ms- Excel Quiz

22 Questions

Settings
Please wait...
Yaahub - Ms- Excel Quiz

.


Questions and Answers
  • 1. 
    A function must always start with
    • A. 

      =sumif

    • B. 

      =sum

    • C. 

      =

    • D. 

      =sumif(

  • 2. 
    Common Functions that we use most often are
    • A. 

      =Sum

    • B. 

      =Average

    • C. 

      =Min

    • D. 

      =Max

    • E. 

      All of the above

  • 3. 
    Excel aloows you to create ____________________________ that refer to column and row labels in place of the cell reference or range.
    • A. 

      Comments

    • B. 

      Natural Language Formulas

    • C. 

      Arguments

    • D. 

      Functions

  • 4. 
    A ________triangle appears in the upper-right corner of any cell with an attached __________________.
    • A. 

      Green triangle, note

    • B. 

      Red triangle, comment

    • C. 

      Green triangle, comment

    • D. 

      Red triangle, note

  • 5. 
    A block of cells in an Excel worksheet
    • A. 

      Area

    • B. 

      Range

    • C. 

      Cell

    • D. 

      Active cell

  • 6. 
    A range of cells can be __________________or ____________________.
    • A. 

      Connected, nonconnected

    • B. 

      Adjancent,non adjancent

    • C. 

      Contiguous, noncontiguous

  • 7. 
    Worksheets that are selected as a unit; any action performed on this uit will affect all the worksheets in the group.
    • A. 

      Active

    • B. 

      Grouping

    • C. 

      Attached

  • 8. 
    A Range name may use up to ________ characters.
    • A. 

      355

    • B. 

      155

    • C. 

      255

    • D. 

      555

  • 9. 
    The format for an IF statement is:
    • A. 

      =SUM(condition,x,y)

    • B. 

      =IF(condition,x,y)

    • C. 

      =(condition,x,y)

  • 10. 
    Correct format for a SUMIF statement is
    • A. 

      =SUMIF(range, critera,sum_range)

    • B. 

      =SUMIF(range,sum_range,critera)

    • C. 

      =SUMIF(sum_range,critera,range)

  • 11. 
    A graphic that allows you to compare and contrast data in a visual format.
    • A. 

      Plot

    • B. 

      Legend

    • C. 

      Chart

  • 12. 
    A chart plaed as an object within a worksheet
    • A. 

      Chart sheets

    • B. 

      Embedded chart

    • C. 

      Categories

  • 13. 
    All charts use axes except
    • A. 

      Bar

    • B. 

      Line

    • C. 

      Plot

    • D. 

      Pie

  • 14. 
    A chart actually has two backfrounds: the larger _______ _______ and the smaller ______ ______ which can be formmatted.
    • A. 

      Tick mark, background

    • B. 

      Chart area, plot area

    • C. 

      Data axis, value axis

  • 15. 
    A chart that occupies its own worksheet
    • A. 

      Embedded chart

    • B. 

      Chart sheet

    • C. 

      Stand alone chart

  • 16. 
    A key that identifies each of the data series in a chart.
    • A. 

      Key

    • B. 

      Map

    • C. 

      Legend

  • 17. 
    Name the three parts that are typically found in a chart.
    • A. 

      Data series, Series labels and Catefory labels

    • B. 

      Name box, value labels, name labels

    • C. 

      X axis, y axis, z axis

  • 18. 
    Name two of the several ways to enhance a Chart Background
    • A. 

      Delete table

    • B. 

      I D K

    • C. 

      Ask my buddy

  • 19. 
    A ______________ends the argument.
    • A. 

      Quotation mark

    • B. 

      Closed parenthesis

    • C. 

      Comma

    • D. 

      Period

  • 20. 
    Name three rules for naming ranges
    • A. 

      Spaces are allowed, can start with a range name, Y2008

    • B. 

      Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes

    • C. 

      Must make sense, can start with a number, spaces are allowed

  • 21. 
    To display a comment in a worksheet
    • A. 

      Roll mouse over red triangle

    • B. 

      Open comment cell

    • C. 

      Must highlight cell

  • 22. 
    When you use "Natural Language" in a formula the name must be spelled exactly as the oolumn or row label.
    • A. 

      NO

    • B. 

      YES