Anna Is Getting Ready to Insert a Blank Column, Paste

question 7

Multiple Choice

Anna is getting ready to insert a blank column, paste information from a previous spreadsheet into the first four rows of this column, and bold the heading. And she needs to do this for all 150 product lines in her area. How is this task best handled?

• A) Use the insert, copy, and paste commands in Excel^®.
• B) Write a macro to handle this repetitive task.
• C) Write instructions that incorporate the insert and paste functions.
• D) Use the insert, copy, paste, and format commands in Excel^®.

---

Definitions:

Relevant Range

The range of activity within which assumptions about variable and fixed cost behavior are valid.

Cost Behaviour

The way in which a cost changes or reacts in relation to changes in business activity levels.

Variable Selling Expenses

Sales-related costs that vary directly with the volume of sales, such as commissions and shipping charges.

Contribution Approach

An income statement format that organizes costs by their behavior. Costs are separated into variable and fixed categories rather than being separated according to organizational functions.