Font size
S
M
L
XL
Worksheets2022 Final Exam K & L
Total questions: 110
Worksheet time: 55mins
Name
Class
Date
1.
position of text in relation to the width of the page
a)
Alignment
b)
Accessibility Checker
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
3.
label which identifies illustrations such as tables, charts, figures or images located in a document
a)
Caption
b)
Building Blocks
4.
an in-text reference to a source where information was obtained
a)
Citation
b)
Caption
5.
notes which can be electronically entered into documents
a)
Comments
b)
Clipboard
6.
individual controls which can be added to and customized in forms to aid in completion
a)
Content Controls
b)
Comments
7.
makes a duplicate copy of the selected item or text and places it on the clipboard
a)
Copying
b)
Contiguous Selection
8.
removes the selected item or text from the document and places it on the clipboard
a)
Cutting
b)
Copying
9.
an explanation, comment or reference to something in the document which appears at the end of a document
a)
Endnote
b)
Document Inspector
10.
text or graphics which are printed at the bottom of each page in a document
a)
Footer
b)
Endnote
11.
documents which contain fillable areas which record information
a)
Forms
b)
Footnote
12.
break entered by the user before the current page is full
a)
Hard Page Break
b)
Forms
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
14.
left and/or right margins for lines or paragraphs
a)
Indent
b)
Hyphenation
15.
amount of vertical white space between the lines in a paragraph
a)
Line Spacing
b)
Index
16.
series of commands and instructions which are grouped together as a single command to accomplish a task automatically
a)
Macro
b)
Line Spacing
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
18.
set of merge fields stored as one unit
a)
Merge Block
b)
Margins
19.
selection of text which is not located next to each other or touching in a sequence
a)
Non-Contiguous Selection
b)
Merge Field
20.
way in which a rectangular page is orientated for normal viewing
a)
Page Orientation
b)
Non-Contiguous Selection
21.
moves items from the clipboard into the document where the insertion point is located
a)
Pasting
b)
Paragraph Spacing
22.
objects such as document properties or fields which can be inserted from a gallery
a)
Quick Parts
b)
Pasting
23.
break which divides documents into portions which allows users to apply specific formatting changes
a)
Section Break
b)
Record
24.
break entered by Word to start a new page when the current page is full
a)
Soft Page Break
b)
Section Break
25.
list of headings and the pages on which the headings are located
a)
Table of Contents
b)
Style Set
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
27.
sets of coordinated colors, fonts and effects which can be applied to documents
a)
Themes
b)
Template
28.
ability of text to wrap or be located around an object in a document
a)
Text Wrapping
b)
Themes
29.
character or string of characters which represent multiple characters in a search
a)
Wildcard
b)
Watermark
30.
act of creating, editing and producing a text document
a)
Word Processing
b)
Wildcard
31.
visual representations of data
a)
Charts
b)
Animations
32.
animation which occurs while the object is on the slide to emphasize or draw attention to it
a)
Emphasis Effect
b)
Charts
33.
animation which dictates how an object is removed from the slide
a)
Exit Effect
b)
Entrance Effect
34.
animation which moves an object within a slide along a predetermined path
a)
Motion Path
b)
Exit Effect
35.
boxes with borders which hold content; located on slide layouts
a)
Placeholders
b)
Notes Pane
36.
contain formatting, positioning and placeholders for all of the content on the slide
a)
Slide Layouts
b)
Placeholders
37.
animation-like effect which occurs when moving from one slide to another in a presentation
a)
Slide Transition
b)
Slide Master
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
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
40.
palettes of colors, fonts and special effects which complement one another
a)
Themes
b)
Template
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
42.
function used to perform operations or calculations
a)
Arguments
b)
Absolute Cell Reference
43.
runs macros which perform a specific action when clicked
a)
Buttons
b)
AutoRepublish
44.
address of a cell indicating its column and row location
a)
Cell Reference
b)
Buttons
45.
tests whether conditions are true or false and makes logical comparisons between expressions
a)
Conditional Formulas
b)
Check Boxes
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
47.
recognized formats for date and time values
a)
Date and Time Data
b)
Data Source
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
49.
expression which returns a value
a)
Formula
b)
Form
50.
view of workbook contents which displays formulas instead of resulting values
a)
Formula View
b)
Formula
51.
puts related controls into one visual unit
a)
Group Boxes
b)
Function
52.
identify the purpose of a cell or text box
a)
Labels
b)
Group Boxes
53.
contains both relative and absolute references
a)
Mixed Cell Reference
b)
List Box
54.
numerical value which can be used in a mathematical calculation
a)
Number Data
b)
Mixed Cell Reference
55.
used to analyze, explore and present data
a)
Pivot Table
b)
Option Buttons
56.
address of a cell range based on its relative position
a)
Relative Cell Reference
b)
Pivot Table
57.
increases or decreases a value such as a number, time or date
a)
Spin Button
b)
Sparkline
58.
grid of rows and columns in which text and numbers are entered and results are calculated
a)
Spreadsheet
b)
Spin Button
59.
file used to store worksheets
a)
Workbook
b)
Text Data
60.
sheets containing formulas, functions, values, text and graphics which make up a workbook
a)
Worksheets
b)
Workbook
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
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
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
64.
Which tool can be used to identify accessibility issues in Word documents?
a)
Accessibility Checker
b)
Accessibility Inspector
65.
Which option in Backstage View contains the command to mark a document as<br />final?
a)
Info
b)
New
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
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
68.
Which tab holds the command to insert a section break?
a)
Layout
b)
Insert
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
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
71.
Which tab of the Ribbon contains the command to add a cover page?
a)
Insert
b)
Home
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
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
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
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
76.
Which of the following are reusable text, images, phrases or code?
a)
Quick Parts
b)
Fonts
77.
Which of the following tabs holds the command for saving the presentation as a different file type?
a)
File
b)
Home
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
79.
Which of the following options in Backstage View contains the command to create a Word Outline from a presentation?
a)
Export
b)
Info
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
81.
Which of the following can be added to a presentation in order to group slides?
a)
Sections
b)
Comments
82.
Which of the following opens when a comment is added to a presentation?
a)
Comments Pane
b)
Changes Pane
83.
Which option in Backstage View contains the commands for packaging a presentation to a CD?
a)
Export
b)
Info
84.
Which of the following tabs on the Ribbon contains the command to add a comment to the presentation?
a)
Review
b)
Home
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
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
87.
Which group on the Insert tab holds the command for adding a video file to a presentation?
a)
Media
b)
Slides
88.
Which group on the Playback tab of the Audio Tools section holds the command for trimming the audio?
a)
Editing
b)
Preview
89.
Which of the following causes a sound to play continuously until you advance to the next slide?
a)
Looping
b)
Animating
90.
Which group on the Slide Show tab contains the command for recording narration?
a)
Set Up
b)
Start Slide Show
91.
Which group on the Playback tab holds the command for adding bookmarks to videos in the presentation?
a)
Bookmarks
b)
Preview
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
93.
Which of the following options on the File tab contains the commands for creating a video of the presentation?
a)
Export
b)
New
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
95.
Which of the following file types should be chosen when saving a workbook as a template?
a)
Excel Template
b)
Custom Office 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
97.
Which of the following tabs must be present on the Ribbon to insert form controls?
a)
Developer
b)
Form
98.
Which of the following tools can be used to create a data form?
a)
Form Tool
b)
Form Wizard
99.
Which tab on the Ribbon holds the command to open the formula view?
a)
Formulas
b)
Home
100.
Which of the following is NOT a comparison operator?
a)
/ slash
b)
> greater than arrow
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
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
103.
Which of the following form controls can be used to place related controls in one visual unit?
a)
Group box
b)
Label
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
105.
Which tab holds the command to create a PivotTable?
a)
Insert
b)
Home
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
107.
Which group contains the options to import data?
a)
Get External Data
b)
Connections
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”)
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)
110.
To complete conversions, you should use which of the following functions?
a)
CONVERT
b)
REFRESH
Reset
