Excel 2010 For Comp Apps

25 Questions | Total Attempts: 164

SettingsSettingsSettings
Please wait...
Excel 2010 For Comp  Apps

Beginning Excel 2010 Skills


Questions and Answers
  • 1. 
    Is it possible to insert an image from a file into an Excel spreadsheet?
    • A. 

      Yes

    • B. 

      No

  • 2. 
    What name is given to the chart background?
    • A. 

      Chart area

    • B. 

      Background area

    • C. 

      Legend area

    • D. 

      Plot area

  • 3. 
    The Chart Tools commands are found in these three tabs? 
    • A. 

      Design, Shape, Layout

    • B. 

      Layout, Format, Type

    • C. 

      Design, Layout, Format

    • D. 

      Styles, Shapes, Effects

  • 4. 
    What is a worksheet tab in Excel 2010?
    • A. 

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

    • B. 

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

    • C. 

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

    • D. 

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

  • 5. 
    Once data is entered into a cell, can it be edited?
    • A. 

      Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing

    • B. 

      No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet

    • C. 

      No, once a file is saved, cell data cannot be changed

    • D. 

      Yes, but the file must be saved with a different file name

  • 6. 
    Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?  
    • A. 

      #

    • B. 

      %

    • C. 

      &

    • D. 

      $

  • 7. 
    When number signs (#####) are displayed in the cell, it means:  
    • A. 

      The formula in the cell is wrong

    • B. 

      There are too many characters in the cell to be displayed with the current cell width

    • C. 

      The decimal point placement in the cell is wrong

    • D. 

      All of the above

  • 8. 
    According to the picture the selected cell in yellow corresponds to:
    • A. 

      Column A, Row A11, Cell 11

    • B. 

      Column 11, Row A, Cell 11A

    • C. 

      Column 11, Row A, Cell A11

    • D. 

      Column A, Row 11, Cell A11

  • 9. 
    Inserting Page Number is in Header and Footer
    • A. 

      True

    • B. 

      False

  • 10. 
    Which formula can add the all the numeric values in a range of cells?
    • A. 

      Count

    • B. 

      Average

    • C. 

      Sum (Auto-sum)

    • D. 

      Add

  • 11. 
    How do you select cells that are not next to each other? (Ex: As when you are selecting 2 columns of information to graph.)
    • A. 

      Click the first cells, then hold down SHIFT on the keyboard and select the other cells

    • B. 

      Click the first cells, then hold down ALT on the keyboard as you select the other cells

    • C. 

      Click the first cells, hold down CTRL on the keyboard and then select the other cells

    • D. 

      Click the first cells, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard

  • 12. 
    Which function would you use to find the largest number in a selected range of cells?
    • A. 

      MAXIMUM

    • B. 

      MAX

    • C. 

      LARGE

    • D. 

      LARGEST

  • 13. 
     If you wanted to subtract E2 from E1, how would that formula look?
    • A. 

      =E1-E2

    • B. 

      =E2-E1

    • C. 

      E2-E1

    • D. 

      None of the above

  • 14. 
    If you want to remove gridlines from the spreadsheet, which tab would you select?
    • A. 

      File

    • B. 

      Review

    • C. 

      View

    • D. 

      Formulas

  • 15. 
        You would use Excel to:                        
    • A. 

      Make a web page.

    • B. 

      Write a letter

    • C. 

      Create a poster

    • D. 

      Record numerical data

  • 16. 
    Which version of Microsoft Excel are we using in class?
    • A. 

      2007

    • B. 

      2010

    • C. 

      2011

    • D. 

      XP

  • 17. 
    When you filter something in Excel, you are.......
    • A. 

      Sorting it from highest to lowest

    • B. 

      Finding the items that meet the criteria you indicated

    • C. 

      Creating a filtering diagram.

    • D. 

      Removing the items from their original place in the spreadsheet.

  • 18. 
    In Microsoft Excel you produce:
    • A. 

      Spreadsheets and Workbooks

    • B. 

      Documents

    • C. 

      Slide Presentations

    • D. 

      Heart Attacks and Kidney Disease

  • 19. 
    When Sorting in Excel, you need to:
    • A. 

      Go to the Review tab.

    • B. 

      Sort alphabetically first.

    • C. 

      Just sort by the information in 1 columns.

    • D. 

      Highlight all the information in the table of the spreadsheet (except for the total and average rows or columns of information)

  • 20. 
    The correct formula to find the average of cells A4 to C4 is:
    • A. 

      =avg(A4:C4)

    • B. 

      Average(A4:C4)

    • C. 

      =average A4 to C4

    • D. 

      =average(A4:C4)

  • 21. 
    To format the color or border of a cell, or the date or number inside the cell to a certain format, you should:
    • A. 

      Do it in Word.

    • B. 

      Click on the Review tab.

    • C. 

      Right-click in the cell, and select Format Cells.

    • D. 

      Click on the File tab.

  • 22. 
    To insert a picture as the background of a spreadsheet,
    • A. 

      Go to Insert, then Picture.

    • B. 

      Click on the Page Layout tab, then Background.

    • C. 

      Copy and paste the image from the Internet.

    • D. 

      Do a screenshot.

  • 23. 
    The file extension of a Word document is: .doc or .docx. The file extension of an Excel spreadsheet is:
    • A. 

      .cels

    • B. 

      .ppt or .pptx

    • C. 

      .xls or .xlsx

    • D. 

      None of the above

  • 24. 
    Which of the following would Excel be used for in a business:
    • A. 

      Record Income and Expenses

    • B. 

      Track Inventory

    • C. 

      Payroll

    • D. 

      All of the Above

  • 25. 
    Which one of the following best describes the Autofill feature?
    • A. 

      Pressing a button to automatically fill in the missing pieces of an image.

    • B. 

      Isolating certain pieces of information that meet the set requirements.

    • C. 

      Automatically filling the object with color.

    • D. 

      The black cross you get at the bottom right of the cell so you can copy the formula to other cells

Back to Top Back to top