NEW
Font size
S
M
L
XL
WorksheetsIntro to Office EOC Review
Total questions: 74
Worksheet time: 39mins
Name
Class
Date
1.
What would be a correct formula for sum in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
2.
Which symbol must you use to begin a formula?
a)
+
b)
=
c)
/
d)
*
3.
A workbook is defined as having 1 or more ____________________.
a)
books
b)
cells
c)
blocks
d)
spreadsheets
4.
B1 would be referred to as a cell __________________.
a)
mate
b)
book
c)
map
d)
address
5.
What is an active cell?
a)
The first cell in a database.
b)
The cell currently selected.
c)
The cell that all the data goes to.
d)
The cell that you typed in last.
6.
E44 is an example of a __________________.
a)
Cell Reference
b)
Formula Bar
c)
Active Cell
d)
Formula
7.
Which one of these formulas uses relative cell references?
a)
=8/10+3
b)
=$b4$2/10
c)
=F6*H7/J2
8.
Which of these formulas uses absolute cell references?
a)
=8/10+3
b)
=$B4$D2
c)
=F6*H7/2
9.
What does this tool do?
a)
Make a table
b)
Make a chart
c)
Make borders
d)
Make a formula
10.
What term refers to a group of spreadsheets in 1 file?
a)
Cell range
b)
Active cells
c)
Worksheet
d)
Workbook
11.
Absolute Cell reference is
a)
A cell reference that always stays the same, even if you copy it.
b)
A cell reference that has a formula in it
c)
The cell you always need to come back to in a table
d)
Another name for cell A1, the main cell in a spreadsheet.
12.
What function calculates the average value of a range of cells?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
13.
If a cell returns a value of "#####", what does that mean has happened?
a)
Error in calculation
b)
Typed the formula incorrectly
c)
Column width not large enough
d)
Caps lock is on
14.
What symbol is used to designate an absolute cell reference?
a)
#
b)
$
c)
@
d)
!
15.
The feature that allows you to quickly apply the contents of one cell to another cell or range of cells.
a)
Enter
b)
Autofill
c)
Delete
16.
In a worksheet, the vertical spaces with letter headings.
a)
Rows
b)
Cell addresses
c)
Columns
17.
The contents of the active cell, or its formula is always displayed in the _______.
a)
Insert
b)
Formula bar
c)
Tables
18.
In a worksheet, the horizontal spaces with the headings 1,2,3, and so on.
a)
Rows
b)
Columns
c)
Bold
d)
Italics
19.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Cell address
b)
Worksheet
c)
Formula
20.
Text within the spreadsheet is referred to as ____________________.
a)
labels
b)
images
c)
choices
d)
figures
21.
Data which will be calculated is referred to as __________________.
a)
previews
b)
menus
c)
spreadsheets
d)
values
22.
You can find the location of a cell or (cell reference) by looking at the _______.
a)
The intersection of a column and row
b)
Columns and rows next to it
c)
The value of a formula
d)
By looking at the row under the selection
23.
Which button/icon do you click on to condense a range of cells into one cell?
a)
merge and combine
b)
merge and center
c)
center align
d)
justify
24.
Displays cell contents on multiple lines within the cell.
a)
Orientation
b)
Identing
c)
Alignment
d)
Wrap Text
25.
To place data in descending order would mean you've done which?
a)
Cell change
b)
Sort A-Z
c)
Sort Z-A
d)
Wrap Text
26.
The ______ ________ is generally the first slide of a presentation used to tell the title and author of a presentation.
a)
Title and Content Slide
b)
Title Slide
c)
New Slide
d)
Slide
27.
Who should you always keep in mind when you are presenting a PowerPoint?
a)
Auidence
b)
Family
c)
Friend
d)
Yourself
28.
What menu option do you use if you want to rehearse timings?
a)
Home
b)
Insert
c)
Slide Show
d)
Review
29.
Jill sketched the content of the presentation out on paper before creating it on the computer. Which step is she completing?
a)
Step 1 - Determine the purpose
b)
Step 3 - Storyboard the content
c)
Step 6 - Enter the content
d)
Step 7 - Add pictures, videos, and audio
30.
Jill typed the recipe to make a chocolate cake in a slide. What step is she completing?
a)
Step 3 - Storyboard the content
b)
Step 4 - Select a design
c)
Step 6 - Enter the content
d)
Step 8 - Add animations and transitions
31.
What is a program used to create slide shows or multimedia presentations?
a)
Transitions
b)
Multimedia
c)
Presentation software
d)
Designs
32.
This type of presentation is used to train, present information, emphasize key points, and explain procedures.
a)
Narrative
b)
Persuasive
c)
Educational
d)
Multimedia
33.
This type of presentation is used to advertise or provoke action.
a)
Narrative
b)
Persuasive
c)
Educational
d)
Multimedia
34.
This type of presentation is used to broadcast messages, tell a story, and entertain.
a)
Narrative
b)
Persuasive
c)
Educational
d)
Multimedia
35.
_______ are used when you want to add motion to each slide.
a)
Animations
b)
Transitions
c)
Designs
d)
Presentations
36.
________ are used when you want to add motion to individual pieces of text or to pictures.
a)
Transitions
b)
Animations
c)
Designs
d)
Multimedia
37.
True/False: Slides should have no more than 7 lines of text per slide.
a)
True
b)
False
38.
Jill decided to teach elementary school students how to bake a chocolate cake. Which step is she completing?
a)
Step 1 - Determine the purpose
b)
Step 3 - Storyboard the content
c)
Step 4 - Select a design
d)
Step 6 - Enter the content
39.
Beth selected a set of slides for her presentation that has a picture of the beach as her background. Which step has she completed?
a)
Step 4 - Select a design
b)
Step 5 - Edit the Master
c)
Step 7 - Insert image, audio, or video
d)
Step 9 - Rehearse
40.
Andrew added a sound file to his slide. Which step has he completed?
a)
Step 4 - select a design
b)
Step 6 - Insert content
c)
Step 7 - add image, audio, or video clip
d)
Step 8 - add transitions and animations
41.
Daniel made his slides reveal from the right. Which step has he completed?
a)
Step 4 - Select a design
b)
Step 5 - Edit the master
c)
Step 6 - enter the content
d)
Step 8 - add animations and transitions
42.
Amber noticed that she misspelled words on a slide, she decided to edit that slide. What step has she completed?
a)
Step 6 - enter the content
b)
Step 5 - Edit the master
c)
Step 9 - Rehearse
d)
Step 10 - Revise as needed
43.
In order to take part in the Heart of a Champion physicals, students had to complete an online questionnaire form. What type of delivery method was used in this scenario?
a)
Self-Serve
b)
Continuous Loop
c)
Group Delivery with Speaker
d)
Audience Handouts
44.
Before students could enjoy their field trip to the White Water Center, they had to watch a safety presentation. This is an example of which type of delivery method?
a)
Group delivery without speaker
b)
Rolling script
c)
Group delivery with speaker
d)
Audience Handouts
45.
In order to help your audience remember and understand your presentation, you made hard copies of your presentation to share. Which type of delivery method are you using?
a)
Audience Handouts
b)
Self-Serve
c)
Continuous Loop
d)
Group Delivery with Speaker
46.
What document should always be distributed shortly after having an FBLA meeting?
a)
flyer
b)
minutes
c)
newsletter
d)
academic report
47.
When keying a Table of Contents page, how should the page be numbered?
a)
page is not numbered
b)
centered at the bottom of the page, using Roman numeral format
c)
inside the header
d)
author's choice
48.
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
49.
How should the paragraphs in the report be keyed?
a)
hanging indent
b)
indented
c)
centered
d)
block
50.
What should be the line spacing in the BODY of the report?
a)
triple
b)
double
c)
quadruple
d)
single
51.
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
52.
When citing a source within the paragraph you should use which type of citation?
a)
endnote
b)
footnote
c)
parenthetical
d)
notes page
53.
Which alignment is used for the body of a report?
a)
centered
b)
left aligned
c)
justified
d)
right aligned
54.
What is the purpose of a works cited page?
a)
Provide additional readings on a report
b)
Provide all publications related to a report topic
c)
Provides a list of references cited in a report
d)
Provide a list of all sources related to a report
55.
Which would be an activity of an agenda?
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
56.
Which would be an activity of minutes?
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
57.
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
58.
Which would be an activity of a table of contents?
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
59.
How should the references be formatted on the Works Cited page?
a)
Indented
b)
Hanging Indent
c)
Block Style
d)
Center Align
60.
Which component would not be on a Title Page?
a)
Title
b)
Page Number
c)
Student Name
d)
Date
61.
Which business document is sent out prior to a meeting?
a)
Agenda
b)
Minutes
c)
Research Report
d)
Table of Contents
62.
What word processing feature is used to control the left-to-right flow of the text on an agenda?
a)
tab
b)
hanging indent
c)
show/hide
d)
dot leader tabs
63.
When creating an agenda, you should single space between each topic or event.
a)
True
b)
False
64.
An agenda may include times, topics, speakers, locations, or simply a list of items to cover.
a)
True
b)
False
65.
When creating minutes, you should key each topic in single space, paragraph style and double space between topics.
a)
True
b)
False
66.
Which part of minutes would be a review of previous minutes by school board members?
a)
Approval of minutes
b)
Committee Reports
c)
Old Business
d)
Call to Order
67.
Which part of minutes would be during the monthly school improvement team meeting, each grade level representative shared any concerns or suggestions?
a)
Approval of minutes
b)
Committee Reports
c)
Old Business
d)
Call to Order
68.
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
69.
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
70.
What minutes component shows all the members present and members that are absent?
a)
Call to Order
b)
Welcome
c)
Roll Call
71.
Which document will Scott prepare for all attendees at the Banker's Association meeting to list the accountant who is responsible to presenting each topic?
a)
agenda
b)
minutes
c)
memo
d)
outline
72.
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
73.
Where should page numbers be located in an unbound report?
a)
Top Right
b)
Bottom Right
c)
Top Left
d)
Bottom Left
74.
Times New Roman is a good font choice for an unbound report.
a)
True
b)
False
Reset
