Mohammad Rifky. Elif Demirel. Alfredo Sánchez Alberca. Basic Excel Manual for Economics and Business Administration. Log in with Facebook Log in with Google. Remember me on this computer. Enter the email address you signed up with and we'll email you a reset link. Need an account? Click here to sign up. Download Free PDF. Excel Assignments dayo tom. Continue Reading Download Free PDF. Related Papers. Microsoft Excel Step by Step. Download Free PDF View PDF. Excel Data Analysis － Your visual blueprint for creating and analyzing data， charts and Pivot Tables，3ed. using excel for business analysis. Data analysis with microsoft excel updated for office. Basic Excel Manual. Computer Technology Assignment 1 Microsoft Excel 1.

This will open up a Word Document. This is a basic tutorial on Excel and on Excel vocabulary, which will be what is on the final at the end of the semester. Print a copy of Assignment 1, then answer the questions on it as you go through the tutorial. At the end of the tutorial there will be a quiz. Take the quiz, and print the results. Staple your quiz to the tutorial and turn into the basket when finished. Computer Technology Assignment 2 Microsoft Excel 1. Here you have the nutritional information for some of the items on the menus of various fast-food restaurants.

First we are going to move the contents in Cell A2 into A1. Click on cell A2. Place your cursor on the EDGE of the cell so that it turns into a four-sided arrow. Then drag it up one cell, into cell A1. Now lets make column A wider so we can see the contents easier. Place your cursor between the A and B so that it turns into a two-sided arrow. Double click. The column should automatically re-size to the length of the longest word in that column. Highlight Row 1. Right click on the area you have highlighted and choose Insert from the menu. Highlight cells A1-F1 and press c. Change the font size to Change the color to a color of your choice by clicking on the button.

Change the font to a readable font of your choice. Now highlight cells A2-F2. Change the color of the fill to yellow by clicking on the button. Change the font to Bold it by clicking on the button. Now highlight row Right click and Insert. Highlight AF Change the color of the fill to red, the size to 14, and bold it. Now we need to copy and paste the information from sheet 2, for Burger King. Click on Sheet 2 at the bottom of your screen. Highlight cells a A1-F Now highlight cells AF Choose from the home ribbon. Highlight cells AF You have now copied the format to the new cells. Change the fill color to blue.

Highlight cells A3-F Go to the Data Ribbon. Click on the sort button. Pull down the sort by menu, and choose Calories from the list. Sort this one by size. Highlight cells A37 — F Sort this one alphabetically. Now highlight rows Change the font to 8. Do the same for rows , and rows Double click between the A and B again to resize column A, now that the font is smaller. Click on the borders tab and choose All Borders. Do the same for cells AF34, and AF Highlight cells B3-F3. Right click and choose Format Cells. Click on the Alignment tab. Change the orientation to 45 degrees.

Do the same for cells BF And again for cells BF Now we are going to insert some pictures. Go to the internet, and to Google Images. Find a logo that is rather small. Click on it, then go to See Full Size Image. Right click and save this logo into your My Pictures folder. Go back to your assignment and click on Insert, then Picture. Place it roughly in column G. Do the same for the other three logos. Add a header. Go to the Insert ribbon, and choose Header. Type your name in the left column, and Assignment 1 in the middle column. Go to View, and choose Normal to get back to your original view. Check to make sure that your document is only 1 page long. Click on the Office button, go to print, and then print preview.

Check the bottom of the page to see that it says page 1 of 1. If it IS only one page, you are ready to print. Make sure you SAVE this document in MY DOCUMENTS. Then print it and turn it into the basket. Open Microsoft Excel. Choose Assignment 3 from the Spreadsheet file in Computer Technology. Now you will sort the gymnasts, first by county, then by name. Highlight cells A2-G Go to the Data ribbon, and choose sort. In the pull down menu next to Sort By, choose Country. Click Add level. In the next pull down menu, choose name. Press ok. Highlight cells A2-H2.

Go to the Home Ribbon and choose Wrap Text from the menu. Underline cells A2-H2. Highlight A3-A Click on the Alignment Tab. Click to put a check mark next to Shrink to fit. Now the names should all fit, without you having to widen the column. Highlight cells C3-H3. Click on the button in the Home Ribbon. You now have a total for Jade Barbosa. Once you have done it a few times, review using autofill. Highlight cell H4 and put your cursor on the lower right hand corner until it turns into a black plus sign. Drag down to row Now highlight cells C3-C Use the button again to total the scores for uneven bars. Do the same for all the other events. Time to find the Average. You have to be careful because you do not want to calculate the Total into the average!

