Final Exam Practice Questions (Semester with 2 tests)

The final exam will cover material covered since the previous exam. This will include information in the book, lectures, and Projects. The following represents sample questions to practice with, in order to prepare for the final exam. This does not, of course, mean that these items will be on the test or that other items will not be included. Students must also study the material in the book and the questions and study guides given in the book and on the web site for GO with MS Office 2007 Introductory.

GENERAL:
You should be able to do (and answer questions) about the basic Windows and Office functions, such as the following:

  1. How do you start up (Word, Excel, Access, Powerpoint)?
  2. How do you close a Word document without closing Word?
  3. How do you close the (Word, Excel, Access, Powerpoint) program.

MS WORD

  1. Name any three ways to select text: _________________ ________________ ________________
  2. How would you select the entire document in MS Word? ________________________________
  3. Describe how to copy the first paragraph of a document and paste it elsewhere. __________________
  4. How do you get some text or graphics onto the clipboard? __________________________________
  5. How do you change the margins for a document? ______________________________________

  6. How do you change the left indent for a paragraph? ____________________________________
  7. How do you change the right indent for a paragraph? ___________________________________

  8. A hanging indent refers to formatting in which...
      a. Text in the first line is not indented as much as the remaining lines of the paragraph.
      b. All lines of a paragraph are indented more than the paragraph above it.
      c. All lines of a paragraph are aligned under the same tab stop.
      d. The text in the first line is indented more than the remaining lines of a paragraph.

  9. How do you change the text alignment for a paragraph so that it's (centered, aligned on the left, aligned on the right, justified)? _______________________________________________________

  10. What's the difference between Sans Serif fonts and Serif fonts?_______________________
  11. How do you turn bullets on and/or off for a list of items? ______________________________

  12. Where do you click to show hidden characters in your document, such as the paragraph, and tab markers?
    ______________________________________________________________________________
  13. To insert a picture into a Word document, you click on which tab and command(s)? _________________
  14. How would you replace all occurrences of "Dallas" with "Little Rock"? _______________

    ___________________________________________________________________________

  15. How would you change the number of columns in an MS Word document, for example if you were creating a 2-column newsletter? ___________________________
  16. How would you change the paper orientation to Landscape (rather than Portrait) in MS Word?

    _____________________________________________________________________________

  17. How do you spell check a document? ______________________________________________

  18. How do you insert Clip Art? ___________________________
  19. How would you insert left tabs at the 4 and 6 inch marks on a page?
    _______________________________________________________________________

EXCEL:

  1. Although we use the term "spreadsheet" as a generic term, a document produced by Excel is actually called a ________________________________________________________________
  2. Each Excel document consists of several _______________________ with tabs at the bottom of the document window.
  3. The intersection of a column and a row is called a ____________________
  4. The cell which is currently being accessed or used is called the _____________ cell.

  5. You can see the name of the current cell in what part of the Excel Window? ________________
  6. Likewise, the contents of the active cell is shown in what box? ___________________________
  7. How would you change to a currency format for numbers in a cell? ________________________
  8. What and where is the "Fill Handle" (or Cell Handle) in a cell? _____________________________

  9. How do you use the "Fill Handle" to copy a formula to other adjacent cells? __________________

    __________________________________________________________________________

  10. Which of the following is a valid Excel cell address: A10, 10A, 1A3 ________
  11. What kinds of data can you can type into an Excel cell? ___________________________
  12. How would you write a formula B3 times E1, making E1 an absolute cell reference?
    ____________________________________________________________________

  13. You've typed a title into cell A1. How do you use "Merge and Center" to center that title over columns A through E? __________________________________________
  14. Give an example of an Excel function: _____________________________
  15. What's the difference between a formula and a function? _____________________________
  16. How do you use Autofit? ____________________________________________________

  17. What's the difference between an absolute cell reference and a relative cell reference?

    _________________________________________________________________________________

  18. What kind of cell reference is $H$1 ? ________________________
  19. How do you select a range of cells? _____________________________________
  20. Tell one way to move a range of cells from the present location to another location?

    ____________________________________________________________________________

  21. Where do you click to delete a row or column? _____________________________________
  22. How do you insert a new row or column? _____________________________________

  23. Do you have to select data before you make a chart? ________________________________
  24. How do you create a chart? _____________________________________
  25. How would you print out some Excel data with its chart? ________________________________

    ______________________________________________________________

  26. In Excel, how would you print in landscape mode? __________________________________________
  27. How do you change the font face and/or size in a cell? ____________________________________
  28. Give two ways to change the width of a column. ________________________________________

  29. Write the formula for the average of cells A2 through A20, without listing every cell:
    =_________________________________________________
  30. Write the formula, using the PMT funtion, for the monthly payment, where the Principle(amt of loan) is in cell B4, the yearly interest rate is in B5, and the term(in years) is in B6. Remember, you have to divide the interest rate by 12, and multiply the term by 12.
    =_______________________________________________
