download Mastguru Android App

Question Detail

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

Similar Questions :

1. To drag a selected range of data to another worksheet in the same workbook, use the ?

  • Ctrl key
  • Shift key
  • Alt key
  • Tab key

Answer: Option A

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

  • Format
  • Home
  • Insert
  • Tools

Answer: Option D

3. Which among following is divide symbol in excel ?

  • /
  • D
  • Div
  • \

Answer: Option A

4. In Excel Worksheet how can you show or hide the gridlines ?

  • Click Gridline tool on Forms toolbar
  • Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • Both of above
  • None of above

Answer: Option C

5. VLOOKUP function used to ?

  • Finds related records
  • Looks up text that contain "v"
  • Check if two cells are identical
  • None of above

Answer: Option A

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