Question 1

Match between columns
                        Premises: Header Row
Banded Rows
First Column
Last Column
Total Row

Accepted Answer

The Answer of Displays the field names when checked and is...

Question 2

In a structured reference,when you use field headings without row references it is called a(n)________ reference.

Accepted Answer

unqualified

Question 3

"John Smith" is a good example of a field.

Accepted Answer

A) True 
 B)False  False

Question 4

What is not true about using the AND function in a custom conditional formatting rule?

Accepted Answer

A) All the tests must be of the same data type,for example: all numbers or all text. 
B) All the logical tests must be true for the formatting to be applied. 
C) You must have at least two tests in the formula. 
D) You may have as many tests as you need in the formula. 
A) All the tests must be of the same data type,for example: all numbers or all text. 
B) All the logical tests must be true for the formatting to be applied. 
C) You must have at least two tests in the formula. 
D) You may have as many tests as you need in the formula.

Question 5

After a table has been named,that name can be used in functions instead of cell references.

Accepted Answer

A) True 
 B)False

Question 6

You cannot sort cells by their fill color.

Accepted Answer

A) True 
 B)False

Question 7

In a structured reference what do you use to indicate a column heading or field name?

Accepted Answer

A) Brackets [] 
B) Parenthesis () 
C) Curly brackets {} 
D) Quotes "" 
A) Brackets [] 
B) Parenthesis () 
C) Curly brackets {} 
D) Quotes ""

Question 8

Match between columns
                        Premises: Sort Newest to Oldest
Sort Oldest to Newest
Sort A to Z
Sort Largest to Smallest
Sort Z to A

Accepted Answer

The Answer of 11/20/2015;8/20/2015;5/25/91 and 58;29;27 and Karen;Doug;Barb and Number;Othniel;Psychology is...

Question 9

What is not true about creating a data table?

Accepted Answer

A) Each record should be unique somehow. 
B) For efficiency,make sure your data table does not exceed 256 rows. 
C) It is best to put individual data tables on separate sheets. 
D) Delete any blank columns in your table. 
A) Each record should be unique somehow. 
B) For efficiency,make sure your data table does not exceed 256 rows. 
C) It is best to put individual data tables on separate sheets. 
D) Delete any blank columns in your table.

Question 10

The print ________ is the range of cells that will be printed.

Accepted Answer

The answer of The print ________ is the range of...

Question 11

Match between columns
                        Premises: Data bars
Icon Sets
Highlight Cells Rules
Color Scales
Top/Bottom Rules

Accepted Answer

The Answer of Formats cells with gradients of color depending is...

Question 12

Which of the following is not a characteristic of a table?

Accepted Answer

A) Can contain multiple ranges 
B) Helps to manage information 
C) Helps to analyze information 
D) Contains related data 
A) Can contain multiple ranges 
B) Helps to manage information 
C) Helps to analyze information 
D) Contains related data

Question 13

On which tab will you find options if you have to print a large dataset?

Accepted Answer

A) Page Layout 
B) Print 
C) Review 
D) Home 
A) Page Layout 
B) Print 
C) Review 
D) Home

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

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

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 18

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Accepted Answer

The answer of ________ page breaks can be inserted if...

Question 19

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

Accepted Answer

The Answer of Displays on the right side of each is...

Question 20

Filter arrows are always displayed in data tables.

Accepted Answer

A) True 
 B)False

In a structured reference,when you use field headings without row references it is called a(n)________ reference.

"John Smith" is a good example of a field.

What is not true about using the AND function in a custom conditional formatting rule?

After a table has been named,that name can be used in functions instead of cell references.

You cannot sort cells by their fill color.

In a structured reference what do you use to indicate a column heading or field name?

What is not true about creating a data table?

The print ________ is the range of cells that will be printed.

Which of the following is not a characteristic of a table?

On which tab will you find options if you have to print a large dataset?

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?

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

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

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

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Filter arrows are always displayed in data tables.

Introduction to Excel

Formulas and Functions

Charts

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters

Exam 4: Datasets and Tables

In a structured reference,when you use field headings without row references it is called a(n)________ reference.

"John Smith" is a good example of a field.

What is not true about using the AND function in a custom conditional formatting rule?

After a table has been named,that name can be used in functions instead of cell references.

You cannot sort cells by their fill color.

In a structured reference what do you use to indicate a column heading or field name?

What is not true about creating a data table?

The print ________ is the range of cells that will be printed.

Which of the following is not a characteristic of a table?

On which tab will you find options if you have to print a large dataset?

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?

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

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

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

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Filter arrows are always displayed in data tables.

Introduction to Excel

Formulas and Functions

Charts

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters