Question 1

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Accepted Answer

A) True 
 B)False

Question 2

Data ________ is the method used to organize data points in a dataset.

Accepted Answer

The answer of Data ________ is the method used to...

Question 3

What is true about adding a new field to the right side of an existing data table?

Accepted Answer

A) You must convert the table back to a range, add the field, then recreate the table. 
B) You can add it to the right of the data table and Excel will extend the table to include the new field. 
C) You cannot add a new field to an existing data table. 
D) You must insert the new field somewhere inside the existing table, then move the columns to the order you desire. 
A) You must convert the table back to a range, add the field, then recreate the table. 
B) You can add it to the right of the data table and Excel will extend the table to include the new field. 
C) You cannot add a new field to an existing data table. 
D) You must insert the new field somewhere inside the existing table, then move the columns to the order you desire.

Question 4

In Normal view or Page Layout view the data to be printed has a dark blue border.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ is a range of organized, related data.

Accepted Answer

The answer of A(n)________ is a range of organized, related...

Question 6

If you use the Icon sets conditional formatting, you are limited to how many categories?

Accepted Answer

A) One, two, or three 
B) Two, three, or four 
C) Three, four, or five 
D) Four, five, or six 
A) One, two, or three 
B) Two, three, or four 
C) Three, four, or five 
D) Four, five, or six

Question 7

By how many levels will Excel allow you to sort?

Accepted Answer

A) 16 
B) 32 
C) 64 
D) 128 
A) 16 
B) 32 
C) 64 
D) 128

Question 8

Excel will allow you to sort on ________ levels.

Accepted Answer

64, sixty-

Question 9

Which one of the following filter options is not found on the text filter submenu?

Accepted Answer

A) Begins With 
B) Includes 
C) Contains 
D) Custom Filter 
A) Begins With 
B) Includes 
C) Contains 
D) Custom Filter

Question 10

Filter arrows are always displayed in data tables.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The Answer of 58; 29; 27 and 11/20/2015; 8/20/2015; 5/25/91 is...

Question 12

Which of the following is not a way to bring up the Go To dialog box?

Accepted Answer

A) Alt+F7 
B) F5 
C) Ctrl+G 
D) Name Box 
A) Alt+F7 
B) F5 
C) Ctrl+G 
D) Name Box

Question 13

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

Accepted Answer

A) True 
 B)False

Question 14

The ________ wildcard symbol is often used in filters and can represent any number of characters.

Accepted Answer

The answer of The ________ wildcard symbol is often used...

Question 15

When would you not need to use a fully qualified structured reference?

Accepted Answer

A) When referring to a cell outside the table 
B) When referring to a cell on a different worksheet 
C) When referring to a cell on a different workbook 
D) When referring to a cell within the table 
A) When referring to a cell outside the table 
B) When referring to a cell on a different worksheet 
C) When referring to a cell on a different workbook 
D) When referring to a cell within the table

Question 16

Match between columns
                        Premises: Unique Values
Text Contains
Duplicate Values
Clear Format
Equal To

Accepted Answer

The Answer of Formats cells that have exactly the same is...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Using the data bars conditional formatting, how is the highest value represented?

Accepted Answer

A) By the darkest bar 
B) By the tallest bar 
C) By the longest bar 
D) By the most number of bars 
A) By the darkest bar 
B) By the tallest bar 
C) By the longest bar 
D) By the most number of bars

Question 19

Locking is the process of making sure that certain rows or columns are visible at all times.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not a freeze option?

Accepted Answer

A) Freeze Panes 
B) Freeze Top Row 
C) Freeze First Column 
D) Freeze Section 
A) Freeze Panes 
B) Freeze Top Row 
C) Freeze First Column 
D) Freeze Section

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Data ________ is the method used to organize data points in a dataset.

What is true about adding a new field to the right side of an existing data table?

In Normal view or Page Layout view the data to be printed has a dark blue border.

A(n)________ is a range of organized, related data.

If you use the Icon sets conditional formatting, you are limited to how many categories?

By how many levels will Excel allow you to sort?

Excel will allow you to sort on ________ levels.

Which one of the following filter options is not found on the text filter submenu?

Filter arrows are always displayed in data tables.

Which of the following is not a way to bring up the Go To dialog box?

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

The ________ wildcard symbol is often used in filters and can represent any number of characters.

When would you not need to use a fully qualified structured reference?

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

Using the data bars conditional formatting, how is the highest value represented?

Locking is the process of making sure that certain rows or columns are visible at all times.

Which of the following is not a freeze option?

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

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

Data ________ is the method used to organize data points in a dataset.

What is true about adding a new field to the right side of an existing data table?

In Normal view or Page Layout view the data to be printed has a dark blue border.

A(n)________ is a range of organized, related data.

If you use the Icon sets conditional formatting, you are limited to how many categories?

By how many levels will Excel allow you to sort?

Excel will allow you to sort on ________ levels.

Which one of the following filter options is not found on the text filter submenu?

Filter arrows are always displayed in data tables.

Which of the following is not a way to bring up the Go To dialog box?

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

The ________ wildcard symbol is often used in filters and can represent any number of characters.

When would you not need to use a fully qualified structured reference?

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

Using the data bars conditional formatting, how is the highest value represented?

Locking is the process of making sure that certain rows or columns are visible at all times.

Which of the following is not a freeze option?

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