Page 194 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 10: Microsoft Excel

Notes
10.9 Summary
10.10 Keywords
10.11 Self-Assessment Questions
10.12 Review Questions
10.13 Further Readings

Objectives
After studying this unit, you will be able to:
• Discuss the starting of excel
• Explain the excel window in worksheets
• Discuss the creation of excel sheet and saving cash sheets in excel format
• Discuss entering of data and explore number format
• Explain the sort function and entering of dates
• Explain cells and formality of cells
• Discuss excel function, in date time, financial, logic, mathematical and trigonometric
functions

Introduction
This application is one of the most useful tools to carry out most of the common scientific
and statistical tasks in a faster way. The data once entered in to a worksheet can be
manipulated to carry out many results and also using the same data or its output to plot
a graph. This Application has a standard library of mathematical, scientific and statistical
formulae and these facilities can be used to estimate the result. The following topics will
describe how to use this application from first principles.

10.1 Starting Excel
10.1.1 Excel 2003

1. Click the Start button in the lower-left corner.

Figure 10.1: Starting Excel

LOVELY PROFESSIONAL UNIVERSITY 187