Podcast
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?
What is the purpose of step 4 in the instructions?
What is the purpose of step 4 in the instructions?
What is the formula to calculate the Profit in the spreadsheet?
What is the formula to calculate the Profit in the spreadsheet?
What should be inserted in the header of the spreadsheet?
What should be inserted in the header of the spreadsheet?
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?
Where should the total Profit be displayed in the spreadsheet?
Where should the total Profit be displayed in the spreadsheet?
What is the purpose of step 9 in the instructions?
What is the purpose of step 9 in the instructions?