SolutionsPro here are my Week 4 assignments due by midnight tomorrow. Thanks for all you do. You are the best.;Part 1 Week 4 DB assignment;Required Discussion Board assignment.;What is the difference between a workbook and a worksheet? Why would you want to use separate worksheets when using Excel? Please give 2 general examples. Please research and find the method for creating an Excel formula that references information on the first worksheet from a second worksheet. Can you think of a specific personal or business application that would require only one worksheet? Please explain this application.;This assignment's grade is based on the quality of the Discussion Board posts. Be sure to read the Discussion Board assignment requirements. In most situations, you are required to post a specific number of paragraphs or words. Your postings should include proper grammar and spelling. References are required, so be sure you cite your references in correct APA style.;You are also required to respond to your classmates. Remember, a quality post is not a simple one-sentence response. Your responses to your classmates should be at least a paragraph and should be based upon your experiences, the unit readings, or the class materials. If you need more clarification about quality posts, please ask your instructor.;In your own words, please post a response to the Discussion Board and comment on other postings. You will be graded on the quality of your postings.;Part 2 Week 4 DB response to classmantes;Chioma Bisi Ojediran;While a sheet denotes: one, a piece, or single, a book represents a collection of sheets. So is it in Microsoft spreadsheet program known as Excel, where the basic work space is a worksheet and/or workbook.;The Difference between a Worksheet and a Workbook;A worksheet in Excel (also known as a spreadsheet) is a single ?sheet? that contains cells prearranged in rows and columns and contains data concerning a particular section of information. The maximum size of a worksheet is 1,048,576 rows by 16,384 columns (Scott, E., n.d.). It starts with row number 1 and column A and each cell can contain a text, number or formula. A user can enter, adjust, and manipulate the data in the spreadsheet. One cell can reference another either in the same worksheet or in the same or different workbook. So basically, the user is keying-in information into one of the pages of a workbook.;A workbook on the other hand, is an Excel file that contains many worksheets in which related data are entered and stored. When an Excel spreadsheet program is opened, it loads an empty workbook file consisting of three blank worksheets by default. However, it can contain many more sheets. Each worksheet is found on a separate tab at the bottom of the Excel window. It is just like a story book where each page contains part of the story. So in either business or personal yearly budget for instance, each worksheet in a workbook can contain monthly budget in a year.;Why use separate worksheets when using Excel?;I would want to use separate worksheets personally so as to keep myself organized in my activities. Examples are my tuition loan bills vis-?-vis my out-of-pocket payments. This is because I will not want the data to get mixed-up. When it is time to pay my loan, I should be able to compare my given debt figures with mine. Another example is not to use the same sheet for payroll and attendance because the user may be confused. When it comes to money, people do not joke. Don?t tell anyone he or she has been payed while looking at the attendance sheet. Again on a business level, it will be advisable to use separate sheets for profit and loss accounts for easy read. A mix-up will be devastating.;The Excel formula that references information on the first worksheet from a second is done by this example;Open Excel spreadsheet application and create a new worksheet named ?January?. Type ?Revenue? in cell A1 and 4000 in cell B1;Create another worksheet named ?February? Type ?Revenue? in cell A1 and ?6000 in cell B1. These are revenue values for January and February.;Then create the last worksheet named ?Totals? and type ?Totals? in cell A1.In cell B1, type this formula: =January!B1. Notice that the formula begins with an equal sign, followed by the name of the worksheet you want to reference, that is ?January?. Then is an exclamation mark, followed by the cell that is being referenced. The value that B1 cell in the total worksheet gets is from the B1 cell in the January worksheet.;Now, click inside the total worksheet?s B1 cell and notice that Excel will display the cell?s formula above the cell like this;=January!B1+February!B1;Placing a plus sign after the original reference to the first sheet and then appending a reference to the second after a plus sign. This means you want Excel to add the first and second cell values to create a total. This shows total revenue for January and February in the worksheet?s B1 cell (Lee. K., 2014);Specific Personal or Business Application that require only One Worksheet;Unless the data a user need to handle is large, only one worksheet can be used for data for work schedule, application form, expenses for utilities and services like gas, electricity, security, trash removal, Home properties for insurance claim in event if robbery, natural disaster or accidental neighborhood happenings, balance sheet, sales and expenditures and more. That will help to keep track of the data in a structured way.;References;Lee K., (2014), ?How Do I Reference a Cell?, Retrieved;from: http://smallbusiness.chron.com/reference-cell-another-worksheet-excel-65230.html;Scott,E.,(n.d.), Difference Between Excel Worksheet & Workbook. Retrieved from;http://smallbusiness.chron.com/difference-between-excel-worksheet-workbook-3498.htm;Derrick Wilborn;A workbook is a book that whose pages are nothing but worksheets or spreadsheets. If a workbook contains all pages of the same sort, i.e. recordkeeping spreadsheets, the workbook is normally titles as a recordkeeping workbook. Workbooks are capable of holding an almost infinite number of worksheets as well.;A work sheet is an amalgamation of cells that hold data pertaining to a certain piece of information. The person creating the spreadsheet or worksheet can manipulate the data on it in order for it to auto calculate different numbers.;Worksheets would be used by a company when storing different information that has nothing to do with one another. For instance, you could use a spreadsheet to plot the company growth and projections for annual finance, but you would use a different one to plot gaps in a competitors company or to plot places where a competitor may be ready to be financially taken over or to chart where a potential client is spending his money and whether that expenditure has been lucrative, thereby allowing you to know how to maneuver into a position to get that potential clients business.;You may also use one worksheet for balancing your checkbook, but in order to factor the results into a household budget, you may require another worksheet.;In order to reference information from one worksheet to another. You first have to click on the cell containing the formula where you need to reference a different worksheet. Hit the tab for the other worksheet. Note the cell number that you want to reference, for instance A1, B2, C3. Then go back to the other worksheet and enter the name of the second spreadsheet followed by an exclamation point and the cell number. For instance, if the spreadsheet is listed as blackbook, with the cell number being A4. You would enter, blackbook!A4 onto the first worksheet so that it would calculate or incorporate the info from the second sheet.;Christopher Nelson;EXCEL;Christopher Nelson;American InterContinental University;When you first open up Excel, it opens in a workbook with three worksheets ready for use at the bottom of the page marked as sheet 1, sheet 2 and sheet 3. If you would like to change the names of the sheets and call it a new name all you need to do is right click and look for the box where it will tell you to rename. Double click on rename and you can type in the name you would like for that sheet. Example sheet 1 will be changed to class 101. You could do this for each sheet after. If you had multiple classes, you could change each sheet per class. A worksheet is the data that is put in on each one of the sheets. Example you made out a list of bills that needed to be paid. In Column A, Row 2 you could put car note, Column A, Row 3 put rent for the house, and Column A, Row 4 Water. Now each bill needs to be paid each month. Column B, Row 1 you would put January, Column C, Row 1 February, and Colum D, Row 1 would be March. Then you could put in the amount you have paid. The excel worksheet a great way to know if you paid your bills for that month or to see over time how much you are spending on the bill. You may want to you separate worksheets, like bills would be the first worksheet and the second could be work bills or leisure items like vacations or places you have been. I have a worksheet that tells the name and place of each person I have buried for the United States Army so far I have conducted 447 funerals for military members.;One reason I would think that a business would only use one worksheet applications is when personnel need to e-mail an excel worksheet to another office employee. Say the employee does not need all the added information that maybe on another worksheet, like social security numbers or account numbers. Some people do not think of this and would send the whole excel workbook file, and now many others are having access to information that may get into the wrong hands.;References;Scott, E. (2014) Difference between excel worksheet and workbook. Retrieved from www.smallbusiness.chron.com;Part 3 Week 4 Individual Project;In this project, you will complete a partially filled out expense report for a company's sales force and then save it. To view these instructions while you work in Excel, you can print this page of instructions or move back and forth between this page and Excel by clicking each application's button on the Windows taskbar.;Click on the following link: Expense Report, save it on your computer in your usual work folder, and then open it in Excel. This partially completed workbook contains an incomplete expense report that needs formatting changes, boxes filled in with appropriate information, and formulas created for correct calculations.;First, click on the small box that is to the left of column A and above row 1. This will highlight the entire spreadsheet.;Next, position your cursor between columns A and B so that your cursor looks like a plus sign with arrows on the left and right. Double-click here to make the columns fit around the existing data. To finish, click anywhere in the worksheet once to remove the highlight from the entire page.;Create a border around the data entry portion of this spreadsheet. This is done by selecting cells A8?M12. Put a border around the outside of this area only.;Fill in all blank boxes with appropriate data within the A8?M12 data range. For text or date information, provide appropriate text or date entries. Reasonable numbers can be entered. For example, lunch should not cost $678, that is unreasonable.;Format all of the dollar figure numbers as 2-decimal U.S. currency. Example: $45.00.;In cell I4, type the words, "Allowance Per Mile." In cell L4, type the number 0.40. Format this number as currency. Select cells I4?K4, and use the Merge and Center button to format this.;In the Daily Totals column, calculate the cost for each day. To do this, type this formula: =Sum(C8:H8,J8:M8). Copy this formula down to the other appropriate rows below.;Next, calculate to totals for each category. In row 14, under the Brkfast column, add all of the numbers above it using a Sum formula, then copy it across under each column.;In cell J8, calculate the cost allowance per mile under the Mileage $ column for each date. You need to multiply the mileage by the mileage allowance. Be sure to use an absolute reference when referring to the mileage allowance because it is not in the table and only occurs once at the top of the sheet.;Copy this formula down to each of the 4 columns directly below cell J8.;Make all headings bold.;Create a report title by typing the words "Expense Report" in cells E2. Select cells E2?J2, and use the Merge and Center button to center the title across the report. Change its font size to 14. Also, use the Merge and Center button to place the words "Transportation" above "Air" and "Ground" and "Meals" above "Brkfast," Lunch," and "Dinner." Do not forget to format these words to match the other headings.;Format the dates into the full month name, day, and year format.;Finally, repeat steps 2 and 3 so that the spreadsheet has all of the data showing in it.;Save your completed report as your ?First initial Last name Expense Report 1". Example: J Doe Expense Report 1.;Submit the assignment.
Paper#68807 | Written in 18-Jul-2015Price : $37