230 Final - Excel

In a chart, which of the following can you fill with pictures? •A. bars •B. columns •C. pie slices •D. all of the above

All of the above

Which of the following is used to separate data? •A. text file •B. field •C. Text Import Wizard •D. delimiter

delimiter

Which of the following includes or refers to data from another workbook? •A. dependent workbook •B. source workbook •C. external reference formula •D. identifiers

dependent workbook

In an Excel table, which of the following represents a column of data? •A. header row •B. record •C. field •D. table

field

Which of the following represents an individual column in a text file? •A. text file •B. field •C. Text Import Wizard •D. delimiter

field

Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column? •A. AutoFilter •B. Advanced Filter •C. Flash Fill •D. PivotTable

flash fill

In an Excel table, which of the following contains descriptive titles or labels? •A. header row •B. record •C. field •D. table

header row

Which of the following is a character such as an exclamation point that marks or signifies a component of an external reference? •A. relative reference •B. mixed reference •C. external reference formula •D. identifier

identifier

Which of the following is the process of referring to data in another workbook? •A. Data connection •B. Linking •C. Trace Dependents •D. Consolidating

linking

When you place a screenshot in a worksheet, what type of object is it? •A. SmartArt graphic •B. Linked •C. Picture •D. Shape

picture

In an Excel table, which of the following represents a row of data? •A. header row •B. record •C. field •D. table

record

Which of the following includes data that is referenced in a dependent workbook? •A. dependent workbook •B. source workbook •C. external reference formula •D. identifiers

source workbook

Which of the following is a predesigned set of built-in format options? •A. Table Tools •B. Conditional Formatting •C. table style •D. table format

table style

Which of the following is not an example of SmartArt objects? •A. organization charts •B. matrices •C. pyramids •D. text effects

text effects

Which of the following is a document that includes basic data, no f8rmatting, and commas or other characters to separate the data into fields? •A. text file •B. field •C. Text Import Wizard •D. delimiter

text file

What type of file can most software applications read? •A. Word documents •B. Excel documents •C. Access documents •D. text files

text files

Which of the following use ranking or averages to format cells? •A. Top/Bottom Rules •B. Quick Analysis tool •C. Highlight Cells Rules •D. all of the above

top/bottom rules

Which of the following is a horizontal or vertical boundary that identifies what is plotted? •A. axis •B. chart area •C. legend •D. plot area

•A. axis

Which of the following chart types illustrates data changes over a period of time or shows comparisons among items? •A. column •B. bar •C. line •D. pie

•A. column

Which of the following is a horizontal or vertical line that extends across the plot area to help in identifying values? •A. gridline •B. tick mark •C. trendline •D. data point

•A. gridline

Which of the following are miniature charts displayed in a cell or cell range with your data? •A. sparklines •B. markers •C. elements •D. none of the above

•A. sparklines

Which of the following could you add to a chart to predict future values? •A. trendline •B. data label •C. data table •D. source data

•A. trendline

Which of the following might a manager use to forecast the next quarter's sales based on historical numbers? •A. trendline •B. data label •C. data table •D. source data

•A. trendline

LivePreview identifies the file and provides basic instructions for a hyperlink.

•Answer: False •Feedback: A ScreenTip identifies the file and provides basic instructions for a hyperlink.

A Snapshot is a picture of a full or partial computer screen inserted as an object in a worksheet.

•Answer: False •Feedback: A Screenshot is a picture of a full or partial computer screen inserted as an object in a worksheet.

A SmartArt graphic is linked to worksheet data.

•Answer: False •Feedback: A SmartArt graphic is not linked to worksheet data.

A text file is a document that includes formatted text.

•Answer: False •Feedback: A text file is a document that includes raw data, with no formatting.

If you save a workbook while sheets are grouped, the workbook will open with ungrouped sheets the next time you open the file.

•Answer: False •Feedback: If you save a workbook while sheets are grouped, the workbook will open with grouped sheets the next time you open the file.

In a pie chart, a data series is a slice of a pie.

•Answer: False •Feedback: In a pie chart, a data point is a slice of a pie.

In a table, each row of data is a field and each column is a record.

•Answer: False •Feedback: In a table, each row of data is a record and each column is a field.

In an ascending sort, data is sorted alphabetically from Z to A.

•Answer: False •Feedback: In an ascending sort, data is sorted alphabetically from A to Z.

Use the Page Layout tab to insert a picture in an Excel worksheet.

•Answer: False •Feedback: Use the Insert tab to insert a picture in an Excel worksheet.

After your data is formatted as a table, each label in the header row displays an AutoFilter arrow.

•Answer: True

When using an Advanced Filter, you need to create a criteria range.

•Answer: True

Which of the following should you press to delete a selected chart element? •A. Ctrl+X •B. Delete •C. Enter •D. Shift+Enter

