Font size
S
M
L
XL
Worksheets2022 BIM II Final Exam Review
Total questions: 110
Worksheet time: 9hrs 10mins
Name
Class
Date
1.
position of text in relation to the width of the page
a)
Alignment
b)
Accessibility Checker
c)
Worksheets
d)
Workbook
2.
list of all of the sources which have been used in the process of researching the information included in a document
a)
Bibliography
b)
Alignment
c)
Accessibility Checker
d)
Worksheets
3.
label which identifies illustrations such as tables, charts, figures or images located in a document
a)
Caption
b)
Building Blocks
c)
Bibliography
d)
Alignment
4.
an in-text reference to a source where information was obtained
a)
Citation
b)
Caption
c)
Building Blocks
d)
Bibliography
5.
notes which can be electronically entered into documents
a)
Comments
b)
Clipboard
c)
Citation
d)
Caption
6.
individual controls which can be added to and customized in forms to aid in completion
a)
Content Controls
b)
Comments
c)
Clipboard
d)
Citation
7.
makes a duplicate copy of the selected item or text and places it on the clipboard
a)
Copying
b)
Contiguous Selection
c)
Content Controls
d)
Comments
8.
removes the selected item or text from the document and places it on the clipboard
a)
Cutting
b)
Copying
c)
Contiguous Selection
d)
Content Controls
9.
an explanation, comment or reference to something in the document which appears at the end of a document
a)
Endnote
b)
Document Inspector
c)
Cutting
d)
Copying
10.
text or graphics which are printed at the bottom of each page in a document
a)
Footer
b)
Endnote
c)
Document Inspector
d)
Cutting
11.
documents which contain fillable areas which record information
a)
Forms
b)
Footnote
c)
Footer
d)
Endnote
12.
break entered by the user before the current page is full
a)
Hard Page Break
b)
Forms
c)
Footnote
d)
Footer
13.
refers to splitting a word which would otherwise extend beyond the right margin with a hyphen and placing the remainder of the word on the next line
a)
Hyphenation
b)
Header
c)
Hard Page Break
d)
Forms
14.
left and/or right margins for lines or paragraphs
a)
Indent
b)
Hyphenation
c)
Header
d)
Hard Page Break
15.
amount of vertical white space between the lines in a paragraph
a)
Line Spacing
b)
Index
c)
Indent
d)
Hyphenation
16.
series of commands and instructions which are grouped together as a single command to accomplish a task automatically
a)
Macro
b)
Line Spacing
c)
Index
d)
Indent
17.
amount of white space between the text and the edge of the page on each of the four sides
a)
Margins
b)
Mail Merge
c)
Macro
d)
Line Spacing
18.
set of merge fields stored as one unit
a)
Merge Block
b)
Margins
c)
Mail Merge
d)
Macro
19.
selection of text which is not located next to each other or touching in a sequence
a)
Non-Contiguous Selection
b)
Merge Field
c)
Merge Block
d)
Margins
20.
way in which a rectangular page is orientated for normal viewing
a)
Page Orientation
b)
Non-Contiguous Selection
c)
Merge Field
d)
Merge Block
21.
moves items from the clipboard into the document where the insertion point is located
a)
Pasting
b)
Paragraph Spacing
c)
Page Orientation
d)
Non-Contiguous Selection
22.
objects such as document properties or fields which can be inserted from a gallery
a)
Quick Parts
b)
Pasting
c)
Paragraph Spacing
d)
Page Orientation
23.
break which divides documents into portions which allows users to apply specific formatting changes
a)
Section Break
b)
Record
c)
Quick Parts
d)
Pasting
24.
break entered by Word to start a new page when the current page is full
a)
Soft Page Break
b)
Section Break
c)
Record
d)
Quick Parts
25.
list of headings and the pages on which the headings are located
a)
Table of Contents
b)
Style Set
c)
Soft Page Break
d)
Section Break
26.
organized list of the figures, images and tables in a document which are labeled with captions
a)
Table of Figures
b)
Table of Contents
c)
Style Set
d)
Soft Page Break
27.
sets of coordinated colors, fonts and effects which can be applied to documents
a)
Themes
b)
Template
c)
Table of Figures
d)
Table of Contents
28.
ability of text to wrap or be located around an object in a document
a)
Text Wrapping
b)
Themes
c)
Template
d)
Table of Figures
29.
character or string of characters which represent multiple characters in a search
a)
Wildcard
b)
Watermark
c)
Text Wrapping
d)
Themes
30.
act of creating, editing and producing a text document
a)
Word Processing
b)
Wildcard
c)
Watermark
d)
Text Wrapping
31.
visual representations of data
a)
Charts
b)
Animations
c)
Word Processing
d)
Wildcard
32.
animation which occurs while the object is on the slide to emphasize or draw attention to it
a)
Emphasis Effect
b)
Charts
c)
Animations
d)
Word Processing
33.
animation which dictates how an object is removed from the slide
a)
Exit Effect
b)
Entrance Effect
c)
Emphasis Effect
d)
Charts
34.
animation which moves an object within a slide along a predetermined path
a)
Motion Path
b)
Exit Effect
c)
Entrance Effect
d)
Emphasis Effect
35.
boxes with borders which hold content; located on slide layouts
a)
Placeholders
b)
Notes Pane
c)
Motion Path
d)
Exit Effect
36.
contain formatting, positioning and placeholders for all of the content on the slide
a)
Slide Layouts
b)
Placeholders
c)
Notes Pane
d)
Motion Path
37.
animation-like effect which occurs when moving from one slide to another in a presentation
a)
Slide Transition
b)
Slide Master
c)
Slide Layouts
d)
Placeholders
38.
graphic objects which can be inserted to create diagrams on a slide to illustrate information, concepts or ideas in a presentation
a)
SmartArt
b)
Slide Transition
c)
Slide Master
d)
Slide Layouts
39.
sample files which contain some formatting and can be customized to serve as a starting point for a new presentation
a)
Template
b)
Tables
c)
SmartArt
d)
Slide Transition
40.
palettes of colors, fonts and special effects which complement one another
a)
Themes
b)
Template
c)
Tables
d)
SmartArt
41.
points to a specific cell and does not change when copied; includes dollar signs in the reference name
a)
Absolute Cell Reference
b)
Variants
c)
Themes
d)
Template
42.
function used to perform operations or calculations
a)
Arguments
b)
Absolute Cell Reference
c)
Variants
d)
Themes
43.
runs macros which perform a specific action when clicked
a)
Buttons
b)
AutoRepublish
c)
Arguments
d)
Absolute Cell Reference
44.
address of a cell indicating its column and row location
a)
Cell Reference
b)
Buttons
c)
AutoRepublish
d)
Arguments
45.
tests whether conditions are true or false and makes logical comparisons between expressions
a)
Conditional Formulas
b)
Check Boxes
c)
Cell Reference
d)
Buttons
46.
provides a convenient way to enter or display one complete row of information in a range or table without scrolling horizontally
a)
Data Form
b)
Conditional Formulas
c)
Check Boxes
d)
Cell Reference
47.
recognized formats for date and time values
a)
Date and Time Data
b)
Data Source
c)
Data Form
d)
Conditional Formulas
48.
function requiring two values, a date and the number of months which need to be added or subtracted
a)
EDATE
b)
Date and Time Data
c)
Data Source
d)
Data Form
49.
expression which returns a value
a)
Formula
b)
Form
c)
EDATE
d)
Date and Time Data
50.
view of workbook contents which displays formulas instead of resulting values
a)
Formula View
b)
Formula
c)
Form
d)
EDATE
51.
puts related controls into one visual unit
a)
Group Boxes
b)
Function
c)
Formula View
d)
Formula
52.
identify the purpose of a cell or text box
a)
Labels
b)
Group Boxes
c)
Function
d)
Formula View
53.
contains both relative and absolute references
a)
Mixed Cell Reference
b)
List Box
c)
Labels
d)
Group Boxes
54.
numerical value which can be used in a mathematical calculation
a)
Number Data
b)
Mixed Cell Reference
c)
List Box
d)
Labels
55.
used to analyze, explore and present data
a)
Pivot Table
b)
Option Buttons
c)
Number Data
d)
Mixed Cell Reference
56.
address of a cell range based on its relative position
a)
Relative Cell Reference
b)
Pivot Table
c)
Option Buttons
d)
Number Data
57.
increases or decreases a value such as a number, time or date
a)
Spin Button
b)
Sparkline
c)
Relative Cell Reference
d)
Pivot Table
58.
grid of rows and columns in which text and numbers are entered and results are calculated
a)
Spreadsheet
b)
Spin Button
c)
Sparkline
d)
Relative Cell Reference
59.
file used to store worksheets
a)
Workbook
b)
Text Data
c)
Spreadsheet
d)
Spin Button
60.
sheets containing formulas, functions, values, text and graphics which make up a workbook
a)
Worksheets
b)
Workbook
c)
Text Data
d)
Spreadsheet
61.
Which of the following is a placeholder in the main document used in a mail merge where a piece of information from the data source will be entered?
a)
Merge Field
b)
Record
c)
Merge Block
d)
Caption
62.
DeAndre is looking for a template to use for his portfolio. Which file should he<br />choose based on the file extension?
a)
Portfolio.dotx
b)
Portfolio.docx
c)
Portfolio.dbb
d)
Portfolio.xls
63.
Which of the following is a tool which can be used to find and remove hidden data<br />and personal information?
a)
Document inspector
b)
Accessibility checker
c)
Accessibility inspector
d)
Data properties
64.
Which tool can be used to identify accessibility issues in Word documents?
a)
Accessibility Checker
b)
Accessibility Inspector
c)
Document Inspector
d)
Data properties
65.
Which option in Backstage View contains the command to mark a document as<br />final?
a)
Info
b)
New
c)
Save
d)
Export
66.
Lauren wants to add a comment to a document she is reviewing. Which tab on the<br />Ribbon contains the command for adding a new comment to a document?
a)
Review
b)
Home
c)
References
d)
View
67.
If Ray wanted to accept the changes Martin made to his document, which group<br />on the Review tab holds this command?
a)
Changes
b)
Comments
c)
Tracking
d)
Compare
68.
Which tab holds the command to insert a section break?
a)
Layout
b)
Insert
c)
Design
d)
Review
69.
Kara needs to convert a table in her document to text. Which group on the Table<br />Tools section of the Layout tab does she need to use?
a)
Data
b)
Rows & Columns
c)
Merge
d)
Alignment
70.
Ankit has a table in his document which breaks across multiple pages. Which of<br />the following should he do so the header rows appear at the top of the table on the<br />second page?
a)
Repeat row headers
b)
Sort
c)
Convert to text
d)
Expand row headers
71.
Which tab of the Ribbon contains the command to add a cover page?
a)
Insert
b)
Home
c)
Design
d)
Layout
72.
Which of the following must be added to the figures and tables in a document for<br />them to be included in a table of figures?
a)
Captions
b)
Themes
c)
Placeholders
d)
Citations
73.
Which of the following should be added to a document if you do not have all of the<br />information you need for a citation but want to mark the location where the citation<br />should appear?
a)
Placeholder
b)
Merge field
c)
Citation block
d)
Source Field
74.
Which of the following should you click to open the menu which contains the<br />command to add a new source?
a)
Insert Citation
b)
Insert Footnote
c)
Insert Placeholder
d)
Bibliography
75.
Which of the following is a series of commands or instruction which have been<br />grouped together to accomplish a task automatically?
a)
Macro
b)
Building block
c)
Merge field
d)
Style set
76.
Which of the following are reusable text, images, phrases or code?
a)
Quick Parts
b)
Fonts
c)
Address blocks
d)
Style set
77.
Which of the following tabs holds the command for saving the presentation as a different file type?
a)
File
b)
Home
c)
Insert
d)
Slide Show
78.
Which of the following is the first step in reusing slides from another presentation?
a)
Clicking New Slide on the Home tab
b)
Clicking Reuse Slide on the Design tab
c)
Applying a Theme to the slides
d)
Clicking Import in Backstage View
79.
Which of the following options in Backstage View contains the command to create a Word Outline from a presentation?
a)
Export
b)
Info
c)
New
d)
History
80.
Which of the following should be selected on the Insert tab if you want to link a spreadsheet to a presentation?
a)
Object
b)
Spreadsheet
c)
Table
d)
Slide placeholder
81.
Which of the following can be added to a presentation in order to group slides?
a)
Sections
b)
Comments
c)
Changes
d)
Animations
82.
Which of the following opens when a comment is added to a presentation?
a)
Comments Pane
b)
Changes Pane
c)
Review Pane
d)
Notes Pane
83.
Which option in Backstage View contains the commands for packaging a presentation to a CD?
a)
Export
b)
Info
c)
Options
d)
Save
84.
Which of the following tabs on the Ribbon contains the command to add a comment to the presentation?
a)
Review
b)
Home
c)
Design
d)
Slide Show
85.
Which group on the Review tab contains the command which can be used to track changes made to reviewed presentations?
a)
Compare
b)
Proofing
c)
Insights
d)
Ink
86.
Which of the following is an animation which effects how the object or text is removed from a slide during a presentation?
a)
Exit
b)
Entrance
c)
Emphasis
d)
Motion
87.
Which group on the Insert tab holds the command for adding a video file to a presentation?
a)
Media
b)
Slides
c)
Illustrations
d)
Comments
88.
Which group on the Playback tab of the Audio Tools section holds the command for trimming the audio?
a)
Editing
b)
Preview
c)
Bookmarks
d)
Audio Options
89.
Which of the following causes a sound to play continuously until you advance to the next slide?
a)
Looping
b)
Animating
c)
Transitioning
d)
Recording
90.
Which group on the Slide Show tab contains the command for recording narration?
a)
Set Up
b)
Start Slide Show
c)
Monitors
d)
Playback
91.
Which group on the Playback tab holds the command for adding bookmarks to videos in the presentation?
a)
Bookmarks
b)
Preview
c)
Editing
d)
Video Options
92.
Which of the following can be used if you want to make an object move along a path you have drawn?
a)
Custom Motion Path
b)
Entrance Effect
c)
Emphasis Effect
d)
Exit Effect
93.
Which of the following options on the File tab contains the commands for creating a video of the presentation?
a)
Export
b)
New
c)
Open
d)
Share
94.
Which of the following buttons in the Info portion of Backstage View opens a menu which contains the command to check for accessibility issues?
a)
Check for Issues
b)
Protect Workbook
c)
Browser View Options
d)
Password
95.
Which of the following file types should be chosen when saving a workbook as a template?
a)
Excel Template
b)
Custom Office Template
c)
Excel 97-2003 Workbook
d)
Compatibility Template
96.
Which of the following locations in the New portion of Backstage View should be clicked to view a workbook template you created?
a)
Personal
b)
Business
c)
Featured
d)
Design
97.
Which of the following tabs must be present on the Ribbon to insert form controls?
a)
Developer
b)
Form
c)
Control
d)
Data Form
98.
Which of the following tools can be used to create a data form?
a)
Form Tool
b)
Form Wizard
c)
Form Genie
d)
Form Template
99.
Which tab on the Ribbon holds the command to open the formula view?
a)
Formulas
b)
Home
c)
Page Layout
d)
Data
100.
Which of the following is NOT a comparison operator?
a)
/ slash
b)
> greater than arrow
c)
< less than arrow
d)
>= greater than arrow, equal sign
101.
Which of the following is a feature which updates the web page each time a change is saved on the source worksheet or workbook?
a)
AutoRepublish
b)
Publish to web
c)
Refresh
d)
AutoComplete
102.
Which of the following is a workbook designed with a standard structure and format which makes it easier to capture, organize and edit information?
a)
Form
b)
Style set
c)
Layout
d)
Data sheet
103.
Which of the following form controls can be used to place related controls in one visual unit?
a)
Group box
b)
Label
c)
Button
d)
Check box
104.
Which of the following form controls could be used to turn on or off a value which indicates a choice?
a)
Check box
b)
Label
c)
Group box
d)
Spin button
105.
Which tab holds the command to create a PivotTable?
a)
Insert
b)
Home
c)
Developer
d)
Page Layout
106.
Which of the following can be used to plot one or more data series on a secondary axis?
a)
Dual-Axis chart
b)
PivotTable
c)
Moving average chart
d)
Conditional formatting
107.
Which group contains the options to import data?
a)
Get External Data
b)
Connections
c)
Sort and Filter
d)
Data Tools
108.
Which of the following formulas adds together values greater than 5000 in cells C2 through C17?
a)
=SUMIF(C2:C17,“>5000”)
b)
=SUMIF(C2:C17,“5000”)
c)
=SUMIF(C2:C17,“<5000”)
d)
=SUMIF(C2:C17,“=5000”)
109.
Which of the following formulas would return the last three characters found in cell A5?
a)
=RIGHT(A5,3)
b)
=RIGHT(text,A5,3)
c)
=RIGHT(A5,text3)
d)
=RIGHT(3,A5)
110.
To complete conversions, you should use which of the following functions?
a)
CONVERT
b)
REFRESH
c)
TRANSLATE
d)
UPDATE
Reset
