Grantham Week 4 Advanced Microcomputer Applications Discusion

User Generated

Fxlpnz

Business Finance

Grantham University

Description

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.


Please respond to the initial question by day 5 and be sure to post two additional times to peers and/or instructor by day 7. The initial post by day 5 should be 75 to 150 words, but may go longer depending on the topic. If you use any source outside of your own thoughts, you should reference that source. Include solid grammar, punctuation, sentence structure, and spelling.

Grading Criteria Maximum Points
In your initial post, clearly present well-reasoned ideas and concepts. 25
Post to at least two additional students or the instructor reflecting on the other participants' postings. You should actively participate in the discussion. 10
Total 35


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

Here is the work Buddy, please feel free to let me know of any concern

Running head: ADVANCED MICROCOMPUTER APPLICATIONS

Advanced Microcomputer Applications

Name

Institution

1

ADVANCED MICROCOMPUTER APPLICATIONS

2

Multiple tabs in one worksheet
It will be necessary to create a workbook with multiple tabs when analyzing annual
supply chain of a company from different suppliers. So there will be data for suppliers 1, 2 and 3
in three different tabs but all in one worksheet.
Disadvantage of several tabs in one worksheet
1. A very common disadvantage of maintaining several tabs in one worksheet is security. If
a technicality with the computer used arises, important Data maybe lost at once. This may
not be a good occurrence for someone relying on the data lost. Keeping data in separate
files will be safer.
2. Maintaining several tabs in one worksheet frequently result to user biasness. This
implication is that if in any case that other set of data is needed for analysis, they are
always forgotten. Data in separate files will be easier to use.
3. Learning the correct syntax for several tabs in one worksheet is difficult as opposed to
separate data.
Attached worksheet is a combination of three different residential areas (Spring Valley, Blue
Bay and Green leaf) with same variables of land value, building value, acres, age and price.

Reference
Elizabeth Natter, 2019. Chron: The Advantages and Disadvantages of Spreadsheets


LandValue ($)
18100
23600
25900
22100
23900
22400
24100
26300
24900
13600
36100
19500
38800
23500
26300
21900
23400
15000
15000
9200
9200
5600
9000
21000
23500
36000
23700
22000
19900
22100
24600
21500
15000
15700
14200
10700
16600
25500
15100
7400
28500
25100
50100
83300
124500
47000

BuildingValue ($) Acres
92500
152700
134300
129600
168700
118300
123300
133800
139400
87200
210400
101300
224700
139000
164200
122400
149600
102200
102200
22000
22000
48000
58800
109600
165900
262500
114900
102700
95800
116300
165500
113400
81100
129200
81600
49700
72700
110700
74300
55500
129400
83900
164600
276000
552300
214400

Age
0,5
0,22
0,3
0,23
0,32
0,25
0,26
0,26
0,24
0,17
0,6
0,16
0,44
0,22
0,35
0,17
0,22
0,12
0,12
0,17
0,17
0,12
0,24
0,21
0,15
0,22
0,22
0,2
0,23
0,18
0,29
0,17
0,16
0,23
0,15
0,15
0,18
0,21
0,23
0,15
0,25
0,2
0,23
0,61
1,05
0,22

53,9
19,7
15,9
41
39,9
41,8
70,9
37,8
33
34,7
52,9
67,8
21,7
10,8
3,9
15,7
15,7
97,8
97,7
120,9
120,9
103,9
88
36,7
5,7
2,9
37,7
48,9
78,9
30,8
43
44,9
62,9
46,7
57,9
99,8
91,8
48
71,8
96,8
49,9
45,8
44
47,...


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags