Microsoft Excel Functions & Formulas

1. The function that lets you add up a range of cells or values

• SUM

• MIN

• AVERAGE

• MAX

2. What function was used to find the lowest grade?

• average

• sum

• min

• max

3. What function was used to find the highest grade?

• average

• min

• sum

• max

4. SUM, AVERAGE, IF, MIN and MAX are examples of _______.

• user-defined functions

• table functions

• online functions

• predefined functions

5. All formulas used within the table are seen on the __________

• cells

• name box

• cell reference

• formula bar

6. The function COUNT is specific for ___________

• counting cells

• counting text

• counting numbers

• counting tables

7. To sort names in a worksheet, we can use this button.

• 
• 
• 
• 

8. In a worksheet, the vertical spaces with the headings A, B, C and so on

• cell

• column

• row

• data

9. To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

• &

• #

• =

• *

10. Microsoft Excel is categorize as ?

• Database Software

• Word Processing Software

• Spreadsheet Software

• Presentation Software