Excel 2 Final

24 Questions | Total Attempts: 364

SettingsSettingsSettings
Please wait...
Excel Quizzes & Trivia

Final of concepts and terms for level 2.


Questions and Answers
  • 1. 
    To arrange rows in alphabetical order based on column A, you need to use the command _____.
    • A. 

      Tools | Sort

    • B. 

      Data | Sort

    • C. 

      Edit | Data | Sort

    • D. 

      None of the above

  • 2. 
    To edit existing data in a cell without having to retype it all, you should _____.
    • A. 

      Double-click the cell

    • B. 

      Click in the Formatting toolbar

    • C. 

      Hold SHIFT down while clicking the cell

    • D. 

      None of the above - you must retype

  • 3. 
    The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is _____.
    • A. 

      (D4+C2)*B2

    • B. 

      D4+C2*B2

    • C. 

      =(D4+C2)*B2

    • D. 

      =(B2*(D4+C2)

  • 4. 
    The default orientation for the printed page is _____.
    • A. 

      Portrait

    • B. 

      Landscape

    • C. 

      Whatever was last used

    • D. 

      Vertical

  • 5. 
    If you select a cell with a date in it and drag the fill handle down across several cells, what happens is that _____.
    • A. 

      The date is copied to each cell

    • B. 

      The date is increased by 1 day into each cell

    • C. 

      The date is increased by 1 week into each cell

    • D. 

      Nothing as AutoFill applies only to numbers

  • 6. 
    To print just part of a sheet, you would select what you want to print and _____
    • A. 

      Click the Print button

    • B. 

      Press the PRINT SCREEN key

    • C. 

      Select Print selection on Page Setup | Sheet and then print

    • D. 

      Select Print selection in the Print dialog and then print

  • 7. 
    To remove the contents of several cells at once, you can _____.
    • A. 

      Select the cells and press DELETE.

    • B. 

      Select the cells and choose Edit | Clear... | Contents

    • C. 

      Select the cells and drag the fill handle back up over them

    • D. 

      All of the above

  • 8. 
    Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are _____.
    • A. 

      8,16,32

    • B. 

      2,4,2

    • C. 

      2,2,2

    • D. 

      6,8,10

  • 9. 
    If a cell shows  ####### , it means that _____.
    • A. 

      Your formula has a syntax error

    • B. 

      The row is too short to show the number at the current font size

    • C. 

      The column is too narrow to show all the digits of the number

    • D. 

      Either a or b

  • 10. 
    The default number of worksheets in an Excel Workbooks is ___?
    • A. 

      There is no default. It has to be set each time Excel is opened.

    • B. 

      3

    • C. 

      255

    • D. 

      1

  • 11. 
    Which of the following is not a valid method for selecting a range of cells?
    • A. 

      Click in the cell to be the upper left corner, press and hold your left mouse button while dragging your mouse to the cell that will be the lower right corner of your range.

    • B. 

      Click in the cell to be the upper left corner, hold your shift key down and then click in the cell that will be the lower right corner of your range.

    • C. 

      Click in the cell to be the upper left corner, hold your shift key down and then use your tab key to move to the cell that will be the lower right corner of your range.

    • D. 

      Click in the cell to be the upper left corner, hold your shift key down and then use your arrow keys to move to the cell that will be the lower right corner of your range.

  • 12. 
    One way to enter data into a cell is by typing into the formula bar and clicking on the check mark button.
    • A. 

      True

    • B. 

      False

  • 13. 
    There are 3 possible cursors when you point to an Excel cell. Which of the following statements is true?
    • A. 

      The white cross is used to select or move a cell or a range of cells.

    • B. 

      The small black crosshair on the lower right corner of a cell can be used to create a series or copy the contents from one cell to another.

    • C. 

      Pointing to a border with the mouse will allow you to enlarge the cell.

    • D. 

      A cell cannot be moved with the mouse.

  • 14. 
    If a cell has the contents, 12032.50 and has been formatted to a currency format with no decimals places, which of the following will appear in the cell?
    • A. 

      12,032

    • B. 

      $12,032

    • C. 

      $12,033

    • D. 

      $12033

  • 15. 
    The only formats you can choose for numbers in a chart are currency, fractions, or percentages.
    • A. 

      True

    • B. 

      False

  • 16. 
    When you use the spellchecker feature, if Excel displays "no suggestion" you don't have to close the spellchecker dialog box in order to correct your entry.
    • A. 

      True

    • B. 

      False

  • 17. 
    When you create a chart on the same sheet as your worksheet it is called:
    • A. 

      An embedded chart

    • B. 

      An exception chart

    • C. 

      A companion chart

    • D. 

      There is no special name

  • 18. 
    You can rename worksheets by either double clicking or right clicking on the tab. When the tab is highlighted, you can retype the new name.
    • A. 

      True

    • B. 

      False

  • 19. 
    In order for filters to work correctly, the data must be Excel list format. The rules that define sorting also define filtering.
    • A. 

      True

    • B. 

      False

  • 20. 
    Which method is the correct one to draw a perfect square after you have chosen the rectangle drawing tool?
    • A. 

      Draw a rectangle and then double clicking the lower right sizing handle.

    • B. 

      Use the ruler on the top and sides as a guide.

    • C. 

      Hold the shift key down while dragging the crosshair with your left mouse button.

    • D. 

      Right click and drag the crosshair into the shape you want.

  • 21. 
    If the dates "07/15/00" and "July 15, 2000" were in cells that are part of formulas, they would be treated exactly the same by Excel because all dates are actually numbers no matter how they are formatted.
    • A. 

      True

    • B. 

      False

  • 22. 
    Which of the following statements about Consolidate is not true?
    • A. 

      Consolidating data enables you to summarize data from several ranges in a single range.

    • B. 

      To consolidate data, you must specify where to place the result (destination) and you must specify the various ranges that will be consolidated (source areas).

    • C. 

      The source for the data must be from the same worksheet or workbook.

    • D. 

      The source for the data must be from the same worksheet or workbook, or can also come from another workbook.

  • 23. 
    The IF function will enable you to perform a calculation if a certain condition is true and to perform a different calculation if that condition is false.
    • A. 

      True

    • B. 

      False

  • 24. 
    In order to customize a toolbar, you must have the Customize dialog box open or attempting to move it will execute the button's functions.
    • A. 

      True

    • B. 

      False

Back to Top Back to top