Class 8 Spreadsheet

A _________ is an expression to perform calculation.

• Function

• Formula

• Cell address

The ________ automatically fills contiguous cells with data in a particular pattern.

• Formula

• Pointing

• Autofill

The example of Absolute reference is

• B2

• $B2

• $B$2

The default alignment of text in MS Excel is

• Left

• Right

• Center

The default alignment of numbers in MS Excel is

• Left

• Right

• Center

Symbol for concatenation operator in MS Excel is

• ?

• =

• &

• $

Function used to count number of cells having numeric value is

• Count numbers

• Count

• Sum

• Min

The border that appears when a range is selected is called _____

• Boundary

• Marquee

• Cell reference

Cell reference is

• Cell Address in a formula

• Cell Address

• Row number

• Column letter

A function always starts with an

• ?

• +

• =

• >