ITE 140 Chapter 6 Quiz_ Exam 2

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

To add a shape to a lower level of an organization chart, right- click the shape, click Add Shape, and then click _____.

Add Shape Below

A _____ is a graphic representation of data

Chart

When you open a template from Custom Office Templates folder, it opens as a(n)_______

Excel Template

Which of the following SmartArt graphic categories would be best to show a timeline

Process

To prevent others from altering the formulas or changing other templates components, you should use ____.

Protection

_______ prevents anyone from changing a workbook.

Protection

If you try to enter data in a protected cell, a message displays informing you that the cell is protected and therefore ________.

Read-only

An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called.

Recommended Charts

A ____ is a visual representation of information and ideas

SmartArt graphic

______ are workbooks you can use as the bases for other similar workbooks.

Templates

The entire chart with all of its elements if called the _____

chart arear

Objects that make up a chart are called ____.

chart elements

Charts can be placed on a separate sheet called a _______.

chart sheet

To make comparisons among related data, use a ____ chart.

column

A chart is inserted into the same worksheet that contains the data used to create the chart is called ______

embedded

When electing the range for a line chart, you may need to include a (n) ____ to have the same number of cells in each row

empty cell

After text is entered and formatted in your template, add _____ to the cells where you want the result of the calculations to display.

formulas

Templates can have built-in _____ that display the results of calculations based on the data that is entered into the template

formulas

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

labels

When creating a column chart, selecting ___ for the data helps the reader understand the chart

labels

The Text Pane displays to the ____ of the SmartArt diagram

left

The key that defines the colors assigned to categories in a chart is called a (n) ____.

legend

To display trends over time, use a ___ chart.

line

When you protect a worksheet, you can add an optional ________ to prevent someone from disabling a worksheets protection

password

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

placeholders

The area bounded by the axes, including all the data series is called

plat area

If you need to make charges to a template after it is protected, you must first remove the _______.

protection

An organization chart depicts ______ within an organization

reporting relationships

The _____ is the range of numbers in the data series and that controls the minimum, maximum and incremental values on the values axis

scale

A group of related data plotted in a chart is called data _______.

series

To delete a box from a SmartArt organization chart, a _____ border must display around the box.

soldline

If you want all of the forms within an organization to have a uniform appearance and have the data organized in the same manner, you should use ______.

standardization

The two main reasons for creating templates for commonly used forms in an organization are _______.

standardization and protection

Sparklines are ____.

tiny charts that fit within a cell and give a visual trend summary alongside your data.

When you create a chart you must first decide if you are going to plot values representing ______

totals OR details

A _____ is a graphic representation of trends in a data series

trendline

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

unlocked

Column charts present data graphically in ___ columns

vertical

The Select locked cells option enables you to click the locked cell and ____ the formulas

view

When you open a template from the New tab in the Backstage view, it opens as a(n)_____

workbook


Ensembles d'études connexes

MSPA I Gustar: Pregunta, pregunta, cambia

View Set

BECOMING HUMAN: Nature vs. nurture

View Set

ACID/BASE and Fluid Electrolytees

View Set

Session 21: Communicating with other drivers

View Set

AP Euro Unit 9- Concert of Europe and Romanticism

View Set

Ch. 30 Management of Patients with Hematologic Neoplasms

View Set