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

Choose one answer.

	a. Design mapping
	b. Story mapping
	c. Focus messaging
	d. presentation
	e. delivery

Question 2

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

Choose one answer.

	a. Design mapping
	b. Story mapping
	c. Focus messaging
	d. presentation
	e. delivery

Question 3

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.

Choose one answer.

	a. queries
	b. select queries
	c. switchboard
	d. tables
	e. form

Question 4

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

Choose one answer.

	a. record
	b. primary key
	c. product
	d. database
	e. table

Question 5

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.

Choose one answer.

	a. notes master
	b. title master
	c. slide master
	d. handout master
	e. master slide

Question 6

A(n) __________ is a term used to describe business or knowledge workers who are involved in the process of data collection and storage, transformation of business systems, and information dissemination.

Choose one answer.

	a. Computer Programmer
	b. Business Analyst
	c. Database Analyst
	d. Business Manager
	e. Project Coordinator

Question 7

Allen Johnson just took over a Coin Laundry and Washing business from his silent partner who recently abandoned the operation and the partnership. On his first day in the facility, Allen realizes there are no business transaction or inventory records. Throughout Allen's first day, customers drop off bundles of clothes to be washed and folded. When Allen asks for names and addresses, customers respond with strange looks and replies that the previous owner never asked for such information. At the end of the first day, Allen has over one hundred transactions written in a notebook. Allen has a laptop, a printer, a word processing tool, and a spreadsheet tool. In order to minimize his work, which process should Allen follow to create customer receipts as well as receipts that remain with the store to track those clothes that will be picked up in the future?

Choose one answer.

	a. Create an invoice template using the spreadsheet software and have it populate the customer name based on the selected information.
	b. Create an invoice template using the word processing software and manually enter customer information and each transaction.
	c. Create an invoice template using the word processing software and embed a link to the spreadsheet software data that will populate the invoice and record the transaction.
	d. Create a blank invoice blank and manually enter the necessary customer information and each transaction.
	e. Continue to make manual entries in the notebook.

Question 8

Choose one answer.

	a. Request a spreadsheet file and upload the data into the database.
	b. Hire a data entry clerk to enter the data.
	c. Ask the customer to send only one week of data at a time.
	d. Continue with the existing process.
	e. Request and enter only two weeks of data at a time.

Question 9

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. After entering the data into the database, Allen spends another four hours creating a presentation with embedded graphics taken from his customer's printout. Which of the following would be the best recommendation for Allen?

Choose one answer.

	a. Continue with his current process.
	b. Create a business form and link it to a presentation template.
	c. Create and printout a business form containing the required information.
	d. Extract a spreadsheet file from the database with the required information.
	e. Create and extract the necessary graphic reports.

Question 10

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. The Shipping Department for Allen's company wants a copy of the data once entered. They take the list and manually mark off the shipped items. Once all of the items have shipped, Shipping enters the item updates into the same database. Which of the following options would make this process more efficient?

Choose one answer.

	a. Provide the Shipping Department access to a database report of the data with update permission for a shipping status field.
	b. Provide the Shipping Department with update access to the database.
	c. Provide the Shipping Department with update and query permission of the database.
	d. Continue with the existing process.
	e. Allen should give the original data to the Shipping Department to enter.

Question 11

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?

Choose one answer.

	a. Provide the Inventory Control Manager access to a database form that contains the required information.
	b. Extract the required data to a spreadsheet file and deliver it to the Inventory Control Manager.
	c. Tell the Inventory Control Manager that you can only deliver the report once a week.
	d. Continue with the existing process.
	e. Allen should ask his administrative assistant to prepare the report for the Inventory Control Manager.

Question 12

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. Allen has a weekly meeting with his manager that requires him to prepare a report of all sales orders and their delivery status. The report takes him almost two hours to prepare and it usually contains math errors or omitted information. Which of the following would make this process more efficient?

Choose one answer.

	a. Print the raw data and bring it to the meeting.
	b. Create a form in the database that contains all the required information and print prior to the meeting.
	c. Extract the data into a spreadsheet and use the spreadsheet tool to manipulate the data.
	d. Continue with the existing process.
	e. Allen should task his administrative assistant to prepare the report for the manager.

Question 13

Amany just completed her 12-page monthly status report for her project, and was asked by her boss to turn the report into a presentation for a briefing tomorrow morning using their standard master template. You over heard the conversation and noticed Amany's frustration with the request. What would you recommend to Amany to reduce her workload on this assignment?

Choose one answer.

	a. Manually type the information into the presentation software.
	b. Use the cut and paste function of the spreadsheet tool to populate the presentation.
	c. Change the word processing document from "portrait" to "landscape" format.
	d. Get help from a co-worker to retype the information into the presentation software.
	e. Import the slides into the master template using the "objects" function.