Put your cursor in cell C Then highlight cells C3-C NOT the total. You should get If you got a much higher number, that is because you calculated the total with it. Now do the same for each of the events. Formatting — Highlight cells AH Change the background color by clicking on the button. Do the same for A2-H2. Highlight A1-H1. Change the font to 16 and choose a readable font of your choice. Highlight cells A1-H Change the borders to All borders. Then choose Thick Box border from the list. Add a header and print. Turn into the basket. This is a list of Student Loans from Summer Ridge Community College. Make the following changes to the look of the sheet: a. Highlight A1-I1 and center across using the button.

Do the same to A2-I2. Change the font size to 18 pts. Change the font to Times New Roman. Highlight A3-I3. Click on the button. With the cells still highlighted, center them. Then Underline. Change the shading to gray. Double click between the A and B to widen column A, so you can see all names. Now you will be changing the format of several of the columns. Highlight column B. On the Number tab, choose Special, and Social Security Number. Highlight column C. At this school, account numbers are formatted as -. You will have to do a custom format. Go to Format Cells, and choose Custom. In the Type box, type - and press ok.

Highlight column D. Press the button to change the format to money. Highlight column E. Go to Format Cells, and choose Date from the Category list. Double click between the E and the F to resize column E. Resize any other column that needs it. Now we will calculate the monthly payments required by each account, in the F column. Place your cursor in cell F4. The minimum due is determined by one payment every 12 months for ten years. This is really TWO math problems, but it can be done in one formula as follows: i. Type the first problem—the amount due divided by 10 years which tells you how much they must pay EACH YEAR into parenthesis. Then divide that by 12—the 12 months of one year. Now you will calculate the interest for each payment and add it to your total.

Again, this is TWO problems you will put in one formula. Sort — Currently the names are sorted by name. We want to sort them by account number. Highlight cells A3-I Go to Data, Sort. Sort by Account number and press ok. Tabithah Garland should now be the first name on the list. Filter — Now you will use a filter to answer the questions on the Questions Worksheet. Highlight cells A3-I31 and click on Filter. Now there are pull down arrows on each row. Click on the Questions worksheet and answer the questions using your filter. When you are trying to find an answer, make sure you are filtering the right column.

When you are finished, make sure you pull down the arrow again and choose ALL to show all listings again. To get these answers, you will be using Sort A-Z and Number Filters as well. Make sure you test them out! When finished, add a header to both pages and print both. Staple them and turn in to the basket. Your teacher has asked you to record grades for one of her classes. You are to list the assignments and test, compute the total points for each and calculate the percentage and assign the grade. Key in the worksheet below.

Be sure to add a Header with your name, period, and assignment number. Add a first name for each of the last names given. After keying in the column headings and column A, add gridlines with the border key. Widen columns to accommodate all entries do not cut off any information. Use auto sum to find the totals in column F. To find percent in cell G5, divide the total by the points possible— Format column G to a percent by highlighting the cells and press the button from the tool bar. Sort the students and all information about each A-Z. Enter the cells to be averaged between the parenthesis. Auto fill the formula across. Enter the cells to be maxed between the parenthesis. Enter the cells to be min between the parenthesis. Format the document to look like the one below.

Print preview, print, and turn into the basket. Open Student Common and choose assignment 7. Type in the information from the in-class survey. If you were absent that day, use the information given below. Before making the charts, right click on the Assignment 6 tab. You will make four graphs for each survey, as indicated below: a. Birthdays — Pie i. Highlight cells A4-B Go to the Insert tab and choose Pie from the list. Choose a style. In the Chart Layouts, choose a layout that shows the percentages. Change your chart title to Birthdays. Highlight your graph and choose move chart from the toolbar. Arrange the chart on the new sheet you created. Highlight cells D3-F Create a line chart. Choose a chart layout, and title your chart Cumulative GPA and then your name.

Right click on the left axis and choose Format Axis. Change the maximum to fixed, and then type in 4. You may change the minimum axis if you wish. Move the chart to your Graphs tab. Favorite Junk Foods — Column i. Highlight AB Go to Insert, Column, and choose a style from the first column. Now click on the first bar, pizza, so only it is highlighted. Right click. Choose Format Data Point. Click Fill. Then click on 1. Click on Picture or Texture fill. You will see a picture of pizza. Click on that. Then choose Stack and Scale. Do this for all the other columns.

General Survey — Bar i. Highlight DG Follow the same steps, adding a title and moving to the graphs column. Print only the graphs page. Make sure all of them fit on one page using print preview. If you were absent the day we did this in class, please use this information. Today you will be creating a graph in Excel which will show the popularity of your name and other names that are meaningful to you. NOTE: If you have a very unusual name that is not on the list at all or very little, you may select any other names of your choice for this assignment. Please open up a blank page in Excel. Now, go to the Social Security website.

This site tracks the top 1, names each year going way, way back. Below that, is the specific name selector. Enter your name, or the name you would like to graph, in the space provided. Indicate the gender. On number of years, enter about , or far enough back so that the year will appear. You now will see a list of each year and what the name you entered ranked each year. If the rank shows a, that means that it was not in the top 1, for that particular year. Now we will graph it. Because this graph is going to show change over time, we are going to create a line graph. First we need to enter the information. In a column, enter the years , , , , , , , , , , , and the most recent year. Then, enter the rank for each year.

If that particular year does not have a rank, leave it blank. Your information should look something like this: 6. Graph it. Highlight the information, and choose a line chart from the Insert menu. Most likely, you got a chart that looks like the one below. In the chart below, Excel recognized that the years are YEARS and not just numbers. If your chart does not look like the example, you will need to reformat the years so that Excel does not treat them as numbers. To do this, highlight your years entered. In the number list, choose Text. If your chart DOES look like the one below, do not follow the above step. Example 1 7. Now, this chart is ok, but there are many things we can do to make it more meaningful.

When making a chart, you want to make sure that the data you are trying to present is clear and meaningful. This chart as it is, is misleading. This is not quite true. We need to reverse our dates, so that the high points of the line indicates high popularity There are two ways to do this: a. You can either retype in or rearrange your dates in the data you entered so that the most recent date is on top, b. Or you can right click on the axis the numbers lining the left side and choose Format Axis. Choose one of these options, or try both.

In my example, I will do the second option. Example 2 9. Now your graph more accurately shows the popularity of the name. But there is still a problem. The graph makes it look as if Molly was not at all popular in , and increased rapidly after This is not quite true either—because our Axis is off. Remember that we are looking in the top 1, names—and Molly starts at Therefore, it was moderately popular in , not at the bottom of the list. To fix this problem, right click on the left axis, and choose Format Axis. You will see a dialogue box appear like the one above. Then change the amount to 1, Then click Close. Example 3 c. Now the graph is a better representation of the name. Highlight your chart and go to Chart Tools.

Change the layout to Layout 1, as shown. Now, I have assumed in this example that you have chosen a name that has data for each of the years given. It is very possible that the name you choose will not have existed in , or it will have periods where it does not show up on the list at all. I will address these problems as well as we add three more names to our chart. Choose three more names and list them and their data next to your first name. You may want to select family members or friends, names that mean something to you.

They will not yet have any impact on your first graph. Go back to the Social Security website and enter the name on the left side and select Go. Then enter the information. I have chosen to enter the names Ashley and Chloe. To add these names to your graph, do the following steps: a. Highlight your graph. Note that your data has colored lines around it. Put your cursor on upper right hand corner of the green section, so that your cursor turns into a two-sided arrow. Then pull the lines over to encompass your new columns.

Example 4 c. Now the new information was added to your graph. Now we still have problems. Take the above data for example: 1. Keep the Cell C1 selected, and drag its AutoFill handle to the range as you need. And then all cells are extracted See screenshot above. How to calculate a running average in a column: To calculate a running average, or a moving average, for a range of cells a column , you use the AVERAGE function. The only trick you need to apply is to make your range changing continuously. In the example below we want to calculate the running average of the sales from January to June. Our ranges for the months will be as follows: January — one cell : B2:B2 February- 2 cells B2:B3 March — 3 cell2: B2:B4 … and so on.

Answer so on. Enter the first formula in cell C2 and auto fill down the rest of the range. Convert birthdate to exact age with DATEDIF function: Sometimes exact age is requires, and you may want to know how many years, months, and days from the birth date to current date. Scores of less than 70 percent fail, and those scores greater than that, pass. The information in column C is attained by using an IF statement. Once the formulas are entered, you can continue to reuse this spreadsheet forever. Just change the names at the beginning of each quarter, enter the new grades at the end of each quarter, and Excel calculates the results. Copy this formula from C4 to C5 through C Count characters in cells: When you need to count the characters in cells, use the LEN function.

The function counts letters, numbers, characters, and all spaces. For example, the length of "It's 98 degrees today, so I'll go swimming" excluding the quotes is 42 characters—31 letters, 2 numbers, 8 spaces, a comma, and 2 apostrophes. In these examples, cell is the cell you want to count, such as B1. In this example, the LEN function counts the characters in each cell and the SUM function adds the counts. Use an IF statement to convert numeric scores to a pass-fail status. The result is random numbers between That includes any edits to the worksheet, also simply opening the workbook. Calculate the difference between two dates: Use the DATEDIF function when you want to calculate the difference between two dates.

