My CAT Practical Summary in Microsoft Word, Excel, Acces, and an explanation on HTML. Is a full in-depth explanation of these programs on a Matric level from a student that has an average of 90% in the subject from grade 10 to 12. The summary includes screenshots and step by step instructions on ho...
Saul-Marco Swart 2020 Copyright Reserved
Creating folders
Right click on home screen and go to new and select folder.
Compressing two documents into one
First open one document. Go to the insert ribbon.
Go to add from files and
select the document you wish to combine.
Converting CSV files into excel
Select the csv file and open it with excel.
Go to file and then Save AS.
Change the file type to excel workbook format
Document properties – changing them
Right click the file and select properties.
Extracting content from a zipped file
Right click on the file and say extract all.
File names
Right click on the file and say rename.
File sizes
Go to file properties.
File types, extensions
Go to file properties.
Group files by size
Go into the file and select size in the top right.
Image dimensions
Go to file properties.
Select details and locate the dimensions.
Inserting documents into files
Drag the document into the file or right click the file and say move to the preferred file.
Shortcuts
Right click the desktop and create a shortcut either with a file location or web page URL.
System properties
Where to find system properties on your computer
Go to setting then system settings and select about, and view the device specifications.
Adding files
Download the files from the internet.
Preventing programmes from starting up
Right click the application go to properties and select Security and edit the permissions so it wont’t start
up.
Deleting programmes that are not in use but taking up space
Use the disk clean-up function on your computer.
Reason for thumbnail image
The reason is to see what file or application your opening.
Screen resolutions importance
Use the recommended screen resolution in display settings to get the most out of your screen.
Opening files with other programmes (how to do it)
Right click on the file and say open with. Select the program you wish to open the file with.
Protecting a document word, excel, access,
1. Select the file ribbon.
2. Go to Info.
3. Select protect document and select the preferred type of protection.
Saul-Marco Swart 2020 Copyright Reserved 1
,Saul-Marco Swart 2020 Copyright Reserved
Word
Being able to use breaks to change formatting
Use the next Page Break option to change formatting.
Using breaks to create two even columns
Select the paragraph and select columns ,then 2 columns and align with the ruler until evenly
distributed.
Header changes with section breaks
Go into the header and select the header and footer ribbon. Under options in the middle right select
different odd and even pages.
Borders
Under the home ribbon go to paragraph. Select the Bottom Right icon that and go to borders and
shading. There you will be able to change the style, colour and weight of the line.
Adding a bookmark
Select where you want to put a bookmark. Go to the insert ribbon and select links and then bookmark.
Linking text to bookmark
Highlight the text and right click, select link to, place in this document, select the bookmark to you
wish to link the text.
Naming a bookmark
When creating a bookmark the option to name the bookmark will appear.
Activating track changes
Go to the review ribbon and select Track Changes under tracking.
Changing name of track changes to your name
Select revision pane under tracking and the authors name would appear in the left of the screen, here
you would be able to change it.
Adding comments
Highlight the text and right click on the text, select new comment and add a comment.
Find and replace
Go to the home ribbon and select advanced find under editing.
Protect document with and without a password
Go to the file ribbon and select info and select protect document.
Review changes indicated in balloons
Go to the Review ribbon select show mark-up under tracking and select balloons.
Restrict editing to allow only tracked changes
Go to the file ribbon and select info and select protect document and select restrict editing under
editing restrictions in the right select track changes in the drop-down list.
Spell check
Go to the Home ribbon select the editor pen icon and review spelling and grammar mistakes on the
right pane of the screen once completed a pop-up message will show up that you spell checked.
Inserting fields creating a template
Select the file ribbon and select any custom template similar to the one you want to create.
Open the template and go to the developer ribbon and add the fields you want to add. After you have
added the features you want save the template as a normal word document.
All caps
Under the home ribbon select Aa’s drop down arrow and select uppercase.
Expanded/Condensed
Select the drop down arrow under font in the home ribbon and go to advanced , under spacing select
expanded or condensed in the drop down list.
Saul-Marco Swart 2020 Copyright Reserved 2
, Saul-Marco Swart 2020 Copyright Reserved
Types of fonts
Select the font you want under font in the home ribbon.
Hidden
Select the under paragraph in the home ribbon.
Size
Select the size you want under font in the home ribbon.
Small caps
Under the home ribbon select Aa’s drop down arrow and select lowercase.
Strike through
Under the home ribbon select ab to strikethrough the text.
Superscript
Select x2 under font in the home ribbon.
Subscript
Select x2 under font in the home ribbon.
Footers
Double click on the footer and make the preferred changes or select the type of footer in the headers
and footers ribbon.
Different odd and even pages
Select the header or footer and go to the header and footer ribbon and select the tick-box for different
odd and even pages.
Page numbers
Select the header or footer and go to the header and footer ribbon select Page Number under header
and footer and select the type of page numbering you want.
Not on 1st page
Select the header or footer and go to the header and footer ribbon and select the tick-box for not on
1st page.
Headers
Double click on the header and make the preferred changes or select the type of footer in the headers
and footers ribbon.
Automatically updating date
Select date and time under the header and footer ribbon, select the date style you want and tick the
update automatically box .
Document name, author and path.
Select date and time under the header and footer ribbon, select document info an insert the path,
author or name in the header.
Section Headers (changing as section changes)
Under the header and footer ribbon select navigation and select link to previous if there is a section
break the sections headers and footer will be connected (STAY THE SAME).
Images
Behind text: Right click the image and select wrap text and select the behind text option.
Cropping: Right click the image and select crop and adjust.
Enlarge to specific height/width: Right click the image and select size and position.
Grouping: Right click the image and select group by.
Inset automatic caption: Right click the image and select Caption and the tick the auto-
caption-box and select the type of file you want to auto-caption when you insert it.
Move with text: Right click the image and select wrap text and click on move with text.
Custom Margins
Select margins under the layout ribbon and select margins and adjust your custom margins.
Saul-Marco Swart 2020 Copyright Reserved 3
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller saulmarcoswart. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R200,00. You're not tied to anything after your purchase.
