| |
IN-ATES FRAGEN [?] |
QUIZ FRAGEN [?] |
FRAGEN INSGESAMT |
| |
227 |
19 |
246 |
| 1. Using the Application
|
34 |
8 |
42 |
| SEKTION 1
1.1. Working with Spreadsheets
SAMPLE QUESTION
|
18
|
5
|
23
|
1.1.1. Open, close a spreadsheet application. Open, close spreadsheets. |
4 |
0 |
4 |
1.1.2. Create a new spreadsheet based on default template, other available template locally or online. |
2 |
1 |
3 |
1.1.3. Save a spreadsheet to a location on a local, online drive. Save a spreadsheet under another name to a location on a local or online drive. |
3 |
4 |
7 |
1.1.4. Save a spreadsheet as another file type like: text file, pdf, csv, software specific file extension. |
8 |
0 |
8 |
1.1.5. Switch between open spreadsheets. |
1 |
0 |
1 |
| SEKTION 2
1.2. Enhancing Productivity
SAMPLE QUESTION
|
16
|
3
|
19
|
1.2.1. Set basic options/preferences in the application: user name, default folder to open, save spreadsheets. |
3 |
0 |
3 |
1.2.2. Use available Help resources. |
1 |
1 |
2 |
1.2.3. Use magnification/zoom tools. |
3 |
0 |
3 |
1.2.4. Display, hide built-in toolbars. Restore, minimize the ribbon. |
9 |
0 |
9 |
1.2.5. Recognise good practice in navigating within a spreadsheet: use shortcuts, go to tool. |
0 |
1 |
1 |
1.2.6. Use go to tool to navigate to a specific cell. |
0 |
1 |
1 |
| 2. Cells
|
33 |
3 |
36 |
| SEKTION 1
2.1 Insert, Select
SAMPLE QUESTION
|
8
|
3
|
11
|
2.1.1. Understand that a cell in a worksheet should contain only one element of data, for example, quantity in one cell, description in adjacent cell. |
0 |
1 |
1 |
2.1.2. Recognize good practice in creating lists: avoid blank rows and columns in the main body of list, ensure cells bordering list are blank. |
1 |
2 |
3 |
2.1.3. Enter a number, date, text in a cell. |
3 |
0 |
3 |
2.1.4. Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet. |
4 |
0 |
4 |
| SEKTION 2
2.2. Edit, Sort
SAMPLE QUESTION
|
12
|
0
|
12
|
2.2.1. Edit cell content, modify existing cell content. |
4 |
0 |
4 |
2.2.2. Use the undo, redo command. |
2 |
0 |
2 |
2.2.3. Use a simple search command for specific content in a worksheet. |
3 |
0 |
3 |
2.2.4. Use a simple replace command for specific content in a worksheet. |
1 |
0 |
1 |
2.2.5. Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order. |
2 |
0 |
2 |
| SEKTION 3
2.3. Copy, Move, Delete
SAMPLE QUESTION
|
13
|
0
|
13
|
2.3.1. Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets. |
3 |
0 |
3 |
2.3.2. Use the autofill tool/copy handle tool to copy, increment data, formula, funtion. |
6 |
0 |
6 |
2.3.3. Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets. |
2 |
0 |
2 |
2.3.4. Delete cell contents. |
2 |
0 |
2 |
| 3. Managing Worksheets
|
26 |
1 |
27 |
| SEKTION 1
3.1. Rows and Columns
SAMPLE QUESTION
|
17
|
0
|
17
|
3.1.1. Select a row, range of adjacent rows, range of non-adjacent rows. |
2 |
0 |
2 |
3.1.2. Select a column, range of adjacent columns, range of non-adjacent columns. |
3 |
0 |
3 |
3.1.3. Insert, delete rows and columns. |
2 |
0 |
2 |
3.1.4. Modify column widths, row heights to a specified value, to optimal width or height. |
6 |
0 |
6 |
3.1.5. Freeze, unfreeze row and/or column titles. |
4 |
0 |
4 |
| SEKTION 2
3.2. Worksheets
SAMPLE QUESTION
|
9
|
1
|
10
|
3.2.1. Switch between worksheets. |
1 |
0 |
1 |
3.2.2. Insert a new worksheet, delete a worksheet. |
1 |
0 |
1 |
3.2.3. Recognize good practice in naming worksheets: use meaningful worksheet names rather than accept default names. |
0 |
1 |
1 |
3.2.4. Copy, move a worksheet within a spreadsheet, between spreadsheets. Rename a worksheet. |
7 |
0 |
7 |
| 4. Formulas and Functions
|
42 |
4 |
46 |
| SEKTION 1
4.1. Arithmetic Formulas
SAMPLE QUESTION
|
11
|
4
|
15
|
4.1.1. Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas. |
0 |
1 |
1 |
4.1.2. Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division). |
5 |
0 |
5 |
4.1.3. Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!, #VALUE!. |
2 |
1 |
3 |
4.1.4. Understand and use relative, absolute cell referencing in formulas. |
4 |
2 |
6 |
| SEKTION 2
4.2. Functions
SAMPLE QUESTION
|
31
|
0
|
31
|
4.2.1. Use sum, average, minimum, maximum, count, counta, round functions. |
24 |
0 |
24 |
4.2.2. Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <. |
7 |
0 |
7 |
| 5. Formatting
|
39 |
0 |
39 |
| SEKTION 1
5.1. Numbers / Dates
SAMPLE QUESTION
|
9
|
0
|
9
|
5.1.1. Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands. |
6 |
0 |
6 |
5.1.2. Format cells to display a date style, currency symbol. |
2 |
0 |
2 |
5.1.3. Format cells to display numbers as percentages. |
1 |
0 |
1 |
| SEKTION 2
5.2. Contents
SAMPLE QUESTION
|
13
|
0
|
13
|
5.2.1. Apply text formatting to cell contents: font sizes, font types. |
2 |
0 |
2 |
5.2.2. Apply formatting to cell contents: bold, italic, underline, double underline. |
1 |
0 |
1 |
5.2.3. Apply different colours to cell content, cell background. |
2 |
0 |
2 |
5.2.4. Apply an autoformat/table style to a cell range. |
4 |
0 |
4 |
5.2.5. Copy the formatting from a cell, cell range to another cell, cell range. |
4 |
0 |
4 |
| SEKTION 3
5.3. Alignment, Border Effects
SAMPLE QUESTION
|
17
|
0
|
17
|
5.3.1. Apply, remove text wrapping to contents within a cell, cell range. |
2 |
0 |
2 |
5.3.2. Align cell contents: horizontally, vertically. Adjust cell content orientation. |
5 |
0 |
5 |
5.3.3. Merge cells and centre a title in a merged cell. Unmerge cells. |
4 |
0 |
4 |
5.3.4. Apply, remove border effects to a cell, cell range: lines, colours. |
6 |
0 |
6 |
| 6. Charts
|
28 |
1 |
29 |
| SEKTION 1
6.1. Create
SAMPLE QUESTION
|
12
|
1
|
13
|
6.1.1. Understand the uses of different types of chart: column chart, bar chart, line chart, pie chart. |
0 |
1 |
1 |
6.1.2. Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart. |
3 |
0 |
3 |
6.1.3. Select a chart. |
1 |
0 |
1 |
6.1.4. Change the chart type. |
1 |
0 |
1 |
6.1.5. Move, resize, delete a chart. |
7 |
0 |
7 |
| SEKTION 2
6.2. Edit
SAMPLE QUESTION
|
16
|
0
|
16
|
6.2.1. Add, remove, edit a chart title. |
1 |
0 |
1 |
6.2.2. Add, remove a chart legend. |
2 |
0 |
2 |
6.2.3. Add, remove data labels to a chart: values/numbers, percentages. |
3 |
0 |
3 |
6.2.4. Change chart area background colour, legend fill colour. |
2 |
0 |
2 |
6.2.5. Change the column, bar, line, pie slice colours in the chart. |
3 |
0 |
3 |
6.2.6. Change font size and colour of chart title, chart axes, chart legend text. |
5 |
0 |
5 |
| 7. Prepare Outputs
|
25 |
2 |
27 |
| SEKTION 1
7.1. Setup
SAMPLE QUESTION
|
10
|
0
|
10
|
7.1.1. Change worksheet margins: top, bottom, left, right. |
1 |
0 |
1 |
7.1.2. Change worksheet orientation: portrait, landscape. Change paper size. |
3 |
0 |
3 |
7.1.3. Adjust page setup to fit worksheet contents on a specified number of pages. |
2 |
0 |
2 |
7.1.4. Add, edit, delete text in headers, footers in a worksheet. |
1 |
0 |
1 |
7.1.5. Insert, delete fields: page numbering, date, time, file name, worksheet name into headers, footers. |
3 |
0 |
3 |
| SEKTION 2
7.2. Check and Print
SAMPLE QUESTION
|
15
|
2
|
17
|
7.2.1. Check and correct spreadsheet calculations and text. |
2 |
0 |
2 |
7.2.2. Turn on, off display of gridlines, display of row and column headings for printing purposes. |
3 |
0 |
3 |
7.2.3. Apply automatic title row(s) printing on every page of a printed worksheet. |
1 |
0 |
1 |
7.2.4. Preview a worksheet. |
1 |
2 |
3 |
7.2.5. Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart. |
8 |
0 |
8 |