First put a start date in a cell, and an end date in another. Then type a formula like one of the following. Difference in days In this example, the start date is in cell D9, and the end date is in E9. The formula is in F9. Difference in weeks: In this example, the start date is in cell D13, and the end date is in E That divides the number of days by 7, since there are 7 days in a week. Note that this result also needs to be formatted as a number. Difference in months In this example, the start date is in cell D5, and the end date is in E5. Time Difference between two dates: To calculate the time between two dates and times, you can simply subtract one from the other.

However, you must apply formatting to each cell to ensure that Excel returns the result you want. Type two full dates and times. Each cell should have a month, day, year, hour, minute, and a space before the AM or PM. This isn't the date you'll set, it's just a sample of how the format will look. Subtract the two. The result will probably look like a number and decimal. You'll fix that in the next step. Set the [h]:mm format. Highlight Duplicate Cells Using Conditional Formatting:  Select the range of cells to be formatted.

edu uses cookies to personalize content, tailor ads and improve the user experience. By using our site, you agree to our collection of information through the use of cookies. To learn more, view our Privacy Policy. edu no longer supports Internet Explorer. To browse Academia. edu and the wider internet faster and more securely, please take a few seconds to upgrade your browser. Khan Sayyad. Olivia Qin. Mohammad Rifky. Elif Demirel. Alfredo Sánchez Alberca. Basic Excel Manual for Economics and Business Administration.

Log in with Facebook Log in with Google. Remember me on this computer. Enter the email address you signed up with and we'll email you a reset link. Need an account? Click here to sign up. Download Free PDF. Excel Assignments dayo tom. Continue Reading Download Free PDF. Related Papers. Microsoft Excel Step by Step. Download Free PDF View PDF. Excel Data Analysis － Your visual blueprint for creating and analyzing data， charts and Pivot Tables，3ed. using excel for business analysis. Data analysis with microsoft excel updated for office.

Basic Excel Manual. Computer Technology Assignment 1 Microsoft Excel 1. This will open up a Word Document. This is a basic tutorial on Excel and on Excel vocabulary, which will be what is on the final at the end of the semester. Print a copy of Assignment 1, then answer the questions on it as you go through the tutorial. At the end of the tutorial there will be a quiz. Take the quiz, and print the results. Staple your quiz to the tutorial and turn into the basket when finished. Computer Technology Assignment 2 Microsoft Excel 1. Here you have the nutritional information for some of the items on the menus of various fast-food restaurants. First we are going to move the contents in Cell A2 into A1.

Click on cell A2. Place your cursor on the EDGE of the cell so that it turns into a four-sided arrow. Then drag it up one cell, into cell A1. Now lets make column A wider so we can see the contents easier. Place your cursor between the A and B so that it turns into a two-sided arrow. Double click. The column should automatically re-size to the length of the longest word in that column. Highlight Row 1. Right click on the area you have highlighted and choose Insert from the menu. Highlight cells A1-F1 and press c. Change the font size to Change the color to a color of your choice by clicking on the button.

Change the font to a readable font of your choice. Now highlight cells A2-F2. Change the color of the fill to yellow by clicking on the button. Change the font to Bold it by clicking on the button. Now highlight row Right click and Insert. Highlight AF Change the color of the fill to red, the size to 14, and bold it. Now we need to copy and paste the information from sheet 2, for Burger King. Click on Sheet 2 at the bottom of your screen. Highlight cells a A1-F Go back to Sheet 1. Place your cursor in cell A Now highlight cells AF Choose from the home ribbon.

Highlight cells AF You have now copied the format to the new cells. Change the fill color to blue. Highlight cells A3-F Go to the Data Ribbon. Click on the sort button. Pull down the sort by menu, and choose Calories from the list. Sort this one by size. Highlight cells A37 — F Sort this one alphabetically. Now highlight rows Change the font to 8. Do the same for rows , and rows Double click between the A and B again to resize column A, now that the font is smaller. Click on the borders tab and choose All Borders. Do the same for cells AF34, and AF Highlight cells B3-F3.

Right click and choose Format Cells. Click on the Alignment tab. Change the orientation to 45 degrees. Do the same for cells BF And again for cells BF Now we are going to insert some pictures. Go to the internet, and to Google Images. Find a logo that is rather small. Click on it, then go to See Full Size Image. Right click and save this logo into your My Pictures folder. Go back to your assignment and click on Insert, then Picture. Place it roughly in column G. Do the same for the other three logos. Add a header. Go to the Insert ribbon, and choose Header. Type your name in the left column, and Assignment 1 in the middle column.

Tips: Sometimes you may want to change the SCALE of your chart. Class 1 Computer Science Operating A Keyboard Assignment. edu uses cookies to personalize content, tailor ads and improve the user experience. Change the height of row 3 to At this school, account numbers are formatted as -.

Categories:

• Essay Website
• Custom Essays
• Essay Online
• Online Essays
• Essay Experts