MS Excel Advanced Unit 3

What is the purpose of the AutoRepublish feature?

• It creates a backup of the workbook each time a change is made.

• It updates the web page each time a change is saved on the source workbook or worksheet.

• It automatically formats the data in the workbook when changes are made.

• It sends notifications to users when a change is made to the workbook.

What are Sparklines in a worksheet?

• Detailed reports generated from worksheet data.

• Tiny charts in a worksheet cell which provide a visual representation of data.

• Functions that calculate data across multiple worksheets.

• Tools to enhance the printing layout of a worksheet.

What is the function of a Data Form in a worksheet?

• It is used to create forms for data entry on a web page.

• It is a feature that encrypts data in a worksheet.

• It provides a convenient way to enter or display one complete row of information in a range or table without scrolling horizontally.

• It automatically generates charts based on the selected data range.

In what format can worksheets be saved to facilitate easy publishing on the Internet?

• PDF

• DOCX

• HTML

• TXT

Which of the following can be saved in a web page format?

• Only entire workbooks

• Only portions of workbooks

• Only items in worksheets

• Entire workbooks, portions of workbooks, and items in worksheets

To save a document as a web page, which option should you select in the Save As Type menu in the Save As dialog box?

• Web Page

• PDF

• Word Document

• Excel Spreadsheet

What is the final step to complete the process of saving a document as a web page?

• Selecting the File tab

• Choosing a location to save the file

• Adding a page title

• Clicking Save

What happens when you click Save after choosing to publish a document as a web page?

• The document is automatically emailed.

• The Publish as Web Page dialog box will open.

• The document is printed.

• The document is closed without saving.

What is the final step to complete the task of saving as a web page after configuring the necessary options in the Publish as Web Page dialog box?

• Clicking Save

• Clicking Publish

• Closing the dialog box

• Selecting AutoRepublish

Which feature updates the web page each time a change is saved on the source worksheet or workbook?

• AutoSave

• AutoRepublish

• AutoUpdate

• AutoRefresh