ICDL Module 4

Table of Contents

1. Using the Application

First stages with spreadsheets

Open Calc in Linux

Open Calc in Windows

Close Calc

Components of the Calc screen

Create a new spreadsheet (default template)

Save a spreadsheet to a location on a drive in Linux

Save a spreadsheet under another name

Save a spreadsheet in another file type such as: text file, HTML, template, software specific file extension, version number

Switch between worksheets, open spreadsheets

Use available Help functions

Close a spreadsheet

Adjust settings

Page Width

Display, hide built-in toolbars

Freeze, unfreeze row and / or column titles

Modify basic options / preferences in the application user name, default directory / folder to open, save spreadsheets

2. Cells

Insert data

Data types

Entering data

Select cells

Select a row, range of adjacent rows, range of non-adjacent rows

Select a column, range of adjacent columns, range of non-adjacent columns

Rows and columns

Insert a single row

Insert several rows

Insert one or more columns

Delete rows, columns in a worksheet

Modify column widths, row heights

Edit data

Edit existing content of a cell

Replace content of a cell

Use the undo, redo command

Duplicate, Move, Delete

Within a worksheet, between worksheets, between spreadsheets

Duplicate within a worksheet

Duplicate between worksheets

Duplicate between open spreadsheets

Use autofill tool/copy to copy, increment data entries

Move the content of a cell, cell range within a worksheet, between worksheets, between spreadsheets

Delete cell contents

Search and Replace

Use the replace command for specific content in a worksheet

Important Find and replace options

Sort Data

Numeric sorts

Alphabetic sorts

Multiple sort criteria

3. Worksheets

Handling worksheets

Insert a new worksheet

Rename a sheet

Delete a worksheet

Duplicate a worksheet within a spreadsheet, between spreadsheets

Duplicate a worksheet between spreadsheets

Move a worksheet within a spreadsheet, between spreadsheets

4. Formulas and Functions

Arithmetic formulas

Indicating a calculation

Arithmetic operators

Arithmetic using cell references: Automatic recalculation

Recognise and understand error values associated with using formulas

Cell referencing

Relative addressing

Absolute addressing

Mixed addressing

Working with functions

SUM

AVERAGE

MAX and MIN

COUNT

Using functions in a spreadsheet

Generate formulas using logical function IF yielding one of two specific values

5. Formatting

Number, Date

Decimal Places

Format cells to display a date style

Format cells as currency style

Format cells to display numbers as percentages

Contents

Apply formatting to cell contents such as: bold, italic, underline, double underline

Apply different colours to cell content, cell background

Copy the formatting from a cell, cell range to another cell, cell range

Apply text wrapping to contents within a cell

Alignment, Border Effects

Centre a title over a cell range

Adjust cell content orientation

Add border effects to a cell, cell range

6. Charts

Using Charts and Graphs

Creating graphs with more than one data series

Add / Remove a title, label to the chart/graph

Change the background colour in a chart/graph

Change the column, bar, line, pie slice colours in the chart/graph

To change the colours of an existing chart

Change the chart/graph type

Duplicate, move charts/graphs within a worksheet, between open spreadsheets

Resize, delete charts/graphs

7. Prepare Outputs

Worksheet Setup

Change worksheet orientation: portrait, landscape

Adjust page setup to fit worksheet contents on one page, on a specific number of pages

Add, modify text in Headers, Footers in a worksheet

Insert fields: page numbering information, date, time, file name, worksheet name into Headers, Footers

Preparation

Calculations

Text

Preview a worksheet

Turn on, off display of gridlines, display of row and column headings for printing purposes

Apply automatic title row(s) printing on every page of a printed worksheet

Printing