Excel

trendline

A ________ is a graphic representation of trends in a data series.

field

A ________ is a single piece of information that is stored in every record.

list

A series of rows that contains related data is known as a ________.

unlocked

In order for individuals completing your form to type their data into designated cells, the cells must be ________.

Record

all of the categories of data pertaining to one person, place, thing, event, or idea within a table row

show and hide

he outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click.

Text and graphics

hyperlinks can be attached to which of the following items?

Arrange all

o tile multiple open worksheets on the screen, use the ________ command.

Protection

________ prevents anyone from changing a workbook.

database

An organized collection of facts related to a specific topic is known as a ________.

.xlsx

By default, Excel 2016 files are saved in the native Microsoft Excel Workbook file format with the following file exte

labels

Column and row titles that describe the values in the column or row are known as ________.

vertical

Column charts present data graphically in ________ columns.

tab delimited text file

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.

detail

Subtotaled rows that are totaled and summarized are referred to as ________ data.

placeholders

The Text Pane includes ________ in which you can type text into a SmartArt graphic.

panes

The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines as a result of using the Freeze Panes command are referred to as ________.

Fakse

True or False: You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

False

True or False: subtotal rows that are totaled and summarized are referred to as actual data.