Intro. to Microsoft Excel - Course 2

0 %

Course content

Course Materials
- Course Materials
Module 0
- Module 0- Introduction
Module 1
- Module 1 - Excel Fundamentals 10 xp
  - Quiz
Module 2
- Module 2 - Excel Essentials 10 xp
  - Quiz
Module 3
- Module 3 - Excel Formulas 10 xp
  - Quiz
Module 4
- Introduction to Excel Functions
- Date and Time Function
- Text Function
- Maths and Conditional Aggregate Function
- Statistics
- Logical Function
- Lookup Function
- Quiz 10 xp
Module 5
- Module 5 - Analysis Data with Pivot Tables 10 xp
  - Quiz
Module 6
- Module 6 - Creating Charts 10 xp
  - Quiz
Assignment -Lab
- Assignment Lab

Module 5 - Analysis Data with Pivot Tables

10 XP

Fullscreen Share

About
Comments (0)

Rating

0 0

There are no comments for now.

Join this Course

to be the first to leave a comment.

1. What is the main purpose of a PivotTable in Excel?

A) To create charts B) To summarize and analyze large amounts of data C) To calculate averages D) To organize data alphabetically

2. In a PivotTable, what is a "Row Label"?

A) The total of the values in a column B) The title of the worksheet C) A field used to group data in rows D) A filter for specific data

Additional Resources

Join this Course to access resources