Question 1

Which of the following is a way to edit grouped worksheets?
A) Freeze the worksheet panes
B) Create a read-only version
C) Protect them
D) Insert a header

Accepted Answer

Inserting a header is a way to edit grouped worksheets in Excel. When worksheets are grouped, any changes made to one worksheet, including adding headers or footers, will apply to all grouped sheets.

Question 2

Which of the following save options should you use so that someone who has an earlier version of Excel can view your Excel document?
A) Excel 2010 Workbook
B) Excel 97-2003 Workbook
C) Excel 2003-2007 Workbook
D) Excel 98 and Later Workbook

Accepted Answer

The Excel 97-2003 Workbook option is compatible with earlier versions of Excel, allowing them to view the document. The other options are for newer versions of Excel and may not be compatible with earlier versions.

Question 3

To save a single-file web page that integrates all worksheets and graphics from one workbook, you need to save the file as ____.
A) XLS
B) view
C) MHTML
D) HTML

Accepted Answer

Saving the file as MHTML (Web Page, Single File) will integrate all worksheets and graphics from one workbook into a single-file web page. XLS and HTML formats will not integrate all worksheets and graphics into a single file. "View" is not a valid option for saving a file format.

Question 4

MHTML is also known as ____.
A) MHT
B) MHL
C) HTML
D) XML

Accepted Answer

MHTML stands for MIME HTML, which means it is a modified version of HTML that allows web pages to be saved as a single file with all the images, style sheets, and other external resources included. The file extension used for MHTML files is .mht, hence the abbreviation A) MHT. MHL (B) is not a commonly used term in relation to web development, while HTML (C) and XML (D) are related to MHTML but are not equivalent to it.

Question 5

The coding format used for all web documents is called ____.
A) HTML
B) XML
C) MHTML
D) JAVA

Accepted Answer

The answer of The coding format used for all web...

Question 6

When you view each worksheet from a workbook in its own window, you are viewing ____.
A) copies
B) instances
C) work windows
D) mirrors

Accepted Answer

The answer of When you view each worksheet from a...

Question 7

A hyperlink jumps to a ____.
A) source
B) target
C) webpage
D) dialog box

Accepted Answer

The answer of A hyperlink jumps to a ____.
A) source
B)...

Question 8

When closing an instance of a workbook, it is important to use the close button not the Close command on the File menu.​

Accepted Answer

The answer of When closing an instance of a workbook,...

Question 9

A translucent background design that prints behind your data is called a ____.
A) transparency
B) bitmap
C) watermark
D) logo

Accepted Answer

The answer of A translucent background design that prints behind...

Question 10

If you share a workbook on OneDrive, recipients can edit the file in the Excel web app.​

Accepted Answer

The answer of If you share a workbook on OneDrive,...

Question 11

To add the name of the worksheet to a header or footer, click the Sheet Title button in the Header and Footer Elements group.​ ____________________

Accepted Answer

The answer of To add the name of the worksheet...

Question 12

If you want to enter header or footer information on one worksheet and have it appear on several other worksheets, you should first ____ the worksheets.
A) protect
B) group
C) show
D) hide

Accepted Answer

The answer of If you want to enter header or...

Question 13

A worksheet displayed in its own window is called a(n) ____.
A) workspace
B) instance
C) workbook
D) group

Accepted Answer

The answer of A worksheet displayed in its own window...

Question 14

A company's internal website is called a(n) ____.
A) Internet
B) Intranet
C) Server
D) Weblink

Accepted Answer

The answer of A company's internal website is called a(n)...

Question 15

When you save an Excel workbook as an earlier version of Excel, what appears in the title bar when you open the file?
A) Enable Worksheet
B) [Protected]
C) [Compatibility Mode]
D) The version number of Excel

Accepted Answer

The answer of When you save an Excel workbook as...

Question 16

You can paste an image of an open file, called a screenshot , into an Excel workbook.​ ____________________

Accepted Answer

The answer of You can paste an image of an...

Question 17

To ____ an Excel workbook, is to place it on a network or on the web so that others can access it using their web browsers.
A) link
B) export
C) publish
D) upload

Accepted Answer

The answer of To ____ an Excel workbook, is to...

Question 18

You can see multiple instances of Excel workbooks when you place the mouse pointer over the Excel icon on the status bar.​ ____________________

Accepted Answer

The answer of You can see multiple instances of Excel...

Question 19

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?
A) Tiled
B) Layered
C) Horizontal
D) Cascade

Accepted Answer

The answer of Which of the following is not a...

Question 20

Excel automatically inserts a page break when worksheet data doesn't fit on one page.​

Accepted Answer

The answer of Excel automatically inserts a page break when...

Quiz 6: Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Which of the following is a way to edit grouped worksheets?

Which of the following save options should you use so that someone who has an earlier version of Excel can view your Excel document?

To save a single-file web page that integrates all worksheets and graphics from one workbook, you need to save the file as ____.

MHTML is also known as ____.

The coding format used for all web documents is called ____.

When you view each worksheet from a workbook in its own window, you are viewing ____.

A hyperlink jumps to a ____.

When closing an instance of a workbook, it is important to use the close button not the Close command on the File menu.

A translucent background design that prints behind your data is called a ____.

If you share a workbook on OneDrive, recipients can edit the file in the Excel web app.

To add the name of the worksheet to a header or footer, click the Sheet Title button in the Header and Footer Elements group. ____________________

If you want to enter header or footer information on one worksheet and have it appear on several other worksheets, you should first ____ the worksheets.

A worksheet displayed in its own window is called a(n) ____.

A company's internal website is called a(n) ____.

When you save an Excel workbook as an earlier version of Excel, what appears in the title bar when you open the file?

You can paste an image of an open file, called a screenshot , into an Excel workbook. ____________________

To ____ an Excel workbook, is to place it on a network or on the web so that others can access it using their web browsers.

You can see multiple instances of Excel workbooks when you place the mouse pointer over the Excel icon on the status bar. ____________________

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?

Excel automatically inserts a page break when worksheet data doesn't fit on one page.