Excel - Chapter 4

OR condition

How does Excel treat criteria entered on different rows?

AND condition

How does Excel treat criteria entered on the same row?

Values

How does Excel treat dates?

as an outline

How does the Subtotal command format the list data?

Structured reference

In an Excel table, what is the name assigned to a column with its table called?

field

In an Excel table, which of the following represents a column of data?

Sorting

The process of arranging data in a specific order based on the value in a field.

All of the Above: tab comma space

Using the Text Import Wizard to set the type of delimiter used in a text file, which of the following delimiters is commonly used?

List-type

Web site data can be imported into excel if the data is

column headings

What do AutoFilter arrows replace when you scroll down in a table with many records?

duplicate row

What do you call a row in a table that has exactly the same information in one or more columns?

banded rows

What is another name for rows that alternate shading on the rows?

a criteria range

What must you build to use an Advanced Filter?

@

What symbol precedes all structured references in Formula AutoComplete lists?

text files

What type of file can most software applications read?

delimited text file

What would a text file be called that uses a character, such as a comma or a tab, to separate the fields?

True

When pasting data from a Word document into Excel, you can keep the Word formatting intact or choose the current worksheet format. True or False?

False

When using an Advanced Filter, the criteria range must be at least three rows. T/F?

at least two rows.

When using an Advanced Filter, the criteria range must be?

TableN, where N is a number

When you first create an Excel table, what name does Excel give it initially?

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 or False?

PivotCharts

Which of the following can be built from a PivotTable?

All of the above: cell icon font color cell fill color

Which of the following can you sort Excel data by?

The Auto Outline command

Which of the following creates groups based on formulas that are located in a consistent pattern in data list?

ALL OF THE ABOVE 1. Give each header a unique label. 2. Keep the same type of data within each column, such as text or values. 3. Do not leave blank cells within the data.

Which of the following guidelines will make your tables easier to use and navigate?

PivotTable

Which of the following is a cross tabulation report based on list-type data?

text file

Which of the following is a document that includes basic data, no formatting, and commas or other characters to separate the data into fields?

table style

Which of the following is a predesigned set of built-in format options?

ALL OF THE ABOVE: #All #Data #Headers

Which of the following is a specific item name in a structured reference that Excel automatically places in a table?

Data Visualization

Which of the following is a type of conditional formatting that displays cells with a fill color, a horizontal bar, or an icon?

fixed width text files

Which of the following is commonly used in legacy or mainframe computers?

filter

Which of the following is criteria that determines which data is shown and which is hidden?

External data

Which of the following is data that originates in another program or format?

PivotTables are not interactive because you cannot rearrange parts of the report for analysis by clicking or dragging.

Which of the following is not true of PivotTables?

The first row must use column names from the worksheet data but need not use all of them.

Which of the following is not true of a criteria range?

Flash Fill

Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?

sort the rows by the field to be totaled

Which of the following must you do for the Subtotal command to work?

Access database files have a .txt extension. ***Access database files have an .accdb extension.

Which of the following statements about Access databases is incorrect?

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

Which of the following statements becomes true after your data is formatted as a table?

The Subtotal command is not available when the range is formatted as an Excel table.

Which of the following statements is not true about Subtotal commands?

A connection is an identifier for data that originated inside the workbook.

Which of the following statements is not true?

You can import text from a Word document directly into Excel.

Which of the following statements is not true?

ALL OF THE ABOVE: 1. Highlight Cells Rules formatting uses relational operators. 2. Highlight Cells Rules formatting uses comparison operators. 3. You can create your own rule using other operators or a formula.

Which of the following statements is true about Highlight Cells Rules?

The length of the data bars compares the value in each cell to the other values in the selected cell range.

Which of the following statements is true about data bars?

.csv

Which of the following types of file might you see when downloading a blank statement?

Top/Bottom rules

Which of the following use ranking or averages to format cells?

descending

Which of the following words best describes a Z to A sort?

All of the Above: Data that you import from the web usually needs to be formatted in Excel to match your other worksheet data. Depending on how data is formatted on the web page, you may not need to insert column headings after importing. Data that you import from a web page establishes a connection to the site that you can refresh whenever necessary.

Which statement is true?

True

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

Pivot Tables (info)

A PivotTable is a separate worksheet in which you can sort, filter, and calculate large amounts of data. The list of data in a PivotTable is dynamic. PivotTables provide great flexibility when it comes to analyzing your data.

A connection (info)

A connection is an identifier for data that originated outside the workbook. If you import data from a text file or a database, you can refresh the data by importing it again. If you import data as a web query, you can replace the data in your worksheet with current data on the web site. A data connection to an Internet location is named Connection.

True

A duplicate row is a row in a table that has exactly the same information in one or more columns. True or False?

False

A text file is a document that includes formatted text. True or False?

True

Another type of conditional formatting is data visualization. T/F?

Criteria Range (info)

Criteria must be typed into the second row. The first row must use column names. You can create a criteria range in empty rows anywhere on the worksheet or on another sheet.

False

Data visualization is used to create PivotTables. True or False?

False ** For the Subtotal command to work properly, you must sort the rows by the main field (column) to be totaled.

For the Subtotal command to work properly, you must sort the rows into order by the first column. True or False?

True

The Subtotal command is not available when the range is formatted as an Excel table. T/F?

FALSE

The automatic name for a table and several of its parts is a PivotTable. T/F?

structured reference

The automatic name for a table and several of its parts is called?

Subtotal command (Info)

Subtotal command is available is automatically inserts summary rows for data that are arranged in related groups. If you apply a filter to data with subtotals, you can hide the subtotal rows

Access

The Microsoft office relational database application that works with excel to import and export data is called?

True

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

Access database (info)

You can import a table or a query directly from an Access database into an Excel worksheet. When a database includes many tables and queries, the Select Table box opens so that you can choose the table or query you want to import. If a database has a single table or query, it is automatically imported into Excel.

Word, text files & Excel (info)

You cannot import text from a Word document directly into Excel. You can copy and paste data from Word into an Excel worksheet. It is possible to import text files directly into Excel. It is possible to save a Word document as a text file.

External Data

imported content in a worksheet that originated in another format or program

Sort dialog box

used in a multiple column sort

You can import or copy external data into Excel from the source. The source can be a text file, a database, or a web location.

what can you import into Excel?