Recent Lessons

Show all results for ""

10 Questions

1 Views

Microsoft Excel Fundamentals

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

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?

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?

As currency with 2 decimal places (C) Signup and view all the answers

What is the purpose of step 4 in the instructions?

To show the total Profit in cell H7 and apply bold formatting (A) Signup and view all the answers

What is the formula to calculate the Profit in the spreadsheet?

Sales Amount minus Cost Amount (C) Signup and view all the answers

What should be inserted in the header of the spreadsheet?

Your name, class, and ZID (A) Signup and view all the answers

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 (B) Signup and view all the answers

Where should the total Profit be displayed in the spreadsheet?

Cell H7 (D) Signup and view all the answers

What is the purpose of step 9 in the instructions?

To save the file (D) Signup and view all the answers