C A T
omputer pplication echnology
Word
● Track Changes
○ Review Tab → tracking
● Bookmarks
○ To insert
■ Select a word → insert tab at the top → links tab inside the
insert tab → bookmark → (name can’t have a space)
○ To find bookmark
■ Command 7 → press the drop down in the search bar → go to
→ select bookmark → go to
● Hyperlinks
○ Insert tab → links
● Cross-References
○ Insert tab → cross-references
● Line and page break
○ Home tab → paragraph dialogue box → line and page breaks
■ Widow/orphan control = prevents a single line of paragraph from
appearing on page
■ Keep with next = prevents one paragraph from being separated
from the next (with headings and paragraphs)
■ Keep lines together = keeps all lines in same paragraph together
■ Page break before = specific paragraph will always appear at
top of new page
● Mail Merge
○ Mailings tab
■ 1. Start Mail Merge
■ 2. Select recipients
■ 3. Insert merge field
■ 4. Preview results
● Check accessibility
○ File tab → info → check for issues → check accessibility
● Check compatibility
○ File tab → info → check for issues → Check compatibility
● replace image/caption image
○ right click on image → replace image → find image on computer in
exam folder → insert
○ Insert image → right click image → change the name of the caption →
insert the caption at the bottom or top depending on the photo
● add author (file properties)
■ metadata → press file and then info
○ to add author → file, info, author, change
● create a new style
○ home → style, select
○ see how many headings have one specific style :
■ right click on current style → select all instances
○ font formatting
● font type, font size, font style, font colour
○ style → create → modify → format [in the corner]
○ create a style
■ style → create → modify
● modify a style
○ based on an existing style
○ right click on style → modify
● apply an indent (left)
○ paragraph box → small corner item
○ indents on right and left [in cm]
○ first line line indent
■ for exam : can give you a screenshot, with an indent shown on
the ruler, and then say apply that indent on the next paragraph
● shade a paragraph
○ paragraph box → paint bucket [shading]
○ paragraph box → borders & shading drop down → borders & shading
● insert file as an object (icon)
○ insert → object [text section] → object [drop down] → create from file
→ tick link to file & display as icon → browse [find what file you are
looking for]
● copy data from 1 table to another
○ insert a table
■ adding more rows : repeat pressing tab until you have enough
rows
○ first have to sort data
■ select table : layout [2nd layout (for table)] → sort → chose data
○ then copy and paste appropriate data
■ select what info you needed from sorted table and copy and
past
● apply a formula to a table
○ =MAX(above)
■ layout [2nd layout (for table)] → formula [in data section]
● if you select a number and highlighted dark grey, it uses a
formula
■ to change the formula of a number
● right click number → edit field → formula
● multilevel list
○ home → paragraph → multilevel list → define new multilevel list →
choose number system → go in front of inserted number → include
level number from → select level one → insert a dot
● insert filename field with path in header
○ double click in top margin → click in header → go to header footer tab
→ go to insert section → quick parts → field → click on filename → tick
add path to filename
● put text into columns with a line between
○ use column breaks to put headings at the top of column
■ select everything you want in columns → layout → more
columns → select amount of columns & tick add lines → insert
column breaks so info goes to right column
● justify text
○ has a solid left margin and a solid right margin
○ home → paragraph
○ ctrl + j
● extra
○ add : SUM( )
○ highest : MAX( )
○ average : AVERAGE( )
○ random paragraphs → = rand( number of paragraphs you want )
○ to select certain heading at same time shift → select [repeat for
whatever lines you are trying to select]
○ non printable characters : ⁋
○ page break : press control enter
● Table of contents
○ Inserting table of contents :
■ References → insert table of contents
○ If you don't want to include a view values :
■ Select all the information in table of contents → tap on the drop
down of table of contents → custom table of contents → options
→ change Table of Content Layout to whichever level you want
to include
○ Update table of contents
■ Select table of figures → go to references tab → captions →
update table
● form controls :
○ developer tab → controls → legacy tools [last icon]
■ insert items in a drop down list
● insert tab stop with no header → go to developer → go to
legacy tools → drop down → then enter the different
options
○ to change where an option goes
■ press upward arrow
■ set the default value in a check box control form
● developer tab → controls → legacy tools [last icon] → set
auto to checked
■ insert date control
● developer tab → controls → legacy tools [last icon] →
change type to date
■ insert plain text control
● developer tab → controls → legacy tools [last icon] →
text format to whatever paper says
EXCEL
● DATE
○ Today's date :
■ TODAY()
○ NUMBER value of the date
■ Change the format to number to see when the date was from 1
january 1900
○ Days:
■ (end_date,start_date)
○ Time
■ (end-begining*24)
● TRUNC
○ Gets integer part of a number with a decimal
● INT
○ Rounds a number down to the nearest integer
● COUNTIFS / SUMIFS
○ Count if → Counts the number of cells that meet multiple criteria
■ Counting how many entries meet more than one condition.
○ Sum if → Adds up the values that meet multiple criteria
■ Summing values only if several conditions are met.
● VLOOKUP
○ (LookUp_Value; table_Arrary; col_index_num; range_lookup)
○ Table_array : make it absolute
○ Range_lookup : false if there is no range
○ Vertical table : vlookup
○ Horizontal table : hlookup
○ TIPS ( If range_lookup is TRUE or left out, the first row must be sorted
in ascending order. Use FALSE if you want an exact match
● STRING FUNCTIONS
○ Concatenate → joins two sentences
○ Len → length of the string
○ Upper → converts all letters to uppercase
○ Lower → converts all letters to
○ Left(string, N)→ extracts N letters to the left
○ Right(String, N) → extracts N letters to the right
○ Mid(String, M, N) → extracts the letter in position M for N amount of
letters
○ Find(substring, string) → determines where the substring starts in the
string
○ Value(string) → converts the string to its numerical value
● GRAPHS
○ To make changes in graph
■ Right click on the graph → select data
ACCESS
● TABLE (datasheet view)
○ remove a record
■ go to home → records → delete
○ add a record
■ go to form and enter data, then press save to load it to the
actual data / or just type in
○ row height
■ right click → row height
○ alternative row colour
■ home → text formatting → alternate row colour
○ alignment
■ select column → go to alignment
○ column width
■ right click on column → field width
● TABLE (design view)
○ field size (the number of characters the field can contain)
■ when adding a new one → go to characteristics → change
number of characters
○ required field (validation technique)
■ in properties (set to no) → if yes is selected → compulsory to fill
out
Data types, field size
● yes/no
○ in design view → data type column → select yes/no
● currency
○ in design view → data type column → select currency
Input Mask
[given html sheet and input mask character sheet]
● for cell number → 0000000000
■ compulsory letter
● tap on cell → select input mask in the properties
● compulsory letter → L
■ optional letters
● optional letter → ?
■ all letters should be uppercase
● greater than sign before all the writing → > L ?
Validation Rule
● go to row that has the field that you want to change → go to properties →
make default value the most likely value
Freeze a field
● Datasheet view → home tab → records tab in the home tab → more → freeze
fields
Required field
● Design view → change required to yes or no
Queries - set criteria, group by with functions
● Creating a query :
○ Go to create tab @ the top→ go to the queries tab in the create tab →
query design → select the table (in the add tables panel on the left of
the screen) → select the fields → insert criteria → apply sorting →
save the query with a name
● Set Criteria :
○ Change to whatever the question says
○ If you want the ones with or without values say NULL or is NOT NULL
● Group by with functions
○ Go to query design tab at the top → look at show/hide tab in query
design → select totals → ([total : group by] should pop up at the bottom
of the screen on top of sort) → press drop down by group by→ select
function → choose how to sort
● When doing a function in query
○ To get rid of decimals go to property sheet
○ In general
○ Put fixed as formal
○ And how many decimals you want
● Always put a footer in when doing the calculations
● When adding a calculation add a textbox
Form - insert picture, add a field using textbox, conditional formatting, change fill
colour, resize fields to same width
● Creating form
○ Create tab → forms tab in create tab → form wizard
● Insert picture
○ Design view → form design tab → control tabs in form design → tap
the drop down → select → choose image
● Adding a field with a text box
○ Design view → form design tab → control tabs in form design → tap
the drop down → select → type in field name with no brackets
● Conditional Formatting
○ Design view → Format tab → control formatting in format tab → select
conditional formatting → make new rule
● Resize fields to same width
○ Design View → Select which you want to change → Arrange → sizing
& ordering tab in arrange tab → select size/space → change to
whichever it says (widest/narrowest/etc) → align → choose alignment
Report - add grouping, insert function in group footer, insert image and resize
● Creating a report :
○ click on create tab → go to reports → click on report wizard
● Insert function in group footer (Main functions : min, max, count, avg)
○ After creating report → go back to design view → right click at bottom
(grey area) → select sorting and grouping → tap more in the tab at the
bottom → change without footer section to with footer section
○ In the footer → go to the tab at the top of the screen → report design
→ controls → tap on → type in the box FUNCTION([fieldName])
■ Remember the field name in SQUARE BRACKETS!
● Inserting an image
○ Report design tab → controls tabs in report design → tap the drop
down → select → choose image
● Resizing an image
○ Report design tab → tools tab in report design tab → find width and
height and change to given values
HTML
● Commenting
○ <!- - - ->
● Attributes with a line
○ <hr width = “75%”/> : the line will always adjust with the screen
● Lists (<li></li>)
○ <ol type = “I” or type = “i” or type = “a” or type = “A”/ >
○ <ul type = “circle” or type = “square” />
● Image
○ <img src = "monday.png" width = "400" alt = "Explain what picture is" />
● Link
○ Click<a href = "http://www.google.com">here </a> to go to google
■ The word here will be where u can tap the link
● Tables
<table bgColor = "lightblue" border = "1" cellPadding = "5" cellspacing = "10">
● The bold writing is to set attributes to the table
● Cell padding → Adds space inside each cell — between the cell content and the cell border.
● Cell spacing → Adds space between the cells.
<tr>
<th colspan = "3"> heading 1 </th>
● THIS IS FOR A MERGED CELL
</tr>
<tr>
● Inserting a new row
<th> Heading </th>
● Inserting a new HEADING (AUTOMATICALLY CENTRES AND BOLD)
<th> Heading </th>
<th> Heading </th>
</tr>
<tr bgColor = "yellow">
● Inserting a new row where all the cells are yellow
<td bgColor = "lightgreen"> Row 1 Col 1 </td>
● Inserting a new COLUMN, NB (th and td) where that cell is lightgreen
<td> Row 1 Col 2</td>
<td> Row 1 Col 3 </td>
</tr>
<tr>
<td> Row 2 Col 1 </td>
<td> Row 2 Col 2</td>
<td> Row 2 Col 3 </td>
</tr>
</table>
