download Mastguru Android App

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

2. How do you change column width to fit the contents ?

  • Single-click the boundary to the left to the column heading
  • Double click the boundary to the right of the column heading
  • Press Alt and single click anywhere in the column
  • All of above

Answer: Option B

3. Which function calculates your monthly mortage payment ?

  • PV
  • NPER
  • PMT
  • All of above

Answer: Option C

4. Insert picture option is in which of the following toolbars ?

  • Standard
  • Formatting
  • Drawing
  • Picture

Answer: Option D

5. A function inside another function is known as ?

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

Answer: Option D

Read more from - MS Excel Questions Answers
Post a comment

    Mastguru Youtube Channel

    Videos @mastguru

    Free useful videos - Subscribe Mastguru
     

    Get Free Current Affairs and Govt Jobs Alerts in your mailbox

    To Appreciate Our Effort, Please Like Us

    Quantitative Aptitude
    English Aptitude
    Reasoning Aptitude
    Computer Awareness
    General Knowledge
    Current Affairs
    IT Officer Aptitude
    Programming Aptitude
    Latest Govt Jobs