Excel Chpt 3-4

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

False

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

False

Filter arrows are always displayed in data tables.

False

Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

False

Selecting a range automatically makes it a data table.

False

To understand a chart you need to include the chart data.

False

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

Formula Autocomplete

Which of the following is not a freeze option?

Freeze Section

What is a disadvantage of a stacked column chart?

Segments do not start at the same point.

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

They are easier to read

In rare cases you can chart text entries.

false

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

false

Which of the following is not a conditional formatting option?

table format

You can link to a cell as the title of a chart.

true

Which chart type is not listed in the All Charts window?

Sparkline

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

The first unfrozen cell becomes the active cell.

If you use the Icon sets conditional formatting, you are limited to how many categories?

Three, four, or five

After a table has been named, that name can be used in functions instead of cell references.

True

You can add a row to a data table as long as you put in the row immediately below the table.

True

You can freeze as many columns and rows at the same time as you desire.

True

Which group on the Design tab would you select if you wanted to change the source information in the chart?

data

A stacked column chart displays multiple columns for each category.

false

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

false

In Normal view or Page Layout view the data to be printed has a dark blue border.

false

What is the default data table style?

medium 2

The filter "Begins With..." option is found on which type of filter?

text filter

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

true

The Chart Styles gallery displays style options for the selected chart only.

true

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

true

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

true

When you want to chart two related types of data, the Combo chart is perfect.

true

You can switch the rows and columns in a chart to communicate a different perspective on your data.

true

You might want to avoid using 3-D charts because they can distort the appearance of the data.

true

How many variations of the stock chart does Excel have?

4

How many sizing handle are found on embedded charts?

6

How does Excel indicate that a column has been selected in a structured reference?

A colored border appears around that column.

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

Conditional formatting

You cannot sort cells by their fill color.

False

ocking is the process of making sure that certain rows or columns are visible at all times.

False

What group is not found on the Sparkline Tools Design tab?

Format

Which chart element cannot be chosen from the Chart Elements dialog box?

Format Back Wall

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

Highlight Cells Rules

What is not true about an effective chart?

It always contains more than one series.

Which table style option is useful to display aggregated data when it is checked?

Last column

What is the default data table style?

Medium 2

Which wildcard character only replaces one character with one other character?

Question mark ?

By default, what is the first table on a worksheet named?

Table 1

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

The range to be included in the calculation

When would you not need to use a fully qualified structured reference?

When referring to a cell within the table

"John Smith" is a good example of a field.

false

A chart sheet can hold, at most, two charts.

false

On which tab will you find options if you have to print a large dataset?

page layout

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

pie

What chart type represents data as spokes going from the center to the outer edge of the chart?

radar

What is not a purpose of using an effective chart?

reveals even subtle errors in formulas

To what does the @ symbol refer in a structured reference?

row

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

the count function

It is important to select parallel ranges.

true

In the task pane, what does a diagonal white triangle next to a chart category indicate?

Correct None of the category's options are displayed.

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

Sparkline

Which chart type is a visual "dashboard" of your data?

Sparkline

By default Excel prints page in what order?

Top-left section, bottom-left section, top-right section, and bottom-right section

What is true about adding a new field to the right side of an existing data table?

You can add it to the right of the data table and Excel will extend the table to include the new field.

Including what, distorts the effectiveness of charting data points?

aggregates

What does Excel not determine about the value axis when you create a chart?

average value

Which chart type is preferable when the category names are long?

bar

Which chart type cannot be displayed as a sparkline?

bar chart

Where does Excel display the Total row in a table?

below the last row in a table

Which one of the following filter options is not found on the number filter submenu?

bottom 10

Where does Excel display the Quick Analysis tool?

bottom-right corner

In a structured reference what do you use to indicate a column heading or field name?

brackets []

Using the data bars conditional formatting, how is the highest value represented?

by the longest bar

Which of the following is not a characteristic of a table?

can contain multiple ranges

Which axis in a chart displays the descriptive labels for the data points?

category

What can you not do from the Select Data Source dialog box?

change chart type

What icon is not displayed when you select a chart?

chart types

Which chart type displays the data vertically?

column

What chart type can display two different chart types at the same time?

combo

Which chart type is best when you want to chart two unrelated data types?

combo chart

What cannot be found on the Manage Rules dialog box?

copy rule

Which of the following is not a chart element?

data area

A chart style effects the formatting of the chart itself, but not the chart data.

false

Locking is the process of making sure that certain rows or columns are visible at all times.

false

Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

false

Records are individual pieces of information.

false

The range used for a sparkline cannot include more than one row.

false

To print row labels on the left side of each page you would select the row(s) that contain the labels in the rows to repeat at left box.

false

Which one of the following filter options is not found on the date filter submenu?

first quarter

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?

top right

After a table has been named, that name can be used in functions instead of cell references.

true

Even after selecting a data source for a chart you can still apply various filters on one or more series.

true

Excel normally uses all the selected data in creating a chart.

true

In a data table calculated columns will copy down the table automatically.

true

It is a good practice to print column and row labels on each page.

true

It is good practice to delete any blank rows or columns before creating a chart.

true

Sparklines do not include the normal chart labels.

true

When you use the Freeze Panes option you freezing both columns and rows.

true

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015

What is not true about using the AND function in a custom conditional formatting rule?

All the tests must be of the same data type, for example: all numbers or all text.

What is not true about creating a data table?

Make sure to leave one blank row below the data labels.

In the task pane, what does a diagonal white triangle next to a chart category indicate?

None of the category's options are displayed

What font color does Excel use by default for many of its elements?

Black, Text 1, Lighter 35%

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

Sparkline

What data does Excel print by default?

The entire dataset on the active sheet

What should you not select when selecting data for a chart?

Worksheet titles

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

false

Excel uses dashed blue lines to indicate manual page breaks.

false

Excel uses solid blue lines to indicate automatic page breaks.

false

In Page Break Preview, the area to be printed has a light blue background.

false

It is impossible to create a data table from random, unorganized data.

false

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

false

To understand a chart you need to include the chart data.

false

When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

false

Which table style option shows the field names when it is checked?

header row

Which tab displays the tools for creating charts?

insert

Which table style option is useful to display aggregated data when it is checked?

last column

Where does the primary axis display on a Combo chart?

left side

Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

true

You can select multiple print areas.

true

You cannot enter data or formulas on a chart sheet.

true

Which conditional formatting option is not found in the Quick Analysis Gallery?

undo format

Which axis in a chart displays incremental numbers for the data points?

value

In a bar chart, which axis displays the categories?

vertical

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)

2 or 3

As a general rule, Pie charts should be limited to how many slices?

7

Which chart type displays the data vertically

Column

In the task pane, what does a diagonal black triangle next to a chart category indicate?

All the category's options are displayed.

Which of the following is not a way to bring up the Go To dialog box?

Alt+F7

Which chart type displays the data horizontally?

Bar

What can you not do from the Select Data Source dialog box?

Change chart type

What is not found on the Chart Elements List?

Chart Type

Which of the following is not a chart element?

Chart foreground

In conditional formatting what happens if the cell value does not pass the logical test?

The cell is not formatted.

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

false

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

false


Ensembles d'études connexes

CCNA Intro to networks modules 14-15

View Set

AWS Cloud Practitioner Module 4 - Networking

View Set

Compound Subjects, Predicates, and Sentences.

View Set

Customer Accounts--Documentation

View Set

Which of the following formula is represents a molecular compound

View Set