Basic features of a spread sheet

Spreadsheet is a huge table with many rows and columns. Spreadsheets are generally used to analyze data, make projections based on the data, and graphical representation of data.

Learning outcome

At the end of the tutorial the learner will be able to have generally basics about an excel spreadsheet, what its comprised of, how it can be used to up speed work some of the few lessons will include.

• How to open Microsoft excel?
• Understanding the ribbon.
• Customization of the excel environment

(a). ribbon

(b). changing colour theme

(c). formulas settings.

(d). proofing settings

(e). save settings

• Opening a spreadsheet
• Entering data in a spreadsheet
• Using a spreadsheet to add, subtract or multiply data automatically
• Hiding and unhiding rows and columns
• Filtering data
• Auto fitting
• Inserting a comment.

You can use a spread sheet to: Enter data.

• Edit data. Format data.
• Perform calculations on the data.
• Draw charts and graphs based on the data.