Computer Concepts Tutorial
Selected Reading
- Computer Concepts - Discussion
- Computer Concepts - Useful Resources
- Computer Concepts - Quick Guide
- Application of Digital Financial Services
- Application of Presentations
- Communication & Collaboration
- Introduction to Internet, WWW, Browsers
- Spread Sheet
- Elements of Word Processing
- Introduction to GUI based OS
- Introduction to Computer
- Computer Concepts - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Spread Sheet
Computer Concepts - Spread Sheet
Microsoft Excel is a spreadsheet apppcation which is used to create and manage psts of information. Excel allows to enter, edit, manage and analyze large amount of data in a worksheet and create colorful charts and graphs. It uses formulae to calculate and analyze data. It helps to combine a series of commands using "Macros", thus saving time. At higher levels, you can use it as a complete development tool catering to many complex requirements.
| Sr.No. | Spread Sheet Concepts & Description |
|---|---|
| 1 |
The topics explaining the entire concepts related to spread sheet in detail, i.e., Elements of an electronic spread sheet, manipulation of cells, functions and charts. |
| 2 |
Manipulation of cells is entering and modifying the contents of the cells. |
| 3 |
Here, we will look into how to create text series, how to create number series and how to create data series |
| 4 |
Modifying or adding text or using cut, copy, paste operations to an existing document is known as editing. |
| 5 |
We shall learn how to use functions and charts in Microsoft Excel Using Formulas pke Addition, Subtraction, Multippcation, Division |
| 6 |
A chart is a graphical representation of worksheet data. Charts can make data interesting, attractive and easy to read and evaluate. They can also help you to analyze and compare data. |
Example Program
We shall discuss an example to understand this concept −
Aim
To prepare a bar chart.
Procedure
Cpck Start → All programs → MS-Office → MS-Excel.
Insert a table in the worksheet.
Select Insert → Chart icon.
Select column option from chart type.
In the title bar, Cpck on chart title box and type, population of metropoptan cities.
Result
The given database is created in excel worksheet using the bar chart.
Summary
This topic had given detailed description about the concepts of opening new and existing worksheets, renaming the work sheet, organizing spread sheet, printing spread sheet, saving workbooks, manipulation of cells, entering text, numbers and dates, creating text, number and date series, editing worksheet data, inserting and deleting rows & columns, changing cell height and width, using formulas, and creating a chart. This chapter also focused on cell address, numbers and text, title bar, menu bar, formula bar, and functions & charts.
Advertisements