Spreadsheet dig. notes.docx

Spreadsheet MS OFFICE - It is a collection of office related software. - It includes: 1. MS Word -- Word processor used for creating documents 2. MS PowerPoint -- Used for making presentations 3. MS Excel -- Spreadsheets software used for making spreadsheets. 4. MS Access -- Used for...

Spreadsheet MS OFFICE - It is a collection of office related software. - It includes: 1. MS Word -- Word processor used for creating documents 2. MS PowerPoint -- Used for making presentations 3. MS Excel -- Spreadsheets software used for making spreadsheets. 4. MS Access -- Used for creating database. SPREADSHEET - A sheet which is in the form of a grid. - It is a collection of rows and columns. - Example -- Ms Excel, etc. COMPONENTS OF MICROSOFT EXCEL 1. Workbook -- A file in Ms Excel is called workbook. 2. Worksheet -- A single page in a workbook is called worksheet. 3. Row -- A horizontal line going from left to right. 4. Column -- A vertical line going from top to down. 5. Cell -- Intersection of row and column. 6. Row header -- A vertical line before rows that shows row numbers. 7. Column header -- A horizontal line above columns that shows column letters. 8. Sheet tab -- A tab at the bottom left corner that helps to add, delete, rename a sheet. 9. Cell address -- Each cell has cell address i.e. column letter followed by row number. 10. Horizontal scroll bar -- It is used to scroll the page left and right. 11. Vertical scroll bar -- It is used to scroll the page top and down. 12. Name box -- Shows cell address of active cell 13. Active cell -- Cell which is highlighted by black boundary. 14. Formula Bar -- A bar in front of the name box which shows -fx sign and shows formula of cell. 15. Cell Range -- Range of cells when multiple cells are selected. It is called cell range Ex: (C1:C10) in which, C1 is the beginning cell and C10 is the last cell selected. 16. Cell Reference -- The cell range which denotes multiple cells is called cell reference. TYPES OF CELL REFERENCE 1. Relative Cell Reference -- - When we copy the formula, the cell address are changed automatically according to the rows and columns, it is called relative cell reference. Ex: =A1+B1+C1 =A2+B2+C2 When formula copied. 2. Absolute Cell Reference -- - Sometimes, we want to keep the cell address fixed while copying the formula. We apply \$ sign before cell address to perform it, it is called absolute cell reference. Ex: =\$A\$1+10 =\$A\$1+10 When copied =\$A\$1+10 3. Mixed cell reference -- - It is a combination of both where some addresses are changing and some remain fixed. Ex: =A1+B1+\$C\$1 = A2+B2+\$C\$1 When copied. =A3+B3+\$C\$1 FUNCTIONS Function are the predefined formulas to perform various calculation. - They are also called built-in formulas. - Functions contain arguments. ARGUMENTS - The cell addresses or cel numbers that we write inside the function brackets (also called parenthesis) are called arguments. SYNTAX - It is the function name (arguments) Ex: (from school notebook) Question: What are the points must be taken care of while writing the format of a function? Answer: Points to be taken care of while writing the format of a function are: - Each function must begin with an 'equal to' (=) sign. - Parenthesis is used to indicate the opening and closing of a function. - Arguments are written within the parenthesis. - Commas are used to separate the arguments. TYPES OF FUNCTIONS 1. Sum ( ) -- It will give sum of the values given in cell range or in the arguments. 2. Average ( ) -- It will give the average of the values or the average of the values present in the given range. 3. Max ( ) -- It will give highest number from the range or from values. 4. Min ( ) - It will give the smallest value from cell range or from argument values. 5. Product ( ) -- It will give product of values or product of numbers of cell range.