Question 1

The default style used to display the date is ____.

Accepted Answer

The answer of The default style used to display the...

Question 2

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

Accepted Answer

Santiago can split the worksheet to view and scroll through different parts at the same time by using the "Split" feature in Excel. This will create two separate panes that will allow him to navigate through the worksheet independently.

Question 3

When you ____________________ rows and columns, the data remains intact; it is just not displayed on the screen.

Accepted Answer

The answer of When you ____________________ rows and columns, the...

Question 4

Which of the following is NOT true about default print options in Excel?

Accepted Answer

By default, Excel does not print gridlines, row numbers, or column letters unless specifically set to do so in the Page Layout options.

Question 5

Which of the following is NOT true about table styles?

Accepted Answer

The answer of Which of the following is NOT true...

Question 6

To display the current date in a footer, insert the date ____________________.

Accepted Answer

The answer of To display the current date in a...

Question 7

Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to print her workbook. By default, which of the following worksheet data will print?

Accepted Answer

By default, headers will print along with the worksheet data. Comments, column letters, and gridlines do not print unless specifically set to do so in the print settings.

Question 8

By default, Excel aligns numbers at the ____ of the cell.

Accepted Answer

Aligning numbers to the right makes it easier to read and compare values as the digits line up on the side. This is a common convention in spreadsheet programs.

Question 9

To remove the data and the formats from a cell, you need to ____________________ the cell.

Accepted Answer

The answer of To remove the data and the formats...

Question 10

Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to share her workbook electronically, but she doesn't want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.

Accepted Answer

Saving the file as a PDF would preserve the formatting and prevent the recipients from being able to modify the data. HTML, .xlsx, and template files would not prevent recipients from modifying the data.

Question 11

A(n) ____________________ is descriptive text that is printed in the top margin of a worksheet.

Accepted Answer

The answer of A(n) ____________________ is descriptive text that is...

Question 12

When a comment is added to a selected cell, it can be viewed in _____.

Accepted Answer

Comments in Excel are displayed as ScreenTips when you hover over the cell that contains a comment.

Question 13

Which of the following is NOT true about changing alignment?

Accepted Answer

All the statements provided are true regarding changing alignment in Excel. Excel does align text to the left by default, allows for vertical alignment adjustments, and also permits the adjustment of the margin between the cell edge and its contents.

Question 14

To change the angle of the text direction, click the ____________________ button.

Accepted Answer

The answer of To change the angle of the text...

Question 15

Which of the following is NOT true about changing the page setup?

Accepted Answer

The default setting for a worksheet is portrait orientation, not landscape orientation.

Question 16

A ____ is the design of the typeface.

Accepted Answer

The term "font" refers to the entire set of characters in a particular size and style of a typeface, including uppercase and lowercase letters, numbers, symbols, and punctuation. The design of the typeface is what determines the look and style of the font.

Question 17

Santiago has entered data in his worksheet and is working on fine-tuning the display. Which of the following is NOT an option for Santiago to apply for conditional formatting?

Accepted Answer

Quick Styles are not an option for conditional formatting. They are used to quickly apply pre-designed formatting to cells, but do not change based on the data in the cell. Data Bars, Color Scales, and Icon Sets are all options for conditional formatting as they change based on the numerical data in a cell.

Question 18

An example of a font size is 12 _____.

Accepted Answer

Font size is commonly measured in points, with 12 points being a common default size for body text. Characters, pixels, and millimeters are also used for measurement in some contexts, but are not as common for specifying font size.

Question 19

The header and footer commands are located on the ____ tab.

Accepted Answer

The header and footer commands are located under the INSERT tab in Microsoft Word.

Question 20

You can easily change the print settings using commands in the ____.

Accepted Answer

You can change print settings in both the Page Setup dialog box and the Backstage view. The Page Setup dialog box allows you to adjust page margins, orientation, and size, while the Backstage view allows you to set the number of copies, choose a printer, and adjust other printing options. You can access both of these options from the HOME tab. Therefore, the correct choice is either a or b, which is option D.

Quiz 19: Organizing and Enhancing Worksheets