Knights - (Intermediate Account 5. Change the book title in...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CheckCell Key: 49c5588e37385d3454b2eef2e1394db3e Banner: 391668 Last Name: McCurdy First Name: Caitlin Email: crm05c@acu.edu
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Knights Bookstore Book Title Cost of Book Selling Price Profit Per Book Cost Accounting 75 125 50 Intermediate Accounting 110 150 40 Advanced Accounting 84 137 53 Financial Accounting 96 145 49 Financial Management 108 167 59 Management 83 107 24 Management of Banking and Money 91 102 11 Business Law Today 116 197 81 Astronomy 71 227 156 Introduction to Sociology 65 146 81 Income Tax and You 127 150 23 1. Create a formula in cell D6 that computes the profit per book. 2. Create a formula in cell F6 that computes the total profit by multiplying the profit per book times the number 3. Use the fill handle to copy the formulas in D6 and F6 to the rest of each column. 4. Use the format painter to copy the format in cell A6 to the 3 other accounting books.
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (Intermediate Account 5. Change the book title in cell A12 to read "Economics of Banking and Money." 6. Use the Go To function to select cell A16. 7. Use the replace function to change the word economics in cells A11 and A12 to the word management. 8. Use the replace function to change the format of all cells using italics back to regular. 9. Insert clip art that is a balloon in the shape of a light bulb. 10. Position the clip art so that it is right next to the total profit column with the top left corner of the picture in ce Number of Books Sold Total Profit 29 1450 38 1520 42 2226 67 3283 35 2065 95 2280 64 704 27 2187 74 11544 15 1215 46 1058 r of books sold. ting, Advanced Accounting, Financial Accounting) cell G5....
View Full Document

This note was uploaded on 04/29/2008 for the course MGMT 120 taught by Professor Lynn during the Fall '08 term at Abilene Christian University.

Page1 / 3

Knights - (Intermediate Account 5. Change the book title in...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online