CIS210 | Networking in Computer Science - Lackawanna university
- After reviewing the Profit and Payroll worksheets, Dora typically generates some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Accounting,and if necessary, move the new worksheet after the Profit worksheet.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Upoad your completed work to Canvas _ Weekly Assignent 2 Final Figure 1: Payroll Worksheet Final Figure2: Profit Worksheet CIS210 Computerized Spreadsheet Module 3 Assignment Watch the videos provided in the introduction and Lesson 3. You will use what you learned about 3D formulas from the videos and apply it to this week's assignment. Download the attached Excel file. Take the data provided and use two 3D formulas. The first one, shown in the video (from this week's module), will be a grand sum of all of the sales data across three years. The second 3D formula will be an average of the data across 3 years. Submit an excel file of your data with the calculated 3D formulas. CIS210 Computerized Spreadsheet Module 4 Assignment Watch the videos posted in the introduction 4 and Week 4 lesson. Apply what you have learned to build your personal budget plan in Excel; it does not need to match the videos' examples. Include budgeting items that apply to your life situation. Although your budget shouldn’t be an exact match to the video, make sure you include the following: Predesigned spreadsheet templates are NOT accepted, please start with a blank document. At least 2 formulas One chart. Be sure to modify the chart title and the legend. Use the strategies you have learned to format your workbook; you can use any theme, cell style, or color. You may like to review this video for more information: https://youtu.be/NZJXNw_rzTQ (Links to an external site.) Save the budget as a template, the first video in this week's introduction shows how to do this. Submit the template as an Excel file. CIS210 Computerized Spreadsheet Module 5 Assignment You will take the data provided in the attached excel file and link the raw unformatted data into a second worksheet. You should use the strategy shown in the video below. Once you get the data into the second sheet make sure to format it correctly from general numbers to the accounting or currency format. https://youtu.be/rDMfksI3n7M CIS210 Computerized Spreadsheet Module 6 Assignment Once you have successfully constructed the database you will then have to go and use three out of the five database formulas shown in the video. So, out of these five (DCOUNT, DAVERAGE, DMIN, DMAX, DSUM) you must find at least three in your data. Once you have successfully built your database and have used three of the formulas, submit your Excel file. https://youtu.be/91HzoJ_FNUY CIS210 Computerized Spreadsheet Module 7 Final Exam CIS 210 Final Exam
For your final Exam please complete only ONE of the 2 options below:
Final Exam _ Option 1 ( predesigned spreadsheet templates are NOT accepted) During the past weeks, you have learned how to design a good excel workbook, how to insert functions & formulas, and how to link worksheets and external workbooks. Now it is your time to apply what you have learned. Start with a blank Excel workbook, and create an Excel workbook about any topic ( Do not use a predesigned spreadsheet template). You may like to review the exercises provided in this course, search the internet and look at the following link for ideas: https://instanteduhelp.com/microsoft-excel-projects-spreadsheet-ideas/ (Links to an external site.)
Your workbook should have at least the following:
At least 5 formulas/ functions, for instance: sum, average, minimum, max, multiply, divide, subtract, or PMT What if function (any rules) Conditional formatting (any rules) One chart/ graph. Be sure to modify the chart title and the legend Sparklines (any kind) Tab name and color ( any colors) Printout ( header with your name) Use the strategies you have learned to format your workbook, you can use any theme, cell style, or colors. You may like to review this video for more information: