Spreadsheet software , Basic Computer Science

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.

Posted Date: 4/19/2013 3:18:06 AM | Location : United States







Related Discussions:- Spreadsheet software , Assignment Help, Ask Question on Spreadsheet software , Get Answer, Expert's Help, Spreadsheet software Discussions

Write discussion on Spreadsheet software
Your posts are moderated
Related Questions

how to set up the location (e.g. plaza, hall of fame, lecture theater or etc.) and services that will be used during the exhibition; devices needed; and finally produced a compreh

Question 1 Explain boundary fill and flood fill polygon filling algorithm Question 2 Draw and explain the block diagram of typical workstation Question 3 Explain the ras

Problem A) The TCP/IP reference model is the network model used in the current Internet architecture. This model is derived from the OSI model and they are relatively same in n

what is the meaning of data definition

Will someone be able to help me with this I have two text files that I can send. I am confused, is someone looking at this or is it still waiting to be assigned? this is the code

Problem 1 Perform the following conversion a. (ABE) 16 =() 2 b. (101011) 2 =() 10 2 Explain how full adder adds three bits 3 Explain digital multiplexers

Block diagram of digital computer: The general pattern of computer architecture has remained unchanged over the last four decades or so. It has a single processor, which accep

My question on the following link: http://www.3n33.com/upload/download.php?img=1410

They are used to reduce or enlarge the content of the counters. DEC INC DEC INSTRUCTION Idea: To diminish the operator. Syntax: DEC destiny This action subtracts 1 from the destiny