CLASS 6 CH- 5 WORKING WITH MS-EXCEL 2016

WORKING WITH MS-EXCEL 2016

1. What is a spreadsheet ? What are the advantages of using             spreadsheet software?

     Spreadsheet is a document that stores data in a grid of horizontal   

     rows and vertical columns. 

     Advantages of spreadsheet software are: 

1. Easy to enter and format data. 
2. Making changes is easier. 
3. Calculations are error free. 
4. Ability to create
5. graphical or visual representations of your data. 
6. Can be used for what if analysis and decision making.

इस video की सहायता से सीखें, कैसे एक्सेल में functions यूज  करतें है. 

b) Explain rows and columns in terms of MS‐Excel.

Column starts at the top of the worksheet, goes to the bottom of the worksheet and is identified by a letter. 

Each row starts at the left edge of the worksheet, continues to the right and is identified by a number. 

There are 1,048,576 rows and 16,384 columns in one Excel 2016 worksheet.

c) Explain the types of data that can be entered into the Excel spreadsheet.

Three different kinds of data that can be entered into the excel spreadsheet. 

LABELS: Used to define the information on the spreadsheet i.e. headings of columns. 

VALUES: They are any numbers we wish to enter that will be used as a part of a calculation(0‐9). 

FORMULAS: A Formula is a mathematical calculation of numbers with operators.

d) What is cell range?

Cell range is a selected rectangular area of adjacent cells. When we select a range, the selection becomes dark and has a border around it.