Revision

?
What are features of a spreadsheet
Spreadsheet packages have a number of common features • They perform calculations and recalculations automatically • They allow results to be displayed in tabular or graphical format • They consist of a table divided into rows and columns to produce
1 of 11
How a macro is created in a spreadsheet
Use the record new macro function to carry out a task like the examples listed on last page.
2 of 11
Features of Macros
• Keystrokes or mouse clicks can be recorded to make the macro • The actions are saved as Visual Basic code which can be edited by hand • Shortcut keys can be allocated to macros eg Ctrl+C to copy Ctrl+V to paste Macros can be assigned to a button
3 of 11
Examples of Macro Use
Producing a graph from a table of data • Importing data from another program eg prices from a spreadsheet into a flyer Exporting data to another program Sorting data in a table Saving the contents of a worksheet as an archive file and then clearing
4 of 11
Cells
• Each cell has a column reference (a letter) and a row reference (a number). The active cell is clearly highlighted • The contents of the active cell are displayed in the data entry bar/formula bar.
5 of 11
Count function
the count functin will count the number of entries there are e.g. How many cells contain data in them.
6 of 11
MAX function
The MAX function finds the largest value stored in a group of cells. Eg =MAX(C3:C8) finds the highest score obtained by a pupil in Test 1. The MAX function automatically updates the value in C11 if any of the values in the range C3:C8 change.
7 of 11
MIn function
The MIN function finds the smallest value stored in a group of cells. Eg =MIN(C3:C8) finds the lowest score obtained by a pupil in Test 1. The MIN function automatically updates the value in C12 if any of the values in the range C3:C8 change.
8 of 11
AVERAGE
The AVERAGE function calculates the average of a group of selected cell values. Eg AVERAGE(C3:G3) calculates the average for Claire Doyle. The AVERAGE function automatically updates the value in H3 if any values in the range C3:G3 change.
9 of 11
Data formating
When entering data into a spreadsheet, you can format the data into a specified category. • Cells can be further formatted by specifying aspects such as the number of decimal places, font size and style.
10 of 11
Data formating
To enhance presentation borders and shading can be added to cells. It is also possible to format the alignment of data in cells.
11 of 11

Other cards in this set

Card 2

Front

Use the record new macro function to carry out a task like the examples listed on last page.

Back

How a macro is created in a spreadsheet

Card 3

Front

• Keystrokes or mouse clicks can be recorded to make the macro • The actions are saved as Visual Basic code which can be edited by hand • Shortcut keys can be allocated to macros eg Ctrl+C to copy Ctrl+V to paste Macros can be assigned to a button

Back

Preview of the back of card 3

Card 4

Front

Producing a graph from a table of data • Importing data from another program eg prices from a spreadsheet into a flyer Exporting data to another program Sorting data in a table Saving the contents of a worksheet as an archive file and then clearing

Back

Preview of the back of card 4

Card 5

Front

• Each cell has a column reference (a letter) and a row reference (a number). The active cell is clearly highlighted • The contents of the active cell are displayed in the data entry bar/formula bar.

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »