Creating a Chart from Excel Data
Enter data in your spreadsheet:
I have selected the cells with the expense names and the January amounts in the next figure.
In Excel click on the Insert tab. Then choose the type of chart you want to create.
Lets pick a p
TECHOLOGY for ACCT
Accounts receivable (net)
Additional Paid in Capital-Common
Bond payable,10%, due 2017
Common stock, $20 par
Cost of goods sold
Study Guide for Excel Exam 1
Workshops 2 & 3 Excel Basics
Using excel formulas to calculate basic accounting information.
Using absolute and relative cell references where appropriate
Using built-in cell styles or other formatting to make
Accounting and Business
Q UIZ AND T EST H INTS
The following hints may be helpful to you in preparing for a quiz or a test over
the material covered in Chapter 1.
1. Terminology is important in this chapter. Review the Key Terms