Ch. 4 - Formatting, Organizing and Getting Data Flashcards
Double-Click a field in the PivotTable and select Field Settings or Value Field Settings to open the dialog box.
True or False
False
A PivotTable is a cross tabulation report based on list-type data.
True or False
True
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
Type descriptive labels in the first row and begin in each label with a number
If data are formatted as an Excel table, convert it to a normal cell range to use the Subtotal command.
True or False
True
What type of file can most software applications read?
-Word Documents
-Excel Worksheets
-Access Queries
-Text Files
Text Files
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
Data Visualization
The Subtotal command includes SUM, AVERAGE, MAX, or MIN as well as other Statistical functions.
True or False
True
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.
Access database files have a txt. extension
External data are data that originated in another program or format.
True or False
True
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
Formatting is applied to the cells that do not meet the criteria
Which of the following is a character used to separate data in a text file?
-Delimiter
-Record
-Field
-Criteria
Delimiter
Which of the following source data cannot be imported into Excel?
-Text File
-Database
-Cloud Location
-Word Document
Database
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
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
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
You can import a word document into excel
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
Importing data
Use the Sort options dialog box to change the sort orientation to sort data left to right.
True or False
True
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.
Grand totals display at the left for columns and at the bottom for rows
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
table
In an advanced filter, how does Excel treat criteria entered in different rows?
-And condition
-Or condition
-Filter condition
-Both condition
Or condition
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
The default calculation for numeric data is Average
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
??
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
TableN, where N is a number
Which of the following is the column name with its table name?
-Column Reference
-Mixed Reference
-Ordered Reference
-Structured Reference
Structured Reference