•B. Delete

Which of the following charts displays relationships among numeric values in two or more data series? •A. area •B. XY •C. stock •D. radar

•B. XY

What do trendlines demonstrate? •A. totals •B. averages •C. maximum values •D. none of the above

•B. averages

Which of the following chart types displays comparisons among individual items or values at a specific period of time? •A. column •B. bar •C. line •D. pie

•B. bar

Which of the following is a preset combination of colors and effects for a chart, its background, and its elements? •A. chart layout •B. chart style •C. Quick Layout •D. none of the above

•B. chart style

What would you call the number values located on top of the bars in a column chart? •A. trendline •B. data label •C. data table •D. source data

•B. data label

Which of the following is a requirement or condition that identifies which data is shown and which is hidden? •A. legend •B. filter •C. gridlines •D. data labels

•B. filter

Which of the following lets you refine which data is displayed in a chart? •A. legend •B. filter •C. gridlines •D. data labels

•B. filter

In a column chart, what happens to your chart when you add a data series? •A. the title becomes smaller •B. the width of size of the chart increases •C. another column is added to the chart •D. a trendline is added to the chart

•C. another column is added to the chart

Which of the following makes it easier to take screenshots? •A. maximizing the current window •B. minimizing the current window •C. arranging open windows side by side •D. show the desktop

•C. arranging open windows side by side

Which of the following terms refers to a group of data points or values? •A. source data •B. data point •C. data series •D. category label

•C. data series

Which of the following pie charts has a hollow center? •A. 2-D pie chart •B. 3-D pie chart •C. doughnut chart •D. sunburst chart

•C. doughnut chart

Which of the following explains the symbols, textures, or colors used to differentiate data series? •A. axis •B. chart area •C. legend •D. plot area

•C. legend

In a pie chart, what is a data series represented by? •A. a piece of the pie •B. several pieces of pie •C. the whole pie •D. none of the above

•C. the whole pie

Which of the following displays averages in your data and can be used to forecast data? •A. gridline •B. tick mark •C. trendline •D. data point

•C. trendline

Which of the following statements is not true about screenshots? •A. You can capture a screenshot image of any open window. •B. You can capture a screenshot of a portion of a web page. •C. It is possible to format, position, and size screenshots. •D. When capturing an image from a web site, it is not necessary to obtain permission from the author of the web site.

•D. When capturing an image from a web site, it is not necessary to obtain permission from the author of the web site.

Which of the following can you apply after you select a chart element? •A. fill color •B. outline width •C. special effect •D. all of the above

•D. all of the above

Which of the following shapes can you use to highlight important parts of a chart? •A. arrow •B. circle •C. callout •D. all of the above

•D. all of the above

Which of the following would be a way to emphasize the highest sales month? •A. arrow •B. circle •C. callout •D. all of the above

•D. all of the above

Which of the following give chart elements a realistic, three-dimensional look? •A. bold fonts •B. outlines •C. increased outline weight •D. bevels and shadows

•D. bevels and shadows

Which of the following terms refers to the text label that describes each data series? •A. source data •B. data point •C. data series •D. category label

•D. category label

Which of the following is a single value or piece of data from a data series? •A. gridline •B. tick mark •C. trendline •D. data point

•D. data point

Which of the following chart types use one data series to display each value as a percentage of the whole? •A. column •B. bar •C. line •D. pie

•D. pie

Which of the following is a type of conditional formatting that displays cells with a fill color, a horizontal bar, or an icon? •A. advanced filter •B. PivotTable •C. Microsoft Access database •D. data visualization

Data visualization

A static consolidation places formulas on the consolidated sheet in an outline format.

False

Which of the following is true of a SmartArt graphic's position in a worksheet? •A. It rests on an invisible, transparent layer in the worksheet. •B. It appears with a solid background and border by default •C. It is linked to worksheet data. •D. It is always anchored to the top margin of the worksheet

It rests on a invisible transparent layer in the worksheet

Which of the following is an illustration, which often includes text that can be placed in Excel worksheets? •A. SmartArt graphic •B. Screenshot •C. Screen Clipping •D. Shape

SmartArt graphic

A chart object is a selectable item surrounded by a square border that is separate from worksheet data.

True

A chart sheet is an Excel chart that is displayed on its own sheet in the workbook.

True

A chart style is a preset combination of colors and effects for a chart, its background, and its elements.

True

A consolidated worksheet summarizes data from multiple worksheets using a mathematical or statistical function.

True

A legend is the chart element that explains the symbols, textures, or colors used to differentiate data series.

True

A tick mark is a small line or marker on an axis to guide in reading values.

True

A worksheet can have only one outline.

True

After you choose a color for a chart element, you can refine it to use a gradient, a variegated blend of the color.

