Basics, Word, Excel 2016 Semester Review

You can click a cell or select a range to enter its address in the formula

To change the color of a chart element, right-click the element and use the fill button.

You can sort rows containing merged cells in a Word table

A dropped capital letter, called a drop cap, is used to call attention to an opening paragraph

A mail merge is an Excel spreadsheet that produces a personalized or customized document

Transposed data must be placed in blank cells

Use the filter shortcut button to display selected data elements of a chart

Excel aligns values and dates to the left by default

The CONCATENATE function requires a text argument

The shape representing each data point of a chart is

To calculate a value in A1 with a percentage increase in A2 added to it, use the formula

Theme fonts/colors, cell color appear at top of selection list when appropriate button clicked

Every Ribbon group has a dialob box launcher button

Selecting multiple rows of chart data creates multiple categories

It is possible to rename and move worksheets

You change data/chart formatting in a linked chart & open the destination file again it updates

It is impossible to start a numbered list with any number other than 1

Sorting data Z to A sorts lowest to highest or least recent to most recent

The recipient is the person who

End of cell markers

Contextual tabs are always available on the Ribbon

You can see where page breaks occur in Normal & Page Layout views

When you delete a folder

In the RIGHT function, Num_chars is the number of characters you want the function to extract

The LOWER function only affects letter; it does not change numbers or characters

To insert a selection from the Clipboard into a document

You cannot use tab stops within a table cell

The recommended charts feature examines data & provides recommended chart types

Most commands are available as buttons on the Ribbon

A square that you click to select or clear an option is a(n)

To explode a pie chart means to delete it

For an embedded chart, you can close Excel without saving after you have made changes

The specified range of cells to be printed is

You cannot hide rulers in the Word interface

When budgeting for IT systems, it is important to factor support, maintenance, and training

When you move a file or folder to another folder

When you modify a style that has been used, text formatted w/style is updated

When you use a formula in a table in Word

In grouped worksheets, any editing made to the active sheets are made to the group

Any word not in Word's dictionaries is marked as misspelled, even if it's spelled correctly.

When you delete a selection & move it to the clipboard, the term for this action is

A cover letter

When Excel starts, it displays an empty workbook with five empty worksheets

Making data/formatting changes to Excel chart embedded in Word also changes the original data

Thumbnails are

If you need to print only part of a worksheet, you can select and print a specific area

To maintain the link, the source & destination files don't need to stay in place.

To insert three rows at once into a table, first select a single row in a Word table

Saving changes makes an additional copy of the file with the most recent changes

There are default settings for documents such as margins, line spacing, font, & size.

Microsoft's online cloud storage system integrated with Office is called

When you want to repeat the same information at the top of each printed page, create a

The default column format has

When you delete a column or row, existing column/rows shift left or up to close to the gap

Insert the merge field in the document where you want the corresponding variable data to print

When you make formatting changes to a chart those changes flow between the locations

Font size is measured in inches

To display formulas in cells rather than formula results use

You can collapse the Ribbon to display only tabs to see more of a file and expand when needed

Sorting is

The format painter enables you to copy formatting from one cell to another

The axis of a chart on which categories are plotted is called the X axis

To update a chart picture, you need to change the data in Excel and paste a new picture

To find the percentage of a value, convert the percentage to a decimal, then multiply

When you select a table style, it overrides existing formatting

You can insert rows only above the current row in a Word table.

Paragraph spacing affects space before and after each line

The mouse pointer changes shape depending on

Flash Fill is case sensitives

After you create a pie chart you can move it to its own chart sheet

You can scale the printout to a % or specify how many pages it should be

Splitting a Window into panes will affect the appearance of a printout

COUNTIFS allows you to enter multiple qualifying conditions

For anything other than basic calcuations, you should use an Excel worksheet, not a Word table.

You can link or embed an Excel chart into another document, such as a Word document

If you justify text in a cell, be sure you have at lest three lines of text

If you enter a letter of the alphabet as the first character in a cell, you are entering

Office Clipboard is a temporary storage area that can hold up to 48 selections at a time

A set of related data points to be charted is

An example of a mixed cell reference is

To apply a style to text, select the text and then click the Word Art name

Word 2016 can open and edit PDF files.

You can define a unique print area for each worksheet in your workbook

Excel will display an error message when improper parentheses cause logic flaws in a formula

Changes to a linked object in a destination document are automatically made to source document

To format text 45 degrees right ended angled up use

Red wavy underlines indicate

Horizontal alignment is the position/amount of

Before you can format or manipulate objects, you must first select them

In a Word table, how can you align text in a cell

Spaces are allowed in range names

Formulas can refer to cells in other workbook files

You can customize the Ribbon to add a command

Excel inserts a subtotal line whenever it detects a change in the value of the chosen field

You can convert existing text to a table

Document that contains formatting, styles, & sample text you can use to create documents is

The Ribbon

A chart is also known as a graph

You cannot use a picture or a symbol as a bullet

For charts with multiple series, you have to format the labels for each series independently

Circle that is part of a series, only one of which can be selected at a time is a(n)

A memo, or memorandum is

Changing the margins for a table affects all cells in the table

The saluation is the line at the start of a letter including greeting & recipient's name

A link to an Excel chart is a Word document allows you to start Excel from inside Word

By default, text flows to the top of the next column when the current column is filled

