1. Excel - 1 Chapter 1 – Introduction to Excel: What is a...

Info iconThis preview shows pages 1–6. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 Chapter 1 – Introduction to Excel: What is a Spreadsheet? Exploring Microsoft Excel 2003 2 Daily applications ¡ finance ¡ marketing ¡ sale and logistics ¡ human resources ¡ research ¡ government ¡ etc. etc. …. 3 Introduction to Spreadsheets ¡ Spreadsheet – a computerized 2D model ¡ Divided into rows and columns ¢ Columns identified with alphabetic headings ¢ Rows identified with numeric headings ¡ Cell – the intersection of a row and a column ¢ Consists of column letter and row number 4 Rows, Columns, and Cells Cell referenced by column, then number Active cell surrounded by heavy border Column headings above each column. Columns designated with letters Row headings to the left of each row. Rows designated with numbers 5 Types of Cell Entries ¡ Constant – an entry that does not change ¢ Can be a numeric value or descriptive text ¡ Function – a predefined computational task ¡ Formula – a combination of numeric constants, cell references, arithmetic operators, and functions ¢ Always begins with an equal sign 6 An Excel Workbook Title bar shows name of workbook Standard toolbar Menu bar displays commands Formatting toolbar 7 The Active Cell, Formula Bar, and Worksheet Tabs Click tabs to move to a different worksheet Active cell is highlighted Formula bar displays contents of active cell 8 Using Cell Ranges ¡ Range – a rectangular group of cells ¢ May be a single cell or the entire worksheet ¢ May consist of a row (or part of a row), a column (or part of a column) or multiple rows and/or columns ¡ To select a range: ¢ Click left mouse button at the beginning of the range ¢ Hold left mouse button as you drag the mouse ¢ Release left mouse button at the end of the range Spreadsheets are typically built by copying cells ¡ Stage 1: Design a “typical case”...
View Full Document

This note was uploaded on 10/25/2009 for the course BUSINESS 772 taught by Professor Sadeh during the Spring '07 term at Interdisciplinary Center Herzliya.

Page1 / 15

1. Excel - 1 Chapter 1 – Introduction to Excel: What is a...

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

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