IGCSE ICT - Data Analysis

Absolute cell reference

• is group of selected cells which are highlighted

• is reference which is automatically fills other cells

• does not change when the formula is copied or moved to a new location

You can use this feature to fill in a series of numbers and dates.

• AutoCorrect

• AutoFill

• AutoComplete

• AutoFix

With the __________________ feature, Excel

compares the first few characters

you enter in a cell to existing entries

in the same column and proposes

the existing entry. You can press

Enter to accept the proposed entry.

• AutoFill

• AutoComplete

• AutoCorrect

• AutoFix

This feature in

Excel corrects common

mistakes as you enter data.

• AutoFix

• AutoCorrect

• AutoComplete

• AutoFill

The ______________ feature

enables you to repeat the

same data in a column or

row.

• AutoFix

• AutoComplete

• AutoCorrect

• AutoFill

a value, a cell reference, a

range, or text that acts as an

operand in a function formula

and it is enclosed in

parentheses after the function

name.

• argument

• criteria

• reference

• function

the intersection of a single

row and a single column

• range

• reference

• cell

• argument

cell reference

• is the column letter followed by the row number

• the intersection of a single row and a single column

• graphical representation of your worksheet data

• function tallies the number of occurrences of numerical data

to select an entire column, click the

• CTRL+A

• ALT+A

• column heading

• the first cell of column twice

When you _______ data, the

data that does not meet

the criteria is hidden, and

only the data that meets

the criteria is shown.

• hide column

• hide row

• filter

• edit