Excel 2007 Practice Exam

Yesterday we took a practice exam. Usually whenever we work on anything in Excel, the steps aren't too difficult, however, I saw a few things I wasn't familiar with. I had never used a Text Function in this program before so I really had to wing it. I remember specifically the question asked to use the lowercase function, and miraculously I found it.

Excel Review

1. The simplest way to enter data in a worksheet is to click the cell in which you want to enter data and type.

2. The purpose of AutoFill and FillSeries is to enter patterns of data or a series of data by more quickly and efficiently.

3. When using AutoFill, there are four options that appear:
a. Copy Cells
b. Fill Series
c. Fill Formatting Only
d. Fill Without Formatting

4. The Pick from Drop-down List action can be used for more options than what is initially shown on the icon.

5. The Paste Options button appears on the far right of the Ribbon in the Home tab. In a spreadsheet it may be used to copy data from cells and pasted to other cells or worksheets.

6. You may locate specific data on a work sheet by using the Find & Select feature located on the far-left side of the Ribbon in the Home Tab.

7. The Replace tab in the Find & Select dialogue box can be used to replace or correct specific data in a worksheet.

8. Three proofing and Research tools available in Excel 2007:
a. Spelling Checker
b. Thesaurus
c. Translator
9. You can create a Data table in Excel 2007 by clicking on the Table icon on the Insert tab.

10. The purpose of a Total row in a table is to calculate the total value of data in a specific series of cells.

Summary: Correcting & Expanding Upon Worksheet Data

Checking for errors is always a great idea. Checking for corrections in formulas or numeric values should always seem obvious, but Excel has a Spelling Checker feature. This feature highlights possibly-misspelled words and gives a lists correctly spelled words. There is also a translation, and a thesaurus feature.

Summary: Finding and Replacing Data

Some worksheets in Excel contain very little data in which it is very easy to find mistakes and correct them. However, worksheets contain billions of cells. When there is a ton of information in a worksheet it becomes difficult to find certain data among a pile of data. Learning to use the Find & Replace feature is very important as it may save one a whole lot of time and frustration.

Summary: Entering and Revising

The easiest way to insert data is to select a cell and type a value. However, this method may only be effective when entering small pieces of info. However I prefer the AutoFill, and FillSeries features. It is a quick and efficient way to enter data which in other cases is just boring. In my opinion, simple little things like that make a huge difference

Current Event 2

Despite the negative feedback from the citizens who attended President Calderon's speech, Mayor Cook says Mexico's Cabinet was a good start and the President was honest about the problems facing Juarez.

I don't know if anybody really knows what the solution is," said Cook. Maybe it's true. some people, including myself, are rather quick to judge the government's faults instead of noticing what is being done about the problem. All that can we can do right now is watch and ultimately show support.

Current Event 1

In the newspaper on Friday, February 12, 2010, the headline was about the public address made by President Calderon (Mexico). In this address he stated that his administration was doing as much as possible to crack down on government corruption, and organized crime. However, the citizens of Juarez did not buy it. Relatives of massacre victims demand the President's resignation.

In my opinion, Mexico's war on drugs will not successfully come to a halt unless the United States military steps in to help. Until then, the corruption in the government is overwhelming any effort the government is putting forth to stop the violence.

Excel Tasks 11-20

Enter Number - Select the cell that you want to enter numbers into, then type the number, or you can go up to the formula bar and type it.

Exit Excel - Go up to the Microsoft Office Button and click Excel.

Fill Series - Drag and Drop. Choose the cell you want use. Go to the bottom right corner of the cell and drag down. You'll see a gray area of what you selected.

Font Size - Select the cells you want to use and go to the home tab. Then go to the font group and select your size.

Fonts - Select the cells you want to use and go to the home tab and font group. Then choose the font you want to use.

Function (AutoSum) - Select the cells in which you want to use the autosum function. Go to the home tab and editing group and click the auto sum button.

Go To - In the home tab and editing group, click the "find and select" icon and choose Go To when you finsh choosing where you want to go.

Help (Display Help Contents) - At the top right corner there is a blue question mark. You must click on the icon, and then in the box, click on the purple book to show the contents.


Help Search - At the top right Corner there is a blue question mark icon.
Click on it and type what you are searching for.

Modify Formula - In the Formula bar, you can change cells by typing which formulas you wish to use.

Excel Tasks 1-10

Apply Style - Choose the cells you want to edit. Go to the home tab. Click the cells style button and select your style.

AutoCorrect - Click on the Microsoft office button and click the excel options. When the dialogue box pops up, go to the proofing tab, then click auto corrects optionThen you click the changes you want to make and click okay.

Bold Cell Contents - Choose the cell you want to bold. Go to home tab and in the font group click bold.

Cell Formatting -Select the cells you want to remove formatting from. In the home tab and editing group click on the eraser and clear formating.

Center Across Cells - Select the cells then in the home tab and cells group click formate button, then choose format cells , go to alignment group and under text alignment click center across.

Create Chart - Go to the insert tab then go to charts group and selct the chart you want.

Clear Cells - Select the cells you want then go to home tab and editing group. Click on eraser then chose clear contents.

Color Text - Choose the cells you want to color in the home tab and font group. Click the font color arrow then choose the color you want to get.

Copy Cells - Select the cells you want to copy. Then go to home tab and clipboard group and click copy.

Create New Blank Workbook - Click on the office button then. Then click blank workbook.

Apple Unveils the iPad

Apple recently released their newest gadget called the "iPad." It is a tablet that can run more than 140,000 apps that were made so popular by the iPhone. However, the device seems rather pointless to me. Pretty neat. But rather unnecessary. I don't completely understand what the use of it is which could be the reason for the lack of my interest. No disrespect to Apple, or the engineers who developed this modern marvel, but I would just rather have an iPhone.