Transcript Slide 1

2008 November
CAT Practical examination
1.1 File management
Hidden
2
1.3 Save as RTF
3
1.5 Add password
Add password
4
Word
2.1 Set author properties
Properties
6
2.3 Line spacing
Paragraph line spacing
Paragraph line
spacing
7
2.4 Replace electric with
ELECTRIC in red
Click here for formatting
Whole word
Format in red
8
2.5 Border around text
Paragraph
9
2.6 Footnote
10
2.7 Delete comment
Right-click then …
11
2.8 Change bullets
Select text, then
go to Customize
12
2.8 Change bullet
Character
13
2.8 Change bullet
14
2.8 Bullet changed
15
2.9 Manuscript signs
• Stet – means leave it alone, do not
correct, sorry, ignore my correction
• Trs – transpose, switch around
16
2.10 Use a column break if
necessary
17
2.10 Use a column break if
necessary
18
2.11 Hanging indent
Indent
19
3.4.1 Odd and even page numbers
20
3.4.3 Modify a heading style
21
3.4.5 Table of Contents
If you have a problem
with the TOC,
go to Options.
Should only be 2 levels.
Options
22
3.4.5 Table of contents
Click OFF Outline levels
23
Excel
4.5 Calculate between sheets
Link to other sheet
25
4.8 Format as Dollars
Currency dollars
26
4.9 Vlookup Absolute
27
5.1.6 Nested IF
28
5.2.2 Sumif
29
5.3.1 Count number of P3
2 steps
Then count all the P3s
First left
30
5.3.2 How old
=Now()
Minus when bought
Divided by number of days per year
Formatted as a number
31
Access
6.1.1 Field size
Field size
33
6.1.2 Primary key
Primary
key
34
6.1.3 Default value
Default value
35
6.1.1 and 6.1.4 Format and
Validation rule and text
1 Decimal place
BETWEEN ? AND ?
36
6.1.6 Input mask
Two letters, capital letters,
and two numbers
37
6.2.1 OR
38
6.2.2 Older Date – Not displayed
Not displayed
< Less than
39
6.2.3 New field - Calculation
New field
Colon
Field name
Multiplication
40
6.2.4 Group
41
6.2.4 Group footer
On footer
42
6.2.4 Count anything (*)
In footer
=Count(*)
43
6.2.4 Average avg
=avg([HDD])
44
6.2.4 Oldest
=min([date_of45
6.2.5 Import
Import
46
Semicolon First row
Semi colon
First row
47