04_Excel_part1 - LECTURE 4: INTRODUCTION TO MICROSOFT EXCEL...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: LECTURE 4: INTRODUCTION TO MICROSOFT EXCEL CSI 1306 F Computing Concepts for Business Spreadsheet Program: Some Definitions a screen-oriented interactive program enabling a user to lay out financial data on the screen , WordNet Dictionary a computer application that simulates a paper, accounting worksheet , Wikipedia a sheet of paper, marked with a grid, in which financial data is recorded and totals calculated manually; A computer simulation of such a system of recording tabular data, with totals and other formulas calculated automatically , Wiktionary Spreadsheet Program: Some Definitions a computer program designed to do large numbers of calculations with minimum effort. Also can be used to sort and filter lists , Univ. of Kings College an application program, used in financial forecasting, that can quickly handle calculations and perform evaluations. Spreadsheets can predict, store and calculate , Boles Junior High School What is the common denominator behind all these definitions? Spreadsheets Standard Requirements for a Spreadsheet divide worksheet into rows & columns (cells) enter text, numbers & dates into cells enter formulas which reference contents of other cells copy formulas from one cell to another & change cell references automatically automatically recalculate values in related cells when a change is made to a cell change size of cells format cell contents Spreadsheets Standard Requirements for a Spreadsheet (contd) add or delete rows & columns of cells sort, summarize & extract information from worksheets for reports display or print information from the worksheet in the form of graphs or charts Compared to word processors each cell offers computing power through formulas, as well as text editing & formatting capabilities Spreadsheets Worksheets 256 columns & 65,536 rows (default) columns labeled with letters of alphabet  A to Z, AA to AZ, BA to BZ, etc. rows labeled with numbers maximum size of worksheet depends on memory available Workbooks a collection of worksheets in the same physical archive each workbook can contain up to 256 worksheets Spreadsheets Desktop standard menus and bars worksheet occupies most of the screen formula bar  cell address  contents of the current cell sheet tabs  click to activate different worksheets in a workbook Spreadsheets Basic Operations moving the cell pointer  click on a cell  Press CTRL + G to activate Go to dialog box...
View Full Document

Page1 / 41

04_Excel_part1 - LECTURE 4: INTRODUCTION TO MICROSOFT EXCEL...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online