Question 1

To center text across columns, select the range of cells to be merged, then click the Merge & Center button in the Cell group on the Home tab._________________________

Accepted Answer

Alignment

Question 2

If a label is too long to fit into a cell, it extends into the next cell on the right, if that cell is empty._________________________

Accepted Answer

When a label is too long to fit into a cell, it extends into the next cell on the right, if that cell is empty. This is known as text wrapping.

Question 3

As you insert and delete rows and columns, Excel adjusts relative cell references in formulas to keep them accurate._________________________

Accepted Answer

This is true. Excel automatically adjusts the cell references in formulas as you insert or delete rows and columns to maintain accuracy.

Question 4

The Money Number Format button displays cell contents in your local currency format._________________________

Accepted Answer

Accounting

Question 5

Pressing the F5 key changes a cell reference to an absolute reference._________________________

Accepted Answer

Pressing F4 key changes a cell reference to an absolute reference in Excel.

Question 6

Case 13-1
Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below.
-Jim has noticed that when it comes to the column totals, he wants those formulas to remain the same, even when copied.He is wanting to create a(n) ____ reference.
A)relative
B)absolute
C)data
D)function

Accepted Answer

Absolute reference will keep the formula the same when copied to another area of the worksheet.

Question 7

To select all cells in a row, click the row header on the left side of the row._________________________

Accepted Answer

Clicking on the row header on the left side of the row will select all cells in that row.

Question 8

You can use buttons in the Font group on the Edit tab to select different font attributes for any data in worksheet cells._________________________

Accepted Answer

Home

Question 9

To create a(n) relative reference, insert a dollar sign ($) before the column reference and another dollar sign before the row reference._________________________

Accepted Answer

absolute

Question 10

Case 13-1
Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below.
-In several areas of the worksheet, Jim uses absolute references.The correct format for an absolute reference is ____.
A)$C3
B)$C$3
C)C3$
D)C3

Accepted Answer

The correct format for an absolute reference includes putting a dollar sign ($) before both the column letter and row number, such as $C$3. This will ensure that the reference will not change if copied or moved to another location in the worksheet.

Question 11

Case 13-1
Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below.
-Jim is copying a formula from cell C3 to cell F3 and wants the cell references to change accordingly.He is wanting to create a(n) ____ reference.
A)relative
B)absolute
C)data
D)function

Accepted Answer

Jim wants the cell references in the formula to change accordingly, which means he wants to create a relative reference. A relative reference adjusts the cell references in a formula as it is copied to a new location.

Question 12

Excel gives you the ability to apply number formats to your values.Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.

Accepted Answer

The answer of Excel gives you the ability to apply...

Question 13

Workbooks are an important part of Excel.Please 1) Describe a workbook and how they are used, 2) Explain how many default worksheets are included in each workbook, and 3) Describe some of the adjustments you can make to worksheets.

Accepted Answer

The answer of Workbooks are an important part of Excel.Please...

Question 14

The most commonly used number formats are available as buttons in the Formatgroup on the Home tab._________________________

Accepted Answer

Number

Question 15

To move the data in cells, select the cells, then click the Cut button.Click the cell where you want to paste the data, then click the Paste button._________________________

Accepted Answer

This is the correct method for moving data in cells within a spreadsheet.

Quiz 13: Formatting a Worksheet