True

After you create a dynamic consolidation, expand outline items to display individual values that are summarized.

True

An external reference formula refers to cells in another workbook and establishes a link to the source workbook.

True

An identifier is a character such as an exclamation point that marks or signifies a component of an external reference.

True

Another name for the base or bottom of a 3-D chart is chart floor.

True

Consolidation by category can be static or dynamic.

True

Data tables are located just below a chart.

True

Each group of data points or values used in a graph is a data series.

True

Each individual shape in a SmartArt object has its own selection handles, a rotation handle, and a bounding frame.

True

Exploding a pie slice emphasizes that slice, because it moves the slice away from the rest of the pie.

True

External data is data in a worksheet that originated in another program or format.

True

Flash Fill is a feature that recognizes a pattern in the first cell and suggests data for the remaining rows in a column.

True

If data is formatted as an Excel table, convert it to a normal cell range before using the Subtotal command.

True

In Excel, dates are treated as values.

True

In order to use the Consolidate command by position, worksheets must have common data in the same rows and columns on each worksheet.

True

Insert a hyperlink to open another workbook or a web page.

True

It is possible to replace a chart title box with WordArt.

True

Once you have created a chart, it is possible to change the chart type.

True

Sparklines are miniature charts displayed in a cell or cell range with your data.

True

The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme.

True

The Consolidate command calculates totals, averages, or other functions for data from multiple worksheets.

True

The Subtotal command includes SUM, AVERAGE, MAX, and MIN as well as other Statistical functions.

True

The cells used to build a chart are its source data.

True

To capture one part of a computer screen, use the Screen Clipping command.

True

To delete a chart element, click it to select it and press Delete.

True

To link workbooks, use the consolidate command or build formulas that refer to cells in other workbooks.

True

When the source data is final and will not be edited, you can use a static consolidation.

True

When you group sheets, most editing and formatting commands that you perform affect every sheet in the group.

True

When you save worksheet data as a text file, Excel renames the sheet with the same file name that you type for the text file.

True

When you work with large numbers of records in a worksheet, you can use groups to hide data that is not needed at the moment.

True

With Conditional Formatting, Top/Bottom Rules use a ranking to format the highest (top) or lowest (bottom) items, either by number or percentage.

True

You can create your own conditional formatting rule as well as edit existing rules with the Manage Rules command.

True

You can dynamically consolidate data by using 3D references in your own formulas.

True

You can import a table or a query from an Access database into an Excel worksheet.

True

Using the Text Import Wizard to set the type of delimiter used in a text file, which of the following delimiters is commonly used? •A. tab •B. comma •C. space •D. all of the above

all the above

Which kinds of source data can you import into Excel? •A. text file •B. database •C. web location •D. All of the above

all the above

Which of the following functions can be inserted by the Subtotal command? •A. SUM •B. AVERAGE •C. MIN and MAX •D. all of the above

all the above

Which of the following guidelines will make your tables easier to use and navigate? •A. Give each header a unique label. •B. Keep the same type of data within each column, such as text or values. •C. Do not leave blank cells within the data. •D. all of the above

all the above

Which of the following is a specific item name in a structured reference that Excel automatically places in a table? •A. #All •B. #Data •C. #Headers •D. all of the above

all the above

Which of the following is a task you can perform using the Table Style Options group of commands? •A. show or hide various parts of a table •B. hide the header row or display a total row •C. hide the AutoFilter arrows •D. all of the above

all the above

Which of the following is an example of a data visualization command? •A. Data Bars •B. Color Scales •C. Icon Sets •D. all of the above

all the above

Which of the following charts displays the magnitude of change over time and shows the rate of change? •A. area •B. XY •C. stock •D. radar

area

How does the Subtotal command format the list data? •A. It doesn't format the list data. •B. as an outline •C. as a table •D. as a PivotTable

as an outline

How does Excel treat dates? •A. as text •B. as values •C. as filters •D. as criterion

as values

When you sort a cell range using A to Z or Z to A, what is rearranged? •A. numeric values •B. cells within a selected row •C. cells within a selected column •D. complete rows of data

complete rows of data

Which of the following applies specified formats to cells only when the cells meet some criteria? •A. Subtotal command •B. Auto Outline command •C. Group button •D. Conditional Formatting

conditional formatting

Which of the following types of file might you see when downloading a bank statement? •A. .docx •B. .xlsx •C. .csv •D. .pdf

.csv

Which of the following statements about SmartArt graphics is not true? •A. You can customize the text in a SmartArt graphic. •B. A SmartArt graphic includes a text pane for entering text. •C. As you type in a SmartArt graphic, the text and its shape are sized to fit the contents. •D. A SmartArt graphic is linked to worksheet data.

A SmartArt graphic is linked to worksheet data