To undo the previous action(s), click on the Undo button

To redo actions, click on the Redo button

OR

You can use the Edit menu - click here to find out how

Discuss in forum (0)

Popularity: 6%

Auto fill

When hovered over the main body of the spreadsheet, the mouse normally appears n the screen as a white cross.

If the mouse is hovered over the bottom right corner of a cell, the white cross changes into a black cross. This is the Auto fill cross, which can be used to copy and increment data,

When the white cross has changed to a black cross, click and drag…read more

Discuss in forum (0)

Popularity: 6%

A basic calculation could involve, for example, a simple addition between two values. Te calculation (or formula) always begins with an equals sign (=), which indicates to Excel that some kind of calculation is about to be entered. An example of a simple calculation is:

= A1+A2

Click here to find out what this basic formula would do…

Discuss in forum (0)

Popularity: 6%

Some of the more involved formulas may get very long and time consuming to type on. Excel therefore provides shortcuts in the form of functions, which are pre0defined mathematical strings which contain formulae and are named by a term which best describes their use:

Common functions

=SUM (??:??): Totals the contents of a range of cells (see below)
=AVERAGE(??:??): Calculates the average of the contents of a range of cells
=SQRT(??): Calculates the Square rRot of the contents a cell

To find out more common fnctions click here

Discuss in forum (0)

Popularity: 6%

To insert a Column/Row:

Click on the columns or row identifier to the left of the row/top of the columns (i.e. the columns letter or row number):

Click on the insert menu and select Columns or Rows

The new column/wow will be inserted at the point selected.

Multiple columns/rows can be inserted by selecting the required number of columns/rows before clicking on the insert menu.

To find out how to delete a Column/Row and to try out a simple exercise click here

Discuss in forum (0)

Popularity: 9%

Method 1

Select the column/row then right click

Choose Column Width or Row Height from the menu that appears

Enter the new measurement and click on OK

Method 2

Hover the mouse pointer between…read more

Discuss in forum (0)

Popularity: 6%

It is very easy to change the appearance of your spreadsheet by applying formatting commands. For example, you can:

• Change the font style, size and color
• Add borders, shading and patterns
• Change the way numerical values are displayed, e.g. specify the number of decimal places, add a dollar sign, etc
• Change the alignment of entries
• Adjust column widths and row heights

Click here to find out more about formatting and how formatting can be applied

Discuss in forum (0)

Popularity: 6%

The Page Set Up dialogue box enables you to change such setting as:

• Page Orientation and Order
• Paper size
• Print Quality
• Margins

To find out how to:

• Add Headers and Footer to you r Spreadsheet (see below)
• Center your spreadsheet on the page
• Print Guidelines ad Comments

Click here

Discuss in forum (0)

Popularity: 6%

To view your spreadsheet as it will print, either click on the File menu and select Print Preview OR click on the Print Preview icon

Next: To go to next page
Previous: To go to previous page
Zoom: To zoom in or out
Print…read more

Discuss in forum (0)

Popularity: 6%

To print your spreadsheet either:

Click on the Print button within the Print Preview Window OR

Click on the File menu then select Print

The Print dialogue box will appear:

It is possible to specify exactly what to print by making changes in the Print range/Print what sections, to find out more click here

Discuss in forum (0)

Popularity: 6%