Podcast
Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App
Questions and Answers
What is the formula to calculate the Cost Amount in the spreadsheet?
What is the formula to calculate the Cost Amount in the spreadsheet?
- Cost Price multiplied by Mark-up percentage
- Sales Price divided by Quantity Sold
- Sales Price minus Mark-up percentage
- Cost Price multiplied by Quantity Sold (correct)
What is the purpose of the Shares.xlsx file?
What is the purpose of the Shares.xlsx file?
- To create a budget for a personal expense
- To track the inventory of a store
- To calculate the profit of a sales transaction
- To monitor changes in a share portfolio (correct)
What is the formula to calculate the Sales Amount in the spreadsheet?
What is the formula to calculate the Sales Amount in the spreadsheet?
- Profit multiplied by Quantity Sold
- Sales Price multiplied by Quantity Sold (correct)
- Cost Price multiplied by Quantity Sold
- Cost Amount divided by Mark-up percentage
How should the cells relating to monetary amounts be formatted?
How should the cells relating to monetary amounts be formatted?
Signup and view all the answers
What is the purpose of step 4 in the instructions?
What is the purpose of step 4 in the instructions?
Signup and view all the answers
What is the formula to calculate the Profit in the spreadsheet?
What is the formula to calculate the Profit in the spreadsheet?
Signup and view all the answers
What should be inserted in the header of the spreadsheet?
What should be inserted in the header of the spreadsheet?
Signup and view all the answers
What is the formula to calculate the Percent Change for each share in the Shares.xlsx file?
What is the formula to calculate the Percent Change for each share in the Shares.xlsx file?
Signup and view all the answers
Where should the total Profit be displayed in the spreadsheet?
Where should the total Profit be displayed in the spreadsheet?
Signup and view all the answers
What is the purpose of step 9 in the instructions?
What is the purpose of step 9 in the instructions?
Signup and view all the answers
Flashcards are hidden until you start studying
