Information Technology Exam guide Unit 7: Spreadsheets

SPECIFIC OBJECTIVES:

The student should be able to:

Explain the purpose of a spreadsheet;

Definition of spreadsheet: a spreadsheet is a table consisting of cells (rows, column locations) that hold accounting or financial
data and simulates the traditional physical spreadsheet;

it captures displays and manipulates data.

Use appropriate terminology and notions commonly associated with spreadsheets;

Row, column, cell, cell address, label, value, formula, function,
worksheet, template, range, title, window, record.

Select basic pre-defined systems functions;

Formulae involving addition, subtraction; multiplication;
division; powers; square roots, the use of brackets.

Explain the use of common features of spreadsheet software;

Row/column title locking,

relative addressing,

absolute addressing.

Invoke row and column title locking;

Horizontal, vertical, both.

7.

Relative versus absolute addressing.

Manipulate data on a spreadsheet;

Manipulate columns and rows;

Insert and delete columns and rows.

Format a spreadsheet;

Numeric data formatting,

text formatting,

alignment, borders.

Sort a spreadsheet;

Primary field,

secondary field,

ascending vs. descending order.

Find a record matching a given criterion;

Select appropriate graphical representation of data;

Use of two or more worksheets to solve problems involving some
or all of the functions and operations listed above.