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.