Spreadsheet software , Basic Computer Science

Assignment Help:

Spreadsheet Software : Consider the grid in Fig. 9.4. It is split into rows and columns and is a pictorial representation of a typical spreadsheet program.

1424_spreed sheet.png

 Figure: Spreadsheet Cells.

You can enter data in any 'cell', e.g. Al, 253, etc. and, for example, perform arithmetic operations on that data and then 'post' the result to another cell. Take the following example. If you wanted to maintain a record of lab expenditure, you could set up a spreadsheet in the following way:

Column A         Column B            Column C                  Column D

Date            Order No.                Item                       Net Cost

Column E        Column F

VAT/Sales      Tax Total Cost

(Value added tax)

If all items in column D had VAT or sales tax chargeable at 17.5%, then

Column G                       Column H

TOTAL of                   Total sales tax

net expenditure                    paid

In a separate cell you could show the balance outstanding on your annual budget.

You should be able to see the possibilities of such a program. Figure shows an example of a printout from a spreadsheet.

 2304_cash flow anaylissi.png

Figure: Example Printout from Spreadsheet.

You still need to ask yourself the same general questions as we listed for database as follows:

 

(I) Performance

 

For example, can the program:

(a) Carry out all arithmetic functions?

(b) Accept full character data and editing?

(c) Allow title lock and windowing?

(d) Allow easy cursor movement?

(e) Allow copying of blocks of cells?

(f) Allow alternative screen displays of formulae/data?

(2) Size

The size of the spreadsheet May be limited by the program itself or the size of the computer's RAM (Random access memory). A useful working size is 50 columns x 250 rows.

(3) Cost

The same criteria apply as for databases.


Related Discussions:- Spreadsheet software

Search in problem solving-artificial intelligence, Search in Problem Solvin...

Search in Problem Solving: If Artificial intelligence I may inform the other sciences about anything, it is about problem solving and, in specific, how to find solutions to pro

Management information system, suggest 5 ways by which new products and ser...

suggest 5 ways by which new products and services can be developed using management information system

Oop, evolution of oop

evolution of oop

Assembly language, write and run the following programs using 8086 assembly...

write and run the following programs using 8086 assembly language that interchange the upper and lower four bits of AL register.

Accessing other computers, Accessing Other Computers The advanced netw...

Accessing Other Computers The advanced networking features of Windows combined with the easy to use user interface make the task of sharing information with other computers/us

Multiple Statement Groups as Suites, Sets of individual statements making u...

Sets of individual statements making up a single code block are known as suites in Python. Composite or complex statements for example if, def while and class are those which neces

Explain the characteristics of vector processing, Question 1 Draw the bloc...

Question 1 Draw the block diagram of von Neumann Architecture and explain about its parts in brief Question 2 Draw the block diagram of Intel 8085 CPU organization and explai

OPERATING SYSTEM, WHAT IS MULTIPLE CONTIGUOUS VARIABLE PARTITIONING

WHAT IS MULTIPLE CONTIGUOUS VARIABLE PARTITIONING

Transmission control protocol, The TCP/IP networking protocol suite is so b...

The TCP/IP networking protocol suite is so basically named for two of its very most and important protocols: Transmission Control Protocol online tutoring Indication Manage

One dimensional array, One dimensional array:  A one-dimensional arra...

One dimensional array:  A one-dimensional array  is a structured collection of elements  that can be accessed individually by specifying the position of a component with  ind

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