Navigate

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. A function inside another function is known as ?

  • Round function
  • Sandwich function
  • Switch function
  • Nested function

Answer: Option D

2. To convert a column of data into row, which command will you choose

  • Edit -> Paste Special -> Transpose
  • Cut and Paste
  • Both of above
  • None of above

Answer: Option A

3. Which among following is types of excel data types ?

  • Numbers, Formulas, Labels
  • Data, Words, Numbers
  • Words, Number, Labels
  • Equations, Data, Numbers

Answer: Option A

4. 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

5. Macros can be executed from the which of the following menu ?

  • Format
  • Home
  • Insert
  • Tools

Answer: Option D

Read more from - MS Excel Questions Answers