OCP A - Computer Applications 1 - Excel 2007

49 Questions | Total Attempts: 57

SettingsSettingsSettings
OCP A - Computer Applications 1 - Excel 2007 - Quiz

Directions: Please read and answer each question. This 49-question test is timed, allowing you a total of 55 minutes to complete this portion of the test. When done, print your certificate, give it to your instructor, and request the project(s) portion of this test (if not already completed). Good luck!


Questions and Answers
  • 1. 
    The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Office button, the Ribbon, and the status bar.
    • A. 

      True

    • B. 

      False

  • 2. 
    The Save As command saves an existing workbook on a disk, using its current name and save location.
    • A. 

      True

    • B. 

      False

  • 3. 
    To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.
    • A. 

      True

    • B. 

      False

  • 4. 
    Unless you specify otherwise, text you enter in a cell is lined up along the upper-right side of the cell.
    • A. 

      True

    • B. 

      False

  • 5. 
    A format is the design of text.
    • A. 

      True

    • B. 

      False

  • 6. 
    The default number format is General, which displays numbers the way you type them.
    • A. 

      True

    • B. 

      False

  • 7. 
    At times, you might need to remove, or clear, all formatting applied to a cell or range of cells.
    • A. 

      True

    • B. 

      False

  • 8. 
    Design view is helpful when you prepare a worksheet for printing.
    • A. 

      True

    • B. 

      False

  • 9. 
    Each formula begins with a quotation (") mark.
    • A. 

      True

    • B. 

      False

  • 10. 
    Formulas can include more than one operator.
    • A. 

      True

    • B. 

      False

  • 11. 
    In Excel, a computerized spreadsheet is called a ____.
    • A. 

      Worksheet

    • B. 

      Table

    • C. 

      Workbook

    • D. 

      File

  • 12. 
    The name of each worksheet appears in the ____ at the bottom of the worksheet window.
    • A. 

      Sheet box

    • B. 

      Sheet task bar

    • C. 

      Sheet dialog box

    • D. 

      Sheet tab

  • 13. 
    Numbers that extend beyond a cell's width appear as ____ in a cell.
    • A. 

      &&&&

    • B. 

      ????

    • C. 

      ####

    • D. 

      ++++

  • 14. 
    To replace cell contents, select the cell, type the new data, and then enter the data by clicking the Enter button on the Forumla Bar or by pressing the ___.
    • A. 

      Enter key

    • B. 

      Tab key

    • C. 

      Either a. or b.

    • D. 

      Neither a. nor b.

  • 15. 
    You can close a workbook by clicking the Office Button to display the Office menu and clicking ____.
    • A. 

      Open

    • B. 

      Close

    • C. 

      Exit

    • D. 

      End

  • 16. 
    Figure 1-1Excel Case 1-1Dori is working in a large worksheet and plans to use the Expanded Find and Replace dialog box shown in Figure 1-1 to help her find and replace some updated information. Please refer to the figure above asyou answer the question below.Dori knows that she has entered an incorrect value of 4,231 in one of the cells and wants to find it. She would choose "cell contents" as her place to search in the ___ search option section.
    • A. 

      Look in

    • B. 

      Search

    • C. 

      Within

    • D. 

      None of the above

  • 17. 
    You can change the width of several columns at one time. Select the columns you want to resize. Then use the pointer to click and drag the ___ edge of one of the selected column headings.
    • A. 

      Top

    • B. 

      Left

    • C. 

      Right

    • D. 

      Bottom

  • 18. 
    Excel ______ all numbers.
    • A. 

      Right-aligns

    • B. 

      Left-aligns

    • C. 

      Top-aligns

    • D. 

      Bottom-aligns

  • 19. 
    Data can be indented (or ___) within cells to help distinguish categories or set data apart.
    • A. 

      Shifted to the right

    • B. 

      Shifted to the left

    • C. 

      Shifted up

    • D. 

      Shifted down

  • 20. 
    You can select a different theme for your workbook. Click the ___ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.
    • A. 

      Page Layout

    • B. 

      Layout

    • C. 

      Format

    • D. 

      Page Format

  • 21. 
    To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ___ group, click the arrow next to the Font box to display a gallery of available fonts.
    • A. 

      Font

    • B. 

      Edit

    • C. 

      Styles

    • D. 

      Data

  • 22. 
    Excel Case 2-2Josh wants to apply a cell style to certain cells in his worksheet. Please answer the question below.Josh wants to get to the Cell Style gallery. How does he navigate to the Cell Style gallery?
    • A. 

      In the Styles group on the Home tab of the Ribbon, click the Cell styles button.

    • B. 

      In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button.

    • C. 

      In the Editing group on the Home tab of the Ribbon, click the Cell Styles button.

    • D. 

      None of the above

  • 23. 
    Click the Ctrl+V keys to ____ the selected cells.
    • A. 

      Copy

    • B. 

      Cut

    • C. 

      Paste

    • D. 

      Move

  • 24. 
    To use the drag-and-drop method, select the cell or range you want to move or copy. Then, position the pointer on the top border of the selected cells. the pointer changes from a white cross to a ____ arrow. to move the selected cells, drag them to a new location.
    • A. 

      One-headed

    • B. 

      Two-headed

    • C. 

      Three-headed

    • D. 

      Four-headed

  • 25. 
    To check the spelling in a worksheet, click the Review tab on the Ribbon, and then, in the ___ group, click the Spelling button.
    • A. 

      Editing

    • B. 

      Proofing

    • C. 

      Checking

    • D. 

      Searching

Back to Top Back to top