NEW
Font size
WorksheetsMOS Final Exam
Total questions: 60
Worksheet time: 30mins
A tool that offers quick access to commands for performing many file management tasks all displayed in a single navigation pane that can be customized to meet users’ needs.
Insertion Point
Groups
Backstage View
Block Style
A box that displays additional options or information you can use to execute commands.
Group Box
Dialog Box
Dialog Box Launcher
Preview Box
The large “I” created when users place the cursor near the insertion point.
I-Beam
L-Beam
P-Beam
B-Beam
A style that requires a colon after the salutation and a comma after the closing.
Open Punctuation
Mixed Punctuation
Block Style
Open Style
A tool that is divided into eight that contain groups.
Menu
Template
Ribbon
A storage area that temporarily stores the items for a user to paste in another location of the document or office file.
Clipboard
Document Properties
Navigation Pane
Read Mode
Hidden information such as personal data is added to the document, such as, creator of the document, company name, and keywords.
Object Zoom
Thumbnails
Go To
Document Properties
A set of characters that have the same design.
Letter
Number
Font
WordArt
A setting that inserts a one-half inch of blank space between the left margin and the first line of the paragraph: one-half inch is the default setting for this indent.
First-line Indent
Hanging Indent
Indent
Leaders
A tool identified with symbols such as dotted, dashed, or solid lines that fill the space before tabs.
Negative Indent
Line Spacing
Leaders
Indent
A format commonly used for brochures, graphics, tables and so on that orients text across the longer dimension of the page.
Landscape Orientation
Non-breaking spaces
Portrait Orientation
Section Break
The rectangles that are formed when rows and columns intersect.
Cells
Cell Range
Box
Formulas
A function that calculates totals, averages, determines the highest/lowest value and counts.
Table
Split Cells
Sort
Formulas
Which of the following is a placeholder that tells Word to insert changeable data into a document
Field name
Field
Data field
Data source
The process of trimming the horizontal or vertical edges of a picture to get rid of unwanted areas.
crop
floating object
embedded object
screen cropping
An image or other object positioned precisely on the page, allowing the text to wrap around it in one of several available formats. Compare to inline object.
shapes
linked object
floating object
caption
A citation in a document placed at the end of the document in which the citation is located. An endnote is formatted as double spaced with no hanging indent according to the MLA guidelines.
header
footnote
endnote
footer
The view accessed via the File tab that contains tools and commands in Office 2016.
File tab
dialog box launcher
drop-down list
backstage view
Small, downward-pointing arrows next to tools on the Ribbon that provide drop-down lists with additional options.
Notes Page view
drop-down arrows
drop-down list
Normal view
A feature on a SharePoint server that enables people to publish presentations with each slide saved as an individual file, so that others can reuse slides on an individual basis without having to think about which presentation they originally came from.
slide library
theme
thumbnail
Typefaces that are used to display characters, numbers, and symbols in your PowerPoint presentations
fonts
non printing characters
Formatting
Text Box
The amount of vertical space between paragraphs
Vertical Alignment
Line Spacing
Character Spacing
Text Box
A group of steps, procedures, or actions that are listed in numerical order
Numbered List
Word Style
WordArt
Text Box
A graphic that repeats to fill an image, creating the appearance that the surface is a certain material, such as marble, wood, or paper
Texture
Font Color
Character Style
Watermark
An arrangement of columns and rows used to organize information
Row
Column
Workbook
Table
Pre-set settings that determine how Excel behaves when performing an action
group
default settings
template
tab
A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
navigation pane
tab
print settings
template
A reference that identifies a cell’s location in the worksheet based on its row number and column letter.
external reference
operand
formula
cell reference
The rules Excel follows to calculate any formula that contains two or more operators.
Order of Operations
Relative Cell Reference
Scope
Operand
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
True
False
Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
Quick Access Toolbar
Workbook
Command group
Name Box
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
Natural Series
Move Pointer
Office Clipboard
Flash Fill
A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.
count function
autosum
sum function
count function
A predefined formula that performs a calculation
count function
sum function
function
max function
A formatting characteristic, such as bold, italic, or underlined text.
attribute
hyperlink
format painter
mini toolbar
A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.
attribute
merged cells
hyperlink
mini toolbar
To automatically display data on the next line when it is too long to display within the cell’s width. Wrapping automatically increases a cell’s height.
paste special
mini toolbar
rules manager
wrap
After you select a color and apply it to a cell’s background, the Fill Color button takes on that color
True
False
The MIN function returns the smallest value in a range of cells.
True
False
The left-to-right measurement of a column
Column Heading
Column Length
Boundary
Column Width
The lines that display around worksheet cells
Boundaries
Gridlines
Cell Column
Cell Range
The identifying letter of a row
Row Heading
Row Height
Scaling
Column Heading
A built-in set of filtering capabilities.
AutoFilter
Data File
Delimiter
Macro
A condition you specify to limit which records are returned when filtering data
criteria
lookup functions
table
table array
In a shared workbook, a feature that includes the name of the person who made each change, when the change was made, and what data was changed
password
change history
strong password
Track Changes
A feature that marks and records changes made to a workbook
change history
strong password
Track Changes
shared workbook
A small box on the side and/or corner of the graphic that you click and pull to increase or decrease the size of a graphic
handle
metadata
shape
saturation
A visual representation of information and ideas, such as an organization chart, a flow chart, a process, or a Venn diagram
metadata
WordArt
SmartArt graphic
text box
Miniature graphs that summarize data; typically used to graphically describe trends in data
embedded chart
legend
plot area
sparklines
An explanatory list that identifies the patterns or colors assigned to the data series or categories in a chart
legend
embedded chart
data label
axis
A row or column of data represented by a line, set of columns, bars, or other chart type
chart
chart sheet
data marker
data series
A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data
plot area
legend
PivotChart
PivotTable
An Office feature that combines text and artistic effects
text box
WordArt
metadata
SmartArt graphic
Changing from color to black and white or to greater or reduced levels of color
saturation
artistic effect
shape
duotone
An image with two colors
duotone
metadata
graphic
shape
A tool to copy character and paragraph formatting
Format Painter
Clipboard
Text Box
Style
A feature that enables you to see a preview of an option when you hover the mouse pointer over it
Read Mode
Print Mode
Live Preview
Web Layout
which of the following is the term for customized company logo applied to page background behind a document's text?
MarkArt
Insert picture command
Watermark
SmartArt
The blank borders that occupy the top, bottom, and sides of a document.
Margins
Page Break
Section Break
Portrait Orientation
A command in Word that places a duplicate copy of selected text in the Clipboard.
Cut
Paste
Copy
Replace
