sy2016-2017 2ND QTR MICROSOFT EXCEL EXAM
best of luck to you! hopwood email address example: bigcoloma.daddy@hopwoodcnmi.org
Email address
NAME
Your answer
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
Please complete the captcha before submitting the form.
Submit
Never submit passwords through Google Forms.
This form was created inside of CNMI Public School System. Report Abuse - Terms of Service - Additional Terms