Question 1

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

Accepted Answer

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

Question 2

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

Question 3

Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1,Page 2)on your display.

Accepted Answer

The answer of Excel indicates where page breaks will occur...

Question 4

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

Accepted Answer

A) True 
 B)False

Question 5

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

Accepted Answer

The answer of To go to the first unfrozen cell...

Question 6

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

Accepted Answer

The Answer of Includes complimentary fill colors and Complete set is...

Question 7

How does Excel indicate that a column has been selected in a structured reference?

Accepted Answer

A) A light shading appears in that column. 
B) There is nothing to indicate a column has been selected. 
C) A colored border appears around that column. 
D) A type of colored sticky note is attached to that column. 
A) A light shading appears in that column. 
B) There is nothing to indicate a column has been selected. 
C) A colored border appears around that column. 
D) A type of colored sticky note is attached to that column.

Question 8

Excel uses dashed blue lines to indicate manual page breaks.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

Excel uses solid blue lines to indicate automatic page breaks.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The Answer of Rules used to emphasize cells and Sequence is...

Question 12

What is not true about tables in Excel?

Accepted Answer

A) Column headings stay on the screen automatically. 
B) Filter arrows make it quick and easy to filter the data in the table. 
C) Row headings stay on the screen automatically. 
D) You can export the data to a SharePoint list. 
A) Column headings stay on the screen automatically. 
B) Filter arrows make it quick and easy to filter the data in the table. 
C) Row headings stay on the screen automatically. 
D) You can export the data to a SharePoint list.

Question 13

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

Accepted Answer

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

Question 14

You can select multiple print areas.

Accepted Answer

A) True 
 B)False

Question 15

By default,what is the first table on a worksheet named?

Accepted Answer

A) Table 1 
B) Table A 
C) Table 
D) Data tables do not have names. 
A) Table 1 
B) Table A 
C) Table 
D) Data tables do not have names.

Question 16

Which table style option shows the field names when it is checked?

Accepted Answer

A) Header Row 
B) Total Row 
C) First Column 
D) Banded Columns 
A) Header Row 
B) Total Row 
C) First Column 
D) Banded Columns

Question 17

In Page Break Preview,the area to be printed has a light blue background.

Accepted Answer

A) True 
 B)False

Question 18

Selecting a range automatically makes it a data table.

Accepted Answer

A) True 
 B)False

Question 19

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

Which of the following is not a freeze option?

Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1,Page 2)on your display.

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

How does Excel indicate that a column has been selected in a structured reference?

Excel uses dashed blue lines to indicate manual page breaks.

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

Excel uses solid blue lines to indicate automatic page breaks.

What is not true about tables in Excel?

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

You can select multiple print areas.

By default,what is the first table on a worksheet named?

Which table style option shows the field names when it is checked?

In Page Break Preview,the area to be printed has a light blue background.

Selecting a range automatically makes it a data table.

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

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

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

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

Which of the following is not a freeze option?

Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1,Page 2)on your display.

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

How does Excel indicate that a column has been selected in a structured reference?

Excel uses dashed blue lines to indicate manual page breaks.

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

Excel uses solid blue lines to indicate automatic page breaks.

What is not true about tables in Excel?

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

You can select multiple print areas.

By default,what is the first table on a worksheet named?

Which table style option shows the field names when it is checked?

In Page Break Preview,the area to be printed has a light blue background.

Selecting a range automatically makes it a data table.

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

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

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