Exam 12: Collaborating on a Shared Workbook

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

(Essay)

4.8/5

(89)

Question 61

Identify the letter of the choice that best matches the phrase or definition. -Stored within the destination file and remains connected to the source file

(Multiple Choice)

4.8/5

(69)

Question 62

If you do not have a digital certificate,you can get one from a third-party _______,known as a certificate authority (CA).

(Multiple Choice)

4.8/5

(77)

Question 63

The encryption password is different from the passwords that prevent users from editing a worksheet or the entire workbook.

(True/False)

4.8/5

(84)

Question 64

To make it possible for other users to access and edit the same data _______,you need to share a workbook.

(Multiple Choice)

4.8/5

(68)

Question 65

An International format,53,08,421.64 with thousands above 9,999 marked in two-digit groups with a comma,and decimals marked with a period is used in _______.

(Multiple Choice)

4.8/5

(71)

Question 66

Identify the letter of the choice that best matches the phrase or definition. -Defined and created specifically for a workbook

(Multiple Choice)

4.9/5

(80)

Question 67

You can accept an edit to keep its new value,or you can reject an edit to return to the original value._________________________

(True/False)

4.9/5

(70)

Question 68

Screen elements that are part of the worksheet are modified only in that worksheet and not in other worksheets and workbooks.

(True/False)

4.9/5

(86)

Question 69

The wide collection of file hosting sites that allow document sharing supported by the Internet include _______.

(Multiple Choice)

4.9/5

(67)

Question 70

Standard properties are properties associated with all Office files and include the author,title,and subject._________________________

(True/False)

4.8/5

(84)

Question 71

_______ displays and stores an object within the destination file.

(Multiple Choice)

5.0/5

(77)

Question 72

Once workbook sharing is removed,the contents of the tracking log are _______,and there is no way to retrieve the history of edits made to the document.

(Multiple Choice)

4.8/5

(73)

Question 73

The Standard option optimizes the _______ for use with online publishing and printing.

(Multiple Choice)

4.8/5

(82)

Question 74

Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.

(Essay)

4.9/5

(72)

Question 75

Showing 61 - 75 of 75

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

Identify the letter of the choice that best matches the phrase or definition. -Stored within the destination file and remains connected to the source file

If you do not have a digital certificate,you can get one from a third-party _______,known as a certificate authority (CA).

The encryption password is different from the passwords that prevent users from editing a worksheet or the entire workbook.

To make it possible for other users to access and edit the same data _______,you need to share a workbook.

An International format,53,08,421.64 with thousands above 9,999 marked in two-digit groups with a comma,and decimals marked with a period is used in _______.

Identify the letter of the choice that best matches the phrase or definition. -Defined and created specifically for a workbook

You can accept an edit to keep its new value,or you can reject an edit to return to the original value._________________________

Screen elements that are part of the worksheet are modified only in that worksheet and not in other worksheets and workbooks.

The wide collection of file hosting sites that allow document sharing supported by the Internet include _______.

Standard properties are properties associated with all Office files and include the author,title,and subject._________________________

_______ displays and stores an object within the destination file.

Once workbook sharing is removed,the contents of the tracking log are _______,and there is no way to retrieve the history of edits made to the document.

The Standard option optimizes the _______ for use with online publishing and printing.

Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Working With Text Functions

Filters