Recent Lessons

Show all results for ""

Feature Overview

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Quizzes

Create quizzes and tests automatically from your content using AI.

Flashcards

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

Mobile Apps

The smarter way to study – wherever you are.

Pricing Schools Business

Features Pricing Schools Business

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

Microsoft Excel Fundamentals

Choose a study mode

Podcast

Questions and Answers

What is the formula to calculate the Cost Amount in the spreadsheet?

What is the purpose of the Shares.xlsx file?

What is the formula to calculate the Sales Amount in the spreadsheet?

How should the cells relating to monetary amounts be formatted?

What is the purpose of step 4 in the instructions?

What is the formula to calculate the Profit in 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?

Where should the total Profit be displayed in the spreadsheet?

What is the purpose of step 9 in the instructions?

More Like This

Microsoft Excel Basics

Formulas and Charts in Microsoft Excel

Microsoft Excel Basics

Microsoft Excel Basics