Services
Discover
Homeschooling
Ask a Question
Log in
Sign up
Filters
Done
Question type:
Essay
Multiple Choice
Short Answer
True False
Matching
Topic
Computing
Study Set
Exploring Microsoft Office Study Set 1
Quiz 21: Excel: Datasets and Tables: Managing Large Volumes of Data
Path 4
Access For Free
Share
All types
Filters
Study Flashcards
Practice Exam
Learn
Question 81
Essay
If you have a table that extends to row 21 and you start typing in row 22,what happens?
Question 82
Essay
What are the four types of sorts in Excel 2013?
Question 83
Essay
What are the areas of the New Formatting Rule dialog box that need to be selected to create a new rule?
Question 84
Essay
How can you identify the difference between automatic page breaks on a worksheet and manual page breaks?
Question 85
Essay
What are two built-in functionality features in tables in Excel 2013 that assist in creating formulas?
Question 86
Essay
When you freeze panes and press Ctrl+Home when columns A and B and row 1 are frozen,what happens?
Question 87
Essay
What are icon sets?
Question 88
Essay
What options are available in the Top 10 AutoFilter dialog box?
Question 89
Essay
Why might you want to freeze rows or columns in a large dataset?
Question 90
Essay
What do banded rows and banded columns do in an Excel table?
Question 91
Matching
Match of the following:
Premises:
Responses:
Freeze Top Row
appears as a blue dashed line.
Freezing keeps rows and/or columns
structured,related data in columns and rows.
An automatic page break
keeps the top row visible as you scroll.
Premises:
Freeze Top Row
Freezing keeps rows and/or columns
An automatic page break
Responses:
appears as a blue dashed line.
structured,related data in columns and rows.
keeps the top row visible as you scroll.
Question 92
Matching
Match of the following:
Premises:
Responses:
A field
is an individual piece of data.
A record
is a set of formatted rows and columns of data.
Print order
is a complete set of data for an entity.
Premises:
A field
A record
Print order
Responses:
is an individual piece of data.
is a set of formatted rows and columns of data.
is a complete set of data for an entity.
Question 93
Matching
Match the tab name to the feature available on that tab:
Premises:
Responses:
View tab
Print
Insert tab
Breaks
File tab
Table
Premises:
View tab
Insert tab
File tab
Responses:
Print
Breaks
Table
Question 94
Matching
Match of the following:
Premises:
Responses:
Converting a table back into a range
increases the number of rows.
Adding a record to a table
enables unique table tools.
Creating a table from existing data in a range
represents a record.
Premises:
Converting a table back into a range
Adding a record to a table
Creating a table from existing data in a range
Responses:
increases the number of rows.
enables unique table tools.
represents a record.
Question 95
Matching
Match the sort options to their explanations:
Premises:
Responses:
Table style controls
fill color of the header row,columns,and records in a table
Table Style Options group
arranges numbers in sequential order
Sorting Dates oldest to newest
arranges data in alphabetical order
Premises:
Table style controls
Table Style Options group
Sorting Dates oldest to newest
Responses:
fill color of the header row,columns,and records in a table
arranges numbers in sequential order
arranges data in alphabetical order
Question 96
Matching
Match the filter options to their explanations:
Premises:
Responses:
Filtering
conditional formatting that displays doubled cells
Duplicate Values
specify a number or percentage of records to display
Top 10 option
arranges records in a table by the value
Premises:
Filtering
Duplicate Values
Top 10 option
Responses:
conditional formatting that displays doubled cells
specify a number or percentage of records to display
arranges records in a table by the value
Question 97
Matching
Match the following terms to their descriptions:
Premises:
Responses:
Total row
Last row of a table to display summary statistics
Conditional formatting
Statistical functions
Sum,average,min,max
Highlights or emphasizes cells that meet certain conditions
Premises:
Total row
Conditional formatting
Sum,average,min,max
Responses:
Last row of a table to display summary statistics
Statistical functions
Highlights or emphasizes cells that meet certain conditions
Question 98
Matching
Match the conditional formatting options to their descriptions:
Premises:
Responses:
Color scale
horizontal gradient or solid fill indicating a cell's relative value
Highlight Cells Rules
highlights cells meeting criteria with a color,font,or border
Icon set
conditional format that displays a particular color based on the relative value of a cell
Premises:
Color scale
Highlight Cells Rules
Icon set
Responses:
horizontal gradient or solid fill indicating a cell's relative value
highlights cells meeting criteria with a color,font,or border
conditional format that displays a particular color based on the relative value of a cell
Question 99
Matching
Match the following terms to their descriptions:
Premises:
Responses:
Unqualified reference
type of conditional formatting
Top/Bottom Rules
applies special formats or highlights or emphasis to cells
Conditional formatting
structured formula that includes references
Premises:
Unqualified reference
Top/Bottom Rules
Conditional formatting
Responses:
type of conditional formatting
applies special formats or highlights or emphasis to cells
structured formula that includes references