ACCESS:
  1. A database can consist of: (a) one or more tables (b) only one table (c) is the same as a table (d) none of those? __________________________
  2. Give an example of a database that you could create with Access. ___________________________

  3. Which of the following would not be a good example of a database? (a) a dictionary, (b) a bookstore inventory (c) student information at UALR (d) an interoffice memo? ____________
  4. List four of the "Objects" that are available on the database window. __________________________
  5. What's the difference between a "Database" and a "Table"? _________________________________

  6. How can you tell the name of a Database? __________________________________________
  7. How can you tell the name of a Table? __________________________________________
  8. How would you list Database, Table, Record, and Field in terms of a hierarchy? __________________________________________
  9. Looking at a database as a hierarchy, a table can be described as a set of related (a) fields (b) objects (c) records (d) queries? __________________________
  10. A record can be described as a set of related (a) fields (b) objects (c) queries (d) forms? __________________________

  11. How do you switch between database objects when you have a database window open? __________________________
  12. Looking at the Database window, where do you click to change the design of a table? __________________________

  13. Looking at the Table datasheet, where do you click to change the design of a table? __________
  14. What is the purpose of a database Form? __________________________
  15. What is the purpose of a database Report? __________________________
  16. How do you enter new data into a table? __________________________

  17. How do you edit the data in the table on the datasheet? __________________________
  18. How do you find a record with a particular value (in a table)? __________________________

  19. When you're using the Form Wizard, what do the two arrows pointing to the right (>>) do? __________________________

  20. When you create an Access database table, once you define a field you can't change its name (True or False)? __________________________
  21. When you created your report, what sequence of choices did you make to do it (meaning where do you click on the windows)? __________________________
  22. How do you create a relationship between two tables? __________________________________

POWERPOINT:

  1. What's the purpose of PowerPoint? __________________________
  2. Which of the following does PowerPoint create (a) 35mm slides (b) on-screen presentations (c) transparencies or (d) all of those? __________

  3. Name three of the different Views available to you in PowerPoint. __________________________
  4. Which PowerPoint Views allow you to view and edit slides one slide at a time? ___________________
  5. Which PowerPoint view displays several slides on the screen? __________________________

  6. How do you actually start the slide show? __________________________
  7. PowerPoint allows you to (a) use presentations with content already on the slides, (b) use colorful slide design templates for a presentation you create, (c) start with a blank presentation, or (d) all of those? ________________
  8. How do you open an existing presentation in PowerPoint? __________________________
  9. How do you enter or change text on a slide of a PowerPoint presentation? __________________

  10. How do you save a presentation on your flash drive? _____________________
  11. How do you save a presentation for use at another site that doesn't have PowerPoint?
    _________________________________________________________

  12. How do you get HELP in PowerPoint? __________________________
  13. When you're actually making a presentation, how do you advance to the next slide? ____________

  14. When you're actually making a presentation, how do you go to the previous slide? ___________
  15. How do you print only one slide per page in PowerPoint? __________________________
  16. How do you print several slides per page in PowerPoint? __________________________