computer mt notes.pdf

# SPREADSHEET ## What is an electronic spreadsheet? A spreadsheet is a sheet consisting of cells formed by the intersections (vertical) of columns and rows. The cells are used to enter data and perform various works including data analysis. When a spreadsheet is implemented in a computer, smartph...

# SPREADSHEET ## What is an electronic spreadsheet? A spreadsheet is a sheet consisting of cells formed by the intersections (vertical) of columns and rows. The cells are used to enter data and perform various works including data analysis. When a spreadsheet is implemented in a computer, smartphone or tablet, etc. by using suitable software, then it is known as electronic spreadsheet. ## Examples of spreadsheet software - Visicalc - Lotus 1-2-3 - Excel - Gate Oocalc, etc. ## Spreadsheet file or workbook A file created by a spreadsheet software is called a spreadsheet file or workbook. ## Worksheet A workbook consists of worksheets. Worksheet is the working area or page on the screen. A worksheet consists of rows and columns. WB is like a book while WS are pages of it. - Rows: 10,48,576 (Excel) - Columns: 16,384 (XFD) (Excel) 1024 (AMJ) (Calc) Upto 256 worksheets can be there in a WB. ## If you click on Alt + underlined character... If you click on Alt + underlined character in the menu name, it opens with its relevant option. Eg- Press Alt + F opens file tab. ## Formula Bar Formula Bar - Below formatting toolbar. Formulas that perform different calculations in cells are entered and displayed here. It is denoted by "fx". ## Active cell in a WS Active cell in a WS is known as cell pointer. ## Types of data 1. **Numeric:** Digits (0-9), exponential (e), decimal (.), and numeric operators +,-,*, /, %, $. These operands are data on which formula is applied (right). 2. **Alpha-numeric:** Text data. Alphabets, spaces, digits and/or other characters. If numbers are to be inserted as text, they are mentioned within double quotes " ". 3. **Date and Time:** Date - Sequential numbers known as Series Values. Time - Fractional part. They can be added or subtracted. Other calculations are aligned towards the right side of the cell. 4. **Formula:** Expression which helps us to perform arithmetic calculations and also execute non-arithmetical tasks. Consists of operands and operators. Prefix = before operator/data. ## Creating a Workbook - Ctrl + N 1. File --> New --> Spreadsheet 2. Standard Toolbar --> New - A new workbook named Untitled 1 appears. ## Notes - 'fx' is used to enter or edit a formula. - '∑ Autosum' is used to calculate the sum of specified range of cells. ## To select a worksheet - Ctrl + A or click on the uppermost left corner of the worksheet. - Alt + Pg Dn for one screen to the right. - Alt + Pg Up for one screen to the left. - Ctrl + Pg Dn for next sheet. - Ctrl + Pg Up for previous sheet. - Shift + Spacebar for select row. - Ctrl + Shift + Spacebar for select column. - Shift + Arrow Keys for a range of cells. - Ctrl + W for close WB. - Ctrl + Q for exit from spreadsheet. - Ctrl + O for open existing Workbook. ## Extensions - Calc: ods - Excel: xlsx ## Print dialog box options - Name of Printer - To print all sheets or selected sheets or cells - Range of Pages to be printed - Number of Copies to be printed - Collate ## Adding a sheet in a workbook 1. Right click on sheet tab --> Insert sheet. - 'Insert Sheet' dialog box will open. 2. Select before / after current sheet. - Select no. of sheets and name of sheet -> OK. ## Deleting a sheet from a workbook 1. Take the click on a sheet to be deleted from sheet tabs. 2. Right click on sheet tab -> Delete Sheet -> Yes (in popup box) ## Renaming a sheet 1. Double click or right click on the sheet to be renamed from Sheet tab. 2. Enter the desired name in the 'Rename sheet' box. - Click OK button. ## Moving a sheet 1. Right click on sheet to be moved from sheet tab. - Move/copy sheet. - Move/copy sheet dialog box will open. 2. Specify before which sheet the sheet is to be moved. - OK. the sheet will be moved. ## Format --> Sheet --> Hide... ## Format --> Sheet --> Show... - Select hidden sheet --> OK.