Thanks!

Thanks for being a great group of kids. I also teach Multimedia Technology, sign up, I would love to see you all again. Have a nice break.

Mrs. Gannon

Practice Final Exam Excel

The Microsoft Word questions that you answered on Thursday were very difficult. I will show everyone on Monday how to complete the questions you were having trouble answering. Don't worry, once I demomstrate, you will see how easy the questions really are.

I scheduled the Practice Final Exam for Excel. I went through the entire exam and I got every question right and you should be able to also. Here are a few tips:

Question 1:
This is asking you to make the cell an absolute reference, remember, press f4 to make the cell an absolute reference.

Question 5:
Click the merge and center icon.

Question 7:
Press the delete button

Question 9:
Pick the finacial category and then scroll down to find PMT

Question 11:
Click the cut icon (it is a pair of scissors) that is location on the left of the ribbon.

Question 12:
Right mouse click and pick delete and then click ok to shift cells up.

Question 13:
Right mouse click and pick delete.

Question 20:
Click the format painter icon (it looks like a paint brush) that is located on the left of the ribbon.

Question 21:
Click the Layout Tab (underneath Chart Tools) and then click the down arrow by Data Labels. Choose More Data Labels Options. Place a check mark next to Value and uncheck the category name.

Question 22:
Click the Format Tab (underneath Chart Tools) and then click the more options arrow in the Shape styles group. A galley of all the different styles will appear and then pick the style that is in column 3 row 4.

Question 24:
Click the Autosum icon on the right side of the ribbon

Question 26:
Click the icon that looks like a dollar sign.

Question 29:
Click the icon located in the Alignment group that displays ab and an arrow. (That is the rotate text icon) Then pick Angle Counterclockwise.

Question 32:
Click right above row 1 on the area that looks like a white triangle.

Question 33:
Right underneath the autosum icon, there is an icon that looks like a blue arrow pointing down. (Fill series icon) Click on it and then click on Series, click Month.

Question 35:
Click the merge and center icon.

Question 39
Type =sum(hours)*sum(words)

Practice Final Exam Word

Hello Computer Applications Students!

Today you will be taking the practice fianal exam for Word. Do the best that you can, you will be getting points for taking the exam. It is very hard, so you can work with the people around you to get all of the questions correct. I gave everyone 5 attempts to get the question right. If you do not finish the questions, you can finish them on Monday. There are also three questions that I will be deleting from the final exam. They are WD 1394, WD 1131, and WD 931.

On Friday, you will be taking a practice final exam for Excel.

Assignments for Chapter 4 Excel

Hello,

Today we will finish up the chapter so your assignments will be:

Apply your knowledge, page 323-325. There is a data file on the p:drive
Flash cards for Excel chapter 4. Remember type in 30.
Make sure you completed the training for Excel Chapter 4