Trainee Support Website
Answer to Exercises:
Pg 258 Q1
Pg 122 Q2
Pg 341 Q1,2,3
Pg 343 Q1,2,3
Friday 2nd April:
Started outlook. Basic Navigation, Creating and sending an email. Formatting, Using Stationary, and using Templates
EXCEL: Import Data from text files ( insert , drag and drop )
Import from other applications
Wednesday 31st:
Practice website for enlight testing.
Enlight Test Demo
Note: You will get a warning about installing Enlight ECDL software. Click yes and tick always trust software from enlight.
Monday 29th: Linking worsheets, creating 3d references, Hyperlinks, Emailing and Copying a Worksheet, Styles
Answer to Exercises:
Friday 26th: Change series and build Combination Charts. Insert/Delete/Move/Copy Work Sheets. Move Between them. Conditional Formatting. Print workbooks and Sheets. Use webpage preview and save as webpage. Delete and Insert Cells. Find and Replace. Using the Drawing toolbar
Answer to Exercises: Pg 148 Q 1,2,3 Pg 170 Q3, P214 Q 1,2,3
Pg 215 Q1,2,3 Pg 171 Q2,3
Wednesday 24th: MAX, MIN and AVERAGE Functions. Building a PMT function. Using the IF and Date/Now functions
PMT Function ( Interest Rate / Number of Payments per year <Comma> Total number of months <Comma> MINUS Total Borrowed )
Tuesday 23rd: Operators/Order of preference, Type and Point, Absolute and Relative ( More Detail, Creating and Copying ) Freezing and Splitting the Worksheet. Hiding Rows and Columns. Display Formulas instead of Results, Use Save as.
EXAM (WORD EXPERT): 1.00pm and 2.00pm
Answer to Exercises: Pg 91 Q 1,2,3 Pg 92 Q 1,2,3
Monday 22th: Basic Formulas, Headers and Footers, AutoFill and Autsum Function. Afternoon: Copy and Paste, Insert/Delete/ Rows and coloums. References( Absolute and Relative). Applying Number formats, Alignment of cell contents, applying styles, boarders and shading, Format Painter and Clear formats and cell contents.
Answer to exercises: P45 Q 1,2,3 Pg 67 Q 1,2,3
Friday 19th: Covered Basic Introduction to Excel. Ref: Chapter 1 in book