Question 1

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file.What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

Accepted Answer

Clicking on the select button in Rows to repeat at top area and selecting a title row will ensure that the title row is printed at the top of every sheet. Choosing B, C, or D will not achieve the desired outcome.

Question 2

When you change cell contents to italics,you are changing the cell's alignment.

Accepted Answer

Changing the cell contents to italics does not change the alignment of the cell. It only changes the font style of the text within the cell. Cell alignment refers to the position of the cell's contents (e.g. left, center, right) within the cell.

Question 3

To copy a cell's formatting to another cell,which of the following can you use?

Accepted Answer

Format Painter is the tool that can be used to copy a cell's formatting to another cell. It allows you to quickly copy and apply formatting from one cell to another without having to manually reapply the same format.

Question 4

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

Accepted Answer

The option to highlight top 10 items in a range of cells can be done using the Top/Bottom Rules in Conditional Formatting. Icon sets, color scales, and highlight cells rules are not suitable for highlighting a specific number of items in a range of cells.

Question 5

To insert information that appears at the bottom of every worksheet page,you can use a command on the Insert tab.

Accepted Answer

The command is called "Footer" and can be found on the Insert tab in the Text group.

Question 6

To enter your name in the lower right corner of a worksheet page,you can _____.

Accepted Answer

Selecting the right footer text box and typing your name is the most direct and efficient option to enter your name in the lower right corner of a worksheet page. The other options involve navigating through multiple tabs and options, which can be time-consuming and unnecessary.

Question 7

You double-click the Format Painter button when you want to _____.

Accepted Answer

Double-clicking the Format Painter button allows you to copy a cell's format to multiple cells.

Question 8

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?

Accepted Answer

In step X, you need to select the column to the right of the page break you want to delete. This is because vertical page breaks separate columns, so you need to select the column to the right of the break to remove it.

Question 9

Amari wants to paint the format of one object onto a target object.She selects the first object,then clicks on Format Painter,on the Clipboard group in the Home tab.She then observes the cursor change to a specific icon.Which of the following is the icon into which the cursor changed?

Accepted Answer

The cursor changes to a paintbrush icon when using the Format Painter tool.

Question 10

Helga wants to reset page breaks in a worksheet to display only automatic page breaks.Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

Accepted Answer

To reset page breaks to display only automatic page breaks, Helga needs to select Page Break Preview as X and Breaks as Y in the series of clicks. Then she can select Reset All Page Breaks option to reset the page breaks. Option C is the correct choice because it includes the required options. Option A is incorrect because Normal and Print Area are not relevant to resetting page breaks. Option B is incorrect because Print Tiles is not relevant to resetting page breaks. Option D is incorrect because Custom Views and Background are not relevant to resetting page breaks.

Question 11

To paste copied cell contents with values only,not including formatting,which of the following can you use?

Accepted Answer

The answer of To paste copied cell contents with values...

Question 12

Igor wants to set margins for a worksheet he has created per his choice.Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top,Header,Left,Right,Bottom and Footer text boxes > OK?

Accepted Answer

To set margins, Igor needs to go to Page Layout tab, then click on Page Setup, choose Margins from the drop-down list, and select Custom Margins to specify the desired values for Top, Header, Left, Right, Bottom, and Footer. Therefore, X should be Custom Margins and Y should be Margins drop-down list.

Question 13

To format a cell range so that values between 100 and 500 appear in red,which of the following can you use?

Accepted Answer

Highlight Cells Rules allow for custom formatting based on specific conditions, such as values between 100 and 500 appearing in red. Icon sets, themes, and Top/Bottom Rules do not offer this level of customization.

Question 14

You can edit a worksheet footer in _____.

Accepted Answer

You can edit a worksheet footer in Page Layout view, which allows you to see how your document will look when printed and gives you the ability to edit headers and footers directly.

Question 15

To rotate cell contents to an exact value,you change its _____.

Accepted Answer

To rotate cell contents to an exact value, you change its orientation. Changing the font, width, or indent will not rotate the contents of the cell.

Question 16

The Clipboard task pane shows the contents of the _____.

Accepted Answer

The Clipboard task pane shows the contents of the Office Clipboard, which allows users to copy and paste multiple items and access them all in one place. The other options listed (Table Styles gallery, Quick Analysis tool, and Recently-Used Add-ins) are not related to the Clipboard task pane.

Question 17

Decreasing a cell's indent moves its contents to the right one space.

Accepted Answer

Decreasing a cell's indent moves its contents to the left one space.

Question 18

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Accepted Answer

Yes, you can repeatedly paste an item from the Office Clipboard multiple times.

Question 19

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Accepted Answer

Clicking the Increase Decimal button would change the displayed value to 14.540, not 14.5.

Question 20

You can create conditional cell formats using either the Home tab or the _____.

Accepted Answer

The Quick Analysis tool in Excel allows users to quickly apply conditional formatting among other features, directly from a small popup menu that appears after selecting a range of cells. This tool provides an efficient way to visually analyze data by highlighting cells that meet certain conditions.

Quiz 2: Formatting Workbook Text and Data