Q&A Hero

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: 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: 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: 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 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: 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: 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

Q: The ____________________ is the middle value from a sample.

Q: ____ is the amount added to the prinicpal of a loan by the lender. a. Rate b. Simple c. Interest d. Maximum

Q: TODAY is an example of a(n) ____________________ function.

Q: The FV function stands for ____. a. function value b. future value c. financial value d. formulated value

Q: A(n) ____________________ reference contains both relative and absolute references.

Q: The amount of money being loaned is known as the ____. a. mortgage b. principal c. loan amount d. proposed principal

Q: Not all functions have arguments, and some functions have ____________________ arguments, which are not required for the function to return a value, but can be included to provide more control over the returned value.

Q: In the figure above, nper stands for the ____. a. total number of payment periods b. total number of payments that have already been made c. number of payments per year d. number of interest payments per year

Q: A pie slice is a data marker that represents ____ from a data series. a. only one value b. at least one value c. no more than three values d. no more than five values

Q: In the figure above, pv stands for the ____. a. payments verified b. principal value of the loan c. present value of the loan d. primary interest rate of the loan

Q: To move one slice of a pie chart away from the pie creates a(n) ____. a. spontaneous pie chart b. perfect pie chart c. exploded pie chart d. exponential pie chart

Q: In the figure above, fv and type are ____. a. financial functions b. required arguments c. comparison operators d. optional arguments