Spreadsheet-
Spreadsheet is an computer application used to store data in tabular form i.e. in the form of rows and columns. Spreadsheets are used to store, sort, analyse and manage the data of different organisations and offices. Examples are Microsoft Excel, Libre Office Calc, Google Sheets etc.
Everything has some attributes and fixed value of attribute is called data.
Data can be represented in different types which is called data type. Different datatypes in spreadsheets are-
PARTS OF
SPREADSHEET
Spreadsheet is an computer application used to store data in tabular form i.e. in the form of rows and columns. Spreadsheets are used to store, sort, analyse and manage the data of different organisations and offices. Examples are Microsoft Excel, Libre Office Calc, Google Sheets etc.
What is data?
Attributes
|
Value/Data
|
Name
|
Mango
|
Type
|
Fruit
|
Taste
|
Sweet
|
Data Types
Data can be represented in different types which is called data type. Different datatypes in spreadsheets are-
- Text - combination of letters and numbers is called text data. Exp name: shahid, class: vi A
- Numeric- combination of numbers is called numeric data. Exp weight: 20.5 kg
- Date- Date is written inthe format DD-MM-YYYY. Exp. 02-10-1889
- Image- Image data types is used to store images, pictures.
- Audio- any sound file comes under this datatype. Exp recording on radio
- Video- Video is also a datatype in excel to store videos
How TO START SPREADSHEET
Steps to start a spreadsheet are as follows-
1.
From Windows/Start Button
Step1: Click on Windows/Start Button
Step2: Click on All Apps
Step3: Click on Excel from the software list
2.
From Search Box
Step1: Type the excel
on search box
Step2: Click on the
excel
3.
From Windows Run Dialog Box
Step1: Search the
window button on the keyboard, Press window button with r.
Step2: Type Excel
Step3: Press ok
PARTS OF
SPREADSHEET
Q. What is worksheet? Write down use of worksheet.
Ans: A worksheet is a collection of cells where
you keep and manipulate the data. Each Excel workbook can contain
multiple worksheets.
Q. Explain the Cell?
Ans: A cell is the storage unit in a spreadsheet
program like Microsoft Excel or Google Sheets. Cells are
the boxes in a spreadsheet that may contain data. The cells in a
spreadsheet are organized within a column and row in the worksheet, and can be
formatted for aesthetics or visibility.
Q. When Fill Handle is used?
Ans: In Microsoft Excel, a fill handle is a
feature that allows the user to extend (and fill) a series of numbers,
dates, or even text to a desired number of cells. In the active cell of the
spreadsheet, the fill handle is a small black box at the bottom right
corner, as shown in the image to the right.
Note- Row1 is
called header row.
Note- Each cell has an address which is made by column name followed by row name. Exp A5 where A is name of the column and 5 is name of the row.
Note- Selected cell is called active cell where we can enter the data.
Note- Each cell has an address which is made by column name followed by row name. Exp A5 where A is name of the column and 5 is name of the row.
Note- Selected cell is called active cell where we can enter the data.
ORDERING AND ANALYSING DATA—
Ordering the data----
Ascending order (Smallest to Largest (for Numeric
datatype)
‘A to Z’ or ‘a to z’ ( for text data type))
Descending order (Largest to smallest (for Numeric
datatype)
‘Z to A’ or ‘z to a’ ( for text data type))
Steps to arrange the data in Ascending/ Descending order
Step 1: Select the header cell of column.
Step 2: Go to the Home tab -> Select Sort and
filter option.
Step 3: Click on ‘Sort A to Z’ or ‘Sort Z to A’
Analysing Different Data Sets and Share Findings
Formula A formula simply tells the program what you want it to do.
The formula is always in the cell where you want the answer to appear.
The standard arithmetic operator: add (+) subtract (-) multiply(*) and divide (/) work just as you would expect.
Brackets can be included where you need them and the result will be calculated following the normal BODMAS rules.
Brackets can be included where you need them and the result will be calculated following the normal BODMAS rules.
There are a whole load of other Functions that you can add to a calculation by typing their name or choosing one from the list of functions.
Some of the simpler ones are: Average, Max, Min and Count.
How to write a formula
Its very important to learn how to write a formula in excel because by writing a formula we can minimize over work and can do it smartly. Suppose we want to write a fomula to multiply two numbers which are stored at cell B2 and D2 and we want to store result at cell D2. The steps are as follows- 1. Click on the cell where you want to apply formula like cell cell D2
2. Click on the formula bar to wirte the formula
Note- in spreadsheet formula start with. = Sign.
3. Write the formula which start withh equal sign
Exp. = B2*C2. Here vaalue of cell B2 is multiplied by value of cell C2.
4. On clicking enter key result will be displayed in cell D2.
How to write a formula
Its very important to learn how to write a formula in excel because by writing a formula we can minimize over work and can do it smartly. Suppose we want to write a fomula to multiply two numbers which are stored at cell B2 and D2 and we want to store result at cell D2. The steps are as follows- 1. Click on the cell where you want to apply formula like cell cell D2
2. Click on the formula bar to wirte the formula
Note- in spreadsheet formula start with. = Sign.
3. Write the formula which start withh equal sign
Exp. = B2*C2. Here vaalue of cell B2 is multiplied by value of cell C2.
4. On clicking enter key result will be displayed in cell D2.
Nice
ReplyDelete