Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Application of INSERT FUNCTION | Basic Formulas and Functions
Excel Essentials
course content

Course Content

Excel Essentials

Excel Essentials

1. Introduction to Excel
IntroductionGetting Acquainted with ExcelExcel InterfaceEntering DataChallenge
2. Entering and Formatting Data
Formatting CellsFormatting TextFormatting NumbersChallenge
3. Basic Formulas and Functions
Introduction to Formulas and FunctionsUsing Cell ReferencesUnderstanding RangesCommon FunctionsApplication of INSERT FUNCTIONChallenge
4. Advanced Formulas and Functions
Displaying and Highlighting FormulasIF Logical Test and Relational OperatorsNested IF StatementsCompound Logical Tests with AND, ORUsing Auditing ToolsConditional FormattingChallenge
5. Data Management and Analysis
Sorting DataFiltering Data Using AutoFilterClearing and Reapplying FiltersRules and SearchCreating and Managing TablesTable Styles and Quick Formatting OptionsUsing Table ToolsChallenge
6. Visualizing Data with Charts and Graphs
Types of ChartsCreating a Basic ChartCustomizing Chart ElementsChanging Chart Styles and ColorsAdding and Removing Chart ElementsEditing Data in ChartsAdding Trendlines to ChartsChallenge
7. Working with Worksheets and Workbooks
Add, Delete, Rename, and Rearrange WorksheetsGrouping and Ungrouping WorksheetsUsing the Format PainterInserting and Deleting Columns, Rows, and CellsHiding and Unhiding Columns and RowsSaving WorkbooksOpening and Closing WorkbooksProtecting Workbooks with PasswordsUsing TemplatesChallengeSummary

Application of INSERT FUNCTION

The INSERT FUNCTION (Fx) Command is your secret weapon for mastering Excel.

This powerful tool opens up a world of built-in functions, making calculations, data analysis, and manipulation a breeze.

In this chapter, we'll dive into how to use the INSERT FUNCTION command to supercharge your Excel skills.

Key Points

  • The INSERT FUNCTION command (labeled as Fx) is found on the Formula bar;
  • The Insert Function dialog box allows you to search or browse through categories;
  • Function Arguments are values or references that the function needs to perform its calculation;
  • Excel's AutoComplete feature suggests function names and syntax as you enter arguments;
  • You can select up to 255 different ranges or cells to include in a single function.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Mark tasks as Completed

Everything was clear?

Section 3. Chapter 5

Choose your plan

Application of INSERT FUNCTION

The INSERT FUNCTION (Fx) Command is your secret weapon for mastering Excel.

This powerful tool opens up a world of built-in functions, making calculations, data analysis, and manipulation a breeze.

In this chapter, we'll dive into how to use the INSERT FUNCTION command to supercharge your Excel skills.

Key Points

  • The INSERT FUNCTION command (labeled as Fx) is found on the Formula bar;
  • The Insert Function dialog box allows you to search or browse through categories;
  • Function Arguments are values or references that the function needs to perform its calculation;
  • Excel's AutoComplete feature suggests function names and syntax as you enter arguments;
  • You can select up to 255 different ranges or cells to include in a single function.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Mark tasks as Completed

Everything was clear?

Section 3. Chapter 5

Choose your plan

Application of INSERT FUNCTION

The INSERT FUNCTION (Fx) Command is your secret weapon for mastering Excel.

This powerful tool opens up a world of built-in functions, making calculations, data analysis, and manipulation a breeze.

In this chapter, we'll dive into how to use the INSERT FUNCTION command to supercharge your Excel skills.

Key Points

  • The INSERT FUNCTION command (labeled as Fx) is found on the Formula bar;
  • The Insert Function dialog box allows you to search or browse through categories;
  • Function Arguments are values or references that the function needs to perform its calculation;
  • Excel's AutoComplete feature suggests function names and syntax as you enter arguments;
  • You can select up to 255 different ranges or cells to include in a single function.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Everything was clear?

The INSERT FUNCTION (Fx) Command is your secret weapon for mastering Excel.

This powerful tool opens up a world of built-in functions, making calculations, data analysis, and manipulation a breeze.

In this chapter, we'll dive into how to use the INSERT FUNCTION command to supercharge your Excel skills.

Key Points

  • The INSERT FUNCTION command (labeled as Fx) is found on the Formula bar;
  • The Insert Function dialog box allows you to search or browse through categories;
  • Function Arguments are values or references that the function needs to perform its calculation;
  • Excel's AutoComplete feature suggests function names and syntax as you enter arguments;
  • You can select up to 255 different ranges or cells to include in a single function.

Task

  • Select G29. Click Fx. Select SUM function, click OK.
  • Select from C22 to C28. Click on Number 2.
  • Select D22 to D28. Click on Number 3.
  • Select E22 to E28. Click Number 4.
  • Select F22 to F28. Click ΟΚ.

Section 3. Chapter 5
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt