Excel Chapter 6

Question 1: What is an accelerated depreciation method?

1. A method that leads to depreciation during years one and two only.
2. A method that is calculated more easily than other methods.
3. A method that leads to more depreciation over the life of the asset than would otherwise be recorded.
4. A method that leads to more depreciation during the early years of an assets useful life than in the later years.

Question 2: Which of these is not a depreciation method?

1. Straight-line depreciation
2. Sum of the years digits depreciation
3. Weighted average depreciation
4. Double-declining balance depreciation

Question 3: Which statement is incorrect regarding filters?

1. Records not meeting the criteria of a filter are hidden.
2. When a filter is applied, the AutoFilter button in the associated column heading displays a filter icon.
3. A filter can apply a single criterion only.
4. The AutoFilter button a ScreenTip indicates the current filter setting.

Question 4: A range cannot be converted to a table.

1. True
2. False

Question 5: The straight-line method is the most common depreciation method.

1. True
2. False

Question 6: Salvage value represents the amount a company expects to receive for an asset at the time of its disposal.

1. True
2. False

Question 7: Which formula is not available via the drop-down menu in the total row of a table?

1. Average
2. Max
3. Sum
4. Round

Question 8: What is not a required element for a formula that includes a depreciation function?

1. Cost
2. Useful Life
3. Depreciation factor
4. Salvage value

Question 9: Which of these is not a table option that can be changed from the Table Tools Design tab?

1. Banded Rows
2. Total Column
3. Total Row
4. Banded Columns

Question 10: Each row in a table holds a collection of facts about a certain person, event, or other item.

1. True
2. False