7th Feb test computer

There are _______ columns in excel.

• 265

• 256

• 255

• 246

Arranging data in ascending or descending order is called ________.

• Filtering

• Sorting

• Data Validation

• None

Filtering can be auto and advanced.

• T

• F

The ________ chart is used to Illustrates comparisons among individual items.

• Line Chart

• Bar Chart

• Pie Chart

• Column Chart

The _________ chart is used to compares the aggregate values of a number of data series.

• Radar Chart

• Column Chart

• Line Chart

• Pie Chart

If there is no value in the cell, it takes a _______value by default.

• 1

• null

• 2

• 100

A formula must begin with a __ sign.

• -

• +

• *

• None

______ refers to a cell in a specific location.

• Relative reference

• Absolute reference

• Mixed reference

• cell references

________ identifies the location of a cell or group of cells in the worksheet.

• Cell reference

• Relative reference

• Cell address

• Cell reference and Cell address

_______ is used to shows trends in data at equal intervals.

• Line Chart

• Bar Chart

• Pie Chart

• Column Chart