Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 worksheetsE) B) and D)
F) B) and C)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 functionE) A) and B)
F) A) and C)

Question 6

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 7

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 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

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 10

The Unfreeze command locks columns and rows into place.

Accepted Answer

A) True 
 B)False

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

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

What is a summary sheet?

Correct Answer
verified

The MEDIAN function finds ________.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The Unfreeze command locks columns and rows into place.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

What is a summary sheet?

Correct AnswerverifiedShow Answer

The MEDIAN function finds ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The Unfreeze command locks columns and rows into place.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified