Edu 7266 Excel Review

16 Questions | Total Attempts: 42

SettingsSettingsSettings
Please wait...
Edu 7266 Excel Review

With the whole Microsoft office package, Microsoft Excel, otherwise known as excel spreadsheets is one of the hardest concepts to immediately understand. Edu 7266 Excel Review helps in its mastery. Enjoy the quiz and all the best.


Questions and Answers
  • 1. 
    Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
    • A. 

      Yes

    • B. 

      No

  • 2. 
    On an Excel sheet the active cell is indicated by ____.
    • A. 

      A dark wide border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      None of the above

  • 3. 
    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
  • 4. 
    What's a quick way to extend these numbers to a longer sequence, for instance 23 through 40?
    • A. 

      Select the last two cells and drag the fill handle over the range you want, for instance 18 more rows.

    • B. 

      Select the range you want, including the three cells, point to Fill on the Edit menu, and then click Down.

    • C. 

      Copy the third cell, click in the cell below it, on the Standard toolbar click the down arrow on the paste button, and select Paste Special

  • 5. 
    You have a list containing all the employees in your organization.  You elect the AutoFilter command, and then select New York from the location field.  What is the result?
    • A. 

      The list is sorted by city, with New York first.

    • B. 

      The rows where the location is New York are written to another worksheet.

    • C. 

      The rows where the location is not New York are deleted.

    • D. 

      The rows where the location is not New York are hidden.

  • 6. 
    What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?
    • A. 

      F11

    • B. 

      F5

    • C. 

      F7

    • D. 

      F4

  • 7. 
    If you have cells selected, it is possible to see the sum of the cells in the status bar.
    • A. 

      True

    • B. 

      False

  • 8. 
    In Excel, what does the $ do?
    • A. 

      It turns numbers into currency,

    • B. 

      It locks the cell reference in a function.

    • C. 

      It does nothing.

    • D. 

      It creates a dollar sign.

  • 9. 
    True False: The following is an example of a function: =sum(A1+A2+A3)/3
    • A. 

      True

    • B. 

      False

  • 10. 
    True False: The following illustrates the dynamic capability of a spreadsheet: =(A1+A2+A3+A4+A5)*3 
    • A. 

      True

    • B. 

      False

  • 11. 
    True False: =SUM(B2:D2) derives the same value as =(B2+C2+D2)
    • A. 

      True

    • B. 

      False

  • 12. 
    When an equals (=) sign precedes information entered into a spreadsheet cell, it means which of the following:
    • A. 

      Equals (=) sign indicates that a formula is being entered.

    • B. 

      Equals (=) sign indicates that two values are of equal quantity.

    • C. 

      Equals (=) sign indicates that the cell content are equal to a specified value.

    • D. 

      Equals (=) specify the end of a formula entry and the beginning of a data entry.

  • 13. 
    What is the most optimally formed formula?
    • A. 

      =SUM(B2:B10)/8

    • B. 

      = (8+5+3+2+8)/5

    • C. 

      =SUM(B2:B10)/B1

    • D. 

      =SUM(B2:B10)/B1

  • 14. 
    You are interested in determining if cell N5 contains a number that exceeds 89 and if it does, then cell A5 present the feedback,  “Excellent work!” If N5 is 89 or less, then cell A5 presents “Keep trying!” Select the formula that should be entered in cell A5 to achieve this result.
    • A. 

      =IF(N5>89, “Keep trying!”, “Excellent work!”)

    • B. 

      =IF(N5>89, “Excellent work!”, “Keep trying!”)

    • C. 

      =IF(A5

    • D. 

      =IF N5>89, “Excellent work!”, A5, “Keep Trying!”

  • 15. 
    In order to multiply items in Excel you would use:
    • A. 

      ^

    • B. 

      @

    • C. 

      *

    • D. 

      #

  • 16. 
    My name is    __________________________________
Back to Top Back to top