Computer Applications Final Exam Practice Quiz

100 Questions | Total Attempts: 318

SettingsSettingsSettings
Please wait...
Computer Application Quizzes & Trivia

Computer Applications   Semester 2  Final Exam - June 2013 Open book (Microsoft PowerPoint & Excel 2007) This is a multiple-choice and true/false test. Please use your mouse to click the small option button preceding the best answer to each question. Then, use the scroll bar on the right side of your screen to scroll down to the next question. Repeat as needed until you have answered all questions. Please review your selections before submitting. You may only submit your final exam answers once.


Questions and Answers
  • 1. 
    The name box displays entries as they are made and edited in the workbook window.  
    • A. 

      True

    • B. 

      False

  • 2. 
    Excel files are called workbooks.  
    • A. 

      True

    • B. 

      False

  • 3. 
    A template is a file that contains settings that are used as the basis for a new file you are creating.  
    • A. 

      True

    • B. 

      False

  • 4. 
    Cells are referenced by column number and row letter.  
    • A. 

      True

    • B. 

      False

  • 5. 
    Press the Home key to quickly move to the beginning of a row.  
    • A. 

      True

    • B. 

      False

  • 6. 
    The four steps to developing a worksheet are: Enter, Edit, Test, and Format.  
    • A. 

      True

    • B. 

      False

  • 7. 
    When you start to enter data in a cell, the mode shown in the status bar changes from Ready to Enter.  
    • A. 

      True

    • B. 

      False

  • 8. 
    The AutoCorrect feature automatically inserts proper capitalization at the beginning of sentences and in the names of days of the week.  
    • A. 

      True

    • B. 

      False

  • 9. 
    A text entry that is larger than the column width will be fully displayed only if the cells to the left are blank.    
    • A. 

      True

    • B. 

      False

  • 10. 
    The Save command is used to save a file with a new file name or to a new location.  
    • A. 

      True

    • B. 

      False

  • 11. 
    If you try to close a file before it has been saved, Excel will prompt you to save it.    
    • A. 

      True

    • B. 

      False

  • 12. 
    The Spell Checker feature works by comparing each word to a dictionary of words, called the custom dictionary, that is supplied with the program.  
    • A. 

      True

    • B. 

      False

  • 13. 
    The Spell Checker does not check spelling in text that result from formulas.    
    • A. 

      True

    • B. 

      False

  • 14. 
    You can launch the Spell Checker by pressing the F7 key.  
    • A. 

      True

    • B. 

      False

  • 15. 
    When you move a selection, it is removed or cut from the original location in the source and inserted at the intended destination
    • A. 

      True

    • B. 

      False

  • 16. 
    The system Clipboard can hold up to 24 items.  
    • A. 

      True

    • B. 

      False

  • 17. 
    A selection consisting of two or more cells on a worksheet is a range
    • A. 

      True

    • B. 

      False

  • 18. 
    When you copy by dragging the fill handle, the mini toolbar appears
    • A. 

      True

    • B. 

      False

  • 19. 
    Excel calculates the formula from left to right and performs the calculation in the following order: percent, exponentiation, multiplication and division, and addition and subtraction.  
    • A. 

      True

    • B. 

      False

  • 20. 
    An absolute reference is a cell or range reference in a formula whose location is interpreted by Excel in relation to the position of the cell that contains the formula.  
    • A. 

      True

    • B. 

      False

  • 21. 
    An argument is the data that a function uses to perform a calculation.  
    • A. 

      True

    • B. 

      False

  • 22. 
    The rules you follow when writing a formula are referred to as the structure.  
    • A. 

      True

    • B. 

      False

  • 23. 
    You can add cell references to a formula either by typing them directly or by selecting the cell with the mouse.
    • A. 

      True

    • B. 

      False

  • 24. 
    When a number in a referenced cell in a formula changes, Excel automatically recalculates all formulas in the worksheet.  
    • A. 

      True

    • B. 

      False

  • 25. 
    Grouping settings allow you to change the horizontal and vertical placement as well as the orientation of an entry in a cell.
    • A. 

      True

    • B. 

      False

Back to Top Back to top