COMPUTER APPLICATIONS
PRAC MS EXCEL
KANSIIME MUKAMA BRIAN
MS EXCEL
Microsoft Excel
§ What is MS Excel
§ MS Excel Basics
§ Editing Documents
§ Formatting Cells
§ Formatting Worksheet
§ Working with Objects
§ Working with Formulas
MS EXCEL
Ø What is Microsoft Excel
• MS Excel is a spreadsheet program that allows user to create, edit and analyse
both simple and complex numeric based documents. Examples of such
document includes; Balance sheet. Budgets. Data report, Income statement,
Invoice etc.
• It also has various formatting options like adding images, shapes,charts, and
tables that you can add to your documents.
• Uses of Ms Excel at a Workplace
ü Data organization and analysis
ü Visualization through charts and graphs
ü Financial calculations
ü Project management
ü Performance tracking
ü Budgeting and creating reports
MS EXCEL
Ø Microsoft Excel Terms
• Spreadsheet: ......................................................................................................
• Worksheet: ..........................................................................................................
• Cell: ......................................................................................................................
• Column: :...............................................................................................................
• Row: :.....................................................................................................................
• Range: ..................................................................................................................
• Cell Reference: ....................................................................................................
MS EXCEL
Ø MS Excel Basics
• Getting started with word
Get to know the ribbon, quick access toolbar, working area and status bar to
produce Word documents.
• Creating and opening documents
Learn all about how to open an existing documents and create new ones
• Saving a documents
Learn more about saving and sharing documents
• Moving around page
Learn to move around Ms Excel page using mouse, keyboard, Scroll
buttons and go to commands
• Zoom in and out
Changes the size of the font on-screen without impacting any other attribute
of the document using zoom control buttons.
MS EXCEL
Ø Ms Excel Window Overview
MS EXCEL
Steps on How To Save MS Excel File - Inside a Folder
• Step 1 - Click on file tab
• Step 2 - Select Save as option
• Step 3 - Lacate/Decide where to
save your file. If it your folder
is on destop, choose desktop
• Step 4. Select and open your folder
• Step 5. Name the file
• Step 6. Decide the file tye
(By default, its Ms Excel file type)
• Step 7. Click on Save button
MS EXCEL
Ø Editing Worksheet
• Select/ highlight worksheet
• Move/copy worksheet
• Create/Rename a sheet
• Insert /Delete Rows and Colums
• Decrease and increase column width and row height
• Find and repalce, sort and filter text
• Perform spell checks
• Undo and redo changes
• Hide and unhide a colum, row and sheet
MS EXCEL
Ø Editing Cells
• Being on a cell and being inside a cell
• Insert, select, delete and move data in a cell
• Merge cells, wrap and rotate cells
• Format Number (decimals, commas,currency)
• Setting Fonts (Colors, Size, type)
• Text decorations (Bold, Underline,
• Add Borders and shades
MS EXCEL
Ø Working with objects and symbols
• Insert symbols
• Insert comments
• Insert wordArt
• Add charts (Pie, bar, line and other charts)
• Add text box
• Shapes
• 3D Models
• Add Tables
MS EXCEL
Ø Formatting Worksheet
• Adjust Margins
• Page Orientation
• Add themes
• Set background
• Header and footers
• Freeze Panes
• Printing Worksheet
• Format Painter
MS EXCEL
Ø Working with Formula
• Creating Formulas
• Copying Formulas
• Formula Reference (Relative and Absolute)
• Arithmetic Operators(+,-,*,/)
• Using Functions (sum(), average(), min(), max(), count())
LESSON SUMMARY
01 • What MS Excel
02 • MS Excel Basics
03 • Editing a Worksheet
04 • Editing a Cell
•• Formatting a Worksheet
05
06 • Working with Objects
07 • Working with Formulas
08
SAMPLE QUESTIONS
1) What is the difference between MS Word And Ms Excel
2) Write down steps followed when saving a file
3) Mention any four application programs found in MS Office Suite
4) Write down the steps one when follows when bolding a text in Ms Word
5) Mention any four spreadsheet programss
WHAT IS SMART
LEARNING
Contact details
bratec818@gmail.com
+256 789 948695
