Question

Create a Word Bank used in creating formulas and function in Excel. Copy and fill out the table. Terminologies/Symbols Descriptions Formula Function = =round( ) =min ( ) =max( ) =sum( ) =average( )

Answer 1

Below is a Word Bank with terminologies, symbols, descriptions, and examples of formulas and functions commonly used in Excel:

Term/Symbol Description Example

1. = Equals sign =A1 + B1
2. round( ) Rounds a number to a specified number of digits =ROUND(A1, 2)
3. min( ) Returns the minimum value among the specified values =MIN(A1:A10)
4. max( ) Returns the maximum value among the specified values =MAX(A1:A10)
5. sum( ) Adds up all the numbers in a range =SUM(A1:A10)
6. average( ) Calculates the average of a range of numbers =AVERAGE(A1:A10)

So, the (Equals sign) is used to start a formula in Excel. It tells Excel that what follows is a calculation. Example is =A1 + B1 adds the values in cells A1 and B1.

The round( ) Function is used to round a number to a specified number of digits.