Excel

=Microcomputer Applications Excel Assignments:=

Create a spreadsheet such that:

 * 1) column A is the numbers 1-20
 * 2) column B is the square roots of column A
 * 3) column C is the SQUARE of the numbers of column A
 * 4) column D is the Cube of column A
 * 5) column E is the sum of 2 times column A and 3 times column C divided by column D
 * 6) your name is in cell A22
 * 7) directly under the last cell in each column insert the average function so that the average of each column will be computed

Part 2
Create a new spreadsheet. Column A contains the first name of people in the left row (adjust column width). Column B contains the names of people in the back. Column C contains the names of people in the right hand row. Copy column A to D Copy column B to E Copy column C to F Sort column D in descending order Sort column E in ascending order Sort column F in ascending order

Insert a column between B and C Insert a column between E and F Insert a row between 2 and 5 Insert a row between 5 and 6 Place your name in cell A22.

Assignment 2: CIA World Fact Book
Use the CIA Worldfactbook to obtain the needed information. The CIA Worldfactbook can be located using the Webcrawler. Find the death rate, estimated population, birth rate, life expectancy male, life expectancy female of each of the following countries: USA, England, France, Germany, Brazil, Mexico, Iran, Iraq, and Spain Use Excel to make a spreadsheet of the information. In column A place the names of the countries. In column B place the population data. In column C place the death rate data, and so forth. Below the last country name skip one row. Below the skipped row type the word Average. Put the average function across that row to find the average of each statistic Adjust any column widths to be sure all data fits in the columns. Make a bar graph to compare the death rates of the countries. Make 2 line graphs on the same axes to compare the life expectancies of males and females. Be sure to label graphs properly. Put your name in cell A22.

Create a new spread sheet. Place these names in column A: Alfie, Ralphie, Mel, Belle, Mary, Terri, Larry, Sherry, Jill, Bill. Place these scores in column B: 48,93, 72, 84, 91, 19,47, 63, 74, 68 1. Copy columns a and b onto columns d and e. 2. Copy columns a and b onto columns f and g. 3. Copy columns a and b onto columns h and i. 4. sort d and e according to e and in ascending order. 5. Sort f and g according to f but in descending order. 6. Sort h and i according to I and in ascending order. assignment: Make a 2d bar chart of columns a and b. Make a 3d bar chart of columns a and b.

Here is data on the last production run of the Wacko Widget Works. red widgets...12000 green widgets... 6720 blue widgets...3215 purple widgets...250 puce widgets...2750 pink widgets...1500 Place this data into a spreadsheet. Add a function to find the total # of widgets. Make a bar chart and pie chart of the data, not the total. Add Percentage data labels. Place your name in cell a22.

In a recent ball game the players on the Connecticut team scored the following points: Freeman...5 Hamilton....24 RickMoore....6 Voskuhl....2 El-Amin.....18 Wane...........0 Harrison....0 Jones..........4 Saunders......5 Mouring...0 Make a spread sheet, pie chart and bar chart of the Data. Add a function to find the total # of points scored. Add percentage data labels. Add your name

Use internet resources to find the expected high temperature for today of the capitol cities of:
1. Vermont 2. North Carolina 3. Florida 4. Kansas 5. Washington 6. California 7. Arizona 8. Minnesota 9. Tennessee Enter the data into a spreadsheet and add a function to calculate the average high. Use a spread sheet to create a line graph of these expected highs.

You choose the stores.
Enter the data into a spreadsheet and add a function to calculate the average price. Use a spreadsheet to create a bar graph of the prices. Add your name.

The weekly budget of Pepe's Prestigious Pizza Parlor is as follows:
flour..........$375 sauce..........$750.00 cheese.........$1250.00 pepperoni.......$500.00 salaries.......$1,200.00 other..........$2,500 (building, insurance, etc) Use a spreadsheet to create a pie chart of the business's budget. Add your name