Question 14

Diane Green is hired as a coordinator for your non-profit's fund raising event. The event includes seven fund raising activities that will commence two weeks before the main event, and that must be tracked and reported daily. Based on the success of each individual event, the president of the non-profit will make phone calls and send e-mails to encourage participation. Diane is considering the options listed below. Which one would provide the most valuable results?

Choose one answer.

	a. Send the president a daily spreadsheet containing all of the data from the seven fund raising activities.
	b. Send the president a summary spreadsheet of the seven fund raising activities for the current day.
	c. Create and send the president a word processing document and insert the summary of the seven fund raising activities for the current day.
	d. Create and send the president a word processing document with a summary of the spreadsheet data for the current day and all prior days' fund raising activities.
	e. Explain how the integration of two major office suite tools can help inform business decisions and address business needs.

Question 15

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?

Choose one answer.

	a. How will the information be presented?
	b. What information is expected by the board members?
	c. Is there a possibility that this information will be required for future board meetings?
	d. B and C
	e. A, B, and C

Question 16

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 presentations' content and format. Each presentation features a different layout, font, and header; even the content varies. After returning from the board meeting, Gordon relays to his directors that the Audit Committee is requesting access to the current financial data as well as data from the last four years. The committee is not sure what reports they would need or in what format the data should be presented. Based on this vague request, what tool would you use to prepare this data?

Choose one answer.

	a. Word processing
	b. Spreadsheet
	c. Presentation
	d. Database
	e. Email

Question 17

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?

Choose one answer.

	a. Develop a master slide template for Board of Directors presentations.
	b. Search for a simple standard financial reporting template.
	c. Develop a master word template for the Board of Directors meeting.
	d. Develop a standard set of spreadsheets containing the necessary information.
	e. A and B

Question 18

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?

Choose one answer.

	a. Queries
	b. Tables
	c. Fields
	d. Grids
	e. Sorts

Question 19

Gwen, the new manager of your department has drafted a good presentation from a report that you wrote last month. She is scheduled to make the presentation to your local trade association in a few days. After reviewing her draft, you realize all of her slides are formatted differently with few similarities. To make matters worse, she is working on another draft presentation for a national convention. Which of the following presentation slide formats should she use?

Choose one answer.

	a. Notes master
	b. Title master
	c. Slide master
	d. Handout master
	e. Master slide

Question 20

Gwen, your company's sales manager, uses a spreadsheet to report her monthly and quarterly sales progress. Her new manager, who lives in Paris, has requested that she send him a weekly letter with a summary of this information. Gwen went to see her co-worker for help with business need. Which of the following items best describe what she should ask her co-worker to provide?

Choose one answer.

	a. Summarize how word-processing and spreadsheet data may be integrated.
	b. Explain why such integration can help inform business decisions.
	c. Identify the tool functions that allow for integration and sharing across word-processing documents and spreadsheets.
	d. Describe how to design a spreadsheet document with integrated word-processing data, as well as perform this task.

Question 21

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

Choose one answer.

	a. formulas
	b. numbers
	c. graphs
	d. text
	e. charts

Question 22

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.

Choose one answer.

	a. primary
	b. secondary
	c. master
	d. repeater
	e. foreign

Question 23

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.

Choose one answer.

	a. slide shows
	b. transitions
	c. themes
	d. tables
	e. animation

Question 24

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?

Choose one answer.

	a. Identify the tool functions that allow for integration and sharing across the word-processing and presentation tools.
	b. Explain why the integration of word-processing and presentation data is used in making business decisions.
	c. Describe how to design a word-processing document with integrated presentation data.
	d. Describe how to design a presentation document with integrated word-processing data.

Question 25

John and Susan Miller recently purchased "The Little Wine Shack," a 30-year-old retail wine store, from Ben Anderson. Under Mr. Anderson's ownership, the business grew from having an inventory of a few bottles inherited from his father's wine cellar to a 10,000-bottle cellar and a retail space offering public and private tastings. Mr. Anderson never used a computer but rather relied on his memory to remember customers' favorite wines and previous purchases. In addition, Mr. Anderson made all customer contacts personally by phone. John and Susan want to take a different approach by automatizing many of the store's manual operations, including using a computer to track inventory and customer records. They plan to create both print and electronic weekly newsletters offering, among other things, discount on customers' previously purchased wines. Which of the following tools would help them achieve their objective?

Choose one answer.

	a. Word processing
	b. Spreadsheet and presentation
	c. Presentation, word processing, and spreadsheet
	d. Database and word processing
	e. Presentation, word processing, database, and spreadsheet

Question 26

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?

