Match between columns Premises: .prn .ods .xlsm .txt .xltx

The Answer of Formatted Text (Space delimited) and OpenDocument Spreadsheet is...

Exam 42: Collaboration and Workbook Distribution

AutoCorrect options are located in which Excel Options category?

(Multiple Choice)

4.8/5

(72)

Question 81

What are the benefits of sharing a workbook?

(Essay)

4.7/5

(86)

Question 82

The Share Workbook command is located on the ________.

(Short Answer)

4.8/5

(88)

Question 83

Once a workbook is ________ it is read-only.

(Short Answer)

4.9/5

(81)

Question 84

When a file is created,customizations such as the author's name are saved as ________.

(Short Answer)

4.9/5

(84)

Question 85

Which of following is the default file format for Excel 97-2003?

(Multiple Choice)

4.9/5

(89)

Question 86

Which of the following is not true about compare and merge?

(Multiple Choice)

4.7/5

(78)

Question 87

Where is the Share Workbook command located within Excel?

(Multiple Choice)

4.8/5

(79)

Question 88

Which of the following online storage tools is integrated into Excel 2013?

(Multiple Choice)

4.8/5

(69)

Question 89

The default file format for Excel 2013 files is ________.

(Short Answer)

4.9/5

(78)

Question 90

When active,the Document Panel displays above the current workbook.

(True/False)

4.9/5

(86)

Question 91

To compare and merge workbooks,the workbooks cannot be shared.

(True/False)

4.9/5

(74)

Question 92

When creating a history worksheet using change tracking,the worksheet is automatically saved.

(True/False)

4.9/5

(93)

Question 93

When displayed,the ________ will show file properties directly above the current workbook.

(Short Answer)

4.9/5

(80)

Question 94

Match the following terms with the corresponding descriptions:

Document Inspector

Reviews your files for potential issues that could hinder the ability of users who access your public files and then alerts you to these issues so that you can address them

Accessibility Checker

An electronic,encrypted notation that stamps a document to authenticate the contents,confirming that a particular person authorized it

Mark as Final

Command communicates that it is a final version and makes the file read-only

Correct Answer:

Verified

Document Inspector

Accessibility Checker

Mark as Final

Signature line

Compatibility Checker

(Matching)

4.9/5

(77)

Question 95

Which of the following items is not stored as metadata in a workbook?

(Multiple Choice)

4.9/5

(89)

Question 96

Match the following terms with the corresponding descriptions:

Resolve Conflicts dialog box

Appears as read-only when opened

Compare and Merge

The process by which two or more individuals work together to achieve an outcome or goal by using software technology

Nonshareable workbook

Command to combine the shared workbooks into one workbook so that you can compare the changes to decide which ones to keep

Correct Answer:

Verified

Resolve Conflicts dialog box

Compare and Merge

Nonshareable workbook

Shared workbook

Collaboration

(Matching)

4.8/5

(86)

Question 97

Excel can export PDF files.

(True/False)

4.8/5

(78)

Question 98

Match the following terms with the corresponding descriptions:

.prn

Formatted Text (Space delimited)

.ods

OpenDocument Spreadsheet

.xlsm

Text (Tab delimited)

Correct Answer:

Verified

.prn

.ods

.xlsm

.txt

.xltx

(Matching)

4.8/5

(79)

Question 99

Match the following terms with the corresponding descriptions:

Properties dialog box

Provides additional document details not provided in the property list

Document properties

Properties which are updated automatically that cannot be changed

Document Panel

Displays above the workbook so that you can view and edit properties while reviewing the workbook data

Correct Answer:

Verified

Properties dialog box

Document properties

Document Panel

Excel Options

Automatic property

(Matching)

4.9/5

(74)

Question 100

Exam 42: Collaboration and Workbook Distribution

AutoCorrect options are located in which Excel Options category?

What are the benefits of sharing a workbook?

The Share Workbook command is located on the ________.

Once a workbook is ________ it is read-only.

When a file is created,customizations such as the author's name are saved as ________.

Which of following is the default file format for Excel 97-2003?

Which of the following is not true about compare and merge?

Where is the Share Workbook command located within Excel?

Which of the following online storage tools is integrated into Excel 2013?

The default file format for Excel 2013 files is ________.

When active,the Document Panel displays above the current workbook.

To compare and merge workbooks,the workbooks cannot be shared.

When creating a history worksheet using change tracking,the worksheet is automatically saved.

When displayed,the ________ will show file properties directly above the current workbook.

Which of the following items is not stored as metadata in a workbook?

Excel can export PDF files.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters