Spreadsheet

Cell address is a combination of -

• Column number and Row letter

• Column letter and Row number

• Column letter and Column number

• Row letter and Row number

A range is a -

• Group of cells in a powerpoint

• Group of cells in workbook

• Group of cells in a notebook

• Group of cells in a worksheet

A range in a worksheet can be recognised only in that worksheet -

• TRUE

• FALSE

Rules for naming a range -

• Names can be the same as the formula used

• First character must be a letter, backlash or underscore

• Maximum length will be 1000

• Spaces are allowed within the names

Example of Arithmetic Operators -

• +

• =

• &

• :

A formula contains -

• Cell address and Operators

• Cell range and Operators

• Function and Operators

• Cell reference and Operators

The formula typed in a cell appears simultaneously in formula bar -

• TRUE

• FALSE

Absolute cell reference is denoted by -

• #

• &

• $

• *

Example of chart elements -

• Legend

• Column chart

• Chart area

• Bar chart

Name the cell reference used in above picture -

• Absolute cell reference

• Mixed cell reference

• Relative cell reference

• None of the above