ict excel functions

• SUM()


  Calculates the sum of values in a specified range
• AVERAGE()


  Calculates the average of values in a specified range
• COUNT()


  Counts the number of cells in a specified range
• COUNTA()


  Counts the number of cells that contain any form of content, excluding blanks
• COUNTBLANK()

  Counts the number of blank cells within a specified range
• IF()


  Checks whether a condition is true or false and returns one value if true and another if false
• COUNTIF()


  Counts the number of cells within a range that meet a specified condition
• MAX()


  Returns the largest value in a range of values
• MIN()


  Returns the smallest value in a range of values
• LARGE()


  Returns the nth largest value in a range
• SMALL()


  Returns the nth smallest value in a range
• RANK()


  Returns the rank of a value in a dataset
• SUMIF()


  Adds up values based on a specified condition
• AVERAGEIF()


  Calculates the average of numbers based on a specified condition
• VLOOKUP()


  Searches for a value in the first column of a table and returns a value in the same row from a specified column
• HLOOKUP()


  Searches for a value in the first row of a table and returns a value in the same column from a specified row
• CONCATENATE()


  Combines multiple text strings into one string
• Conditional Formatting


  Allows you to highlight cells with a certain color, depending on the cell's value
• Sort


  Allows you to sort by date, number, alphabetic order and more
• Freeze Panes


  Keep specific rows or columns visible while scrolling through a large worksheet
• Data Validation


  Control the type and format of data entered into cells
• PivotTables


  Summarize and analyze large datasets by rearranging and summarizing data from different perspectives
• Sparklines


  Insert miniature charts into cells to visualize data trends at a glance
• Charts


  Helps us to represent data in graphs and line with markers
• Filter


  Will separate your Excel data if you only want to display records that meet certain criteria