Download - Spread sheet tools presentation
Spreadsheet ToolsDone by: Shamsa AlfalasiID:200922245Course: COL 270-541
Objectives What is Spreadsheet What is tool in Microsoft Excel What is it used for Who uses Microsoft Excel What are the basic tools: Why is it important Conclusion
What is spreadsheet
Definition Excel or
spreadsheet is used to represent the data in more understandable, recognizable and organized form
Example
A tool in Microsoft excel
Definition The "Tools" section
in Microsoft Excel is a function that will allow the user to manipulate or format the cell that has been selected
Example
What it is used for Microsoft Excel is
used to organize numeric data
Who Uses Microsoft excel Accountants Marketing
professionals Financial analysts Students Teachers
Basic Tools Format Orientation Wrap text Formulas and functions:-Sum-Average Charts:-Columns-Pie
Basic tools
Example Select the row
containing the headers and right click on it and select Format Cells option
Example Select the cells
you want to format
Click on the orientation in the home tab
Example Select the cells
you want to wrap
Click on the home tap and then choose wrap text
Formulas and functionsHow to write a formula
The formula starts with a = in the front
Example
Sum Function Adds the values in
the function argument or the values in the cell references in the argument.
Average Provides the
average of the range of references in the argument
Charts
Pie The 3-D pie chart
is a simple chart style that is useful for illustrating the parts of a whole.
Found in the insert tool
Columns Columns are the
vertical divisions of a worksheet that are identified by letters.
They are found in the insert tool
Resources Desk, G. (2008, n/d n/d). How To Use Excel.
Retrieved Nov 7, 2011, from Geeks Desk: http://www.geeksdesk.com/how-to-use-excel/
o eHowTech. (2009 , March 10). Computer Tech Support : Definition of Tools in Microsoft Excel . United States.
Intelligentedu. (n/d, n/d n/d). Microsoft Excel Glossary. Retrieved Nov 7, 2011, from Intelligentedu: http://www.intelligentedu.com/microsoft_excel_glossary.html
Winter, J. D. (n/d). How to use a spreadsheet. How to use excel, 10.