Font size
S
M
L
XL
WorksheetsEOC Review
Total questions: 90
Worksheet time: 45mins
Name
Class
Date
1.
Which chart will BEST represent the percentage of expenses for office supplies, salaries, and travel for a company’s total budget?
a)
Line
b)
Pie
c)
Stacked bar
d)
XY scatter
2.
A stacked bar chart was created torepresent the total sales of eachemployee over a four month period.Which feature will make the plot areaeasier to read?
a)
Chart title
b)
Axis title
c)
Gridlines
d)
Data series
3.
The number of hours worked is recorded in cell D7, Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which function correctly determine show many overtime hours have occurred?
a)
=IF(D7>40,D7-40)
b)
=MAX(D1:D7)*1.5
c)
=OVERTIME(D7*E7)
d)
=IF(D7<40),1.5*E7
4.
Which chart will best represent eachperson's contribution to the totalhousehold budget over a period of sixmonths?
a)
Stacked bar
b)
XY scatter
c)
Exploded pie
d)
Pie
5.
If Jake wants to find out if the size of afruit has any effect on the total sales forthe week of that particular fruit, whatchart should he use?
a)
Column
b)
Pie
c)
Stacked bar
d)
XY scatter
6.
Which chart will best represent the effectof increasing the frequency of acompany's radio advertisements onsales?
a)
Column
b)
Pie
c)
XY scatter
d)
Stacked bar
7.
If Jake wants to study the relationshipbetween the daily temperature and theamount of fruit sold during a week whatkind of chart should he use?
a)
Line
b)
Pie
c)
Stacked bar
d)
XY scatter
8.
A chart is created that compares thenumber of units for products A and Bsold for three months. Which dataappears on the y-axis?
a)
Units Sold
b)
Sales
c)
Products
d)
Months
9.
When creating a chart to analyze theeffect of 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
10.
A spreadsheet is created with drop downitems that a user can select from. This isan example of which function?
a)
LookUp
b)
Fill Series
c)
Count
d)
List
11.
Which function can a credit cardcompany use to determine the time thathas elapsed since a customer's paymentwas received?
a)
Days360
b)
Count
c)
Now
d)
CountA
12.
When creating a chart to analyze theeffect of oil prices on the cost of stocks,which data will appear on the y-axis
a)
Months
b)
Oil Prices
c)
Stock names
d)
Stock prices
13.
Which type of list allows additionalentries other than those provided in thedrop-down menu?
a)
Validated
b)
Non-validated
c)
LookUp
d)
VLookUp
14.
Which chart will BEST represent thedecline of sales for a music companyover the past five years?
a)
Column
b)
Line
c)
Pie
d)
XY scatter
15.
Which function can an accountingdepartment use that will result in thecurrent date?
a)
CountA
b)
Now
c)
Count
d)
Days360
16.
Which chart will BEST represent acomparison of three average familyincomes?
a)
Column
b)
Line
c)
Pie
d)
XY scatter
17.
What area of the chart is used to explainthe symbols, colors, or patterns used todifferentiate the data?
a)
Data label
b)
Chart title
c)
Axis
d)
Legend
18.
Which function will automatically add thetotal value in a range of cells?
a)
SUM
b)
RANGE
c)
COUNT
d)
IF
19.
What is used in a graph to clarify datacategories or values?
a)
X-axis
b)
Y-axis
c)
Plot area
d)
Tick marks
20.
On most charts, what is the horizontal(bottom) edge of the plot area called?
a)
Z axis
b)
A axis
c)
Y axis
d)
X axis
21.
Which type of chart that appears on thesame sheet as the spreadsheet itrepresents?
a)
Embedded
b)
Linked
c)
Column
d)
Line
22.
On most charts, what is the vertical (left)edge of the plot area called?
a)
A axis
b)
X axis
c)
Y axis
d)
Z axis
23.
Which chart BEST enhances individual components?
a)
XY scatter
b)
Exploded pie
c)
Stacked bar
d)
Column
24.
When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the y-axis?
a)
Months
b)
Oil prices
c)
Stock names
d)
Stock prices
25.
When creating a chart to analyze the effect of 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
26.
A chart is created that compares the number of units of Product A sold against the number of units of Product B sold for a period of three months. Which data appears on the y-axis?
a)
Months
b)
Products
c)
Sales
d)
Units Sold
27.
A chart is created that compares the number units of Product A sold against the number of units of Product B sold for a period of three months. Which data appears on the x-axis?
a)
Months
b)
Products
c)
Sales
d)
Units Sold
28.
Which chart will BEST represent the decline of sales for a music company over the past five years?
a)
Column
b)
Line
c)
. Pie
d)
. XY scatter
29.
Which chart will BEST represent each spouse's contribution to the total household budget over a period of six months?
a)
Exploded pie
b)
Pie
c)
Stacked bar
d)
XY scatter
30.
Which chart will BEST represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?
a)
Line
b)
Pie
c)
Stacked bar
d)
XY scatter
31.
Which chart will BEST represent the effect of increasing the frequency of a company's radio advertisements on sales?
a)
Column
b)
Pie
c)
Stacked bar
d)
XY scatter
32.
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)
Line
b)
Pie
c)
Stacked bar
d)
XY scatter
33.
If Jake wants to find out if the size of a fruit has any effect on the total sales for the week of that particular fruit, what chart should he use?
a)
Column
b)
Pie
c)
Stacked bar
d)
XY scatter
34.
. A chart is created comparing employee absences for the Shoe Department over a period of six months, with emphasis on the months. Which data will appear on the x-axis?
a)
Absences
b)
Employee name
c)
Months
d)
Salaries
35.
When creating a chart comparing employee absences over a period of six months, which data will appear on the y-axis?
a)
Absences
b)
Employee name
c)
Months
d)
. Salaries
36.
When creating a chart to compare the test scores of students on the midterm and the end of term exams, which data will appear on the y-axis?
a)
Midterm
b)
Students
c)
Terms
d)
Test scores
37.
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
38.
Which chart will BEST represent an increase in sales for the shoe department over time and compare it to a decrease in sales of the cosmetics department over the same period of time?
a)
Line
b)
Pie
c)
Stacked bar
d)
XY scatter
39.
Which chart will BEST represent the individual sales of each employee to the total sales for the company for a period of six months?
a)
Column
b)
Pie
c)
Stacked bar
d)
XY scatter
40.
If Jake wants to represent the total sales of each fruit for a week, what kind of chart should he use?
a)
Column
b)
Pie
c)
Stacked bar
d)
XY scatter
41.
If Jake wants to represent the percentage of expenses used by gas and labor, what kind of chart should he use?
a)
Column
b)
Pie
c)
Stacked bar
d)
XY scatter
42.
What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?
a)
Count
b)
CountA
c)
Fill Series
d)
If
43.
What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation?
a)
Embed
b)
Import
c)
Link
d)
Target
44.
Which function can an accounting department use in Cell A2 that will result in the current date?
a)
Count
b)
CountA
c)
Days360
d)
Now
45.
Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?
a)
Count
b)
CountA
c)
Days360
d)
Now
46.
. Ernie uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which function should he use
a)
If
b)
LookUp
c)
Max
d)
Min
47.
What function will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise?
a)
If
b)
LookUp
c)
Max
d)
Min
48.
Purchase discounts are awarded as follows: 3% for sales of $300, 5% for sales of $500, and 9% for sales of $900 or more. What function is used to determine which discount is allowed based on the purchase price?
a)
Count
b)
Days360
c)
List
d)
Lookup
49.
A spreadsheet is created with drop down items that a user can select from. This is an example of which function?
a)
Count
b)
Fill series
c)
List
d)
Lookup
50.
The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occurred?
a)
=IF(D7<40),1.5*E7
b)
=IF(D7>40,D7-40)
c)
=MAX(D1:D7)*1.5
d)
=OVERTIME(D7*E7)
51.
Mrs. Bills wants to find all students in a database who have met one of the following conditions: (1) sold less than ten cases (2) raised at least 50 dollars.Which condition will provide the desired results?
a)
Greater Than
b)
Less Than
c)
And
d)
Or
52.
Mrs. Bills wants to view alphabetical list of all students who participated in the Lollipops fundraiser. Which action should she take?
a)
Sort in ascending order on StudentName
b)
Sort in descending order on StudentName
c)
Sort in ascending order on Lollipops
d)
Sort in descending order on Lollipops
53.
Mrs. Bills wants to print an alphabetical list of all students who participated in the Lollipops fundraiser. Which action should she take before printing?
a)
Create a query
b)
Create a report
c)
Create a table
d)
Create a form
54.
Farmer Brown created a database to keep track of his dairy cows. Which of the following is an example of a database record?
a)
Cow=Elsie
b)
Cow, Age, Weight, Milk Production
c)
Elsie, 7, 800, 5
d)
800, 790, 250
55.
What are the four objects used in a relational database?
a)
Tables, Forms, Queries, Reports
b)
Entries, Fields, Records, Tables
c)
Text, Memo, Date/Time, Lookup
d)
Field Size, Format, Input Mask,Caption
56.
Mrs. Bills want to determine who has sold the most Lollipops. Which action should she take to view this information at the top of the page?
a)
Filter on Lollipops greater than 100
b)
Filter on Lollipops less than 100
c)
Sort in ascending order on Lollipops
d)
Sort in descending order on Lollipops
57.
Which object would Farmer Brown create to find out which cows produced more than 5 gallons per day?
a)
Table
b)
Query
c)
Form
d)
Report
58.
Which object would Farmer Brown create to produce a printed copy of monthly milk production?
a)
Table
b)
Query
c)
Form
d)
Report
59.
Which object is considered the basic building block of a relational database?
a)
Memo
b)
Table
c)
Record
d)
Form
60.
Mrs. Bills needs to get a list of students who have sold at least 100 lollipops.Which criterion is used?
a)
Lollipops Less Than 100
b)
Lollipops Greater Than 100
c)
Lollipops Greater Than or Equal to 100
d)
Lollipops Less Than or Equal to 1
61.
Which object would you create to view one record at a time when adding or editing data in a database?
a)
Table
b)
Query
c)
Form
d)
Report
62.
Moore Middle School FBLA plans to announce the new officers’ names and positions, summarize the previous weekend’s fundraising event, and promote the upcoming visit to the nursing home. What is the most appropriate publication choice for this information?
a)
Brochure
b)
Business card
c)
Flyer
d)
Newsletter
63.
Which publication is used to advertise a one- time upcoming event?
a)
Letterhead
b)
Flyer
c)
Newsletter
d)
Brochure
64.
The Chamber of Commerce assists local businesses in securing guest speakers for classroom presentations. What is the most appropriate publication choice for information that highlights the topics of expertise and background data on each speaker?
a)
Brochure
b)
Business card
c)
Illustration
d)
Newsletter
65.
Which design principle is illustrated by the font scheme below?
Major headings – 14 pt Arial fontSubheadings – 12 pt Cambria fontBody text – 11 pt Calibri font
Major headings – 14 pt Arial fontSubheadings – 12 pt Cambria fontBody text – 11 pt Calibri font
a)
Alignment
b)
Contrast
c)
Proximity/unity
d)
Repetition/consistency
66.
James will be presenting a slide show to a group of 7th grade students who are studying the solar system. Which characteristics of the target audience is identified by the student grade level?
a)
Age & Educational background
b)
Age & Interests
c)
Group membership & Educationalbackground
d)
Interests & Age
67.
A flyer used to advertise the school dance is created in which the location,date, time and cost are centered on the document. This is an example of which design principle?
a)
Alignment
b)
Contrast
c)
Proximity/unity
d)
Repetition/consistency
68.
Jack carefully placed photographs of the different animals he saw in Yellowstone National Park next to the blocks of text he wrote describing them. This is an example of which design principle?
a)
Alignment
b)
Consistency
c)
Contrast
d)
Proximity
69.
Robert will be going to a senior citizen meeting to present information about anew retirement community. Which characteristic of the target audience is identified?
a)
Age
b)
Educational background
c)
Group membership
d)
Interests
70.
A publication being prepared thatf ocuses on the limited vocabulary of the audience and uses more graphics to convey the message would be focusing on what trait of the target audience?
a)
Age
b)
Educational background
c)
Interests
71.
Zack is introducing himself to the local Chamber of Commerce in hopes of attracting new customers. What is the most appropriate publication choice that will provide Zack’s contact information?
a)
Business card
b)
Brochure
c)
Letterhead
d)
Newsletter
72.
Which design principle is used to give the reader's eyes a break and focus the reader's attention on important details?
a)
Proximity
b)
Contrast
c)
White space
d)
Balance
73.
Susan was invited to make a presentation to a local Girl Scout troop. Which characteristic of the target audience is identified?
a)
Age
b)
Educational background
c)
Group membership
d)
Interests
74.
Ramon will be speaking to a group of doctors about a new medical procedure.Which characteristic of the target audience is identified?
a)
Age
b)
Educational background
c)
Group membership
d)
Interests
75.
The use of a heading at the top and sometimes at the bottom of stationary is known as:
a)
Business Card
b)
Letterhead
c)
Newsletter
d)
Flyer
76.
Jan created an informational publication on school clubs and activities. This is an example of which type of publication?
a)
Letterhead
b)
Brochure
c)
Flyer
d)
Newsletter
77.
The use of black font on a peach colored page is an example of which design principle?
a)
Alignment
b)
Contrast
c)
Proximity/unity
d)
Repetition/consistency
78.
The FBLA secretary created a publication to display the date, time, and location of the next meeting. This is an example of which type of publication?
a)
Brochure
b)
Flyer
c)
Letterhead
d)
Newsletter
79.
Juan determined that attendees at an ice hockey game typically enjoy listening to rock music and fast-food restaurants. Which characteristic of the target audience has Juan identified?
a)
Age
b)
Educational background
c)
Group membership
d)
Interests
80.
Jan created an informational booklet on school clubs and activities. This is an example of which type of publication?
a)
Agenda
b)
Brochure
c)
Flyer
d)
Newsletter
81.
First National Bank created a publication that explains the different types of interest-bearing savings plans. It includes information on IRAs, 401(k)s, CDs, and money market accounts. This is an example of which type of publication?
a)
Brochure
b)
Flyer
c)
Letterhead
d)
Newsletter
82.
Zack is introducing himself to the local chamber of commerce in hopes of drumming up new customers and getting his name known as a teacher. What is the most appropriate publication choice that will provide Zack's contact information?
a)
Business card
b)
Brochure
c)
Letterhead
d)
Newsletter
83.
The Chamber of Commerce assists local businesses in securing guest speakers for classroom presentations. What is the most appropriate publication choice for information that highlights the topics of expertise and background data on each speaker?
a)
Brochure
b)
Business card
c)
Illustration
d)
Newsletter
84.
Moore High School FBLA plans to announce the new officers' names and positions, summarize the previous weekend's fundraising event, and promote the upcoming visit to the nursing home. What is the most appropriate publication choice for this information?
a)
Brochure
b)
Business card
c)
Flyer
d)
Newsletter
85.
The DataMax Company wants to educate the public about the design and highlight the features of its newest product at an upcoming trade show. What is the most appropriate publication choice for this information?
a)
Brochure
b)
Business card
c)
Letterhead stationery
d)
Newsletter
86.
A publication is being planned to entice people to visit a new exhibit at the NC Museum of Natural History about fun and exciting activities in the Appalachian Mountains. The team wants to inform the public about the new exhibit including the dates and times the museum will be open and the cost of admission. What is the most appropriate publication choice for this information?
a)
Brochure
b)
Business card
c)
Flyer
d)
Newsletter
87.
A design team is creating a publication for the Twisted Stitcher clothing store. The store features original and custom-tailored apparel. publication for the Twisted Stitcher clothing store. The store features original and custom-tailored apparel. What color scheme should the design team use for the company letterhead?
a)
Light green stationery with dark blue font
b)
Light yellow stationery with white font
c)
Purple stationery with purple font
d)
Yellow stationery with mint green font
88.
A design team is developing a publication for a personalized clothing business. The publication will be distributed monthly to members of the Twisted Stitchers sewing club to highlight upcoming events and sewing tips. What is the most appropriate publication choice for this information?
a)
Brochure
b)
Business card
c)
Flyer
d)
Newsletter
89.
A design team is creating personalized publications for each business associate in a clothing store. Each publication will include contact name, phone number, and email address. This is an example of a:
a)
brochure.
b)
business card
c)
flyer.
d)
newsletter.
90.
Jack carefully placed photographs of the different animals he saw in Yellowstone National Park next to the blocks of text he wrote describing them. This is an example of which design principle?
a)
Alignment
b)
Consistency
c)
Contrast
d)
Proximity
Reset
