1 demonstrate basic spreadsheet concepts and functions
TRANSCRIPT
Designing a Spreadsheet WHAT IS A SPREADSHEET?
Rows and columns of data and formulas○ Cell - Intersection of a row and column
A B C D
1
2 *CELL
3
Sabbir Saleh_Lecture 16_Computer Application_BBA 2
ROWS (horizontal)
COLUMNS (vertical)
* CELL ADDRESS = B2
Spreadsheets Perform Mathematical Calculations
Spreadsheet ApplicationsBudgets CheckbookProduct pricesPayrollFinancial statementsProfit/loss statementsCompany bids
Sabbir Saleh_Lecture 16_Computer Application_BBA3
Sabbir Saleh_Lecture 16_Computer Application_BBA 4
Daily Uses of Spreadsheets
Business
School
•School Budgets
•Student Grades
•Payrolls
Personal/Home
•Budget
•Checkbook
•Car loans
•Household Expenses
•Payrolls
•Budgeting
•Investments
•Inventory costs
•Loan Payments
Spreadsheet Input Operations Keyboard or Menu Commands
MouseArrow keysEnter
Alternate Input DevicesPDASpeech RecognitionTablet PCVirtual Keyboard
Sabbir Saleh_Lecture 16_Computer Application_BBA 5
Creating a Spreadsheet
6Sabbir Saleh_Lecture 16_Computer Application_BBA
Data Types Labels (left default alignment)
○ Data expressed in words, symbols, dates, or numbers not used in calculations
Thomas JonesJanuary 3Zip code, SS#, telephone number
Values (right default alignment)○ Data expressed in numbers
150 Formulas
○ Algebraic format of formulas
=A1+B1, =(C4*D10)+A3
Basic Spreadsheet Formulas
Addition =B7+C7 Subtraction =B7-C7 Multiplication =B7*C7 Division =B7/C7
Sabbir Saleh_Lecture 16_Computer Application_BBA 8
Formulas are used for simple mathematical calculations
Saving
Using Menu File, save as Choose location to save
Sabbir Saleh_Lecture 16_Computer Application_BBA 9
Name file
Save
Saving
Keyboard CommandsCtrl S (When using for the first time,
computer will prompt location and file name
Speech CommandsSame procedure as using the menu
Sabbir Saleh_Lecture 16_Computer Application_BBA 10
Printing
Printing Options – (File, Page Setup)
Portrait – paper taller than wide
Landscape – paper wider than tall
With/without gridlines With/without row and
column headings
Sabbir Saleh_Lecture 16_Computer Application_BBA 11
Printing Options
Sabbir Saleh_Lecture 16_Computer Application_BBA 12
Portrait – page longer than wide
Landscape – page wider than long
Printing Options (Continued)
Sabbir Saleh_Lecture 16_Computer Application_BBA
13
With/without gridlines
With/without row & column headings
Retrieving/Editing
Retrieve spreadsheet file to edit through menu
Sabbir Saleh_Lecture 16_Computer Application_BBA14
Retrieve using icon
Editing/Insert Row
Sabbir Saleh_Lecture 16_Computer Application_BBA 15
To insert a row between row 2 and 3, active cell must be in row 3 (row below)
Editing/Insert Column
Sabbir Saleh_Lecture 16_Computer Application_BBA 16
To insert a column between column A and B, active cell must be in column B (inserts left of column)
Editing/Deleting Row or Column
Sabbir Saleh_Lecture 16_Computer Application_BBA 17
From menu, select edit, delete or right click mouse and choose delete
Editing/Deleting Row
Sabbir Saleh_Lecture 16_Computer Application_BBA 18
Select entire row to delete row
Editing/Deleting Column
Sabbir Saleh_Lecture 16_Computer Application_BBA 19
Select entire column to delete column
Formatting Cell Features
Types of Cell FormattingGeneralNumber CurrencyPercentageTextCommaDate
Sabbir Saleh_Lecture 16_Computer Application_BBA 20
Formatting Cell Features
Sabbir Saleh_Lecture 16_Computer Application_BBA21
Format from the formatting toolbar. OR …
Format from Format Menu
Format from the Format Menu
Aligning Data
23Sabbir Saleh_Lecture 16_Computer Application_BBA
Align Data from the Formatting Toolbar OR …