Advanced Microcomputer Applications, computer science homework help

User Generated




Advanced Microcomputer Applications

Week 4 Discussion

Both Excel and Google Sheets allow the user to add additional worksheet tabs to allow for multiple sheets within one larger workbook. Give an example from your personal or professional life where it might be necessary to create a workbook with multiple tabs. Are there any potential challenges or disadvantages to maintaining several tabs in one worksheet vs. keeping several separate files?

Additionally, using your Week 3 discussion submission attachment (your spreadsheet using the SUM function), create two new tabs (to give you a total of 3 sheets). Rename each sheet to a theme of your choice, but something that makes sense when used together (such as tabs for three different client payment logs in your landscaping business). Also, change the colors of each tab to be unique from each other. The workbook should contain data on the original sheet from your prior submission, but otherwise, just focus on the work for the worksheet tabs. You do NOT need to create new data for all three pages. Submit the spreadsheet as an attachment so others can see what you have done and comment on your work. Be sure to use your own sheet tab names and not those that others have used. When thinking about the use of sparklines in a workbook, what are some of the considerations you must make in choosing this as a graphical representation option when compared to a full chart? In your response, indicate what you perceive to be some of the pros and cons of using a sparkline relative to using a full size chart. Are there any situations where using a combination of the two in the same workbook might be useful in your opinion? Why or why not?

Unformatted Attachment Preview

ITEM DESCRIPTION LED Panel Screens indoor/outdoor Line Array Sound System Dome Tent 30m x 70m Chairs Presidential Stage Drapery Décor Coufetti Machine Smoke Machine Stage Lighting Transport QUANTITY 120 Pcs 12 Full range speakers & subwoofer 1 3,000 1 1 1 1 1 1 PUBLIC MOVIE SCREENING BUDGET AMOUNT PER UNIT (USD) NUMBER OF DAYS TOTAL AMOUNT (USD) 105.00 1 12,600.00 4,700.00 522,00.00 40.00 850.00 960.00 450.00 400.00 1,060.00 500.00 1 1 1 1 1 1 1 1 1 4,700.00 5,220.00 120,000.00 850.00 96,000.00 450.00 400.00 1,060.00 500.00 SUB-TOTAL CONTINGENCY 241,780.00 55,880.00 GRAND TOTAL 297,660.00 BUDGET FOR 7 DAY FILM MAKERS BOOT CAMP. TRAINERS. ITEM NUMBER OF TRAINERS AMOUNT PER DAY(Kshs) NUMBER OF DAYS TOTAL AMOUNT Trainers transport 3 2,000.00 2 Trainers accommodation 3 2,500.00 8 Trainers meals 3 2,000.00 7 Trainers allowance 3 7,000.00 7 SUB- TOTAL WORKSHOP PARTICIPANTS. Item Number of participants Amount per day (Kshs) pp. Number of days
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer



Advanced Microcomputer Applications
Institution Affiliation


When working with excel worksheets, they provide the option of having several sheets in
one workbook and one can rename them as per their choice. In my case for instance when
carrying out movie screening, there are various aspects involved and each of them requires a
specific budget. It is, therefore, possible to have all the budgets, each on its own worksheet but in
the same workbook. However, there are various disadvantages that come with working with
several item...

Awesome! Made my life easier.