10 Questions
What is the formula to calculate the Cost Amount in the spreadsheet?
Cost Price multiplied by Quantity Sold
What is the purpose of the Shares.xlsx file?
To monitor changes in a share portfolio
What is the formula to calculate the Sales Amount in the spreadsheet?
Sales Price multiplied by Quantity Sold
How should the cells relating to monetary amounts be formatted?
As currency with 2 decimal places
What is the purpose of step 4 in the instructions?
To show the total Profit in cell H7 and apply bold formatting
What is the formula to calculate the Profit in the spreadsheet?
Sales Amount minus Cost Amount
What should be inserted in the header of the spreadsheet?
Your name, class, and ZID
What is the formula to calculate the Percent Change for each share in the Shares.xlsx file?
Updated Price minus Purchase Price, then divided by Purchase Price
Where should the total Profit be displayed in the spreadsheet?
Cell H7
What is the purpose of step 9 in the instructions?
To save the file
Get started with Microsoft Excel and learn how to create, edit, and format spreadsheets, perform calculations, and create charts. This course covers the basics of spreadsheet software and introduces problem-solving techniques.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
