Question 1

You can freeze as many columns and rows at the same time as you desire.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: Filter Button
First Column
Last Column
Header Row
Total Row

Accepted Answer

The Answer of Used to make aggregated data stand out is...

Question 3

Match between columns
                        Premises: Unqualified reference
Total row
SUBTOTAL function
Structured reference
Fully qualified structured reference

Accepted Answer

The Answer of Contains the table name and Uses a is...

Question 4

What is not true about creating a data table?

Accepted Answer

A) Make sure no column labels are the same. 
B) Make sure to leave one blank row below the data labels. 
C) Format the field names so that they stand out visually. 
D) Keep field names short. 
A) Make sure no column labels are the same. 
B) Make sure to leave one blank row below the data labels. 
C) Format the field names so that they stand out visually. 
D) Keep field names short.

Question 5

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

Accepted Answer

A) December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959 
B) January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959 
C) January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015 
D) December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959 
A) December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959 
B) January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959 
C) January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015 
D) December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959

Question 6

What is the default data table style?

Accepted Answer

A) Normal 
B) Medium 1 
C) Medium 2 
D) None 
A) Normal 
B) Medium 1 
C) Medium 2 
D) None

Question 7

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

Accepted Answer

A) Conditional formatting 
B) AutoFill formatting 
C) AutoComplete formatting 
D) Aggregate Cell formatting 
A) Conditional formatting 
B) AutoFill formatting 
C) AutoComplete formatting 
D) Aggregate Cell formatting

Question 8

Selecting a range automatically makes it a data table.

Accepted Answer

A) True 
 B)False

Question 9

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Accepted Answer

A) A1 becomes the active cell. 
B) Column A and whatever row was active when you pressed the combination becomes the active cell. 
C) Row 1 and whatever column was active when you pressed the combination becomes the active cell. 
D) The first unfrozen cell becomes the active cell. 
A) A1 becomes the active cell. 
B) Column A and whatever row was active when you pressed the combination becomes the active cell. 
C) Row 1 and whatever column was active when you pressed the combination becomes the active cell. 
D) The first unfrozen cell becomes the active cell.

Question 10

Excel uses solid blue lines to indicate automatic page breaks.

Accepted Answer

A) True 
 B)False

Question 11

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

Accepted Answer

A) The PAID record 
B) The range to be included in the calculation 
C) The Excel function called PAID 
D) The label for the resultant Total Row 
A) The PAID record 
B) The range to be included in the calculation 
C) The Excel function called PAID 
D) The label for the resultant Total Row

Question 12

In a data table each column is considered a(n)________.

Accepted Answer

The answer of In a data table each column is...

Question 13

Which conditional formatting option is not found in the Quick Analysis Gallery?

Accepted Answer

A) Text Contains 
B) Duplicate Values 
C) Unique Values 
D) Undo Format 
A) Text Contains 
B) Duplicate Values 
C) Unique Values 
D) Undo Format

Question 14

The filter "Begins With..." option is found on which type of filter?

Accepted Answer

A) Number filter 
B) Date filter 
C) Custom filter 
D) Text filter 
A) Number filter 
B) Date filter 
C) Custom filter 
D) Text filter

Question 15

Match between columns
                        Premises: Print area
Freezing
Conditional formatting
Print order
Page break

Accepted Answer

The Answer of The range of cells that will be is...

Question 16

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

Accepted Answer

A) The COUNT function 
B) The SUM function 
C) The number of rows to subtotal 
D) The row number in which to place the subtotal 
A) The COUNT function 
B) The SUM function 
C) The number of rows to subtotal 
D) The row number in which to place the subtotal

Question 17

It is impossible to create a data table from random, unorganized data.

Accepted Answer

A) True 
 B)False

Question 18

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)

Accepted Answer

A) Unlimited 
B) 256 
C) 1,012 
D) 2 or 3 
A) Unlimited 
B) 256 
C) 1,012 
D) 2 or 3

Question 19

Match between columns
                        Premises: Table style
Table
Record
Field
Total row

Accepted Answer

The Answer of Includes complimentary fill colors and Structured range is...

Question 20

A collection of fields about one person would be considered a(n)________.

Accepted Answer

The answer of A collection of fields about one person...

You can freeze as many columns and rows at the same time as you desire.

What is not true about creating a data table?

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

What is the default data table style?

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

Selecting a range automatically makes it a data table.

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Excel uses solid blue lines to indicate automatic page breaks.

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

In a data table each column is considered a(n)________.

Which conditional formatting option is not found in the Quick Analysis Gallery?

The filter "Begins With..." option is found on which type of filter?

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

It is impossible to create a data table from random, unorganized data.

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)

A collection of fields about one person would be considered a(n)________.

Introduction to Excel

Formulas and Functions

Charts

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 4: Datasets and Tables

You can freeze as many columns and rows at the same time as you desire.

What is not true about creating a data table?

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

What is the default data table style?

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

Selecting a range automatically makes it a data table.

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Excel uses solid blue lines to indicate automatic page breaks.

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

In a data table each column is considered a(n)________.

Which conditional formatting option is not found in the Quick Analysis Gallery?

The filter "Begins With..." option is found on which type of filter?

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

It is impossible to create a data table from random, unorganized data.

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)

A collection of fields about one person would be considered a(n)________.

Introduction to Excel

Formulas and Functions

Charts

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters