Excel Assignment Help

General Help:

mathematical operators: plus (+), minus (–), divide (/), multiply (*), exponent (^),

formatting helps: percent (%), and dollar sign ($)

IF operators: uses not, and, or, =, <,<=,<>,>=,>

Address list:

Sort:
Highlight all the lines you want to sort (and not the titles). Choose the menu's Data / Sort and then in the first "sort by" choose the column with type in it. In the second "sort by" choose the column with last name in it.

Center "Address list":
If necessary, insert a blank row at the top by positioning your cursor at A1 and selecting insert / row from the menu. Then, select all the cells above the title and merge them by choosing format / cells and then choosing the alignment tab and then checking merge cells. Then, you can center your text in that one cell by pressing the center button on the toolbar. (If you find your title is centered way over the the right, you want to unmerge by selecting that cell and choosing format / cell / alignment and unchecking the merge cells box. You probably selected to merge the entire row instead of just the cells you wanted.)

Create the full name automatically:

In the cell you want the full name to appear, type "=" so Excel knows a formula is coming. Click on the first name for the row, which will bring that cell's address into your formula. (You will now have something like =A3.) Now type the & sign (above the seven). You can now insert the space between the two names by typing " ", (double quotes with a space between, so Excel will include the literal of a space). Now tell Excel more is coming by typing another &. Then click on the last name for the row. (You will now have something like =A3&" "&B3)

Fit to 1 page wide

Choose file / page setup and the page tab. Click the button next to "fit to". Since you want to restrict the width to 1 page, ensure 1 is next to "pages wide". Since you do not want to restrict the number of pages, enter 99 next to "tall".

Put in a heading of your name and a footer of page, date and filename.

Choose file / page setup and the header/footer tab. Click on custom header. Enter your name. Choose custom footer. Click on the page number button for page number. Click on the date button for date. Click on the excel button for the filename.

Counting the number of people.

At the bottom of your spreadsheet, type the word "Count" just to make it easy to read. In the next cell, type "=" and then COUNT. You can then click on the "=" or "fx" button to see the formula input. Next to value1, click on the search button, and then select all the values (not the title) in your zip code row. Then, press enter twice until the formula displays. Your formula will look like =COUNT(F3:F9).

Counting the number of people by type.

Below the count, make a little chart listing each type (F, W, X,S) and the name of each type. Then type = next to the first type to indicate a formula is coming. Then type COUNTIF and press the = or fx button. Next to range, click the search button and select the all the value in the type column and press enter. Then, click the search button next to criteria and click the type letter (F,W,X,S) that you are counting. Press enter until the formula appears. It will look something like =COUNTIF(H3:H9,D15). You can repeat the process next to every letter, (or you could put $ before the row and column in the range only and then copy the formula down to the next 3 lines.