Name Period
EXCEL 2013 Formulas & Functions Worksheet
Directions: From the shared drive, open the Excel 2013 Formulas & Functions Worksheet (Word file). Open the Excel 2013 Formulas and Functions PowerPoint. Use the presentation to help you answer the following questions. Use the Tab key to move from one entry box to the next. Save as: “Lastname Firstname Formulas & Functions P#”. Close the file and copy it to the Student Dropbox. Fill in your name and period on the grading sheet and turn it into the basket.
1. / What is input?2. / What is output?
3. / What three types of information can be typed in a cell?
a.
b.
c.
4. / Labels are / Identify in columns and rows
5. / Labels are / aligned.
6. / Excel recognizes a number as a label if an / precedes the number. EX: ‘2007
7. / What are values?
8. / Formulas are used to perform such as adding, multiplying and averaging.
9. / Values are aligned.
10. / If the value (number) is too large for the cell a sign displays in the cell.
11. / The first character in the cell with a formula must be an / sign.
A formula looks something like this: =f4+g4
12. / What are the Arithmetic operators (symbols) that do the following operations:
a. / Addition / b. / Subtraction
c. / Multiplication / d. / Division
13. / Complex formulas contain more than one operation. The sequence used to calculate the
value is called the / of / .
14. / Operations inside / are calculated before other operations. If no parenthesis then:
a. Calculated 1st
b. Calculated 2nd / and / left to right
c. Calculated 3rd / and / left to right
15. / True / or / False / It is more effective to use a cell reference than values in a formula or function. If the values are edited or changed, then the formula automatically recalculates.
16. / A function is a / built in the worksheet that enables you to do complex calculations easily.
17. / Functions begin with a / sign. An example of what a function is the following:
=AVERAGE(B15:E15)
18. / Common Functions used in Excel (match the function to the calculation; they are not in order)
a. / Calculates the sum of a range of cells
b. / Calculates the average of values in a range of cells
c. / Calculates number of values in a range of cells
d. / Displays smallest value in a range of cells
e. / Displays largest value in a range of cells
19. / The Autosum tool is a built-in SUM function. It is the most used function.
20. / If Excel doesn’t select the range you want to sum, what should you do?
21. / A is a group of cells (two or more).
22. / A range of cells can be / .
Name the three types of cell references used to create formulas and describe each:
a.
b.
c.
24. / How can you show the formulas instead of the values: This is a toggle feature off/on
25. / The will be lost when you show formulas.