1.1 -An outline solution is developed to meet the requirements of a given brief

1.2 – The spreadsheet produced addresses the given problem

Excel 2 Quiz 1

2.1 – Toolbar menus are switched off and on.

2.2 – The view of the spreadsheet is enlarged and made smaller.

2.3 – The way that the spreadsheet is viewed is changed.

2.4 – Cells are frozen to prevent scrolling.

2.5 – The default file location is changed.

2.6 – A user name is added to the file.

Excel 2 Quiz 2

3.1 – The purpose of using multiple worksheets within one spreadsheet file are explained with examples.

3.2 – New worksheets are opened. (Minimum 3 worksheets)

3.3 – Worksheets are renamed in terms of their purpose within the solution to the given problem.

3.4 – Cells are manipulated between worksheets.

3.5 – A worksheet within a workbook (or spreadsheet) is deleted.

Excel 2 Quiz 3

4.1 – Formulae are entered taking into consideration the natural order of operation.

4.2 – Formulae are entered to deliberately change the natural order of operation.

4.3 – Formula error messages are correctly interpreted and the formula corrected accordingly.

4.4 – The difference between relative and absolute cell addressing is demonstrated by using it in a formula.

4.5 – Data are changed to test possible solutions to the given problem without having to change formulae.

4.6 – Scenarios are created that demonstrate different possible outcomes.

Excel 2 Quiz 4

5.1 – Functions are explained in terms of their purpose, use and construct

5.2 – Simple Mathematical functions are applied to the given problem

5.3 – Statistical functions are applied that achieve the anticipated result.

Excel 2 Quiz 5

6.1 – Methods of automatically formatting a spreadsheet are explained.

6.2 – A spreadsheet is created using a template

6.3 – Cells are formatted using styles

6.4 – Formats are copied between cells

Excel 2 Quiz 6

7.1 – Text is centered across a cell range

7.2 – Orientation of text within a cell is changed

7.3 – A border is applied to cells and removed from cells

7.4 – Fill (shading) is applied to cells and removed from cells

Excel 2 Quiz 7

8.1 – The spreadsheet is evaluated for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity.

8.2 – The spreadsheet is modified if required and compliance with the brief is confirmed.

Excel 2 Quiz 8