Quiz 6

Pataasin ang iyong marka sa homework at exams ngayon gamit ang 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

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

The entire chart with all of its elements is called the ________.

chart area

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 that is inserted into the same worksheet that contains the data used to create the chart is called ________.

embedded

When selecting 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 the 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

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 worksheet's 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 ________.

plot area

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

process

If you need to make changes to a template after it is protected, you must first remove the_________.

protection

To prevent others from altering the formulas or changing other template 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 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 value axis.

scale

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

series

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

solid line

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

________ are workbooks you use as the basis for other similar workbooks.

templates

Sparklines are ________.

tiny charts

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 Backstage view, it opens as a(n)_________.

workbook


Kaugnay na mga set ng pag-aaral

Combo with "HLTH 1100 chapter 1" and 16 others

View Set

Microeconomics Quiz 10 (Ch. 8 and Info.)

View Set

Rigid-Body Dynamics HW Reading Questions

View Set

Chapter 12: Endoplasmic Reticulum

View Set

SCM 200 Final Exam True or False

View Set

Study set 15 for RN NCLEX (Kaplan)

View Set

algebra 2a - unit 2: key features and graphing quadratics lesson 5-8

View Set