2.1 - MS Excel
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What is a spreadsheet?
💡 Hint: Think about how data is arranged in Excel.
What is the purpose of a chart in Excel?
💡 Hint: What visual aids does Excel provide?
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What is the primary function of a pivot table?
💡 Hint: Think of how the tool processes large amounts of information.
True or False: Macros can only be used in Excel.
💡 Hint: Consider if other office applications might also have similar functions.
1 more question available
Challenge Problems
Push your limits with advanced challenges
You have sales data for the last five years. Create a pivot table and a corresponding chart to show the yearly growth trend.
💡 Hint: Think about how to set up your rows and columns in the pivot table.
Design a macro that formats a monthly report with specific headings, bolds certain key data, and adds a footer.
💡 Hint: Consider what actions you take every month to format that report.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.