download Mastguru Android App

Question Detail

What function displays row data in a column or column data in a row ?

  • Transpose
  • Index
  • Rows
  • Hyperlinks

Answer: Option A

Similar Questions :

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

2. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

  • HTML
  • Pivot Table Field List
  • Pivot Table Report
  • Pivot Table List

Answer: Option C

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

  • Comma
  • Normal
  • Currency
  • Percent

Answer: Option B

4. Formula palette is used to ?

  • format cells containing numbers
  • create and edit formulas containing functions
  • entered assumptions data
  • copy all cells

Answer: Option B

5. Which function calculates your monthly mortage payment ?

  • PV
  • NPER
  • PMT
  • All of above

Answer: Option C

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