Question 1

A filter in Excel displays only a portion of the table data based on matching criteria.

Accepted Answer

A) True 
 B)False

Question 2

You can group worksheets and format them simultaneously.

Accepted Answer

A) True 
 B)False

Question 3

What is the keyboard shortcut for flash fill?

Accepted Answer

A) Alt + E 
B) Ctrl + E 
C) Ctrl + F 
D) Ctrl + F2 
A) Alt + E 
B) Ctrl + E 
C) Ctrl + F 
D) Ctrl + F2

Question 4

What are the default names of worksheets?

Accepted Answer

A) Sheet1,Sheet2,etc. 
B) Worksheet1,Worksheet2,etc. 
C) Excel 1,Excel 2,etc. 
D) 1,2,3,etc. 
A) Sheet1,Sheet2,etc. 
B) Worksheet1,Worksheet2,etc. 
C) Excel 1,Excel 2,etc. 
D) 1,2,3,etc.

Question 5

When a new column is inserted into a worksheet,the remaining columns move to the right.

Accepted Answer

A) True 
 B)False

Question 6

When a cell has conditional formatting and the condition is false,the cell is formatted.

Accepted Answer

A) True 
 B)False

Question 7

If a sheet tab has ________ you know that it is not selected.

Accepted Answer

A) a dotted background 
B) a background color 
C) a bolded border 
D) a red border 
A) a dotted background 
B) a background color 
C) a bolded border 
D) a red border

Question 8

The quickest way to repeat an action in Excel is the ________ function key.

Accepted Answer

A) F2 
B) F4 
C) F6 
D) F11 
A) F2 
B) F4 
C) F6 
D) F11

Question 9

A logical test includes one of three values designated in three different cells.

Accepted Answer

A) True 
 B)False

Question 10

Clearing the contents of a cell deletes the value or formula,but does not clear the formatting applied to the cell.

Accepted Answer

A) True 
 B)False

Question 11

Where do sheet tabs display in a workbook?

Accepted Answer

A) Under the ribbon 
B) On the status bar 
C) Lower area of the workbook window 
D) On the right side of the workbook window 
A) Under the ribbon 
B) On the status bar 
C) Lower area of the workbook window 
D) On the right side of the workbook window

Question 12

The values in parentheses in the SUM function (and other functions)are known as ________.

Accepted Answer

The answer of The values in parentheses in the SUM...

Question 13

________ sheets store information summarized on a summary sheet.

Accepted Answer

The answer of ________ sheets store information summarized on a...

Question 14

Cell contents must always be a value,not a formula.

Accepted Answer

A) True 
 B)False

Question 15

When formatting a worksheet to be printed,________ show where page breaks are located.

Accepted Answer

A) red lines 
B) blue lines 
C) a solid bold line 
D) dotted lines 
A) red lines 
B) blue lines 
C) a solid bold line 
D) dotted lines

Question 16

The ________ function adds the values in a range of cells,and then divides the result by the number of values in the range.

Accepted Answer

The answer of The ________ function adds the values in...

Question 17

How do you know if some rows of a table have been hidden from view when a filter is invoked?

Accepted Answer

A) Row numbers display is red 
B) Row numbers are bolded 
C) Row numbers display in blue 
D) A number pertaining the number of hidden rows displays next to the funnel icon 
A) Row numbers display is red 
B) Row numbers are bolded 
C) Row numbers display in blue 
D) A number pertaining the number of hidden rows displays next to the funnel icon

Question 18

The active worksheet tab displays in bold.

Accepted Answer

A) True 
 B)False

Question 19

What is an Excel table?

Accepted Answer

A) A series of rows and columns that contains related data that can be managed independently from other data in a worksheet 
B) A series of rows and columns that has been assigned a name and can be used in a formula or function 
C) A series of rows and columns that contain related data located on a minimum of two worksheets 
D) A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet 
A) A series of rows and columns that contains related data that can be managed independently from other data in a worksheet 
B) A series of rows and columns that has been assigned a name and can be used in a formula or function 
C) A series of rows and columns that contain related data located on a minimum of two worksheets 
D) A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet

Question 20

________ identify each worksheet in a workbook.

Accepted Answer

The answer of ________ identify each worksheet in a workbook....

A filter in Excel displays only a portion of the table data based on matching criteria.

You can group worksheets and format them simultaneously.

What is the keyboard shortcut for flash fill?

What are the default names of worksheets?

When a new column is inserted into a worksheet,the remaining columns move to the right.

When a cell has conditional formatting and the condition is false,the cell is formatted.

If a sheet tab has ________ you know that it is not selected.

The quickest way to repeat an action in Excel is the ________ function key.

A logical test includes one of three values designated in three different cells.

Clearing the contents of a cell deletes the value or formula,but does not clear the formatting applied to the cell.

Where do sheet tabs display in a workbook?

The values in parentheses in the SUM function (and other functions)are known as ________.

________ sheets store information summarized on a summary sheet.

Cell contents must always be a value,not a formula.

When formatting a worksheet to be printed,________ show where page breaks are located.

The ________ function adds the values in a range of cells,and then divides the result by the number of values in the range.

How do you know if some rows of a table have been hidden from view when a filter is invoked?

The active worksheet tab displays in bold.

What is an Excel table?

________ identify each worksheet in a workbook.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters

Exam 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks

A filter in Excel displays only a portion of the table data based on matching criteria.

You can group worksheets and format them simultaneously.

What is the keyboard shortcut for flash fill?

What are the default names of worksheets?

When a new column is inserted into a worksheet,the remaining columns move to the right.

When a cell has conditional formatting and the condition is false,the cell is formatted.

If a sheet tab has ________ you know that it is not selected.

The quickest way to repeat an action in Excel is the ________ function key.

A logical test includes one of three values designated in three different cells.

Clearing the contents of a cell deletes the value or formula,but does not clear the formatting applied to the cell.

Where do sheet tabs display in a workbook?

The values in parentheses in the SUM function (and other functions)are known as ________.

________ sheets store information summarized on a summary sheet.

Cell contents must always be a value,not a formula.

When formatting a worksheet to be printed,________ show where page breaks are located.

The ________ function adds the values in a range of cells,and then divides the result by the number of values in the range.

How do you know if some rows of a table have been hidden from view when a filter is invoked?

The active worksheet tab displays in bold.

What is an Excel table?

________ identify each worksheet in a workbook.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters