PUG-IT153.ADB1
IT153 Spreadsheet Applications
- Practice in 17 Hands-On Labs — nothing to install
- 6 Interactive Lessons and 18 topics mapped to the official exam objectives
- 97 Practice Test Questions
Beginner Self-paced · 1 year access
17 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
6Interactive Lessons
18Topics
17LiveLab
97Practice Test Questions
45Flashcards
45Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
6 Interactive Lessons · 18 topics01 Getting Started with Excel 2021 5 topics · 12 LiveLab +
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
- Topic E: Use Excel Help
12 LiveLab in this lesson — see the labs panel →
02 Performing Calculations 3 topics · 8 LiveLab +
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
8 LiveLab in this lesson — see the labs panel →
03 Basic charting 2 topics · 1 LiveLab +
- Answers to this lesson’s questions
- Problems
1 LiveLab in this lesson — see the labs panel →
04 Managing Workbooks 3 topics · 14 LiveLab +
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
14 LiveLab in this lesson — see the labs panel →
05 Recording macros 2 topics +
- Answers to this lesson’s questions
- Problems
06 Using the Scenario Manager for sensitivity analysis 3 topics +
- Answer to this lesson’s question
- Remarks
- Problems
Hands-On Labs Our edge
17 LiveLabs- Exporting Ribbon Customizations as a File
- Adding and Replacing Data in a Cell
- Creating and Saving a Workbook
- Copying and Pasting the Data
- Creating Worksheet Formulas
- Determining the Minimum Value
- Determining the Maximum Value
- Reusing Formulas
- Calculating the Sum
- Calculating the Average
- Creating a Scatter Chart
- Deleting a Worksheet
- Hiding a Worksheet
- Adding a New Worksheet
- Adding Color to the Worksheet Tab
- Making a Copy of the Worksheet
- Freezing the Top Row
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Prepare for IT153 Spreadsheet Applications
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 17 LiveLab included
- Certificate of completion
No credit card required