Q&A Hero

Q: ____ order arranges labels in reverse alphabetical order, from A to Z a. Reverse b. Major c. Ascending d. Descending

Q: The fields you use to order your data are called sort ____. a. values b. fields c. tags d. tools

Q: You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option. a. Filtering b. Formatting c. Editing d. Text

Q: When you have more than one sort field, you should use the Sort ____ to specify the sort criteria. a. menu b. status bar c. wizard d. dialog box

Q: To add a sort field in the Sort dialog box, click the ____ button. a. Add Level b. Add Field c. New Sort Field d. New Level

Q: You can create at most one Excel table in a worksheet. a. True b. False

Q: When you create a table, if your data does not contain column headers, Excel adds headers with default names. a. True b. False

Q: You can use a tables sizing handle to add columns or rows to a table. a. True b. False

Q: Before you complete a sort, you need to decide whether you want to put the list in ascending or descending order. a. True b. False

Q: When you delete a record from a table, a dialog box displays to confirm the delete operation. a. True b. False

Q: An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons. a. True b. False

Q: Excel can summarize data in a range of data by inserting subtotals. a. True b. False

Q: You can drag one field to the Filters area of the PivotTable Fields pane to change what values are displayed in the PivotTable. a. True b. False

Q: Each column represents a record that describes some attribute or characteristic of a person, place, or thing. ____________________

Q: The ____ dialog box provides options for moving charts between worksheets and chart sheets. a. Insert New b. Tab c. Move Chart d. Change Chart

Q: Table names cannot include underscores. ____________________

Q: Placing a chart in a ____ displays only the chart and no worksheet cells. a. new worksheet b. tabbed view c. graph display d. chart sheet

Q: Ascending order arranges labels alphabetically from A to Z. ____________________

Q: Excel supports all of the following types of sparklines EXCEPT ____. a. A win/loss sparkline for highlighting positive and negative values b. A column sparkline used for column charts c. A line sparkline for highlighting trends

Q: The first sort field in a sort is called the major sort field. ____________________

Q: To resize an embedded chart, ____. a. select the chart and drag the corner sizing handle of the selection box b. right click the chart and then click Resize on the shortcut menu c. select the chart and press Tab d. both a and b

Q: To create a custom list, in the Sort & Filter group on the Home tab, click the Sort button. Click the Order arrow, and then click Custom List. ____________________

Q: To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left. a. Legend b. Chart Elements c. Formatting d. Layout

Q: If a column consists of day or month labels, you can sort them in their correct chronological order using one of the predefined custom lists. ____________________

Q: ____provide descriptive text for the individual data markers, such as pie slices a. Asset labels b. Legend values c. Data labels d. Leader lines

Q: Custom filters enable you to specify various conditions in addition to those that are based on an equals criterion. ____________________

Q: If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1. a. True b. False

Q: You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table. ____________________

Q: When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. _________________________

Q: The cell with the largest value contains a data marker that extends across the entire width of the cell, and the lengths of the other bars in the selected range are determined relative to that bar. _________________________

Q: In a line chart, the data markers are the points connected by the line. _________________________

Q: Every chart contains elements that can be formatted, added to the chart, or removed from the chart. __________ a. True b. False

Q: Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________

Q: In pie charts, its best to make the slice colors as similar as possible. ___________ a. True b. False

Q: A ________ contains the actual values that are plotted on the chart. a. data source b. data series c. category values d. legend

Q: A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value. ___________ a. True b. False

Q: Category values are usually located in the ____ of the data source. a. first row b. first column c. either a or b d. neither a nor b

Q: You can move a chart from one worksheet to another, or you can place the chart in its own chart sheet. ____________ a. True b. False

Q: The ____ is the only one of the following charts to compare relative values from different categories to the whole. a. pie b. column c. line d. area

Q: Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. ___________ a. True b. False

Q: To add and remove chart elements, you can use the Add Chart Element button in the Charts Layout group on the ____ tab. a. CHART TOOLS LAYOUT b. CHART TOOLS DESIGN c. INSERT d. HOME

