Question 1

To insert one or more columns, select the column or columns, click the down-arrow button next to Insert in the Cells group, then click ____________________.

Accepted Answer

Insert Sheet Columns

Question 2

If a cell containing label data is a column heading, select the cell and click the Align Text Right button in the ____________________ group on the Home tab to move the label to the right side of the cell so that it aligns with the column of numbers.

Accepted Answer

Alignment

Question 3

In addition to font attributes, you can also apply ____________________ formats-currency, percent, commas, and decimals-to cells that contain values.

Accepted Answer

number

Question 4

The ___________________ function can be used to hide rows or columns you don't want displayed.

Accepted Answer

The answer of The ___________________ function can be used to...

Question 5

You can apply multiple font attributes to any worksheet cell.

Accepted Answer

You can apply multiple font attributes such as bold, italic, underline, strikethrough, font color, and font size to any worksheet cell in Microsoft Excel.

Question 6

To change the width of a cell, you must increase the width of the entire column.

Accepted Answer

In order to change the width of a cell, you must adjust the width of the entire column. This is because a cell's width is determined by the width of the column it is located in.

Question 7

To insert more than one row at a time, drag down over the number of rows you want to insert.Click the down-arrow button next to Insert in the ____________________ group, then click Insert Sheet Rows to insert the new rows.

Accepted Answer

The answer of To insert more than one row at...

Question 8

If you copy or move the data in a range of cells, the pasted data is positioned above and to the left of the active cell.

Accepted Answer

When you paste data, it is positioned starting from the active cell and extends down and to the right, covering cells in those directions based on the size of the copied or cut data.

Question 9

Excel treats all cell references as ____________________ references unless you specify otherwise.

Accepted Answer

The answer of Excel treats all cell references as ____________________...

Question 10

You insert a new worksheet by left-clicking the tab for the worksheet that should immediately follow the new worksheet.

Accepted Answer

To insert a new worksheet, you typically right-click on an existing worksheet tab and select "Insert" from the context menu, or you can use the "+" button next to the sheet tabs (in many spreadsheet applications like Microsoft Excel). Left-clicking a tab simply selects that worksheet.

Question 11

Borders and background colors define areas of a worksheet and call attention to important information.

Accepted Answer

Borders and background colors can be used to highlight important information in a worksheet and define different sections of the worksheet.

Question 12

A(n) ____________________ reference does not change, and will always refer to the same cell, even after the formula is copied or moved.

Accepted Answer

The answer of A(n) ____________________ reference does not change, and...

Question 13

The ____________________ button allows you to copy and paste formats from one cell to another.

Accepted Answer

The answer of The ____________________ button allows you to copy...

Question 14

To change the alignment of a range of cells, select the range of cells, then click the desired alignment button from the Alignment group on the Edit tab.

Accepted Answer

To change the alignment of a range of cells, you would typically use the Alignment group on the Home tab, not the Edit tab.

Question 15

You can create mixed references by combining references so that only one of the column or row references is absolute.

Accepted Answer

This statement is true. Mixed references involve combining absolute and relative references in a single formula reference. It is achieved by adding the $ symbol in front of the row or column reference that you want to be absolute while leaving the other part of the reference relative.

Question 16

Font attributes are typically applied to the entire contents of a cell, but it is possible to change the font attributes for selected text inside a cell.

Accepted Answer

It is possible to change the font attributes for selected text inside a cell by highlighting the text and applying the desired font attributes.

Question 17

You can use the ____________________ group on the Home tab and Format Cells dialog box to add borders and a colored background to one or more cells.

Accepted Answer

The answer of You can use the ____________________ group on...

Question 18

You can select a row by clicking the row identifier button on the left side of the window.

Accepted Answer

This statement is true. You can select a row by clicking the row identifier button on the left side of the window.

Question 19

To quickly select all cells in a column, click the column ____________________ at the top of the column.

Accepted Answer

The answer of To quickly select all cells in a...

Question 20

A formula that contains an absolute reference changes when the formula is copied or moved.

Accepted Answer

An absolute reference in a formula remains constant, even when the formula is copied or moved to a different cell.

Quiz 13: Formatting a Worksheet