Triangle Connections Limited

Questionnaires - What Questionnaires?

We have developed a series of short questionnaires to test your knowledge of Microsoft Word, Microsoft Excel, Windows Basics and Email and the Internet.

If you haven't yet seen any of the questionnaires, and you would like to test yourself before seeing the answers, please send an email (including your postal address), or write to us at the address given on the Contact page.

 

Questionnaires - The Answers

The answers to the questionnaires are given below. If you have any queries, or do not understand any of the answers, or want more information about courses available, please send an email (including your postal address), or write to us at the address given on the Contact page.

Microsoft Word
Microsoft Excel
Windows Basics
Email and The Internet

Microsoft Word

  1. The left edge of the screen. Used for selecting items, e.g. line, row of a table.
  2. Click on the View menu, then on Ruler.
  3. Click on the Table menu, then on Table AutoFormat. Select Formats = “(none)”, then click on OK. (Note: This method should only be used when the table is empty, e.g. as soon as it has been created.)
  4. There may be spaces or Tab characters on the line. You can confirm this by clicking on the Show/Hide icon on the Standard toolbar.
  5. c) Press the Home key on your keyboard.
  6. c) Click on the File menu, then on Page Setup, then on the Margins tab. Set Top to 2", then click on OK.
  7. c) Click on the File menu, then on Print. Enter “3,5” (without the quotes) in the Pages box of the Page Range section, then click on OK.
  8. c) Press and hold the Ctrl key and click anywhere within the sentence. (Note: Beware of full stops within the sentence (e.g. after an abbreviation) - the whole sentence will not be selected.)
  9. c) Click within the heading, then click on the Centre icon on the Formatting toolbar.
  10. c) Highlight the text. EITHER Press and hold the Shift key, then press the F3 key. OR Click on the Format menu, then on Change Case, then on UPPERCASE, then on OK.

Note: a) and b) would also do the job for Questions 5-10. But c) is a more efficient method.

Return to top of page

Microsoft Excel

  1. To the left of the Formula Bar. It shows the cell reference of the “active” cell, and can also be used to move quickly to a named Range.
  2. Click on the View menu, then on Status Bar.
  3. Click on the Tools menu, then on Options, then on the View tab. Clear the Gridlines check box in the Window Options section, then click on OK.
  4. Select the cell(s). Click on the Format menu, then on Cells, then on the Alignment tab. Select the Wrap Text check box in the Text Control section, then click on OK.
  5. c) Press the Home key.
  6. c) Select the cell containing the required formatting features. If the 3 cells requiring the formatting features are next to each other in the same row or column, click on the Format Painter icon on the Standard toolbar, then select the 3 cells together. If the 3 cells are not next to each other, double-click on the Format Painter icon, then click on each cell requiring the features, then click on the Format Painter icon again to cancel.
  7. c) Click on the File menu, then on Page Setup, then on the Sheet tab. Click in the Rows To Repeat At Top box, select the rows to be printed on each page, then click on OK.
  8. c) Type “January” into a cell. Move the mouse pointer over the cell’s fill handle. Drag along the row or column for as long as necessary.
  9. c) Move the mouse pointer over the fill handle of the cell containing the total, then drag along the row for the other 3 columns.
  10. c) Use the Average function. Click on the cell which will contain the average. Click on the Paste Function icon on the Standard toolbar. Click on Function Name = Average, check that the required cells are specified correctly, then click on OK.

Note: a) and b) would also do the job for Questions 5-10. But c) is a more efficient method.

Return to top of page

Windows Basics

  1. Click on the appropriate button on the Taskbar.
  2. Click on  in the Title Bar. You might want to minimise a window so that you can see the Desktop or the whole of another window.
  3. Click on the Title Bar of the window, drag the outline to the new position and then release the mouse.
  4. More information needs to be entered in a dialog box, e.g. “Open…” in a File menu needs the name of the file to be opened.
  5. The item is not currently relevant or valid, e.g. “Copy” in the Edit menu if no text has been copied.
  6. The precise method might vary for different applications. But in most cases: Click on the View menu, point to Toolbars, then click on the name of the toolbar you want. (Also see Question 7.)
  7. Displays a context-sensitive shortcut menu depending where the mouse is pointing. For example, right-click on any toolbar to give a list of all toolbars available in the application.
  8. Check boxes are small squares. Click in the box to select or clear an option. When a check box is selected it contains a tick. Any number can be selected at any one time.
    Option buttons (also known as radio buttons) are small circles. Click in the circle to select an option. Only one of the options in the group can be selected.
  9. Click on the Start button, point to Settings, then click on Control Panel. Double-click on the Display icon, then click on the Screen Saver tab. Select a different Screen Saver from the drop-down list, then click on OK.
  10. F1.
  11. a) Press and hold the Shift Key, type the letter, then release the Shift key.
    b) Press and release the Caps Lock key, type the paragraph, then press and release the Caps Lock key again.
  12. Yes to all. The copied text is written to the Clipboard and can be pasted to each of the items named (and more).

Return to top of page

Email and The Internet

Note: Outlook Express and Internet Explorer are used here. Other programs have similar features.

  1. Individual messages will be hard to find if your Inbox contains a lot of emails. You should try and keep as few emails in your Inbox as possible, e.g. by deleting them if you do not need to keep them or by moving them to new folders. (See Question 3.)
  2. In most cases you should keep copies in your Sent Items folder of emails you have sent. But the same comments apply here as for your Inbox.
  3. You should be encouraged to create new folders so that you can store emails moved from your Inbox and Sent Items folder. For example, you could create a new folder for each person you communicate with regularly, or for all emails dealing with the same subject.
  4. Set Priority = High when you are composing the email.
  5. Never type a whole email in upper case - it is seen as shouting, and it is difficult to read.
  6. Do not open it until it has been checked for viruses - email attachments are often used to send viruses.
  7. The email would normally be placed into your Deleted Items folder. Drag it back to the Inbox from there.
  8. Save it to your Drafts folder (or equivalent), and reopen it later.
  9. You are passing over a hyperlink. Click on the link to move to the specified web page, or, if it is an email link, to open your email program and create a new email message.
  10. Click on the History button on the Standard toolbar. Click on the button for the previous day, then work your way through the web sites and web pages until you find the page you want. (Note: The Address Bar only contains web addresses you entered into it, i.e. not of pages you viewed by clicking on links within pages.)
  11. Add it to your Favorites menu.
  12. Use a Search Directory (e.g. Yahoo), or a Search Engine (e.g. Excite, AltaVista, Ask Jeeves).

Return to top of page

    Home    

Last revised: November 14, 2001