Choose one answer.

	a. Word processing
	b. Spreadsheet
	c. Presentation
	d. Database
	e. Email

Question 27

Roger Cline just purchased a store-front mail and shipping business. The previous owner lowered the price because Roger did not want the business's old computer system. After taking over the business, Roger realizes that he needs a way to keep track of the rented mail boxes and to generate monthly/quarterly customer invoices. The franchise parent company requires that the business owner provide the billing status of each box along with occupancy rate and revenue for the store. Presentation of this information is required during a monthly video conference call, and an electronic spreadsheet containing this information must be sent within two hours of the conference call's completion. Based on these requirements, what tool would you recommend?

Choose one answer.

	a. Word processing
	b. Spreadsheet and presentation
	c. Presentation, word processing, and spreadsheet
	d. Database and word processing
	e. Presentation, word processing, database, and spreadsheet

Question 28

Sally has just completed her class project based on her ideas of how to improve the production line at her job. Her professor was impressed with the paper and suggested that she present the information to her boss. Sally's concern was that her boss would never read the 70 pages of words, graphs, and charts. She believed that the most her boss would have time for would be five to seven slides in a presentation. Her professor agreed and suggested that she take a different approach. He would likely

Choose one answer.

	a. identify the tool functions that allow for integration and sharing across the word-processing and presentation tools.
	b. explain why the integration of word-processing and presentation data is used in making business decisions.
	c. describe how to design a word-processing document with integrated presentation data, as well as perform this task.
	d. describe how to design a presentation document with integrated word-processing data, as well as perform this task.
	e. explain how the integration of the four major office suite tools can help inform business decisions and address business needs.

Question 29

Sharon Smith, the Finance Director of Baker and Baker Manufacturing, stands in the hallway outside her boss's office reviewing the report her staff prepared in the last hour. The "report" consists of a collection of hand-written notes regarding the company's financial status. However, Sharon's boss frequently calls her office and demands a status report within the hour. Which of the following tools would be most useful to address Sharon's problem?

Choose one answer.

	a. Word processing
	b. Spreadsheet
	c. Presentation
	d. Database
	e. Email

Question 30

Shirley Gold has decided to start a daycare business but needs funding from a venture capital group. The group has asked her to demonstrate her ability to bill for services, issue correspondence, keep track of financial records, and maintain searchable client records. In addition, the venture capital group requires a quarterly business briefing. Based on these requirements, which of the following tools should Shirley use to demonstrate this capability?

Choose one answer.

	a. Word processing
	b. Spreadsheet and presentation
	c. Presentation, word processing, and spreadsheet
	d. Database and word processing
	e. Presentation, word processing, database, and spreadsheet

Question 31

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?

Choose one answer.

	a. SUM
	b. IF
	c. Average
	d. COUNT
	e. TODAY

Question 32

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

Choose one answer.

	a. SUM
	b. IF
	c. Average
	d. COUNT
	e. TODAY

Question 33

Susan, the new receptionist, is asked to create a calendar to keep track of the scheduled days off work for the eight people in your department. The calendar needs to be produced monthly and hung in the break room. You walk past her desk and notice she is creating the calendar using a spreadsheet application. What tool would you recommend Susan use instead of the spreadsheet application?

Choose one answer.

	a. Database report
	b. Word document with an embedded calendar spreadsheet
	c. Word document using a calendar template
	d. Presentation document with an embedded calendar spreadsheet
	e. Spreadsheet report

Question 34

The Executive Director notices the calendar in the break room and comments on the great idea. Upon returning to her Chicago office, she sends an email asking Susan to help the other four departments implement a break room calendar that can be accessed electronically by those with permission. Based on this request, what tool would you recommend Susan?

Choose one answer.

	a. Word processing
	b. Spreadsheet
	c. Presentation
	d. Database
	e. Email

Question 35

The __________ feature of a word processing header forces it to become a sub-header.

Choose one answer.

	a. template
	b. demotion
	c. promotion
	d. captions
	e. cross-reference

Question 36

The __________ spreadsheet tool function calculates a result depending on one or more conditions.

Choose one answer.

	a. SUM
	b. IF
	c. average
	d. COUNT
	e. TODAY

Question 37

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

Choose one answer.

	a. SUM
	b. IF
	c. average
	d. COUNT
	e. TODAY

Question 38

The __________ spreadsheet tool function lets you view just the records that you want to see. The other records in your data table will still be there, but hidden.

Choose one answer.

	a. sort
	b. filter
	c. subtotal
	d. formula
	e. SUM

Question 39

The __________ tool provides style sheets and the ability to make your document presentation look consistent, within the same document and on sets of documents.

Choose one answer.

	a. word processing
	b. spreadsheet
	c. presentation
	d. database
	e. email

