Excel Chapter 3,4

STUDY
PLAY

Terms in this set (...)

Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

Column chart

Bar chart

Line chart

Pie chart
Pie Chart
What is the typical sequence for creating a chart?

Select the data source, select the chart type, and then size and position the chart.

Select the data source, size the chart, select the chart type, and then position the chart.

Select the chart type, select the data source, and then size and position the chart.

Click the cell to contain the chart, select the chart type, and then select the data source.
Select the data source, select the chart type, and then size and position the chart.
Which of the following applies to a sparkline?

Chart title

Single-cell chart

Multiple data series

Legend
Single-cell chart
If you want to show exact values for a data series in a bar chart, which chart element should you display?

Data labels

Legend

Value axis title

Chart title
Data labels
The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100?

Show Axis in Thousands

More Primary Vertical Axis Title Options

Show Axis in Millions

Show Right to Left Axis
Show Axis in Thousands
You want to create a single chart that shows each of five divisions' proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs?

Surface chart

Clustered bar chart

100% stacked column chart

Pie chart
100% stacked column chart
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?

Change the chart type to a clustered column chart.

Click Switch Row/Column in the Data group on the Design tab.

Click Layout 2 in the Chart Layouts group on the Design tab and apply a different chart style.

Click Legend in the Labels group on the Layout tab and select Show Legend at Bottom.
Click Switch Row/Column in the Data group on the Design tab.
Which tab contains commands to apply a predefined chart layout that controls which elements are included, where, and their color scheme?

Design

Layout

Format

Page Layout
Design
Which icon does not display to the right of a selected chart?

Chart Quick Analysis

Chart Filters

Chart Styles

Chart Elements
Chart Quick Analysis
What indicates that the closing price was higher than the opening price in a stock chart?

A double vertical line between the price markers

A rectangle with a white fill color

A positive data label above the data series for a particular day

A rectangle with a black fill color
A rectangle with a white fill color
You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this?

Adjust page breaks.

Change the print page order.

Set a print area.

Print titles.
Change the print page order.
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?

Split Rows command

Freeze Panes command

Hide Rows command

New Window command and cascade the windows
Freeze Panes command
4)
Which statement is not a recommended guideline for designing and creating an Excel table?

Ensure no blank columns separate data columns within the table.

Avoid naming two fields with the same name.

Leave one blank row between records in the table.

Include field names on the first row of the table.
Leave one blank row between records in the table.
You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office. Which is true of your sort order?

Branch office is the primary sort and should be in Z to A order.

Branch office is the primary sort and should be in A to Z order.

Salary is the primary sort and should be from highest to lowest.

Salary is the primary sort and should be from lowest to highest.
Branch office is the primary sort and should be in A to Z order.
You suspect a table has several identical records. What should you do?

Do nothing; a logical reason probably exists to keep identical records.

Find the duplicate records and change some of the data to be different.

Use the Remove Duplicates command.

Look at each row yourself and manually delete duplicate records.
Use the Remove Duplicates command.
Which check box in the Table Style Options group enables you to apply different formatting to the records in a table?

Banded Columns

Total Row

Banded Rows

Header Row
Banded Rows
8)
Which date filter option enables you to specify criteria for selecting a range of dates, such as between 3/15/2016 and 7/15/2016?
Equals

Before

Between

All Dates in the Period
Between
9)
You want to display a total row that identifies the oldest date in a field in your table. What function do you select from the list?

Min

Max

Sum

Count
Min
What type of conditional formatting displays horizontal colors in which the width of the bar indicates relative size compared to other values in the selected range?

Icon Sets

Data Bars

Sparklines

Color Scales
Data Bars
When you select the ______ rule type, the New Formatting Rule dialog box does not show the Format button.

Format only unique or duplicate values

Format all cells based on their values

Use a formula to determine which cells to format

Format only cells that contain
Format all cells based on their values