Deck 11: Excel Web Feature - Creating Web Pages Using Excel

Question 1

Figure 4 In the accompanying figure, what is the file type of the Web page that is in the browser?

A)html
B)mht
C)xml
D)htm

Answer 1

B

Question 2

After you open the Customize Quick Access Toolbar and click the More Commands command, Excel allows you to ____.

A)add a command to the Quick Access Toolbar
B)customize the worksheet for the browser
C)remove the browser from active status
D)add the browser to active status

Answer 2

A

Question 3

The Web Page Preview command is not available on the Ribbon, but you can add the command to the Quick Access Toolbar.

Answer 3

True

Question 4

The ____ button in the Save As dialog box is an alternative to the Save button.

A)Rename
B)OK
C)Cancel
D)Publish

Question 5

When you save to a Web page, the Web page is shown in the browser as a(n)____ folder.

A)large
B)multiple
C)temporary
D)permanent

Question 6

The hyperlinks in the Excel workbook can link to a Web page, a location in a Web page, but not to an e-mail address.

Question 7

You can add ____ to an Excel workbook before you save it as a Web page.

A)hyperlinks
B)browsers
C)toolbars
D)spell checkers

Question 8

You can publish Web pages by saving them on a(n)____, if you have access to it.

A)Web server
B)USB drive
C)local drive
D)software page

Question 9

Figure 1 In the accompanying figure, how many files will be saved?

A)1 folder
B)1 files for each worksheet
C)1 file
D)1 file plus folder components

Question 10

Saving a workbook in Web Page format does not convert the contents of the workbook into HTML.

Question 11

Excel allows you to publish workbooks, which is the process of ____.

A)printing workbooks for others
B)making workbooks available to others
C)selling workbooks of others
D)modifying workbooks of others

Question 12

Figure 1 In the accompanying figure, what will the file extension be for the saved Web page?

A).mhtl
B).xtml
C).htm
D).mht

Question 13

Figure 4 Which tab do you click to display the Web page shown in the accompanying figure?

A)Sheet 2
B)Sheet 3
C)3-D Pie Chart
D)1st Quarter Sales

Question 14

After you create a folder, you can right-click it while the Save As dialog box is active and perform many file management tasks ____.

A)directly in the MHTML file
B)directly in the .mht file
C)directly in Excel
D)directly on the Web page

Question 15

Many commands available in Excel are not included on any of the tabs on the Ribbon.

Question 16

When you invoke the Web Page Preview command, it starts your computer and displays the active sheet in the workbook as a Web page.

Question 17

Excel allows you to remove commands from the Quick Access Toolbar ____.

A)if you share a computer with someone
B)if the toolbar becomes cluttered
C)by clicking the Reset button on the Excel Options dialog box
D)all of the above

Question 18

You can add ____ to the Quick Access Toolbar.

A)HTML
B)commands
C)Web pages
D)data

Question 19

Figure 2 In the accompanying figure, Microsoft Excel is ____.

A)dynamic
B)static
C)not active
D)active

Question 20

The saved Web page is a snapshot of the workbook. It is similar to a printed report in that you can ____ it, but you cannot ____ it.

A)print, view
B)modify, print
C)modify, view
D)view, modify

Question 21

Figure 2 In the accompanying figure, when you click the Close button, Excel becomes ____________________.

Question 22

Figure 2 By clicking Excel s Web Page ____________________ button, the browser becomes active, as shown in the accompanying figure.

Question 23

Critical Thinking Questions Case WF-2 Sue, the travel agent, has a 2-sheet workbook of tours that she has led. Sometimes, her clients ask for information about the places she has visited with the tours. She is thinking about creating a Web site to display this information. Sue decides to save her workbook to a folder. When the Save As dialog box opens, what selection does she make to save all sheets in the workbook as a Web page?

A)My Documents
B)My Network Places
C)Selection: Sheet
D)Entire Workbook

Question 24

Figure 2 In the accompanying figure, the Web page in the display is considered a temporary Internet file.

Question 25

Modified Multiple Choice By clicking the Web Page Browser button, Excel starts your browser.

Question 26

Modified Multiple Choice The Web page preview in the browser is nearly identical to the display of the worksheet in (the)browser .

Question 27

A Web page is an ideal way to distribute information to a large group of people.

Question 28

Figure 2 The worksheet from the Excel workbook is displayed in a(n)____________________ window, as shown in the accompanying figure.

Question 29

Excel allows you to create folders before saving a file by using the ____________________ dialog box.

Question 30

Figure 3 In the accompanying figure, the menu displayed allows you to add buttons to the Excel Ribbon.

Question 31

Critical Thinking Questions Case WF-2 Sue, the travel agent, has a 2-sheet workbook of tours that she has led. Sometimes, her clients ask for information about the places she has visited with the tours. She is thinking about creating a Web site to display this information. In the Save As dialog box, what format type should Sue enter in the Save as type box to create a single file with an .mht file extension?

A)MHT
B)MHT Web Page
C)Single File Web Page
D)Web Page

Question 32

Figure 4 In the accompanying figure, the Web page in the browser is a temporary Internet file.

Question 33

Figure 2 Excel creates a Web page in a(n)____________________ folder, as shown in the accompanying figure.

Question 34

Critical Thinking Questions Case WF-1 A jewelry design company uses a workbook to keep track of the items it designs and sells. The workbook has four worksheets: one for rings, one for earrings, one for necklaces, and one for bracelets. Each worksheet lists the products, their prices, and a small image of each item. The president of the company requests that the information in the workbook be available as a Web page. Which method would the president use to publish the workbook so it is available for others to view, for example on the World Wide Web?

A)save the workbook as an Excel file and open it in a browser
B)use the Web Page Preview command after adding it to the Quick Access Toolbar and then view the Web page in a browser
C)save the Web page to a Web server or FTP location
D)use the Publish command on the File menu

Question 35

Discuss the use of the Quick Access Toolbar with regards to adding or removing buttons.

Question 36

When you customize the Quick Access Toolbar, the 'Commands Not in the Ribbon' selection displays a list of commands that you do not want to add to the Ribbon.

Question 37

Critical Thinking Questions Case WF-1 A jewelry design company uses a workbook to keep track of the items it designs and sells. The workbook has four worksheets: one for rings, one for earrings, one for necklaces, and one for bracelets. Each worksheet lists the products, their prices, and a small image of each item. The president of the company requests that the information in the workbook be available as a Web page. Every time the workbook changes, the president would like to view the changes in a browser. He decides to create a Web page by using the Web Page Preview button but notices it is not available. What can he do?

A)add the button to the Ribbon
B)add the button to the Quick Access Toolbar
C)use the Web Page Preview command on the Edit menu instead
D)save the workbook to a folder and then use the Create Web Page command from the Save As dialog box

Question 38

Modified Multiple Choice Many commands available in Excel are not included on any of the tabs on the Ribbon .

Question 39

Modified Multiple Choice You can save any type of file to a Web folder or on an FTP location, just as you would save to a folder on your hard disk.

Question 40

Modified Multiple Choice The Web Page Preview button must be added to the Quick Access Toolbar so that the Web page can be previewed.