AN embedded chart in the destination file may also be displayed as an icon

The selection of the chart data to plot can contain blank columns or rows

When you split a window, each pane has its own menu & title bar & ribbon.

Lines of measurement along the category and value axis are called

You can type another function as an argument for the current function

COUNTIF is a statistical function that uses criteria to count the number of items in a range

The only function you can use in a Word table is SUM

Uppercase mode affects only letter characters, not numbers or symbols

Input that tells the computer which task to execute is

If you select an embedded chart before choosing the Print command, only the chart will print

A scanner is a

You can create your own custom building blocks to reuse in any document

The simplest way to include an Excel chart within another document is to paste its picture.

Which of these references refers to the entire table range including headers, data & total rows

In touch mode, you use your fingers or a stylus pen instead of a mouse

The view in Excel used to view data as it will look when printed is

It's appropriate to being a range name with a number

HTML format

Bookmarks are visible in the text

If you need to search for a function, click the Insert Function button on the formula bar

In the Navigation pane, you can click a thumbnail to go to a page

Each Mircosoft Office Program has its own Help program

Word automatically renumbers a list when you add or delete list items

A column is a horizontal series of cells in a table

Clicking the column or row header selects the entire row or column

Soring data does change the order of the pie slices

To center a label across several columns, use the Merge & Center button

You can use the Subtotal feature with an Excel table

When you move the mouse to the left, the mouse pointer moves to the right.

Sizing handles are

To make a pane active

Metadata is

For labels, it is easier to use the <> merge block.

More than 2 or 3 fonts in 1 document look disjointed & unprofessional

If you paste an Excel chart into Word, the Word file is

The horizontal axis is the axis that goes from top to bottom.

Which of these functions is a logical function

When you cut data from a location, it is permanently deleted and unavailable to paste

Statistical function that uses condition to return average of cells that meets criteria is

There are three basic steps to producing any business document

When you choose File>Print, backstage view automatically shows you a preview of the printout

In Word's Draw Table, you create tables w/irregular columns & rows w/information in dialog box

When you change the value in a cell that is references in a formula, you must redo the formula

Use the Format Painter to quickly copy formatting from one location to another

Dialog boxes appear when you click the dialog box launcher on a group on the Ribbon

You can create additional new documents without exiting and restarting Word

A font is

Which of these comparison operators means NOT equal to?

The default cell format in Excel is

You can add words to the AutoCorrect list that you often type incorrectly.

It is possible to store a folder inside another folder

Rotating document text so it displays & prints horizontally on a page is

You can use the Eraser tool to

To show the structure of a company or institution create a(n)

You can save a Word document only as a .docx file type.

Shortcut menues include options relevant to the current item

A hanging indent indents

The way items display on the Ribbon may depend on the width of the program window

To arrange windows so they overlap, with the active window in front is to

You must type all spaces and punctuation between merge fields

Use a range name to reference a cell or range of cells by name rather by cell address

To add space at the left end of the cell with left-aligned entries, use the

A footer is

The default numbering style for the Office theme is an Arabic numberal followed by a period

For a linked chart, you can close Excel without saving after you have made changes

Each merge field can be inserted only once in a document

Calculate a percentage of a total by dividing the individual value by the total value

You have access to all of Word's tools in Red Mode

Non-breaking hypens prevent a word from breaking at the start of a line

To send the current document as an e-mail attachment, Click File, then click

You cannot add or remove chart elements from your chart layout

File properties include info on the file, such as size & when it was created or modified

Direct formatting will NOT change if you change themes.

If you Double-click the format painter, it will remain on until you click it again

After merging to a new document, you can save the new document as a regular Word file.

There are three ways to set the zoom: slider, commands on View tab, zoom dialog box

You can control which function results appear on the Status bar

Use the table move handle to move a table anywhere on the page

Merging cells

A solid color has an opacity of

When you maximize a window

Choose Non in the text-wrapping options in the Table Properties dialog box to

A tab stop is

Combinations of two or more keys pressed together/sequence to perform commands are called

The range A1:A3 consists of

You must start each formula by typing the = sign

An orphan is the

Changing to Landscape orientation allows for more columns to fit on each page, but fewer errors

Once you create a chart, you cannot change its type

If you see ## displayed in a cell instead of a number, the column is to narrow.

Flash Fill can separate labels into different columns or combine labels into 1

Hiding a sheet deletes all data in the sheet

Use the Get Text command to insert a file in another document

You can use AutoCorrect to replace a code with a phrase, paragraph, or an object.

You can insert a graphic in a worksheet header or footer

You can insert a soft page break to force the start of a new page

To select a different storage device for the current document, use

Row height increases autmatically to accommodate the text in a Word table

A formula is a mathematical equation

The purpose of Excel is to analyze business, personal or financial data

A next page section break inserts a section bread

When you click a mouse button, the program executes a command

A colored sheets tax is clicked, color changes white, w/line of original color at bottom of tab

When there are multiple nested pairs of parentheses, Excel calculates

As you type a formula, it displays in the cell and in the formula bar

Once you set indents, the formatting is carried forward each time you start a new paragraph

Formulas and functions are not case sensitive

The range A1:C5 is defined as a block of cells includes Columns A through C in rows 1 through 5

In Mircrosoft Office 2016

If you use a chart picture the data can be changed