# 8.13: What is a Function?

$$\newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} }$$ $$\newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}}$$$$\newcommand{\id}{\mathrm{id}}$$ $$\newcommand{\Span}{\mathrm{span}}$$ $$\newcommand{\kernel}{\mathrm{null}\,}$$ $$\newcommand{\range}{\mathrm{range}\,}$$ $$\newcommand{\RealPart}{\mathrm{Re}}$$ $$\newcommand{\ImaginaryPart}{\mathrm{Im}}$$ $$\newcommand{\Argument}{\mathrm{Arg}}$$ $$\newcommand{\norm}[1]{\| #1 \|}$$ $$\newcommand{\inner}[2]{\langle #1, #2 \rangle}$$ $$\newcommand{\Span}{\mathrm{span}}$$ $$\newcommand{\id}{\mathrm{id}}$$ $$\newcommand{\Span}{\mathrm{span}}$$ $$\newcommand{\kernel}{\mathrm{null}\,}$$ $$\newcommand{\range}{\mathrm{range}\,}$$ $$\newcommand{\RealPart}{\mathrm{Re}}$$ $$\newcommand{\ImaginaryPart}{\mathrm{Im}}$$ $$\newcommand{\Argument}{\mathrm{Arg}}$$ $$\newcommand{\norm}[1]{\| #1 \|}$$ $$\newcommand{\inner}[2]{\langle #1, #2 \rangle}$$ $$\newcommand{\Span}{\mathrm{span}}$$$$\newcommand{\AA}{\unicode[.8,0]{x212B}}$$

## Learning Outcomes

• Define functions in Microsoft Excel

A function is a preexisting formula in Excel that does calculations based on specific values. In previous modules, you learned a few Excel functions: COUNTIF, IF, and SUM. Excel offers hundreds of functions from broadly used to highly specialized. For now, we will focus on financial, logical and look-up functions and formulas.

## Practice Question

https://assessments.lumenlearning.co...essments/18676

A few general tips to remember about functions and formulas:

• Functions begin with an equal sign. Excel will begin suggesting functions as soon as you begin typing the equal sign.
• Functions take one or more arguments, with cell references or numbers, enclosed in parentheses.
• When a function needs more than one argument, enter a comma between the arguments without a space and close the formula inside of parentheses.
• There are multiple ways to enter functions in Excel; type in the formula bar under the ribbon (1), clicking on the fx button by the formula bar (2), select a cell and type = (3), select the Formulas tab Insert Function button (4) or select a specific function based on a category in the Formulas tab (5).

## Practice Question

https://assessments.lumenlearning.co...essments/18677

These next functions and formulas build out your skills in Excel and assist you with business, science, statistics and many other types of data analysis. Let’s get started.