Page 3 - chapter3-tu170

Kuwait Branch Eng: Asma S.Eidian chapter 03

 The intersection of a row and column creates a cell. A cell can contain text or
numeric entries.

 Text entries or labels provide structure to a worksheet by describing the contents
of rows and columns.

 A numeric entry can be a number or a formula.

 A formula is an instruction to calculate or process.

 Functions are prewritten formulas provided by spreadsheet program that
perform calculations such as adding a series of cells.

 A range is a series of continuous cells.

 Spreadsheet programs typically provide a variety of different types of function
including financial, mathematical, statistical, and logical functions.

 Analytical graphs or charts are visual representations of data in a spreadsheet.

 If you change one or more numbers in your spreadsheet, all related formula will
automatically recalculate and charts will be recreated. This is called
recalculation.

 The process of observing the effect of changing one or more cells if often
referred to as what-if analysis.

 Database Management System:-
 A database is a collection of related data. It is the electronic equivalent of a file
cabinet.

 A database management system (DBMS) or database manager is a program that
sets up, or structures, a database. It also provides tools to enter, edit, and retrieve
data from the database.

 The relational database is the most widely used database structure.

 Data is organized into related tables.

 Each table is made up of rows called records and columns called fields.

3 | P a g e / E - m a i l : a s m a . s . e @ h o t m a i l . c o m m o b i l e : + 9 6 5 6 0 7 6 7 5 0 6