What is an accelerated depreciation method?

Answer:

A.

A method that leads to depreciation during years one and two only

B.

A method that is calculated more easily than other methods

C.

A method that leads to more depreciation over the life of the asset than would otherwise be recorded

D.	A method that leads to more depreciation during the early years of an asset's useful life than in the later years

Which statement is incorrect regarding filters?

Answer:

A.

Records not meeting the criteria of a filter are hidden.

B.

When a filter is applied, the AutoFilter button in the associated column heading displays a filter icon.

C.

A filter can apply a single criterion only.

D.	The AutoFilter button ScreenTip indicates the current filter setting.

Which statement is incorrect regarding tables?

Answer:

A.

You can convert a worksheet list into a table.

B.

Since table data cannot be modified, the Re-create button stays active so you can easily start over.

C.

If the table range Excel proposes isn't correct, just change it before creating the table.

D.	Table formatting can be applied and changed after the table has been created.

What feature allows you to display only rows that meet certain criteria in a table?

Answer:

A.

Filter

B.

Calculated Columns

C.

Sort

D.	Quick Analysis