Question 40

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.

Choose one answer.

	a. word processing
	b. spreadsheet
	c. presentation
	d. database
	e. email

Question 41

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

Choose one answer.

	a. Template
	b. Demotion
	c. Promotion
	d. Captions
	e. Cross reference

Question 42

When you arrived at work this morning, there was a note from your boss and a hand written list of 200 potential donors along with their contact information. The note simply said, "Invite them all to the banquet next month-final presentation-keep track of their responses." What tool and tool feature would you use to accomplish this task?

Choose one answer.

	a. Word processing
	b. Note pad
	c. Blank sheet of paper
	d. Database
	e. Email

Question 43

Which of these communication styles, as described in the Interpersonal Attitude Instrument, is data-focused?

Choose one answer.

	a. Analyst
	b. Innovator
	c. Producer
	d. Diplomat
	e. Creator

Question 44

Which of these communication styles, as described in the Interpersonal Attitude Instrument, is delivery-focused?

Choose one answer.

	a. Analyst
	b. Innovator
	c. Producer
	d. Diplomat
	e. Creator

Question 45

Which of these communication styles, as described in the Interpersonal Attitude Instrument, is people-focused?

Choose one answer.

	a. Analyst
	b. Innovator
	c. Producer
	d. Diplomat
	e. Creator

Question 46

Which of these communication styles, as described in the Interpersonal Attitude Instrument, is results-focused?

Choose one answer.

	a. Analyst
	b. Innovator
	c. Producer
	d. Diplomat
	e. Creator

Question 47

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?

Choose one answer.

	a. Explain how the integration of the four major office suite tools can help inform business decisions and address business needs.
	b. Explain and identify the office suite functions that allow for integration and sharing across the four major tools.
	c. Describe how to design a word-processing document with spreadsheet and database content.
	d. Describe how to design a presentation document with integrated word processing and spreadsheet.
	e. Explain how the integration of two major office suite tools can help inform business decisions and address business needs.

Question 48

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?

Choose one answer.

	a. title bar
	b. slide pane
	c. slide master
	d. auto correct
	e. footer

Question 49

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?

Choose one answer.

	a. Word processing
	b. Spreadsheet
	c. Presentation
	d. Database
	e. Email

Question 50

__________ affects the way one slide goes to the next. It adds interest to your slide show, but care should be taken that the effect does not become a distraction.

Choose one answer.

	a. Slide show
	b. Transition
	c. Theme
	d. Table
	e. Animation

Question 51

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

Choose one answer.

	a. Queries
	b. Tables
	c. Fields
	d. Grids
	e. Sorts

Question 52

__________ data is most suitable when information must be separated into conceptual groups such as knives, forks and spoons; or males and females.

Choose one answer.

	a. Categorical
	b. Discrete
	c. Continuous
	d. Random
	e. Sample

Question 53

__________ data is often grouped in categories ("fewer than three," "four or more") and treated as data groups which have numerical values associated with them, but only whole values.

Choose one answer.

	a. Categorical
	b. Discrete
	c. Continuous
	d. Random
	e. Sample

Question 54

__________ in a presentation tool refers to the manner in which individual text or other objects appear as they enter or exit a slide.

Choose one answer.

	a. Slide show
	b. Transition
	c. Theme
	d. Table
	e. Animation

Question 55

__________ 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.

Choose one answer.

	a. Formulas
	b. Numbers
	c. Graphs
	d. Auto fill
	e. Charts

Question 56

__________ is the spreadsheet data type that consists mainly of alphabetic characters, but can also include numbers, punctuation marks, and special characters.

Choose one answer.

	a. Formulas
	b. Numbers
	c. Graphs
	d. Text
	e. Charts

Question 57

__________ is the spreadsheet data type that starts with an "=" sign and contains at least one logical or mathematical operation (or special function), combined with numbers and/or cell references.

Choose one answer.

	a. Formulas
	b. Numbers
	c. Graphs
	d. Text
	e. Charts

Question 58

__________ is/are the unique way(s) in which organizations coordinate work activities, information, and resources in order to create a product or service.

Choose one answer.

	a. Business requirements
	b. Information processing
	c. Data processing
	d. Information management
	e. Business processes

Question 59

__________ provide(s) a professional-looking interface for viewing the forms and reports that you have created in your database.

Choose one answer.

	a. Queries
	b. Select queries
	c. A switchboard
	d. Tables
	e. A form

Question 60

__________ show(s) the database records and fields you have selected (and any calculated fields you may have defined), but do(es) not change any of the values in your underlying database tables.

Choose one answer.

	a. Queries
	b. Select queries
	c. Table queries
	d. Tables
	e. Form