Excel Chapter 3

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

To show the structure of a company or institution, create an

organization chart

To calculate a value in A1 with a percentage increase in A2 added to it, use this formula

=(1+A2)*A1

You can automatically republish your data whenever you change the workbook, using the ____________ option in the Publish as Web Page dialog box

AutoRepublish

The _____ ____ is the overall background for the chart and all its elements

Chart Area

A _____ _____ is a chart that exists on a separate sheet in the workbook

Chart Sheet

________ means to insert an object in a destination document so that it can still be edited by the source application

Embedded

An ________ _____ is a chart that exists as an object in the worksheet alongside the data

Embedded Chart

(T/F) Changes to a linked object in the destination document are automatically made to the object in the source document

False

(T/F) Excel will always display an error message when improperly placed parentheses can cause logic flaws in a formula

False

(T/F) For a linked chart, you can close the Excel window without saving after you have made changes

False

(T/F) For an embedded chart, you can close the Excel window without saving after you have made changes

False

(T/F) Making data or formatting changes to an Excel chart embedded in Word also changes the original data or chart in Excel

False

(T/F) Once you create a chart, you CANNOT change its chart type

False

(T/F) The horizontal axis is the axis that goes from top to bottom

False

(T/F) The selection of chart data to plot CAN contain blank columns or rows

False

(T/F) To explode a pie chart means to delete it

False

(T/F) When you make changes to a chart either in the source or destination workbook for a linked chart, those changes flow between the two chart locations

False

(T/F) You CANNOT add or remove chart elements from your chart layout

False

If you make your online chart ___________, users can view the data in the chart and make changes to it

Interactive

The ______ is a key that identifies each data series in a chart

Legend

The process of saving worksheet data to the Internet is called _______

Publish

A ________ graphic is a pre-drawn graphic used to illustrate a specific data relationship

SmartArt

(T/F) A chart is also known as a graph

True

(T/F) A link to an Excel chart in a Word document allows you to start Excel from inside Word

True

(T/F) After you create a pie chart, you can move it to its own chart sheet

True

(T/F) An embedded chart in the destination file may also be displayed as an icon

True

(T/F) Calculate a percentage of a total by dividing the individual value by the total value

True

(T/F) For charts with multiple series, you have to format the data labels for each series independently

True

(T/F) If you select an embedded chart before choosing the Print command, only the chart will print

True

(T/F) If you use a chart picture, the data can be changed

True

(T/F) Selecting multiple rows of chart data creates multiple categories

True

(T/F) Sorting data DOES change the order of the pie slices

True

(T/F) The Recommended Charts feature examines your data and provides recommended chart types based on the type of your data

True

(T/F) The axis of a chart on which categories are plotted is called the X axis

True

(T/F) The simplest way to include an Excel chart within another document is to paste its picture

True

(T/F) To change the color of a chart element, right-click on the element and use the Fill button

True

(T/F) To find the percentage of a value, convert the percentage to a decimal, then multiply

True

(T/F) To maintain the link, the source and destination files do not need to remain in their original locations

True

(T/F) To update a chart picture, you need to change the data in Excel and paste a new picture

True

(T/F) Use the Filter shortcut button to display selected data elements of a chart

True

(T/F) When you change the data or chart formatting in a linked chart and open the destination file again, the link causes the destination chart to update as well

True

(T/F) You can link or embed an Excel chart into another document, such as a Word document

True

_____ are the areas of a 3-D chart that frame the data series

Walls

A ______ analysis looks at how future results might change based on varying inputs or data

What-If

The shape representing each data point of a chart is

a data marker

A set of related data points to be charted is

a data series

If you paste an Excel chart into Word, the Word file is the

embedded file

When there are multiple nested pairs of parentheses, Excel calculates

from the innermost pair, working outward

HTML format

is a format in which the text and page format is stored in one file and the graphics and other elements are stored in separate files

Lines of measurement along the category and value axis are called

tick marks


Kaugnay na mga set ng pag-aaral

Chapter 13: Health Promotion of the Preschooler and Family

View Set

Chapter 35: Comfort and Pain Management

View Set

EXAm FX Life Policy Provision, Riders and Options 4-24-19

View Set

Chapter 70 (2) - Oncologic or Degenerative Neurologic Disorders

View Set