Question Detail

The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

C1:10H
C1:H10
C1:H-10
C1:H:10

Answer: Option B

Similar Questions :

1. The default style for new data keyed in a new workbook is ?

Comma
Normal
Currency
Percent

Answer: Option B

2. Which types of charts can excel produce ?

Line graphs and pie charts only
Bar charts, line graphs and pie charts
Bar charts and line graphs only
Only line graphs

Answer: Option B

3. Which of these will not select all the cells in a document ?

Using the Edit – Select All menu
Pressing Ctrl + A on the keyboard
Clicking three times with the right mouse button in the spreadsheet

Answer: Option C

4. 3-D reference in a formula ?

Spans worksheets
Can not be modified
Only appears on summary worksheets
Limits the formatting options

Answer: Option A

5. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

NOT
OR
IF
AND

Answer: Option C

Read more from - MS Excel Questions Answers