Font size
S
M
L
XL
WorksheetsCTE EOC-Review 7th Grade
Total questions: 139
Worksheet time: 2hrs 30mins
Name
Class
Date
1.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
2.
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
3.
individual locations on a spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
4.
Individual pieces of information typed into the spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
5.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
6.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
7.
Classification used for cells that contain text or for numbers that will not be used in calculations
a)
Label
b)
Value
c)
Formula
d)
Function
8.
This classification indicates that the data has the potential to be used in calculations.
a)
Label
b)
Value
c)
Formula
d)
Function
9.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
10.
All formulas and functions begin with...
a)
=
b)
SUM
c)
Labels
d)
Text
11.
Cell value remains static when copied to other locations
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
12.
Cell value changes as the formula is copied
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
13.
This function adds the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
14.
This function determines the average of the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
15.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
16.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
17.
Presenting and comparing data in a graphic format
a)
Charts/ Graphs
b)
Handles
18.
used to represent the percentage each item contributes to the total
a)
line chart
b)
pie chart
19.
useful for plotting trends/ styles/ and tendencies
a)
bar/ column chart
b)
line chart
20.
an object that explains the symbols, colors, or patterns used to differentiate data
a)
chart title
b)
data series
c)
legend
d)
plot area
21.
Used to compare the values of various items
a)
bar/column chart
b)
line chart
22.
Labels are text and numbers not calculated. Labels are aligned...
a)
Left
b)
Right
c)
Centered
23.
Values are numbers that have the potential to be used in calculations. Values are aligned
a)
Left
b)
Right
c)
Centered
24.
_______ is used to combine two or more cells
a)
Merge and Center
b)
Wrap Text
c)
Alignment
d)
Format
25.
__________ used to arrange data in alphabetical or chronological order.
a)
Sort
b)
Filter
c)
Fill Handle
26.
This allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges
a)
Freeze Panes
b)
Sort
c)
Fill Series Handle
d)
Wrap Text
27.
_________ is used to fill a column or row with consecutive data
a)
Fill Series Handle
b)
Sort
c)
Wrap Text
d)
Merge and Center
28.
This view is used to view how data is represented on paper
a)
Print Preview
b)
Print Selection
c)
Upload
29.
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
30.
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
31.
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
32.
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
33.
What computer program is made up of rows and columns that form cells?
a)
Database
b)
Desktop Publishing
c)
Spreadsheet
d)
Word Processing
34.
Which function would be used to add a range of cells in a spreadsheet?
a)
AVERAGE
b)
MIN
c)
MAX
d)
SUM
35.
Which function would be used to return the largest value in a range of spreadsheet cells?
a)
MIN
b)
MAX
c)
SUM
d)
AVERAGE
36.
What function would return the same answer as the formula =B2+B3+B4+B5+B6+B7?
a)
=SUM(B2/B7)
b)
=SUM(B2+B7)
c)
=SUM(B2:B7)
d)
=SUM(B2*B7)
37.
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?
a)
=MAX(A1:A6) )
b)
=MIN(A1:A6
c)
. =AVG(A1:A6) )
d)
=SUM(A1:A6
38.
Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
a)
Label
b)
Value
c)
Formula
d)
Function
39.
Audience
a)
the assembled spectators or listeners at a public event, such as a play, movie, concert, or meeting.
b)
a single page of a presentation. Collectively, a group of slides may be known as a slide show.
c)
slides shown in an order; they move in one direction.
d)
the planning and layout of images, illustrations, or videos with the aid of specialized software.
40.
Presentation
a)
a file that has been created with an overall layout and format to be used for a group of documents.
b)
the movement of text, graphics, or objects in a presentation
c)
made up of a series of slides that tell a story or present an idea; should progress like a story, sequentially, and with a clear purpose or plot.
d)
a picture or representation of something; picture
41.
Slideshow
a)
the area behind the main object of concentration on a slide.
b)
a picture or representation of something; picture
c)
a presentation supplemented by or based on a series of projected images or photographic slides
d)
the center of interest or activity
42.
Slide
a)
the area behind the main object of concentration on a slide.
b)
a single page of a presentation. Collectively, a group of slides may be known as a slide show.
c)
the assembled spectators or listeners at a public event, such as a play, movie, concert, or meeting.
d)
the center of interest or activity
43.
Background
a)
what you hear;sound
b)
the area behind the main object of concentration on a slide.
c)
limited amount of colors (3) used throughout presentations
d)
a shortcut that allows you to go from the presentation to another website
44.
image
a)
a picture or representation of something; picture
b)
a single page of a presentation. Collectively, a group of slides may be known as a slide show.
c)
a shortcut that allows you to go from the presentation to another website
d)
what you hear
45.
The planning and layout of images, illustrations, or videos with the aid of specialized software.
a)
design element
b)
slide
c)
transition
d)
background
46.
A file that has been created with an overall layout and format to be used for a group of documents.
a)
image
b)
linear
c)
template
d)
audience
47.
The overall appearance of a document, image, text designed to be more appealing to the viewer and help them identify what they are observing
a)
link
b)
non linear
c)
layout
d)
slideshow
48.
The movement of text, graphics, or objects in a presentation
a)
focus
b)
hyperlink
c)
animation
d)
link
49.
What you hear; sound
a)
layout
b)
audio
c)
transition
d)
color palette
50.
Slides that are shown in an order; they move in one direction
a)
linear
b)
link
c)
white space
d)
visual
51.
Slides can be viewed in any order; the viewer decides in which order to view the slides; usually interactive
a)
visual
b)
image
c)
non linear
d)
slide
52.
Contains the default placeholder styles and arrangement, slide background, text styles, list options and shapes for all slides contained in a presentation, regardless of which slide layout is used.
a)
Presentation Software
b)
Slide Layout
c)
Slide Master
d)
Slide Layout Master
53.
Used to produce interactive slide shows to enhance the presentation of information to an audience.
a)
Presentation Software
b)
Slide Layout
c)
Slide Master
d)
Slide Layout Master
54.
Used to position and hold content such as text, tables, videos and pictures
a)
Theme
b)
Placeholder
c)
Transition
d)
Animation
55.
Jade had determined that the audience for her presentation will need information about joining the American Medical Association. Which step has been completed?
a)
Determine the purpose
b)
Identify target audience
c)
Storyboard the content
d)
Select a design
56.
A social studies teacher has asked the class to explain the Revolutionary War in a 10 slide presentation. What type of presentation would be best?
a)
Educate
b)
Persuade
c)
Narrate
d)
Advertise
57.
A social studies teacher has asked each student to recreate their summer vacation in an amusing 10 slide presentation. What type of presentation would be best?
a)
Educate
b)
Persuade
c)
Narrate
d)
Advertise
58.
Donna has determined who will be attending her presentation. She has sketched a presentation on paper to use as she produces it. Which step has been completed?
a)
Determine the purpose
b)
Identify target audience
c)
Storyboard the content
d)
Select a design
59.
Amy had determined that the people who will be attending her presentation are all members of the American Medical Association. Which step has been completed?
a)
Determine the Purpose
b)
Identify Target Audience
c)
Storyboard the Content
d)
Select a Design
60.
A social studies teacher has asked the class to debate whether the “no gum policy” is fair in a 10 slide presentation.
a)
Educate
b)
Persuade
c)
Narrate
d)
Inform
61.
What combines text, graphics, animation, video, and audio?
a)
Clip art
b)
Drawing
c)
Games
d)
Multimedia
62.
Paul is a travel agent for AAA Travel. He is preparing a presentation that will be viewed at a trade show and hopes that the presentation will drum up more business. Paul made each slide fade out before progressing to the next slide. What should he do NEXT?
a)
Add and format graphics, audio, and video
b)
Enter the content
c)
Practice
d)
Revise as needed
63.
A multimedia slideshow about World War II is presented in history class. What kind of presentation is this?
a)
Exaggerated
b)
Informative
c)
Narrative
d)
Persuasive
64.
A presentation is prepared by a car manufacturer to train sales personnel on operating procedures for a new feature that is standard on all new models. The personnel are instructed to view the presentation on their own time. Which method of delivery is MOST appropriate?
a)
Continuous loop
b)
Group delivery with speaker
c)
Rolling script
d)
Self-serve
65.
A Slideshow about slavery is presented in your class. What kind of presentation is this?
a)
Exaggerated
b)
Informative
c)
Narrative
d)
Persuasive
66.
A presentation is prepared to show new software trade show. Which method is MOST appropriate?
a)
Continuous Loop
b)
Group Delivery with speaker
c)
Rolling Script
d)
Self-serve
67.
Which Slide introduces the audience to the presentation?
a)
End
b)
Name
c)
Start
d)
Title
68.
You are asked to explain PowerPoint in 10 slides. What type of presentation is best
a)
Educate
b)
Persuade
c)
Narrate
d)
Advertise
69.
Susan is presenting BETA information to middle school students. She wishes to key the BETA creed of 12 lines on a slide. Which content rule should she consider?
a)
keep speeches and creeds on one slide for clarity
b)
6-8 rule
c)
rule of sevens
70.
After reviewing his presentation, Abe determined that he needed to add more information into his presentation.
Which step of DEVELOPING A MULTIMEDIA PRESENTATION has he just completed?
Which step of DEVELOPING A MULTIMEDIA PRESENTATION has he just completed?
a)
Add animations and transitionsRevise as neededPracticeSelect a design Add animations and transitions
b)
Revise as needed
c)
Practice
d)
Select a design theme
71.
What is the Rule of 7s?
a)
7 lines of text per slide, 7 slides per presentation
b)
7 paragraphs per slide, 7 words per line
c)
7 lines of text per slide, 7 words per line
d)
7 lines of text per slide, 7 point font
72.
Paul selected his template and color theme in Power Point, now he needs to set the font style and size he wants to use. What is his next step?
a)
Add animation and transition
b)
Edit the master slide
c)
Enter the content
d)
Storyboard the content
73.
A presentation is prepared containing the words of the school's alma mater. It will be broadcast during the graduation ceremony to accompany the band and assist the guests in singing the song. Which method of delivery is MOST appropriate?
a)
Continuous loop
b)
Group delivery with speaker
c)
Rolling script
d)
Self-service
74.
What document includes the order of topics to be covered at a meeting and the individuals responsible for each topic?
a)
Agenda
b)
Minutes
c)
Itinerary
d)
Schedule
75.
What is the summary of the events and business conducted during a meeting?
a)
Agenda
b)
Minutes
c)
Itinerary
d)
Report
76.
What is the Adjournment?
a)
Time the meeting finished
b)
Notation of who adjourned the meeting
c)
Statement that the meeting is over
d)
the end
77.
Side headings of minutes should be keyed in:
a)
All Caps
b)
All Caps and Underlined
c)
Lower and Upper Case Letters
d)
Lower and Upper Case Letters and Underlined
78.
What are the components that make up the heading of an Agenda?
a)
Organization Name
b)
Date
c)
Location
d)
All of the Above
79.
Which of these are components of minutes?
a)
Heading and Call to Order
b)
Approval of Minutes and Committee Reports
c)
Old Business and New Business
d)
All of the above
80.
Who is responsible for signing the signature line of minutes?
a)
CEO
b)
Secretary
c)
Janitor
d)
Principal
81.
What is NOT included in the BODY of an agenda?
a)
Time slots
b)
Speakers
c)
Location
d)
Topics
82.
The HEADING of an agenda must be?
a)
Left aligned
b)
Right aligned
c)
Centered
d)
At the bottom
83.
Agendas are prepared before?
a)
Conference
b)
Lunch
c)
Working out
d)
Bed
84.
The body of the report is the
a)
Content
b)
Meaning
c)
Summary
d)
Title
85.
Part of Minutes that is the keyed name of the Recording Secretary and their handwritten name.
a)
Old Business
b)
New Business
c)
Adjournment
d)
Signature Line
86.
Part of Minutes that is the unresolved discussions from a previous meeting.
a)
Old Business
b)
New Business
c)
Adjournment
d)
Signature Line
87.
Part of Minutes that is a notation of who ended the meeting and the time the meeting was ended.
a)
Old Business
b)
New Business
c)
Adjournment
d)
Signature Line
88.
Part of Minutes that is a review of previous meetings minutes by organization members.
a)
Approval of Minutes
b)
Call to Order
c)
Attendance Record (roll call)
d)
Committee Reports
89.
Document that describes discussions, decisions, and actions that occurred during a meeting.
a)
Title
b)
Heading
c)
Body
d)
Opening
90.
Document that describes discussions, decisions, and actions that occurred during a meeting.
a)
Minutes
b)
Business Letter
c)
Spreadsheet
d)
Agenda
91.
Document that has a list of items to be discussed or acted upon at a meeting?
a)
Minutes
b)
Business Letter
c)
Spreadsheet
d)
Agenda
92.
Which type of business document accompanies a report to list the topics in order in which they occur?
a)
minutes
b)
agenda
c)
table of contents
d)
research report
93.
How should the paragraphs in the report be keyed?
a)
hanging indent
b)
indented
c)
centered
d)
block
94.
What should be the line spacing in the BODY of the report?
a)
triple
b)
double
c)
quadruple
d)
single
95.
Identify the business document that summarizes detailed information regarding on main topic.
a)
Agenda
b)
Minutes
c)
Research Report
d)
Table of Contents
96.
How should the title in the report be keyed?
a)
Initial caps and centered
b)
Centered, bold, & underlined
c)
Left aligned, bold, and initial caps
d)
Right aligned, bold, and all caps
97.
Which alignment is used for the body of a report?
a)
centered
b)
left aligned
c)
justified
d)
right aligned
98.
Which would be an activity of a report?
a)
a list of topics to be covered in the upcoming meeting
b)
summary of the discussion of the meeting
c)
a detailed summary of current market trends
d)
a list of topics with location listed as a page number
99.
Which part of minutes would be unresolved or tabled discussions from a previous meeting?
a)
Approval of minutes
b)
Committee Reports
c)
Old Business
d)
Call to Order
100.
Which part of minutes would be Mrs. Smith, our committee chair, began the meeting at 3:00 pm?
a)
Approval of minutes
b)
Committee Reports
c)
Old Business
d)
Call to Order
101.
Page numbers should be included:
a)
On all pages
b)
On page 1 only
c)
On page 2 and following pages
d)
On even numbered pages
102.
Where should page numbers be located in an unbound report?
a)
Top Right
b)
Bottom Right
c)
Top Left
d)
Bottom Left
103.
When formatting an agenda, the spacing between numbered items should be...
a)
double spaced
b)
single spaced
c)
triple spaced
d)
quadruple spaced
104.
When typing minutes, the spacing withing the paragraphs should be what?
a)
DS
b)
SS
c)
TS
d)
QS
105.
The first page of an MLA document includes:
a)
Student name
Teacher Name
Date
Teacher Name
Date
b)
Student Name
Date
Date
c)
Student Name
Title of paper
Date
Title of paper
Date
d)
Student name
Teacher name
Course
Date
Teacher name
Course
Date
106.
which one of the following is optional?
a)
title page
b)
title
c)
body
d)
header
107.
MLA stands for
a)
Modern laughing Association
b)
Modern Language Association
c)
modern looking furniture
108.
A multi-page document that usually contains several sub-topics of information related to one main topic
a)
Agenda
b)
Minutes
c)
Research Report
d)
Table of Contents
109.
A complete listing of references cited parenthetically in the report and keyed on a separate page
a)
Works Cited
b)
Research Report
c)
Table of Contents
d)
Agenda
110.
Chronological listing with page numbers of contents of an accompanying research report
a)
Table of Contents
b)
Works Cited
c)
Agenda
d)
Minutes
111.
For an essay, what size of font should you write every single word in?
a)
14 point
b)
8 point
c)
12 point
d)
10 point
112.
Which of the following documents has a section called call to order?
a)
MLA report
b)
Minutes
c)
Agenda
113.
What font size is used in MLA 8 formatting?
a)
10
b)
8
c)
11
d)
12
114.
Which of the following date formats are correct for MLA reports?
a)
11/9/2015
b)
November 9, 2015
c)
9 November, 2015
d)
9 November 2015
115.
What are the margins in MLA reports?
a)
.5"
b)
1"
c)
1.5"
d)
2"
116.
Abby Mourning
Ms. Smith
Digital Literacy
17 November 2015
This is an example of a what?
Ms. Smith
Digital Literacy
17 November 2015
This is an example of a what?
a)
header
b)
heading
c)
title
d)
paragraph
117.
What component does an agenda have in common with a table of contents?
a)
Date
b)
List of topics
c)
Page number
d)
Time slots
118.
Which part of a Social Studies report will list all of the sources?
a)
Table of contents
b)
Title page
c)
Work Cited
d)
Report body
119.
Which two documents have the most components in common?
a)
Agenda and business letter
b)
Business letter and minutes
c)
Letter and research report
d)
Minutes and agenda
120.
Kim’s Social Studies teacher has assigned her to research countries in Europe. What type of document would best summarize her research?
a)
Minutes
b)
Agenda
c)
Report
d)
Table of Content
121.
Kim’s Social Studies teacher has assigned her to research countries in Europe. What type of document would best summarize her research?
a)
Minutes
b)
Agenda
c)
Report
d)
Table of Content
122.
Keith prepared a report on different shoe companies. Which part of the report is used as the cover?
a)
Table of contents
b)
Title page
c)
Work Cited
d)
Report body
123.
Keith prepared a report on different shoe companies. Which part of the report lists page numbers for each shoe company?
a)
Table of contents
b)
Title page
c)
Work Cited
d)
Report body
124.
What line spacing is used for works cited?
a)
Single
b)
Double
c)
Triple
d)
Quadruple
125.
What line spacing is used for works cited?
a)
Single
b)
Double
c)
Triple
d)
Quadruple
126.
Notation of who official ended the meeting
a)
Adjournment
b)
Signature Line
c)
New Business
d)
Call to Order
127.
Chronological listing with page numbers of contents of an accompanying research report
a)
Table of Contents
b)
Works Cited
c)
Agenda
d)
Minutes
128.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
129.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
130.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
131.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
132.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
133.
Who might use business meeting minutes?
a)
PTO
b)
A stockholder's meeting
c)
Board of Education
d)
All of the above
134.
A(n) _________ is a short report which is a short report prepared for business without a binder but usually paper clipped or stapled.
a)
bound report
b)
unbound report
c)
title page
d)
work cited page
135.
Which part of minutes would be unresolved or tabled discussions from a previous meeting?
a)
Approval of minutes
b)
Committee Reports
c)
Old Business
d)
Call to Order
136.
Part of agenda that has the organization name, the title Agenda, the date, time and location?
a)
Title
b)
Heading
c)
Body
d)
Opening
137.
What formatting feature is used in cells B14:E14?
a)
Percentage
b)
Accounting border
c)
Merge and center
d)
Wrap Text
138.
A horizontal line of data in a spreadsheet is called
a)
value
b)
column
c)
row
d)
label
139.
Which of the following is a value?
a)
B6
b)
37
c)
Cost
d)
=B2+C3
Reset
