wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MOS Final Exam

Total questions: 60

Worksheet time: 30mins

Name
Class
Date
1.

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.

a)

Insertion Point

b)

Groups

c)

Backstage View

d)

Block Style

2.

A box that displays additional options or information you can use to execute commands.

a)

Group Box

b)

Dialog Box

c)

Dialog Box Launcher

d)

Preview Box

3.

The large “I” created when users place the cursor near the insertion point.

a)

I-Beam

b)

L-Beam

c)

P-Beam

d)

B-Beam

4.

A style that requires a colon after the salutation and a comma after the closing.

a)

Open Punctuation

b)

Mixed Punctuation

c)

Block Style

d)

Open Style

5.

A tool that is divided into eight that contain groups.

a)

Menu

b)

Print

c)

Template

d)

Ribbon

6.

A storage area that temporarily stores the items for a user to paste in another location of the document or office file.

a)

Clipboard

b)

Document Properties

c)

Navigation Pane

d)

Read Mode

7.

Hidden information such as personal data is added to the document, such as, creator of the document, company name, and keywords.

a)

Object Zoom

b)

Thumbnails

c)

Go To

d)

Document Properties

8.

A set of characters that have the same design.

a)

Letter

b)

Number

c)

Font

d)

WordArt

9.

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.

a)

First-line Indent

b)

Hanging Indent

c)

Indent

d)

Leaders

10.

A tool identified with symbols such as dotted, dashed, or solid lines that fill the space before tabs.

a)

Negative Indent

b)

Line Spacing

c)

Leaders

d)

Indent

11.

A format commonly used for brochures, graphics, tables and so on that orients text across the longer dimension of the page.

a)

Landscape Orientation

b)

Non-breaking spaces

c)

Portrait Orientation

d)

Section Break

12.

The rectangles that are formed when rows and columns intersect.

a)

Cells

b)

Cell Range

c)

Box

d)

Formulas

13.

A function that calculates totals, averages, determines the highest/lowest value and counts.

a)

Table

b)

Split Cells

c)

Sort

d)

Formulas

14.

Which of the following is a placeholder that tells Word to insert changeable data into a document

a)

Field name

b)

Field

c)

Data field

d)

Data source

15.

The process of trimming the horizontal or vertical edges of a picture to get rid of unwanted areas.

a)

crop

b)

floating object

c)

embedded object

d)

screen cropping

16.

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.

a)

shapes

b)

linked object

c)

floating object

d)

caption

17.

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.

a)

header

b)

footnote

c)

endnote

d)

footer

18.

The view accessed via the File tab that contains tools and commands in Office 2016.

a)

File tab

b)

dialog box launcher

c)

drop-down list

d)

backstage view

19.

Small, downward-pointing arrows next to tools on the Ribbon that provide drop-down lists with additional options.

a)

Notes Page view

b)

drop-down arrows

c)

drop-down list

d)

Normal view

20.

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.

a)

slide library

b)

theme

c)

thumbnail

21.

Typefaces that are used to display characters, numbers, and symbols in your PowerPoint presentations

a)

fonts

b)

non printing characters

c)

Formatting

d)

Text Box

22.

The amount of vertical space between paragraphs

a)

Vertical Alignment

b)

Line Spacing

c)

Character Spacing

d)

Text Box

23.

A group of steps, procedures, or actions that are listed in numerical order

a)

Numbered List

b)

Word Style

c)

WordArt

d)

Text Box

24.

A graphic that repeats to fill an image, creating the appearance that the surface is a certain material, such as marble, wood, or paper

a)

Texture

b)

Font Color

c)

Character Style

d)

Watermark

25.

An arrangement of columns and rows used to organize information

a)

Row

b)

Column

c)

Workbook

d)

Table

26.

Pre-set settings that determine how Excel behaves when performing an action

a)

group

b)

default settings

c)

template

d)

tab

27.

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.

a)

navigation pane

b)

tab

c)

print settings

d)

template

28.

A reference that identifies a cell’s location in the worksheet based on its row number and column letter.

a)

external reference

b)

operand

c)

formula

d)

cell reference

29.

The rules Excel follows to calculate any formula that contains two or more operators.

a)

Order of Operations

b)

Relative Cell Reference

c)

Scope

d)

Operand

30.

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

a)

True

b)

False

31.

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.

a)

Quick Access Toolbar

b)

Workbook

c)

Command group

d)

Name Box

32.

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.

a)

Natural Series

b)

Move Pointer

c)

Office Clipboard

d)

Flash Fill

33.

A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.

a)

count function

b)

autosum

c)

sum function

d)

count function

34.

A predefined formula that performs a calculation

a)

count function

b)

sum function

c)

function

d)

max function

35.

A formatting characteristic, such as bold, italic, or underlined text.

a)

attribute

b)

hyperlink

c)

format painter

d)

mini toolbar

36.

A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.

a)

attribute

b)

merged cells

c)

hyperlink

d)

mini toolbar

37.

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.

a)

paste special

b)

mini toolbar

c)

rules manager

d)

wrap

38.

After you select a color and apply it to a cell’s background, the Fill Color button takes on that color

a)

True

b)

False

39.

The MIN function returns the smallest value in a range of cells.

a)

True

b)

False

40.

The left-to-right measurement of a column

a)

Column Heading

b)

Column Length

c)

Boundary

d)

Column Width

41.

The lines that display around worksheet cells

a)

Boundaries

b)

Gridlines

c)

Cell Column

d)

Cell Range

42.

The identifying letter of a row

a)

Row Heading

b)

Row Height

c)

Scaling

d)

Column Heading

43.

A built-in set of filtering capabilities.

a)

AutoFilter

b)

Data File

c)

Delimiter

d)

Macro

44.

A condition you specify to limit which records are returned when filtering data

a)

criteria

b)

lookup functions

c)

table

d)

table array

45.

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

a)

password

b)

change history

c)

strong password

d)

Track Changes

46.

A feature that marks and records changes made to a workbook

a)

change history

b)

strong password

c)

Track Changes

d)

shared workbook

47.

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

a)

handle

b)

metadata

c)

shape

d)

saturation

48.

A visual representation of information and ideas, such as an organization chart, a flow chart, a process, or a Venn diagram

a)

metadata

b)

WordArt

c)

SmartArt graphic

d)

text box

49.

Miniature graphs that summarize data; typically used to graphically describe trends in data

a)

embedded chart

b)

legend

c)

plot area

d)

sparklines

50.

An explanatory list that identifies the patterns or colors assigned to the data series or categories in a chart

a)

legend

b)

embedded chart

c)

data label

d)

axis

51.

A row or column of data represented by a line, set of columns, bars, or other chart type

a)

chart

b)

chart sheet

c)

data marker

d)

data series

52.

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

a)

plot area

b)

legend

c)

PivotChart

d)

PivotTable

53.

An Office feature that combines text and artistic effects

a)

text box

b)

WordArt

c)

metadata

d)

SmartArt graphic

54.

Changing from color to black and white or to greater or reduced levels of color

a)

saturation

b)

artistic effect

c)

shape

d)

duotone

55.

An image with two colors

a)

duotone

b)

metadata

c)

graphic

d)

shape

56.

A tool to copy character and paragraph formatting

a)

Format Painter

b)

Clipboard

c)

Text Box

d)

Style

57.

A feature that enables you to see a preview of an option when you hover the mouse pointer over it

a)

Read Mode

b)

Print Mode

c)

Live Preview

d)

Web Layout

58.

which of the following is the term for customized company logo applied to page background behind a document's text?

a)

MarkArt

b)

Insert picture command

c)

Watermark

d)

SmartArt

59.

The blank borders that occupy the top, bottom, and sides of a document.

a)

Margins

b)

Page Break

c)

Section Break

d)

Portrait Orientation

60.

A command in Word that places a duplicate copy of selected text in the Clipboard.

a)

Cut

b)

Paste

c)

Copy

d)

Replace