ITE_140 CH 6 EXCEL Quiz

Sparklines

_______ are TINY charts that fit in a cell, used to visually summarize trends alongside data. Can make your data sparkle ;)

Select Locked Cells

________ Locked Cells option enables you to click locked cells and VIEW the formulas

Templates workbooks

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

Read

_________ -ONLY is a message telling you that the cell is protected

Templates

_________ can have built-in formulas that help standardize calculations

Recommended Charts

___________ Charts helps you choose a chart type by previewing suggested charts based on patterns in your data in Excel

Line Chart

A _____ Char__ displays trends over time

Chart

A graphical representation of data

Column Charts

A type of chart that presents data graphically in vertical columns

Formulas

After text is entered and formatted in your template, add ________ to the cells where you want the result of the calculations to display. Example - In cell F18, type =d18*e18 and then on the _________ Bar, click Enter

Organization Chart

An __________ is a type of SmartArt that depicts reporting relationships within an organization. An example would be showing the hierachy of an organization (CEO, COO, CFO, Account Manager, etc)

Scale

The ________ is the range of numbers in the data series and that controls the minimum, maximum, and incremental values on the value axis. Can do this in the format axis pane (bounds, major unit etc)

Text

The __________ Pane displays to the LEFT of the SmartArt diagram and uses PLACEHOLDERS which allow you to type text into a SmartArt graphic.

Chart Legend

The key that defines the COLORS assigned to CATEGORIES in a chart is called a Chart ________.

column chart Labels

When creating a column chart, selecting Data ________ helps the reader understand the chart.

Totals

A chart is a graphic representation of data. When you create a chart, first decide whether you are going to plot the values representing ___________ or the values representing details—you cannot plot both in the same chart. Excel's Recommended Charts feature can help you make this decision by previewing suggested charts based upon patterns in your data. In this Activity, you will select the details—the number of attendees at each location each year. To help the reader understand the chart, you will also select the labels for the data—the column and row headings that describe the values.

Embedded Chart

An _______ Chart is inserted into the SAME worksheet that contains the data used to create the chart.. If you don't embed the chart into the same worksheet, you can put it on a separate sheet called the Chart Sheet

Changing

Protection prevents anyone from ________ a workbook.

Plot Area

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

Below

To add a shape to a lower level of an ORGANIZATION HIERARCHY SMARTART chart, or BELOW other shapes right-click the shape, click Add Shape, and then click Add Shape ________.

Column Chart

To make comparisons among related data, use a ________ cha____ which displays data vertically

Protection

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

Label

When creating a chart, the column and Row TITLES that describe the values in the column or row are known as a _________. In a data table the LABEL is the same as the table headers

Process

Which of the following SmartArt graphic categories would be best to show a timeline? Use to show a progression, a timeline, or sequential steps in a task, process, or workflow

Data Series

A group of related data plotted in a chart is called a Data ______

SmartArt Graphic

Is a visual representation of your information and ideas. You can create ____________ graphics by choosing from among many different layouts to communicate complex messages and relationships easily and effectively. Unlike charts, a ___________ graphic does not depend on any underlying data in a worksheet; rather, it is a graphical tool that depicts ideas or associations

Protection

To change a template in Excel, you must first remove its ___________ ___________ means that individuals entering data cannot change areas of the worksheet that are protected, and therefore cannot alter important formulas and formats built in to the template.

Solid

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

empty cell

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. Excel identifies the first row as a category because of the empty first cell.

totals OR details

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

Excel Workbook

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

Workbook

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

Password

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

Unlocked Cells

_______ Cells allows an individual completing your form to type their data

Chart Elements

_______ Elements are objects that make up a chart including the chart title, axis titles, data series, legend, chart area, and plot area.

Standardization

________________ and protection are the two main reasons for creating templates for commonly used forms in an organization. _____________ means that all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner.

Trendline

a graphic representation of TRENDS in a data series, such as a LINE sloping upward to represent increased sales over a period of months.