Advance Search

  • All
  • Level I
  • *
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • Level II
  • *
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • Level III
  • *
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • *
Title
1.2.1 Saving a Workbook
Unattempted
2.1.1 Creating a New Workbook
Unattempted
2.2.1 Performing Calculations with Formulas
Unattempted
2.3.1 Entering a Function
Unattempted
2.5.1 Using Relative, Absolute, and Mixed References
Unattempted
3.2.1 Changing the Date Format
Unattempted
3.2.2 Formatting Numbers
Unattempted
3.3.1 Merging a Heading
Unattempted
3.5.1 Applying a Theme
Unattempted
4.3.1 Deleting and Editing the Cell Content
Unattempted
5.1.1 Creating a Simple Chart
Unattempted
5.2.1 Changing the Chart Color
Unattempted
5.2.2 Changing the Chart Style
Unattempted
5.2.3 Editing a Legend in the Chart
Unattempted
5.2.4 Creating a Column Chart and Switching its Rows and Columns
Unattempted
6.1.1 Splitting a Large Worksheet
Unattempted
6.2.1 Setting Page Margin
Unattempted
6.2.2 Setting and Saving the Print Area
Unattempted
6.2.3 Adding a Header
Unattempted
6.3.1 Saving a Workbook as a PDF File
Unattempted
7.1.1 Checking Compatibility
Unattempted
7.2.1 Creating a Workbook from a Template
Unattempted
1.1.1 Inserting Hyperlink to an Image
Unattempted
2.1.1 Creating Names for Cell Ranges
Unattempted
2.1.2 Editing Names
Unattempted
3.1.1 Sorting Data
Unattempted
3.1.2 Sorting by Multiple Columns
Unattempted
3.2.1 Filtering Data 
Unattempted
3.2.2 Formatting Data as a Table
Unattempted
3.3.1 Creating Formulas Using Structured References
Unattempted
5.1.1 Creating a PivotTable Automatically
Unattempted
6.3.1 Inserting WordArt
Unattempted
6.3.2 Inserting SmartArt
Unattempted
7.2.1 Customizing Sparklines
Unattempted
8.2.1 Adding Comments
Unattempted
8.2.2 Merging Shared Workbooks
Unattempted
1.1.1 Using the IF Function
Unattempted
1.1.2 Using the SUMIF Function 
Unattempted
1.1.3 Using the SUMIFS Function
Unattempted
1.2.1 Using VLOOKUP
Unattempted
1.2.2 Using the MATCH Function
Unattempted
2.3.1 Using an Array Formula
Unattempted
2.3.2 Using an Array Function
Unattempted
3.1.1 Performing Calculations Using Date Functions
Unattempted
3.1.2 Performing Simple Time Calculations
Unattempted
3.2.1 Using the Concatenate Function
Unattempted
3.3.1 Calculating the Minimum and Maximum Sales Value
Unattempted
4.1.1 Importing Data from a File
Unattempted
4.2.1 Exporting to a Text File
Unattempted
6.3.1 Creating a Blank Form
Unattempted
1.2.1. Saving a Workbook
Saving a Workbook
Unattempted
2.1.1. Creating a New Workbook
Creating a New Workbook
Unattempted
2.2.1. Performing Calculations with Formulas
Performing Calculations with Formulas
Unattempted
2.3.1. Entering a Function
Entering a Function
Unattempted
2.5.1. Using Relative, Absolute, and Mixed References
Using Relative, Absolute, and Mixed References
Unattempted
3.2.1. Changing the Date Format
Changing the Date Format
Unattempted
3.2.2. Formatting Numbers
Formatting Numbers
Unattempted
3.3.1. Merging a Heading
Merging a Heading
Unattempted
3.5.1. Applying a Theme
Applying a Theme
Unattempted
4.3.1. Deleting and Editing the Cell Content
Deleting and Editing the Cell Content
Unattempted
5.1.1. Creating a Simple Chart
Creating a Simple Chart
Unattempted
5.2.1. Changing the Chart Color
Changing the Chart Color
Unattempted
5.2.2. Changing the Chart Style
Changing the Chart Style
Unattempted
5.2.3. Editing a Legend in the Chart
Editing a Legend in the Chart
Unattempted
5.2.4. Creating a Column Chart and Switching its Rows and Columns
Creating a Column Chart and Switching its Rows and Columns
Unattempted
6.1.1. Splitting a Large Worksheet
Splitting a Large Worksheet
Unattempted
6.2.1. Setting Page Margin
Setting Page Margin
Unattempted
6.2.2. Setting and Saving the Print Area
Setting and Saving the Print Area
Unattempted
6.2.3. Adding a Header
Adding a Header
Unattempted
6.3.1. Saving a Workbook as a PDF File
Saving a Workbook as a PDF File
Unattempted
7.1.1. Checking Compatibility
Checking Compatibility
Unattempted
7.2.1. Creating a Workbook from a Template
Creating a Workbook from a Template
Unattempted
1.1.1. Inserting Hyperlink to an Image
Inserting Hyperlink to an Image
Unattempted
2.1.1. Creating Names for Cell Ranges
Creating Names for Cell Ranges
Unattempted
2.1.2. Editing Names
Editing Names
Unattempted
3.1.1. Sorting Data
Sorting Data
Unattempted
3.1.2. Sorting by Multiple Columns
Sorting by Multiple Columns
Unattempted
3.2.1. Filtering Data 
Filtering Data 
Unattempted
3.2.2. Formatting Data as a Table
Formatting Data as a Table
Unattempted
3.3.1. Creating Formulas Using Structured References
Creating Formulas Using Structured References
Unattempted
5.1.1. Creating a PivotTable Automatically
Creating a PivotTable Automatically
Unattempted
6.3.1. Inserting WordArt
Inserting WordArt
Unattempted
6.3.2. Inserting SmartArt
Inserting SmartArt
Unattempted
7.2.1. Customizing Sparklines
Customizing Sparklines
Unattempted
8.2.1. Adding Comments
Adding Comments
Unattempted
8.2.2. Merging Shared Workbooks
Merging Shared Workbooks
Unattempted
1.1.1. Using the IF Function
Using the IF Function
Unattempted
1.1.2. Using the SUMIF Function 
Using the SUMIF Function 
Unattempted
1.1.3. Using the SUMIFS Function
Using the SUMIFS Function
Unattempted
1.2.1. Using VLOOKUP
Using VLOOKUP
Unattempted
1.2.2. Using the MATCH Function
Using the MATCH Function
Unattempted
2.3.1. Using an Array Formula
Using an Array Formula
Unattempted
2.3.2. Using an Array Function
Using an Array Function
Unattempted
3.1.1. Performing Calculations Using Date Functions
Performing Calculations Using Date Functions
Unattempted
3.1.2. Performing Simple Time Calculations
Performing Simple Time Calculations
Unattempted
3.2.1. Using the Concatenate Function
Using the Concatenate Function
Unattempted
3.3.1. Calculating the Minimum and Maximum Sales Value
Calculating the Minimum and Maximum Sales Value
Unattempted
4.1.1. Importing Data from a File
Importing Data from a File
Unattempted
4.2.1. Exporting to a Text File
Exporting to a Text File
Unattempted
6.3.1. Creating a Blank Form
Creating a Blank Form
Unattempted
Collecting data, please wait...
We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept