Question 1

When cell contents are copied or moved,they are placed on the ________.

Accepted Answer

The answer of When cell contents are copied or moved,they...

Question 2

The MEDIAN function finds ________.

Accepted Answer

A) the average value in a range of cells 
B) the middle value in a range of cells 
C) all numbers that correspond to an argument in the function 
D) the one number that corresponds to an argument in the function 
A) the average value in a range of cells 
B) the middle value in a range of cells 
C) all numbers that correspond to an argument in the function 
D) the one number that corresponds to an argument in the function

Question 3

When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.

Accepted Answer

A) True 
 B)False

Question 4

The ________ command allows you to select one or more rows or columns and lock them into place.

Accepted Answer

The answer of The ________ command allows you to select...

Question 5

The COUNTIF function counts the number of cells within a range that meet the criteria entered.

Accepted Answer

A) True 
 B)False

Question 6

You can double-click a sheet tab to rename it.

Accepted Answer

A) True 
 B)False

Question 7

The NOW function is ________,meaning that it will update automatically each time the workbook is opened.

Accepted Answer

The answer of The NOW function is ________,meaning that it...

Question 8

When you select a single sheet that is part of a group,the grouping of the sheets is cancelled.

Accepted Answer

A) True 
 B)False

Question 9

What is a summary sheet?

Accepted Answer

A) A sheet with two panes: one with the data,the other with the summary 
B) A worksheet where totals from other worksheets are displayed 
C) A worksheet with data on the left side and the summary on the right 
D) A worksheet with sheet names,sheet information,and sheet locations of all other worksheets 
A) A sheet with two panes: one with the data,the other with the summary 
B) A worksheet where totals from other worksheets are displayed 
C) A worksheet with data on the left side and the summary on the right 
D) A worksheet with sheet names,sheet information,and sheet locations of all other worksheets

Question 10

The Unfreeze command locks columns and rows into place.

Accepted Answer

A) True 
 B)False

When cell contents are copied or moved,they are placed on the ________.

The MEDIAN function finds ________.

When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.

The ________ command allows you to select one or more rows or columns and lock them into place.

The COUNTIF function counts the number of cells within a range that meet the criteria entered.

You can double-click a sheet tab to rename it.

The NOW function is ________,meaning that it will update automatically each time the workbook is opened.

When you select a single sheet that is part of a group,the grouping of the sheets is cancelled.

What is a summary sheet?

The Unfreeze command locks columns and rows into place.

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

When cell contents are copied or moved,they are placed on the ________.

The MEDIAN function finds ________.

When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.

The ________ command allows you to select one or more rows or columns and lock them into place.

The COUNTIF function counts the number of cells within a range that meet the criteria entered.

You can double-click a sheet tab to rename it.

The NOW function is ________,meaning that it will update automatically each time the workbook is opened.

When you select a single sheet that is part of a group,the grouping of the sheets is cancelled.

What is a summary sheet?

The Unfreeze command locks columns and rows into place.

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