Friday, 7 June 2013

Day 4

The list below are some of the things in which we must include in our manual:

-File button
-Printing
-Copy and Paste
-Protected View
-Spark-lines
-The quick access tool-bar
-Spreadsheets
-Workbooks
-Locating active cell
-Changing the active cell
-Identifying the active cell
-Selecting multiple cells
-Moving data
-Entering data
-Editing existing data
-Copy and Paste data
-Undoing mistakes
-Undoing multiple mistakes at once
-Redoing an action
-Redoing multiple actions
-Saving your document
-The save button
-Inserting columns
-Inserting rows
-Deleting columns
-Deleting rows
-Resizing columns
-Resizing rows
-Merging cells
-Wrapping text
-Calculating a sum
-Using AutoSum
-Calculating other functions with the AutoSum button
-Constructing your own formula
-MAX function
-MIN function
-How to create charts
-How to change the colour of your chart/ graph
-Customizing your ribbon
-References to other worksheets
-Changing the font text
-Changing the font size
-Changing the style of the text
-Changing the colour of the text
-Adding a cell boarder
-Applying a background colour
-Changing the cell alignment
-Excel help button
-Cell style
-Finding the average
-Copying a formula
-Referencing cells in your formula
-Relative references
-Absolute references
-Mixed references

Some more is be added maybe tomorrow however this is the majority of what Excel can do.

No comments:

Post a Comment