Question : What is a cell in a spreadsheet?

Option 1: the intersection of a row and column

Option 2: inside of a row

Option 3: inside of a column

Option 4: None of these

Question : What is the procedure for selecting cells?

Option 1: Select a row -> Select a column -> Select all cells in a worksheet -> To select a contiguous group of cells

Option 2: Select a row -> Select a column -> To select a contiguous group of cells -> Select all cells in a worksheet

Option 3: Select a column -> Select a row -> Select all cells in a worksheet -> To select a contiguous group of cells

Option 4: Select a row -> Select a column -> To select a contiguous group of cells -> Select all cells in a worksheet

Question : What is the character length of the ‘Text’ data type and ‘memo’ data type -

Option 1:

• Text – 255 Characters
• Memo – 65536 Characters

Option 2:

• Text – 555 Characters
• Memo – 65535 Characters

Option 3:

• Text – 225 Characters
• Memo – 55536 Characters

Option 4:

• Text – 555 Characters
• Memo – 55536 Characters

Question : To make a cell address an absolute cell address place a ________ sign in front of the row and column identities.

Option 1: dollar

Option 2: pound

Option 3: hash

Option 4: None of these

Question : Data collection of your worksheet in a particular order is basically called - 

Option 1: Filtering

Option 2: Searching

Option 3: Sorting

Option 4: None of the above