In an Excel table, which of the following contains descriptive titles or labels?
header row
record
field
cell
What type of file can most software applications read?
Word documents
Excel worksheets
Access queries
Text files
Which of the following is not true for a calculated field in a PivotTable?
The name for a calculated field must be unique.
A calculated field is a field in the PivotTable that is not a field in the source data.
A calculated field uses a value field from the PivotTable's underlying data in a formula.
After you insert a calculated field, it cannot be moved.
How many rows must the criteria range of an Advanced Filter have?
at least 1
at least 2
3 or more
no more than 5
Which of the following statements is not true for importing?
You can import a Word document 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.
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
PivotTable
Which of the following is used for recognizing a pattern in the first cell and suggesting data for the remaining rows in a column?
AutoFilter
Advanced Filter
Flash Fill
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
Which of the following applies formats to cells only when the cells meet the criteria?
Format Painter
Cell Styles
Themes
Conditional Formatting
Which of the following is not a sort option?
cell icon
font color
fill color
cell style
