Skip to content | Change text size

Skills and Knowledge review for Excel level 2

These questions will allow you to determine whether you have the pre-requisite skills needed to sucessfully achieve the outcomes of the Excel Level 2 course.

Some questions have more than 1 answer. Please select ALL correct answers where applicable.

You may wish to read documentation relating to the required skills at

There are a total of EIGHT questions/exercises to complete and it should take no more than 25-45 minutes to complete depending on your skill level.

Use the scroll bars to navigate the web page.
Questions can have more than 1 answer.
Green indicates a correct answer.
Red indicates an incorrect answer.

Q1: The Main Screen: Designed to test your knowledge of Excel toolbars and Screen items.

I have not seen this screen before

The numbers below correspond to a circled number in the diagramn above. The circled number is indicating an Excel object.
If you believe the Name of the Excel object is correct CHECK the answer.
If you believe the Name of the Excel object is incorrect do NOT CHECK the answer.

Select the correct answers for the item shown in the left column.

1 This is called the Worksheet Menu Bar
2 This is called the Main toolbar
3 This is called the Format toolbar
4 This is called the Image toolbar
5 This is called the Comment toolbar
6 This is called the Vertical Scrollbar
7 This is called the Horizontal Scrollbar
8 This is called the Active Work Sheet
9 The name of this Cell is B4 or $B$4 or $b4 or b$4

Following the ref: hyperlink will display help on the topic.
ref:

Q2: Selection of Cells: Resizing Columns: Designed to test your knowledge of Cell Selection

Below is a pattern of selected cells. You are required to start Excel 2003, open a new workbook and generate the selection as shown.

I don't have a clue

I have completed the exercise.

Q3: Formatting: Designed to test your knowledge of formatting cells and cell contents .

Open a new Excel workbook and enter the data as shown in fig 3-1 then Format your worksheet data so that it looks like fig 3-2.

The Months: Font: Arial; 12, Blue, Bold, Align=Right, background=Light Yellow
The Years: Font: Times New Roman, 12, Plum, Bold
The data: AS shown

I don't have a clue

fig 3-1

 

 

fig 3-2

fig 3-3: Use this toolbar to format the worksheet.

I have completed the exercise.

ref:

Q4: Ranges: Designed to test your knowledge of Naming cell ranges

fig 4-1

There are 3 ranges shown. Select the correct method of naming these ranges

  A3:A6, B2:E2, C4:E6
  a3:a6, b2:e2, c4:e6
  a3-a6, b2-e2, c4-e6
  None of the above 
  All of the above 

ref:

Q5: Formulae: Designed tol test your knowledge of formulae.

fig 4-1

In cell B8 there is a formulae that totals the sales figures for the month of january for the years 2001 to 2004.
The best way to do this is entering a formulae (choose from the list) in cell B8.

  =total(2001+2002+2003+2004) 
  Add(2001+2002+2003+2004) 
  =sum(b3:b6) 
  =total(b3:b6) 
  None of the above

ref:

Q6: Formulae FILL & cell referencing: Designed to test Absolute & Relative referencing

When we need to repeat an operation (example: total the columns for the Jan, Apr, Jul & Oct) we enter the formulae for 1 column and then use a fill operation to copy the cell formulae to another location. The formulae will be altered to reflect its new location unless we use absolute referencing to name the cells.

In this example we wish to create a formulae for the month of "Jan" that totals the sales figures as before and also adds the value in cell "A1" to the result.
We will then copy this formulae to cells C8, D8, E8 using the fill operation.

I don't have a clue

The formulae in cell B8 could be

  =SUM(B3:B7) + $A$1
  SUM(B3:B7) + A$1
  =FILL(B3:B7) + 100
  =B3+B4+b5+b6 + $A$1
  =TOTAL(B3:B7) + $A$1
  =ABSOLUTE(B3:B7) + 100

ref:

Q7: Using Formulae: Designed to test the application of simple formulae.

Note: The formulae in cell B8 is the sum of cells B3 to B6 AND includes the number in cell A1.
The formulae must be entered and then the FILL operation used to copy the formulae from cell B8
to cells C8, D8 & E8.

Use the appropiate formulae to find the Average, Maximum and Minimum values as shown. You may need to use EXCEL HELP.
Use the FILL operation to copy the formulae to other cells as required.

I don't have a clue

I have completed the exercise.

ref:

Q8: Using Charts: Designed to test the creation of simple charts.

Create the charts shown. You will need to open Excel and enter the data shown.
Select the range A2 to E6 and then use the Standard toolbar to initiate the Chart Wizard.



Display of the charting toolbar

I don't have a clue

 

  I created the graph  
  I put a heading on the graph 
  I labelled the X-axis 
  I labelled the Y-axis 
  I have the legend 
  I displayed the charting toolbar

ref:

 

 

You have completed the pre-test for the Excel 2003 Level 2 training course. It is now up to you to determine whether you feel confident in the areas tested.

See you at the training course.