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

Instruction-execution cycle, Problem (a) Using a labelled diagram of ...

Problem (a) Using a labelled diagram of an Instruction-Execution cycle, describe how a CPU executes single machine instructions by referring to the five main operations.

Real life business subsystems, Real Life Business Subsystems A Subsyst...

Real Life Business Subsystems A Subsystem is a component of a System even though it can also be described as a system in its own right. Consider a manufacturing firm. It compr

State the advantages of real time processing, Real time (transaction) proce...

Real time (transaction) processing In real time (transaction) processing files are generally updated in real time (for example when booking flights on an airplane); however in

Example of weight training calculations, Example of Weight training calcula...

Example of Weight training calculations: Through having calculated all the error values associated with such each unit like hidden and output then we can now transfer this inf

Neural networks as perceptrons, Neural networks as perceptrons: Howeve...

Neural networks as perceptrons: However ANNs look like this in the general case:  Considered that the w, x, y and z represent real valued weights so all the edges in t

Electronic brokerage facilitate search and retrieval, How does electronic b...

How does electronic brokerage facilitate search and retrieval of information? E Brokerage facilitates search and retrieval of Information: The success aspect of a brokera

Explain topology method used in lan technology in detail, Explain topology ...

Explain topology method used in LAN technology in detail. LAN Topologies: Network topology is a physical schematic that shows interconnection of the various users. There are

Associativity of connectives - equivalences rules, Associativity of Connect...

Associativity of Connectives : Here brackets are very important in order to tell us where to perform calculations in arithmetic and logic. By using these brackets we evaluate

Android projects, how should I do connectivity with google play for my andr...

how should I do connectivity with google play for my android GSM based project

Interfacing assembly language routines, By now you can write procedures bot...

By now you can write procedures both internal andexternal and pass parameters particularly through stack.Let's us use these concepts to see how assembly language can be interfaced

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