On the worksheet, make cell A1 the active cell and then simultaneously replace all occurrences of the text Amount with the text Price. Close any open dialog boxes.
Added by Matthew P.
Close
Step 1
Step 1: Open your worksheet in Microsoft Excel or a similar spreadsheet application where you need to make the replacements. Show more…
Show all steps
Your feedback will help us improve your experience
Shashank Pandey and 74 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
On the Q1 worksheet, enter a formula in cell H5 to calculate the total number of items sold for each item type. Copy the formula through cell range H6:H19. On the Auto Fill Options dialog box, choose Fill Without Formatting.
Akash M.
In cell E15, create a formula, using the mouse to enter cell references, that adds cells B8 and B15 and then subtracts cell e13
In cell C2, enter a formula to calculate the total sale. Multiply the quantity sold (cell B2) by the price per box (cell F1). You are going to copy this formula to cells C3:C9, so use relative and absolute references as appropriate.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD