Page 70 - Computer - 6

7 7 More on Excel 2019
More on Excel 2019

Pre-Processing

• Features of Excel 2019 • Components of Excel 2019 Window
• Entering Data in Cells • Editing Cell Contents
• Undo and Redo Commands • Copying and Moving Cell Contents
• Inserting Cells, Rows, or Columns • Deleting Cells, Rows, or Columns
• Changing Row Height and Column Width • Font Formatting
• Cell Formatting • Working with Long Text
• Number Formatting • Date and Time Formatting

Excel 2019 is one of the most popular spreadsheet software It allows you to create workbooks, containing
one or more pages called worksheets. A worksheet contains cells arranged in the form of rows and
columns.

Let us learn to enter data in cells, edit the cell contents, insert or delete cells, rows, and columns, and
adjust the row height and column width.

FEATURES OF EXCEL 2019

Excel 2019 lets you:
• arrange data in a workbook across multiple worksheets.
• enter data in a variety of formats, such as text, numbers, and formulas.
• edit and format data in different ways.

• automatically recalculate all the formulas whenever a related number or a value is changed.
• perform automated calculations using predefined functions.
• fill data automatically by using patterns in series.
• represent data visually using charts and other graphic objects.

• create, maintain, and analyse databases easily.

68