Scribd
Upload
10 views8 pages

Common Excel Formulas and Functions

The document outlines common Excel functions including SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, and COUNTA, explaining their purposes and how to use them. It also discusses data validation features, such as controlling user input and creating drop-down lists for data entry. Additionally, it introduces the VLOOKUP function, which allows users to search for values vertically in a spreadsheet.

Uploaded by

mariandelldecember161999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views8 pages

Common Excel Formulas and Functions

The document outlines common Excel functions including SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, and COUNTA, explaining their purposes and how to use them. It also discusses data validation features, such as controlling user input and creating drop-down lists for data entry. Additionally, it introduces the VLOOKUP function, which allows users to search for values vertically in a spreadsheet.

Uploaded by

mariandelldecember161999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

Common Excel

Formulas and
Functions
The SUM function adds values. You can
add individual values, cell references or
ranges or a mix of all three.

The AVERAGE function in


Excel calculates the arithmetic mean of
the supplied values.
The MIN function is a premade function in Excel,
which finds the lowest number in a range. It is
typed =MIN. The function ignores cells with text.
It will only work for cells with numbers. Note:
There is another function called MAX, which finds
the highest value in a range, the opposite of MIN.
The COUNT function counts the number of cells that
contain numbers, and counts numbers within the list
of arguments. Use the COUNT function to get the
number of entries in a number field that is in a range
or array of numbers.
COUNTIF function (counts the number of
cells that meet a criterion) COUNTA
function (counts the number of cells that
are not empty in a range)
Data validation is a feature in Excel which is used to
control what users can enter into a cell. It allows you to
dictate specific rules. It also allows users to display a
custom message if users try to enter invalid data.
A drop-down list makes the user select text or values from a list
of options, instead of typing them manually in a cell. This enables
you (the creator) to control all data entries for important cells. The
drop-down list is the most popular data validation tool in Excel.
VLOOKUP stands for Vertical Lookup. As
the name specifies, VLOOKUP is a built-in
Excel function that helps you look for a
specified value by searching for it vertically
across the sheet.

You might also like