Page 54 - TP_Prime_v2.2_Class_6
P. 54
Customise Worksheet Tab
Perform the following steps to customise worksheet tab:
Step 1: Right-click the sheet tab that you want to customise.
Step 2: Click on Rename to rename the sheet or Tab Color
to select a tab colour or Delete to delete the sheet.
Prime (Ver. 2.2)-VI Step 3: Type in the name or select a colour you would like
for your spreadsheet.
Step 4: The information will be added to the tab at the
bottom of the spreadsheet.
You can also use the Insert, Delete, and Move or Copy options Customising Worksheet Tab
to add a new sheet, delete a sheet, and move or copy a sheet respectively.
52
Functions
Functions are predefined formulas in Excel to perform both simple and complex calculations.
These accept arguments and return values. Arguments are input to the functions. These
arguments can be numbers or text. The values should be given in between opening and
closing ( ) parenthesis.
Rules for using Functions
Some rules for using the functions are:
• All Excel functions must begin with the = sign.
Function name must be a valid Excel name.
Function must be followed by opening and closing parentheses.
Most of the functions must contain an argument within them.
Categories of Functions
Excel provides the following categories of functions:
• Mathematical Functions: Calculates the square root or absolute value of a number,
product of numbers etc.
Text Functions: Performs a number of operations on strings (i.e. a collection of characters
like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two
strings, searching for one string inside another, etc.

