ICT Practical Revision Notes

Word Processing (MS Word)

 Serif – with flicks e.g. Times New Roman (short name  long font
name)
 Sans-serif – without flicks e.g. Calibri, Arial (Long name  short font
name)
 One part of document as 1 column and the rest in two columns a →
section break.
 When you want to move text to the next column a → column break.
 To force all further text onto the next page → page break
 A widow = single line that appears on the next page or column,
separated from the rest of the paragraph
 An orphan = single line that appears on the previous page or column,
separated from the rest of the paragraph.
 To add page numbers in the header/footer ------→ Place your cursor
where you want to put the number → Go to insert tab → Quick parts →
Select Numbering category → Select Page in field names → Click Ok
 Add the file size/name (including file path) → click on Quick parts in
Insert tab → click on Field → select File Size or File name.
 For file path → check the box to include file path.
 For file size → choose whether Kilobytes or Megabytes.
 Include date → click on Date & Time in Insert tab → choose an
appropriate format as specified. (If the date/month format is flipped →
change your region/ language settings on your computer to United
Kingdom.)
 Update fields if required (select auto update while inserting fields.)
Database
Sum of fields in a report =SUM([Field_name])
Average of fields in a report =AVG([Field_name])
Minimum of fields in a
=MIN([Field_name])
report
Maximum of fields in a
=MAX([Field_name])
report
=COUNT([Field_name])
Count number of fields in a
(Always use primary field as it is the only
report
unique field)
To add a new field in a New field name :
report with formula [Field_name]*[Field_name]

| Yes | Find values that are Yes/True |

| No | Find values that are No/False |
| #01/01/2009# | Find a specific date |
| >01/03/2009 | Find dates after a given date |
| <01/03/2009 | Find a date before a given date |
| Between 01/03/2009 and 31/03/2009 | Find dates in a given range |

PowerPoint Presentation
 loop a slide show so it plays continuously until the Esc key is pressed 
Slide show tab  click on Set Up Slide Show under Set Up  Show
options  tick the box with “loop...”
Excel
 Showing formulae (To show formulas instead of values)  select Show
Formulas under the Formula Auditing section of the Formulas tab
 To set a cell as currency → click on the popup box in the Number
section of the Home tab → select Currency and pick the required
symbol and number of decimal places as specified on the paper.
 To color a range of cells that contain certain values → under Styles
section in the Home tab → click on the drop-down menu
under Conditional Formatting Choose New Rule → Format only cells
that contain→ add the rule according to the instructions on the paper
from the Format tab (ego: less than 100, format: green)
You can add more than one rule to a range of cells, by repeating the
same steps for the new rule.

 When you are using another file as a source file (LOOKUP function),
make sure it is open until the end, else the spreadsheet will no longer be
able to access that data.
 To make cell reference absolute, press F4 while highlighting it

DESCRIPTION FORMULA
Add, Subtract, Multiply, =A1+B1
 DESCRIPTION FORMULA
Divide
SUM (Adding a range of =SUM(A1:A4)
numbers)

AVERAGE (Find the =AVERAGE(A1:A4)

average)

MIN (Find the lowest value) =MIN(A1:A4)

MAX (Find the highest =MAX(A1:A4)
value)

COUNT (Counting
generally how many numbers
=COUNT(A1:A4)
are in a range including
blanks)

COUNTA (Counting the

number of items in a range =COUNTA(A1:A4)
excluding blanks)

INT (Converts to the lowest =INT(A1)

whole number)

ROUND (Rounding =ROUND(A1,2) [The 2 is the number of

numbers) decimal places]
ROUNDUP (Rounding =ROUNDUP(A1,2)
numbers up) [The 2 is the number of decimal places]
ROUNDDOWN =ROUNDDOWN(A1,2)
(Rounding numbers down) [The 2 is the number of decimal places]
=VLOOKUP(A1,$B$1:$C$8,2)
VLOOKUP (Looking up A1 is the cell to check, $B$1:$C$8 is the array
what particular values mean
to look in, 2 is column 2 from $B$1:$C$8
from a table arranged
vertically) meaning return the value in column 2 in that
section.
HLOOKUP (Looking up =HLOOKUP(A1,$B$1:$G$2,2)
what particular values mean A1 is the cell to check$B$1:$G$2 is the array
from a table arranged to look in, 2 is row 2 from $B$1:$G$2
horizontally)
meaning return the value in row 2 in that
 DESCRIPTION FORMULA
section.
=VLOOKUP(A1,filename.csv!
VLOOKUP/HLOOKUP $B$1:$G$2,2,FALSE)
from another source file =HLOOKUP(A1,filename.csv!
$B$1:$G$2,2,FALSE)
=SUMIF($B$1:$C$8,A1, $D$1:$D$8)
SUMIF (adding up specific Checks if any cells in $B$1:$C$8 = A1 and if
values in a range)
they do then it adds them together
=COUNTIF(A2:A4,">4")
COUNTIF (Counts the Checks that cells have a value greater than 4
number of cells in a range =COUNTIF(A2:A4, A1)
that satisfy the given criteria) Checks that the cells are equal to the value in
cell A1
=IF($B$1:$B$8=A1,”A”,”B”)
IF (Deciding what will go If the value in A1 appears in the range of cells
into a cell)
then write A, if not then write B
=IF($B$1:$B$8=A1,”A”,
IF($B$1:$B$8=A2,”B”,
IF($B$1:$B$8=A3,”C”,D)))
Nested IF
If the value in the range equals A1 then write
A, if it equals A2 write B, A3 write C and
none of them D
Average IF (it searches for =AVERAGEIF($D$4:$D$64,G3,$E$4:$E$64)
criteria and makes an
$D$4:$D$64 is the range, G3 is the
average of the range
according to the criteria) criteria, $E$4:$E$64 is the average range

SQRT (Square root of a =SQRT(B3) [B3 is the number]

number)
HTML
 If the link needs to open in a new window 
<a href=”randomlink.com” target=”_blank”> </a>
 If the link needs to open in a current window 
<a href=”randomlink.com” target=”_blank”> </a>
 To set a bookmark tag in your code around this text 
<div id="top"> Destination text </div>

h2 {font-family: “Times New

Font type
Roman”}
Text size h2 {font-size: 16pt}
Aligning text h2 {text-align: center}
‘Bold’ text h2 {text-weight: bold}
h2 {text-decoration:
‘Underline’ text
underline}
h2 {font-family: “Times
Second choice of font
New Roman, Verdana”}
h2 {font-family: “Times
Adding generic fonts (either serif or sans- New Roman, serif”}
serif) h2 {font-family: “Calibri,
sans-serif”}
Changing color h2 {color: #000000}
Using classes to set styles.
right {text-align: right}
Can be used for many selectors
Comment in HTML - text that is not read <! - -Enter comment here - -
by the computer, only for users >
Comment in CSS - text that is not read by /* Enter comment here */
 h2 {font-family: “Times New
Font type
Roman”}
the computer, only for users

Color Codes
 Pure red is (FF0000)
 Pure green is (00FF00)
 Pure blue is (0000FF)
 Pure yellow is (FFFF00)
 Pure black is (000000)
 Pure white is (FFFFFF)

CSS
 Inline CSS  e.g. <table border=”1” style= “width:200px”>
 Format for external CSS  e.g. h1 {property: value;}
 To add multiple fonts, add commas  e.g. h1 {font-family: Arial,
Calibri, sans-serif;}
 body {background-repeat: no-repeat;}
 body {background-position: top/left/right/bottom;}
 h1 {text-align: left/right/top/bottom;}

Table tags format

cell Table { padding :40px;}
padding
cell Table { spacing : 30px;}
spacing
Table { border-width:3px;}
Table { border-color: #000098;}
borders Table { border-style: solid;}
Table { background-color:
#009499;}

Td/th tags td { font-size: 3;}

Table tags format
td { font-family: Calibri;}
td { color: #000000;}

Dimension table { width:50px;}

s table { height:60px;}