Define the four steps: Process a “continuous section break” at end of paragraph two.

1. Locate insertion point at end of paragraph two

2. Click tab – page layout

3. Click ribbon group – breaks

4. Choose continuous

Define the first three steps: Process a “footnote”, identify keywords “Laurentian” in the contents of paragraph two.

1. Locate cursor at keyword “Laurentian”

2. Click tab – (reference) & group (footnotes)

3. Click insert footnote, type your text

Define the first three steps: Process a “page border”.

1. Select paragraph

2. Click tab – (page layout) & group (page background)

3. Click page border, & select borders

Define the first four steps: modify paragraph style to “fancy”.

1. Click tab home

2. Click ribbon group – styles

3. Click on change styles

4. Click style set, select “fancy”

Define the first three steps: process a TEXT WATERMARK”.

1. Tab – page layout

2. Click ribbon group – page background

3. Click on custom watermark

Define the first three steps: using mail merge, process/merge the addresses onto a common letter.

1. Click tab – mailings

2. Click ribbon group – start mail merge

3. Click on step by step mail merge wizard

Define the first four steps: create multilevel style outline list:

1. Click home tab

2. Click ribbon group – paragraph

3. Click on multilevel list

4. Click style in the gallery of styles

5. Depress tab key and type your text

Define the first 4 steps: you have a 25 page document in portrait orientation, modify page 20 to landscape with page 21 and on back to portrait (assume you are at page 19)

1. Click page layout tab – breaks

2. Process continuous section break at end of page 19

3. Process continuous section break at end of page 20

4. Modify page orientation for page 20 to landscape

Define the first three steps: insert comment at end of paragraph (assume location of cursor is in correct location).

1. Click review tab

2. Click ribbon group – comments

3. Click on new comment

Define the first two steps: indent all but the first line of a paragraph.

1. Select the paragraph all but the first line

2. Horizontal ruler – drag hanging indent marker to position required.

Define the first three steps: nudge shadow to the right by one click

1. Click tab – format

2. Click ribbon group – shadow effect

3. Click right nudge by one click

Define VLOOKUP function arguments (=Vlookup(A2,A10:C22,2)

1. Argument 1: logical test

2. Argument 2: table search

3. Argument 3: results

4. (note: same for HLOOKUP)

Define the first four steps: create a drop down list (validation list) for a lost of ten surnames already on spreadsheet.

1. Click on tab – data

2. Click ribbon group data validation

3. Click on settings tab

4. Click on list (under allow tab)

5. Select list & copy onto source box

Define the first three steps: process a 3-D reference process: sum up values and locate result in D4. Sheet tabs are April, May and June. Reference cell you want is E4.

1. Right click on sheet tab APRIL and click on “selectAll sheets”

2. Slick on cell D4 (to enter a function)

3. Type “-=SUM(‘Apirl:June’!E4)

Define first four steps: freeze top row of labels and column A labels.

1. Click on B2

2. Click on tab – view

3. Click ribbon group window

4. Click on freeze

5. Click ok

Define the first four steps:
A)spreadsheet A2:D10 with labels A2:A10
B) numeric currency details B2:D10
process defined (range) names and process in E2:E10.

1. Select A2:E10

2. Click on tab – formulas

3. Click ribbon group define names

4. Check mark “left column”

5. Click ok
   Define names are processed in E2:E10
    Note – you can also use option “define names” and define names other than actual labels.

Define the first four steps: process/ create a 3D pie chart.

1. Select data series

2. Click on tab – insert

3. Click on ribbon group charts

4. Click on 3D effect Pie ICON

Define the first four steps: from previous chart, explode largest pie slice and assume 3D pie charts is already.

1. Click center of pie

2. Click on largest pie slice

3. Locate mouse pointer in center of slice

4. With left mouse button depressed, over slice SM (s) outward.

Define the first four steps: spreadsheet data is A1:D100, set print area: -A1:D20

1. Select A1:D20

2. Click on tab – page layout

3. Click print area

4. Click on select print area

Define the first three steps: protect cells: B10-M44.

1. Select range B10:M44

2. Click on tab – home

3. Click format

4. Click protect tab

5. Click on locked

Define the first five steps: modify fixed currency symbol to floating symbol.

1. Select range of data

2. Click on tab home

3. Click ribbon group front

4. Click number tab

5. Click currency

6. Adjust decimal option

7. Select format

Define the first five steps: rotate text in A1:G1.

1. Select A1:G1

2. Click on tab – home 

3. Click ok ribbon group alignment

4. Click on alignment tab\adjust degrees or manually adjust degree handle

Define the first two steps: title is in A1, center titles A1:F1.

1. Select A1:F1

2. Click on tab – home

3. Click ribbon group – home

4. Click on merge and center

Define the first four steps: wrap text in cell B2.

1. Select cell B2

2. Click on tab – home 

3. Click ribbon group alignment

4. Click on wrap text