Q: Line charts are best suited for representing data that follows some nonsequential order. ___________ a. True b. False

Q: The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart. a. INSERT and DESIGN b. DESIGN and FORMAT c. INSERT and FORMAT d. FORMAT and PRINT

Q: Interest is the amount of money being loaned. ___________ a. True b. False

Q: The PMT function calculates the payment required in each period to pay back the loan. ___________ a. True b. False

Q: Interest is the amount added to the principal by the lender. _________________________

Q: A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value. _________________________

Q: Pie charts are most effective with ten or fewer slices. _________________________

Q: By default, Excel inserts a chart as an embedded chart. _________________________

Q: You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery. _________________________

Q: Case 4-1 Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. Simon wants to change the charts border. To do this, he should select the CHART TOOLS ____ tab. a. FORMAT b. EDIT c. DESIGN d. LAYOUT

Q: Describe the some of the concepts and definitions associated with loans before using a PMT function.

Q: Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____. a. line chart b. exploded pie chart c. scatter chart d. banded chart

Q: Each slice in a pie chart represents a single value from a data series. ____________ a. True b. False

Q: In cases where a label placed outside a pie might appear farther from its slice than is easily readable, a(n) ____________________ might be added to connect the data to its corresponding slices.

Q: Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________ a. True b. False

Q: You can add ___________________ to identify smaller intervals between the major tick marks.

Q: The range of values, or ___________________, of an axis is based on the values in the data source.

Q: To compare values from several categories with a sequential order, such as dates and times occurring at evenly spaced intervals, you would use a(n) ____________________ chart.

Q: A chart that combines two or more chart types into a single graph is called a(n) ____________________ chart.

Q: Since scientific data is often plotting two numeric values against one another, it is oftentimes best to represent this data type with a(n) ____________________ chart.

Q: Each data source is a collection of ____________________, which is a range of values plotted as a single unit on a chart.

Q: A(n) ____________________ chart shows patterns or relationships between two or more sets of values, much like an XY chart, except the size of the data marker is determined by a third value.

Q: A ____________ displays data values as columns with the height of each column based on the data value.

Q: ______ are horizontal and vertical lines that help you compare data and category values.

Q: Each value from a data series is represented by a ________.

Q: The _______ covers the entire background of the chart, whereas the plot area includes only that portion of the chart in which the data markers, such as the columns in a column chart, have been placed or plotted.

Q: An _______ chart takes up less space than a chart sheet.

Q: The goal of a ______ is to convey the maximum amount of information within a very small space.

Q: The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series. a. clustered column chart b. stacked column chart c. 100% stacked column chart d. column chart

Q: Consider the impact of a poorly designed chart. Explain why it is important to have a well-designed chart, and name at least four tips for creating a good chart.

Q: Which of the following shows the correct order of steps for adding a data series to a chart? a. Select the chart, Click the Add button, Click the Select Data button, Select the range b. Select the chart, Click the Select Data button, Click the Add button, Select the range c. Select the range, Click the Select Data button, Click the Add button, Select the chart d. Select the range, Select the chart, Click the Select Data button, Click the Add button

Q: Edward Tufte was concerned with what he termed as chart ____, in which a proliferation of chart elementschosen because they look niceconfuse and distract the reader. a. espionage b. clutter c. confusion d. junk

Q: A chart sheet can contain ____. a. only one chart b. one or two charts c. one to four charts d. one to six charts

Q: You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane. a. Format Data Labels b. Format Legend c. Format Chart Area d. Format Axis

Q: To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab. a. CREATE b. VIEW c. LAYOUT d. DESIGN

Q: The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Q: When combination charts have data series with vastly different values, you can create ____ charts. a. dual axis b. secondary c. multivalued d. multiple axis

Q: A(n) ____________________ function is a function that works with statements that are either true or false.

Q: The ____ identifies which data markers are associated with each data series. a. x-axis b. y-axis c. chart area d. legend