module 05 spreadsheet

Alpha Tech Program

Recap Module 4Recap Module 4

Module : Introduction To SpreadsheetsModule : Introduction To Spreadsheets

Describe some of its uses

Start and Quit a program

Identify main components of the user interface

Save and open a worksheet

Work with cell, worksheet, workbook

Enter and edit text

Identify and use the formatting features

Enter Currency Unit (Rs), Date

Use functions to perform basic mathematical tasks

Create data series, use auto-fill and enter day-date

Use print preview and page setting for printing

Create an account book to practice features learnt

UsesUses

• Inquire and let ideas pop out

Start And QuitStart And Quit

• Start• Start menu / shortcut

• Quit • Close button / exit from menu

Components Of User InterfaceComponents Of User Interface

• Title bar & Menu bar • Toolbars• Alignment, Number, Styles, Cells and Editing• Min, Max, Close, Scroll, Resize

Save And Open A WorksheetSave And Open A Worksheet

• Save• Save as• Other versions

• Create new spreadsheet• Open from folder• Open from pen-drive / CD

Cell, Worksheet, WorkbookCell, Worksheet, Workbook

• Insertion point• Cell handle

Enter And Edit TextEnter And Edit Text

• Insert• Delete• Select• Copy• Paste• Drag and drop

• Create a grade card for Class Test• Marks, highest, average

FormattingFormatting

• Font Size, Style, Colour• Cell shading• Bold Italic Underline• Number format (text, number, date, currency)• Alignment• Hyperlink• Spacing: character, line, paragraph

Edit Grade CardEdit Grade Card

• Use functions• Data series• Auto-fill

PrintingPrinting

• Page setting– Paper– Margin– Orientation

• Print preview• Print

SummarySummary

PracticePractice

• Create Grade card for Final Exam• Include marks from class test, unit test and finals

Statement True False1 You CANNOT store text, numbers, or formulas in a cell.2 You CAN store text, numbers, or formulas in a cell.

3 A column in a worksheet is identified by a LETTER.4 A column in a worksheet is identified by a NUMBER.

5 A cell range CANNOT extend across multiple rows.6 A cell range CAN extend across multiple rows.

7 A cell VALUE indicates an active cell.8 A cell POINTER indicates an active cell.

9 A workbook CAN contain more than one worksheet.10 A workbook CANNOT contain more than one worksheet.

11 A WORKBOOK is a file created in Excel.12 A WORKSHEET is a file created in Excel.

13 ONLY ONE cell can be active at a time.14 MORE THAN ONE cell can be active at a time.

15 A cell address indicates the exact location of a ROW.16 A cell address indicates the exact location of a CELL.

17 A label HAS a numeric value attached to it.18 A label DOES NOT HAVE a numeric value attached to it.