NEW
Font size
S
M
L
XL
WorksheetsBU102YC Office Productivity Applications Final
Total questions: 43
Worksheet time: 22mins
Name
Class
Date
1.
A database of racing includes the names of each driver, total wins and losses, and average speeds. What criterion will produce Jeff Gordon’s total winnings?
a)
>Jeff Gordon
b)
<Jeff Gordon
c)
=Jeff Gordon
d)
<>Jeff Gordon
2.
Jennifer is creating a database for several customers. How will she list the Customer ID?
a)
Yes/No
b)
Data
c)
Number
d)
Currency
3.
A manager has requested a list of all products over $100 and in size “Large”. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
4.
Robert needs to create a database of all his friends. In a table, is what last name considered?
a)
Field
b)
Record
c)
Table
d)
Cell Address
5.
Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered?
a)
Field
b)
Record
c)
Table
d)
Entry
6.
In a database, what is one piece of information called?
a)
Field
b)
Record
c)
Table
d)
Entry
7.
Ted is creating a database for several customers. What is the data type for the field customer name?
a)
Yes/No
b)
Data
c)
Number
d)
Currency
8.
Chloe is creating a database for several customers. What is the data type for the field total sales?
a)
Yes/No
b)
Data
c)
Number
d)
Currency
9.
Your boss has required all products from lowest price to highest. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
10.
Ms. Thomas has requested a list of all products under $10 and in size “Small”. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
11.
Max wants to create a list of graduate degrees in a database that will allow the selection of only three choices: BSBA, MBA, and MBE. Which field property should he use?
a)
Auto Number
b)
Lookup
c)
Number
d)
Yes/No
12.
A manager has requested a list of products from highest price to lowest. How would this information be retrieved?
a)
Sort Ascending
b)
Sort Descending
c)
Filter
d)
Find
13.
Which criteria will produce an alphabetical list of drivers who have 150 points?
a)
>150 and Sort Ascending
b)
>150 and Sort Descending
c)
>=150 and Sort Ascending
d)
>=150 and Sort Descending
14.
Gina needs to create a database of all her friends. Where will all the information be kept?
a)
Field
b)
Record
c)
Table
d)
Entry
15.
Billy is creating a database for several customers. How will he record whether or not they have a credit card?
a)
Yes/No
b)
Text
c)
Number
d)
Currency
16.
Alice has started a new business. She needs to provide a monthly update to her customers. What is MOST APPROPRIATE?
a)
Newsletter
b)
Letterhead
c)
Flyer
d)
Brochure
17.
Your teacher has asked you to relocate the picture on page one to page two where it relates to the topic. What design principle is NOT being utilized?
a)
Balance
b)
Proximity
c)
Alignment
d)
Repetition
18.
The location, date, time, and cost are centered on a flyer. This is an example of which design principle?
a)
Alignment
b)
Contrast
c)
Proximity/unity
d)
Repetition/consistency
19.
Your teacher has asked you to cut out the overpowering image located on every page of the newsletter. What design principle is NOT being utilized?
a)
Balance
b)
Proximity
c)
Alignment
d)
Contrast
20.
Brenda has started a new business. She needs away to give her contact information. What is MOST APPROPRIATE?
a)
Business card
b)
Newsletter
c)
Flyer
d)
Brochure
21.
Avery has started a new business. She needs a design for the top of her letter. What is MOST APPROPRIATE?
a)
Business card
b)
Letterhead
c)
Flyer
d)
Brochure
22.
Brenda advertises in magazines that targets college graduates. What is her target audience?
a)
Age
b)
Education
c)
Interests
d)
Group membership
23.
Brenda advertises in magazines that targets athletes. What is her target audience?
a)
Age
b)
Education
c)
Interests
d)
Group membership
24.
Your teacher has asked you to change to a yellow text on black background, because your current product is difficult to read. What design principle was NOT being used?
a)
Contrast
b)
White Space
c)
Alignment
d)
Repetition
25.
Bill needs to design an invitation to the FBLA Awards Luncheon. What type of computer program would he MOST LIKELY use?
a)
Desktop Publishing
b)
Multimedia
c)
Spreadsheet
d)
Virtual Reality
26.
Your teacher has asked you to increase the margins to emphasis a picture and give the readers a break from the text. What design principle was NOT being used?
a)
Contrast
b)
White space
c)
Alignment
d)
Repetition
27.
Your teacher has asked you to use the same font and pictures on each page. What design principle was NOT being used?
a)
Balance
b)
Proximity
c)
Alignment
d)
Repetition
28.
What is the use of a personal computer as an inexpensive production system for creating typeset quality text and graphics called?
a)
Desktop Publishing
b)
Word Processing
c)
Spreadsheet
d)
Web Authoring
29.
Brenda advertises in magazines that targets those in the Honor Society. What is her target audience?
a)
Age
b)
Education
c)
Interests
d)
Group Membership
30.
Christina advertises in magazines that targets sport fans. What is her target audience?.
a)
Age
b)
Education
c)
Interests
d)
Group Membership
31.
Carol advertises in magazines that targets 22-25 year old college graduates. What is her target audience?
a)
Age
b)
Education
c)
Interests
d)
Group Membership
32.
Kimberly needs a publication to show all of her services and products that she can mail to potential customers. What is MOST APPROPRIATE?
a)
Business Card
b)
Letterhead
c)
Flyer
d)
Brochure
33.
Which function will result in the total number of entries in the cell range B5 to B14?
a)
Count
b)
Max
c)
Min
d)
Sum
34.
When creating a chart to analyze the effect of the oil prices on the cost of stocks, which data will appear on the x-axis?
a)
Months
b)
Oil prices
c)
Stock names
d)
Stock prices
35.
Which chart type will best represent the percentage of examples for office supplies, salaries, and travel for a company’s budget?
a)
Column
b)
Line
c)
Pie
d)
. Scatter
36.
Which function can an accounting department use in Cell A2 that will result in the current date?
a)
Count
b)
Count A
c)
Days360
d)
Now
37.
If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he use?
a)
Column
b)
Line
c)
Pie
d)
Scatter
38.
Which chart will best represent a comparison of the average family income for the states, with emphasis on the states?
a)
Column
b)
Line
c)
Pie
d)
Scatter
39.
Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?
a)
X-axis
b)
Y-axis
c)
Legend
d)
Chart title
40.
Hal has used four different colors to show the different products that his company sells. What will Hal use to explain the different product colors?
a)
X-axis
b)
Y-axis
c)
Legend
d)
Chart title
41.
Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
a)
Column
b)
Line
c)
Pie
d)
Scatter
42.
Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?
a)
Exploded pie
b)
Line
c)
Pie
d)
XY scatter
43.
What functions will produce results that indicate whether a student has passed or failed a course by entering the text “Pass” or “Fail”?
a)
Count
b)
Count A
c)
If
d)
Sum
Reset
