ICT 3

Types of Addressing in an Excel Table:

• Absolute and non-absolute

• Absolute, relative, and mixed

• Right direction and opposite direction

• Simple and complex

Which sign indicates that the reference was not made correctly?

• #data!

• #reference!

• #numder!

• #del/0

A combination of keyboard shortcuts that can be used to set the column in Excel:

• CTRL+Alt

• Ctrl+space

• Ctrl+Tab

• Ctrl+Shift

In Excel, textual alignment is as follows:

• Right edge

• Left edge

• By the middle

• By the width

To confirm the entry in the cell you need:

• CTRL

• SHIFT

• ENTER

• TAB

The database in an Excel table –

• Multiple cell groups

• A set of linked tables

• A graphic object

• Formula

When you copy the formulas from one cell to another during relative addressing in Excel

• The data will change

• Addresses remain stable

• The addresses automatically change

• Addresses will be deleted

To use data in a table as a database in Excel, you must follow the main menu item:

• Formula

• Data

• Main

• Mode

Sorting and filtering is performed by what menu?

• Formula

• Data

• Insert

• View

A chart in Excel –

• Write type used in the text editor

• Graphic object entered into one sheet of workbook

• At the bottom of the current cell enclosure during autofill is a small black square

• Multiple cells group