Demostrate the example of spreadsheet, Computer Engineering

Assignment Help:

Now consider the following spreadsheet:

Formula in cell D2 is = (B2/C2)

Replicating this formula (by highlighting then drag down to D7) gives all the formulas needed in cells D3 to D7

Formula in D8 (to find average) can be done in 3 ways:

= AVERAGE (C2:C7) or

            = SUM (C2:C7)/6 or

            = (C2+C3+C4+C5+C6+C7)/6

Formula in D9 to find out maximum value in column is = MAX (C2:C7)

-  Problems associated with spreadsheets:

- Capacity (that implies maximum number of columns and rows) can be limiting when dealing with large data sets

 - Security issues in some spreadsheets (it implies if you can open a spreadsheet you can also change any part of it; this can lead to fraud  

- lack of concurrency; generally only one person can work on a spreadsheet at any given time (databases are better in this aspect as they can usually be opened by more than one user at a time)  

- Due to their structure it's easy to enter an error (whether on purpose or by mistake) by entering data in the wrong cells or dependencies among cells incorrectly applied.

 

1918_spread sheet.png


Related Discussions:- Demostrate the example of spreadsheet

What are disadvantages of eprom, What are disadvantages of EPROM? The c...

What are disadvantages of EPROM? The chip must be physically removed from the circuit for reprogramming and its whole contents are erased by the UV light.

Polishing game, Byteland county is very famous for luminous jewels. Luminou...

Byteland county is very famous for luminous jewels. Luminous jewels are used in making beautiful necklaces. A necklace consists of various luminous jewels of particular colour. Nec

What is file allocation table, Q. What is File allocation table? FAT ma...

Q. What is File allocation table? FAT maps the usage of data space of disk. It comprises information about space used by every individual file and unused disk space as well as

Internal organisation of memory chips, expplain in detail the internal orga...

expplain in detail the internal organisation of computer?

Explain about the object identity of object oriented, Explain about the Obj...

Explain about the Object Identity of object oriented analysis Object identity is a feature of an object that differentiates the objects from all other objects in the applicati

Prove using boolean algebra, Q.Prove using Boolean Algebra 1. X (X+Y) = ...

Q.Prove using Boolean Algebra 1. X (X+Y) = X 2. AB + AC + BC' = AC + BC' 3. (A+B+C) (A+B'+C') (A+B+C') (A+B'+C)=A 4. (A+B'+C) (AB+A'C) = (A+C) (A'+B) 5. XY + XZ + YZ

How does vb.net achieve polymorphism, How does VB.NET/C# achieve polymorphi...

How does VB.NET/C# achieve polymorphism?  VB.Net / C# provide polymorphism through the following mechanisms: 1. Inheritance - base class gives overridable methods which ar

What is a process scheduling, What is a Process Scheduling? Scheduling...

What is a Process Scheduling? Scheduling is a key element of the workload management software that usually performs several or all of: Queuing Scheduling Monito

Name the four steps in pipelining, Name the four steps in pipelining. F...

Name the four steps in pipelining. Fetch  : Read the instruction from the memory. Decode : Decode the instruction and get the source operand. Execute : Perform the operat

How can we write an interrupt servicing routine, Q. How can we write an Int...

Q. How can we write an Interrupt Servicing Routine? The following are the fundamentalthough rigid sequence of steps: 1.  Save the system context (flags,registers etc. which

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd