Microsoft Office Specialist

Multiplies the value in cell A3 by 27, then divides by the value in cell A4

____ are mini charts you can insert into a worksheet cell to show a pattern or trend.

Default summary calculations for a selected range of cells appear in (the) 

A green wavy underline in a document indicates a possible ____________ .

The blank areas around the top, bottom and sides of a page are called ___________

What is the intersection of a row and column in a table called?

I can get Microsoft certified if I take the certification class (1 semester) in the future

A(n) ______ cell reference adjust to a new location when  moved or copied to another cell

A __ is a shorthand way to write an equation that performs a calculation. Answer like Jeopardy.

In MOS class I will learn about Microsoft Office 2016 programs. Which answer is NOT a program?

A ____ is a collection of worksheets

Related info in a worksheet column or row , that is plotted on a chart

If I receive a high score on the MOS test(s), I may earn _________

To  keep selected rows and columns on the screen when you have a large worksheet, you can

___ are notes that are added to cells to provide information/feedback about the cell's contents

If data does not fit in a cell, you  ______ the columns & rows to make the data easier to read.

The process of combining a document with information that personalizes it

____________ identify the names of worksheets.

A chart that is inserted directly into the worksheet is called a(n) ____ chart.

A group of selected cells is called a

A part of a document that is formatted with a different layout than the rest of the doc is

To accept an AutoComplete suggestion,

A _____ is a coordinated set of fonts, styles, and colors.

To combine two or more cells into one, use the _______________ command

To change the look of a cell that meets a specific condition, you would use _____

Text or numbers that provide additional information about a data marker

A chart is a ______ representation of data

A MOS certified, entry-level business employee may earn as much as ___ more each year.

____ can be used to perform mathematical, statistical, financial, and logical operations.

When you change the vertical alignment of text, you change the position of text between

_____ copies all the formatting from one cell and pastes it into another cell or range 

A worksheet consists of columns and rows that intersect to form 

Insert special characters in a document using the insert _______ button

Which of the following margins can you customize in a document?

85% of supervisors say Microsoft Office Certified employees are more ___________.

A red wavy underline in a document indicates a possible ____________ .

A(n) ______ cell reference does not change when the formula is moved or copied to anoter cell

The image below is a picture of

What are the three parts of a function?

This displays a subset of data that meet certain criteria

A symbol that represents a single data point or value from the corresponding worksheet cell

To automatically balance columns, insert a(n) ___________ section break.

The ___ is the value a function uses to perform a calc. It can be a number, text, or cell ref 

All formulas begin with a(n) 

A blue wavy underline in a document indicates a possible ____________ .

A placeholder in a main document that is replaced with data  when you perform a mail merge.

A(n) ______ cell reference contains both absolute and relative references

The sequence used to calculate the value of a formula is called the

Text can be aligned using all of the following types of tab stops EXCEPT:

Borders can be placed on __________ sides of a selected paragraph