Ch. 4 - Formatting, Organizing and Getting Data

Question 1

Double-Click a field in the PivotTable and select Field Settings or Value Field Settings to open the dialog box.

True or False

Answer 1

False

Question 2

A PivotTable is a cross tabulation report based on list-type data.

True or False

Answer 2

True

Question 3

Which of the following guidelines does not optimize a table for use of Excel commands?
-Give each header a unique label
-Keep the same type of data within the data.
-Do not leave blank cells within the data
-Type descriptive labels in the first row and begin in each label with a number

Answer 3

Type descriptive labels in the first row and begin in each label with a number

Question 4

If data are formatted as an Excel table, convert it to a normal cell range to use the Subtotal command.

True or False

Answer 4

True

Question 5

What type of file can most software applications read?
-Word Documents
-Excel Worksheets
-Access Queries
-Text Files

Answer 5

Text Files

Question 6

Which of the following is a type of conditional formatting that displays cells with a fill color, a horizontal bar, or an icon?
-Advanced Filter
-Top/Bottom Rules
-Highlight Cells
-Data Visualization

Answer 6

Data Visualization

Question 7

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

True or False

Answer 7

True

Question 8

Which of the following is not a true statement when importing Access database files?
-You can import a table or a query from an access database into an Excel worksheet
-Access database files have a txt. extension
-When a database includes many tables and queries, the Navigation dialog box opens so that you can choose the table or the query to import.
-Field names from the Access table or query are column headings in the Excel table.

Answer 8

Access database files have a txt. extension

Question 9

External data are data that originated in another program or format.

True or False

Answer 9

True

Question 10

Which of the following statements is not true about Highlight Cells Rules?
-Highlight Cells Rules are relational operators to determine if the value or label should be formatted
-Highlight Cells Rules are comparison operators to determine if the value or label should be formatted
-You can create your own rule using common operators or a formula
-Formatting is applied to the cells that do not meet the criteria

Answer 10

Formatting is applied to the cells that do not meet the criteria

Question 11

Which of the following is a character used to separate data in a text file?
-Delimiter
-Record
-Field
-Criteria

Answer 11

Delimiter

Question 12

Which of the following source data cannot be imported into Excel?
-Text File
-Database
-Cloud Location
-Word Document

Answer 12

Database

Question 13

Which of the following is true about table styles?
- A table style is a predesigned set of format settings with a color scheme, alternating fill for rows and columns, vertical and horizontal borders, and more
-You must save your excel file before you apply a table style
-You cannot apply a table style until you have used the Quick Analysis tool

Answer 13

A table style is a predesigned set of format settings with a color scheme, alternating fill for rows and columns, vertical and horizontal borders, and more

Question 14

Which of the following statements is not true for importing?
-You can copy and paste data from Word into an Excel worksheet
-You can import a word document into excel
-It is possible to import text files directly into excel
-It is possible to save a Word document as a text file

Answer 14

You can import a word document into excel

Question 15

Which of the following refers to the process of getting data from an outside source into an Excel worksheet?
-Exporting data
-Importing data
-flash fill
-data connecting

Answer 15

Importing data

Question 16

Use the Sort options dialog box to change the sort orientation to sort data left to right.

True or False

Answer 16

True

Question 17

Which of the following statements for PivotTable layout is not true?
-You can hide or display subtotals
-Grand totals display at the left for columns and at the bottom for rows
-You can display a blank row before or after each item
-A compact format places row data in one column and occupies the least amount of horizontal space.

Answer 17

Grand totals display at the left for columns and at the bottom for rows

Question 18

Which of the following is a list of related pieces of information that is formatted with a title row followed by rows of data?
-table
-header row
-record
-PivotTable

Answer 18

table

Question 19

In an advanced filter, how does Excel treat criteria entered in different rows?
-And condition
-Or condition
-Filter condition
-Both condition

Answer 19

Or condition

Question 20

Which of the following is not true for displaying a total row in a table?
-Open the Table Tools Design tab by clicking any cell within the table
-The total row displays as the last row in the table
-The default calculation for numeric data is Average
-Use Count for an alphanumeric columns

Answer 20

The default calculation for numeric data is Average

Question 21

Which of the following is not true for a criteria range?
-The first row must use the same column names as the data
-You can use a formula in the criteria
-You can only use one row for criteria
-You can create a criteria range in empty rows anywhere on the worksheet or on another sheet

Answer 21

??

Question 22

When you first create an Excel Table, how is it named?
-TableA, where A is a letter
-TableC, where C is a character
-TableN, where N is a number
-TableS, where S is a symbol

Answer 22

TableN, where N is a number

Question 23

Which of the following is the column name with its table name?
-Column Reference
-Mixed Reference
-Ordered Reference
-Structured Reference

Answer 23

Structured Reference