sy2016-2017 2ND QTR MICROSOFT EXCEL EXAM
NAME *
PERIOD *
1 point
1. Most formulas begin with an *
1 point
2. The auto sum is located at the *
1 point
3. Which toolbar feature allows you to combine multiple cells as one? *
1 point
4. The toolbar that automatically adds up a group of numbers is the *
1 point
5. The toolbar that creates black lines around cells when selected is the *
1 point
6. Which toolbar feature do you use when dealing with price? *
1 point
7. A ________ calculates values in a cell or group of cells. *
1 point
FORMULA SECTION : REFER TO THIS IMAGE WHEN ANSWERING 1i through 7i below.
1 i. Provide the formula for each numbered cell in the image. *
refer to the image on TOP EXAMPLE: =M1*N1
1 point
2 i. Provide the formula for each numbered cell in the image. *
refer to the image on TOP EXAMPLE: =M1*N1
1 point
3 i. Provide the formula for each numbered cell in the image. *
refer to the image on TOP EXAMPLE: =M1*N1
1 point
4 i. Provide the formula for each numbered cell in the image. *
refer to the image on TOP EXAMPLE: =M1*N1
1 point
5 i. Provide the formula for each numbered cell in the image. *
refer to the image on TOP EXAMPLE: =M1*N1
1 point
6 i. For this one, what do you hold down on the keyboard to automatically add the next number in sequence? *
refer to the image on TOP......
1 point
7 i. What is the cell location of \$350.00? *
refer to the image on TOP
1 point
weeklong/yearlong expense projection sheet: formulas
15. which # points to =f6*6 *
1 point
16. which # points to =e8*4 *
1 point
17. which # points to =e5*4 *
1 point
18. which # points to =g6*2 *
1 point
19. which # points to =g8*2 *
1 point
20. can you rename sheets in a workbook? *
3 points