Excel 2007 Engr 112 Quiz

1. What is the correct cell entry for the following scenario (no spaces):
You wish to add cell c46 and d53.

You may either use the + sign or the sum command.

Explanation

You may either use the + sign or the sum command.

Submit

2. You can't change the chart type after you create a chart.

True

False

The statement "You can't change the chart type after you create a chart" is false. In most charting software, including popular programs like Microsoft Excel, you have the ability to change the chart type even after creating a chart. This flexibility allows users to experiment with different visual representations of their data and choose the one that best suits their needs.

Explanation

The statement "You can't change the chart type after you create a chart" is false. In most charting software, including popular programs like Microsoft Excel, you have the ability to change the chart type even after creating a chart. This flexibility allows users to experiment with different visual representations of their data and choose the one that best suits their needs.

3. The colon (:) in B3:B6 indicates a ______ in column B, rows 3 through 6.

Cell argument

Cell range

Cell reference

The colon (:) in B3:B6 indicates a range of cells in column B, specifically rows 3 through 6. It is used to specify a continuous set of cells in a column or row.

Explanation

The colon (:) in B3:B6 indicates a range of cells in column B, specifically rows 3 through 6. It is used to specify a continuous set of cells in a column or row.

4. You create a chart. But later on you don't see the Chart Tools. What do you do to get them back?

Create another chart.

Click inside the chart.

Click the Insert tab.

Once you click inside the existing chart, the Chart Tools will be at hand with three tabs: Design, Layout, and Format.

Explanation

Once you click inside the existing chart, the Chart Tools will be at hand with three tabs: Design, Layout, and Format.

5. A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

Click in cell C6, and then press CTRL+SHIFT.

Click in cell C6, and then press F5.

Click in cell C6.

To see the formula result in cell C6, you need to click on cell C6.

Explanation

To see the formula result in cell C6, you need to click on cell C6.

6. Cell references are __________ by default.

Absolute

Relative

Cell references are relative by default. This means that when a formula or function is copied to another cell, the reference to other cells will adjust accordingly. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically change to B2. This allows for easy replication of formulas across multiple cells without having to manually adjust each reference.

Explanation

Cell references are relative by default. This means that when a formula or function is copied to another cell, the reference to other cells will adjust accordingly. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically change to B2. This allows for easy replication of formulas across multiple cells without having to manually adjust each reference.

7. If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5?

=C4*$D$9

=C5*$D$9

=C5*$E$10

As the formula is copied, the relative cell reference, C4, changes to C5. The absolute cell reference, $D$9, does not change; it remains the same in each row it is copied to.

Explanation

As the formula is copied, the relative cell reference, C4, changes to C5. The absolute cell reference, $D$9, does not change; it remains the same in each row it is copied to.

8. What is a function?

A prewritten formula

A math operator

Functions are prewritten formulas, such as SUM, that save time.

Explanation

Functions are prewritten formulas, such as SUM, that save time.

9. Cell reference A10,A20 refers to values in:

The range of cells in column A and rows 10 through 20

The range of cells in columns A through E and rows 10 through 20

Cell A10 and A20

The cell reference A10, A20 refers to specific cells in a spreadsheet. It means that the values being referred to are located in cell A10 and cell A20.

Explanation

The cell reference A10, A20 refers to specific cells in a spreadsheet. It means that the values being referred to are located in cell A10 and cell A20.

10. What does ##### mean?

The column is not wide enough to display the content.

The cell reference is not valid.

You have misspelled a function name or used a name that Excel doesn't recognize.

This answer is correct because when ##### is displayed in a cell, it means that the column width is not wide enough to display the content. This typically happens when the content in the cell is too long or when the cell contains a date or time value that is not formatted properly. To fix this issue, the column width can be adjusted to make it wider or the content can be shortened.

Explanation

This answer is correct because when ##### is displayed in a cell, it means that the column width is not wide enough to display the content. This typically happens when the content in the cell is too long or when the cell contains a date or time value that is not formatted properly. To fix this issue, the column width can be adjusted to make it wider or the content can be shortened.

11. You want to add data labels above each column to show a value for each column. How can you do this? (You learned this in the practice.)

Add the labels manually.

Change the chart style.

Change the chart layout.

Layout 2 will add a data label above each column that shows a value for each.

Explanation

Layout 2 will add a data label above each column that shows a value for each.