Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2010, 04:17 AM
MonkiaSaini MonkiaSaini is offline Please answer my question related to MS Excel 2007. Part 3. Windows XP Please answer my question related to MS Excel 2007. Part 3. Office 2010 (Version 14.0)
Novice
Please answer my question related to MS Excel 2007. Part 3.
 
Join Date: May 2010
Posts: 12
MonkiaSaini is on a distinguished road
Default Please answer my question related to MS Excel 2007. Part 3.

Hello My Friends,

please give answer, question related to MS Excel 2007.

Question: 1
State whether true or false:
For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
a. True
b. False

Question: 2

How would you select an entire PivotTable report?
a. On the Home tab, in the Editing group, select the 'Entire PivotTable' option
b. On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
c. On the Analyze tab, in the Data group, click on 'Select Entire PivotTable' option
d. None of the above

Question: 3
Which keyboard shortcut should be used to enter the current time?


a. CTRL+SHIFT+"
b. CTRL+SHIFT+:
c. CTRL+;
d. None of the above
Question: 4
State whether true or false:
No data is deleted when an outline is hidden or removed.
a. True
b. False

Question: 5
State whether true or false:
When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
a. True
b. False

Question: 6
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
a. Consolidate by position
b. Consolidate by category
c. Consolidate by formula
d. None of the above


Please Help.

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please answer my question related to MS Excel 2007. Part 1. MonkiaSaini Excel 7 11-24-2011 07:33 AM
Please answer my question related to MS Excel 2007. Part 2. MonkiaSaini Excel 0 05-09-2010 04:16 AM
Please answer my questions related to MS Word 2007 MonkiaSaini Word 5 05-09-2010 04:02 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft