1. A __________ __________ is the part of every presentation that controls certain text characteristics such as font type, size, and color, as well as background color and style.

2. (A) __________ is an interaction between a speaker and an audience that usually includes one or more visual aids.

3. Steve is working with some spreadsheet data and needs to calculate a result depending on one or more conditions. What spreadsheet function should Steve use?

4. This word processing feature allows a topic to move one level up the hierarchy.

5. (A) __________ consists of the background, fonts, bullets, formatting, and color scheme that you can apply to define the look of your presentation.

6. Gordon Brown, the Executive Director of Great Energy Inc., sits at his desk and thumbs through the four financial presentations given to him by his Directors. He is scheduled to present the information to the Board of Directors in a few days, but is disappointed with the presentation's content and format. Each presentation features a different layout, font, and header; even the content varies. While gathering and preparing the data for a Board of Directors meeting, which of the following questions would be most useful to ask in selecting the best tool for the task?

7. Allen receives weekly updated printouts from his customer. Each printout contains a list of the equipment needed for the next month. Each weekly update also contains major adjustments for the final two weeks of the report based upon the company's confidence that future business is available. After receiving the 20-page report, Allen spends six hours entering the data into his company database. Twice a week, the Inventory Control Manager requests Allen provide a printout from the database of the equipment that is currently in inventory, and projections for the upcoming weeks. The manager uses the information to place orders for parts to cover the next two weeks. Which of the following would make this process more efficient?

8. Gordon Brown, the Executive Director of Great Energy Inc., sits at his desk and thumbs through the three reports and four financial presentations given to him by his Directors. He is scheduled to present the information to the Board of Directors in a few days, but is disappointed with the presentations' content and format. Each presentation features a different layout, font, and header; even the content varies. Based on the description above, which of the following actions would you recommend to Mr. Brown?

9. __________ is a spreadsheet tool feature that allows you to repeat a data series (such as the days of the week, months of the year, or a numbers series such as odd numbers) over a range of cells.

10. Jerry, the sales manager for your company, has a good presentation that he uses, but each slide is crowded with information that all looks the same. Some of his peers have suggested adding transitions, but he also needs __________ in order to control the manner in which individual text or other objects appear as they enter or exit a slide.

11. The __________ spreadsheet tool function calculates the total of a set of numbers.

12. You were just hired as a business analyst for 'Jahanes Jewelry Company,' an online startup with only seven employees. The president recognizes your talent and periodically asks for your help. He asks you to pull the quarterly sales data from the database and prepare a brochure and a presentation that he can take with him to his meeting with a venture capital group. He also wants a spreadsheet with the most recent data prior to his meeting. The president has meetings scheduled with four other venture capital groups and wants to use a consistent format but slightly different data. He asks you to explain your approach to the other staff members. Which of the following would best describe your approach to addressing the president's business needs?

13. A __________ is the field used to define each record in a table.

14. Your manager asks you to run a small project that includes creating 11 different presentations: 10 for potential school donors, and one for the board of trustees. The investors include alumni and their family members, all of whom have previously provided support to the organization. Each donor presentation needs to have a slightly modified introduction to include data specific to each donor's alumnus and previous donation status. A final presentation will be given to the board of Trustees, and will need to include the collective donor data. Based on the above description, what presentation feature would you use to facilitate and minimize the work required for all 11 presentations?

15. Jerry, your company's sales manager, has developed a presentation where each slide is crowded with seemingly redundant information. He also hands out a well-developed report that explains the product much better than the presentation. If you were Jerry's colleague, which of the following could you do that would most likely improve the presentation?

16. A friend wants to get involved in your mail order greeting card business, and is going to help by answering inquiries, quoting prices, and taking orders. You want to provide an easy way for him to view product details without allowing him to change the data that is already in the system. You will do this by using (a) __________ that allow(s) him to view existing data but not change it.

17. The __________ tool provides wizards to help users to create tables, queries, forms and reports, and it comes supplied with a set of predefined table definitions for tracking assets, customers, sales orders, invoices and many other commonly useful items.

18. Allen receives weekly updated printouts from his customer. Each printout contains a list of the equipment needed for the next month. Each weekly update also contains major adjustments for the final two weeks of the report, based upon the company's confidence that future business is available. After receiving the 20-page report, Allen spends six hours entering the data into his company database. Which of the following would make the process more efficient?

19. __________ are short programs requesting that data be retrieved from, added to, or modified in a table.

20. Steve is working with spreadsheet data and wants to calculate the total of a set of numbers. What spreadsheet function should he use?

21. Greg has a database of all his golf students, and he would like to create short programs designed to retrieve data from the database. What feature of the database should Greg use?

22. In a spreadsheet tool, dates and times are displayed as text but are stored as __________.

23. Your son's Boy Scout troop was the second highest fund raising troop in your state. Next year, the troop wants to double their performance from last year and secure the number one position. One of the parents recommends purchasing a list of every address in your region. She believes this information can help determine the neighborhoods with the highest fund raising potential. What office suite tool should be used with the address list to maximize the analysis of the data?

24. One month after implementing a new manual logging system, Karen asks Steve to convert the document, which is used to log billable time in 15-minute intervals and notes, into an electronic form so that she can have real-time access to the information. Which of the following Office suite of tools would you suggest Steve use to digitalize the log?

25. In order to link separate tables together in a database, the primary key of one table is repeated in another table where it is called a __________ key.