Below are two statements regarding Breaks in Microsoft Word 2010. Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text. Statement Y...
Statement X is correct. Statement Y is incorrect. 0.0%
Statement X is incorrect. Statement Y is correct. 0.0%
Both Statements X and Y are correct. 100.0%
Both Statements X and Y are incorrect. 0.0%
By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?
It is linked 25.0%
It is embedded 75.0%
Consider the following scenario: A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:
be spread across both cells. 0.0%
be deleted. 0.0%
remain intact in the first cell and the second cell will be empty. 100.0%
Dave receives a file named Theme1.thmx from his boss. Opening the file opens a blank PowerPoint document. On clarifying from his boss, he learns that the .thmx file contains a particular theme whic...
By pasting all the text of the report in thePowerPoint file which opens on double clicking the .thmx file and then saving it as a Word document. 0.0%
By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it. 0.0%
Dave's Boss is wrong. No such arrangement is possible in Microsoft Word 2010. 0.0%
By opening the Word file containing the report, and importing the theme from the .thmx file by using the "Browse for themes" option on the Page Layout tab. 100.0%
For which of the following Business Contact Manager record types is it mandatory to be linked to an Account or Business Contact record?
Marketing Activity 0%
Project Task 0%
Opportunity 0%
Business Project 0%
Format Painter will not normally work with pictures in which the text wrapping is set to:
Square 0.0%
Behind Text 0.0%
In Front of Text 0.0%
In Line with Text 100.0%
How can you remove duplicate emails present in a particular folder?
By using the Clean Up Folder option. 100.0%
By repeatedly using the Send/Receive mails option. 0.0%
By applying filtration of the email according to groups, in a particular folder. 0.0%
By sorting the emails received in a particular folder. 0.0%
How do you insert a new slide master into a presentation?
In Master View, click the Insert Layout button 0.0%
In Master View, click the Insert Slide Master button 100.0%
In Slide Sorter View, click the Insert Slide Design button 0.0%
In Normal editing View, click the Insert Slide Design button 0.0%
How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?
By using the last backup .pst file. 33.0%
By scanning the .pst file with scanpst 66.0%
By re-logging into the mail account. 0.0%
The file cannot be repaired. 0.0%
How do you turn off the controls that show in the lower left corner of the screen during a slide show?
Right-click the controls in the slide show and choose Don't Show 0.0%
Choose the menu Tools -> Options and uncheck Show Popup Toolbar on the View tab 0.0%
Choose the menu File -> Options -> Advanced and select Show Popup Toolbar 100.0%
Press F1 during the slide show 0.0%
How many items can be maintained on the clipboard at one time?
One 0.0%
Up to 24 100.0%
Unlimited 0.0%
Up to 100 0.0%
How will you read comments that reviewers have added to your presentation?
On the View tab, in the Show/Hide group, click on Show Comments. 50.0%
On the Review tab, in the Comments group, click on Show Markup. 50.0%
Both a and b 0.0%
None of the above 0.0%
How would you add a logo to all the slides in a presentation?
In the Normal editing View, paste the logo onto every slide in the presentation. 0.0%
In the Slide Master View, add the logo to the slide master and the title slide layout. 100.0%
In the Slide Master View, add the logo to the blank slide layout. 0.0%
None of the above 0.0%
How would you assign a macro to a graphic?
On the Developer tab, in the Code group, click on Macros. 0.0%
On the View tab, click on Macros and then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign. 0.0%
On a worksheet, right-click on the graphic, then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign. 0.0%
You can use any of the above three techniques. 100.0%
You cannot assign a macro to a graphic. 0.0%
How would you write on the slides during a slide show?
In the Slide Sorter view, right-click on the slide that you want to write on, point to Pen Options, and then click on a pen. Drag it to write. 0.0%
On the Slide Show tab, in the Set Up group, select a pen and then drag it to write. 0.0%
In the Slide Show view, right-click on the slide that you want to write on, point to Pointer Options, and then click on a pen or a highlighter option. Hold down the left mouse button and drag to write. 100.0%
All of the above 0.0%
If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cells .
If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Lock the field. 100.0%
Protect the field. 0.0%
Make the field hidden. 0.0%
Turn field shading off. 0.0%
If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?
Even Page 100.0%
Odd Page 0.0%
Continuous 0.0%
In Microsoft Excel 2010, The LOOKUP function returns a value either from a one-row or one-column range or from an array. Which of the following statements are true regarding the LOOKUP function in ...
lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used. 0.0%
The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order. 0.0%
If the array used by the LOOKUP function in Microsoft Excel 2010 contains more columns than rows, then LOOKUP searches for the value of lookup_value in the first column. 100.0%
If the array used by the LOOKUP function in Microsoft Excel 2010 contains more rows than columns, then LOOKUP searches for the value of lookup_value in the first column. 0.0%
In Microsoft Word 2010, "Keep lines together" paragraph formatting:
works well for paragraphs within a table if "Allow row to break across pages" is also selected. 0.0%
automatically enables the text rows to break across pages. 0.0%
does not work for paragraphs within a table if "Allow row to break across pages" is also selected. 100.0%
always works for paragraphs within a table. 0.0%
In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?
Under Picture Tools, on the Format tab, in the Size group, click Dialog Box Launcher, then Crop. Enter the size numbers in the Width, Height, Left and Top boxes. 100.0%
Select the picture and right click on it. Select Size and Position from the list and then enter the size numbers in the Width, Height, Left and Top boxes. 0.0%
Both a and b 0.0%
None of the above 0.0%
In MS Excel when your cursor is in the last cell of a table, what does Tab key do?
Adds a row at the bottom of the table 100.0%
Adds a row at the top of the table 0.0%
Adds a column to the right of the current cell 0.0%
Places your cursor on the next object on the slide 0.0%
In the Customize Ribbon dialog, choosing Reset All Customizations does what?
It restores the Ribbon to the default settings. 100.0%
It restores the Quick Access Toolbar to the default settings. 0.0%
It restores both the Ribbon and the Quick Access Toolbar to the default settings. 0.0%
In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?
By using the 'Orientation' button in the alignment group of the 'Home' tab. 100.0%
By using the 'Format Cells' in the context menu. 0.0%
By using the 'Orientation' button on the 'Page Layout' tab. 0.0%
By using the 'WordArt' button on the 'Insert' tab. 0.0%
In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. What will happen when this particular area is selected?
It will select the whole sheet, having the same effect as that of Ctrl+A. 100.0%
It will close and save this particular worksheet of the workbook. 0.0%
Nothing will happen. 0.0%
It will hide this particular worksheet. 0.0%
In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?
The red triangles represent the comment associated. 100.0%
The red triangles signify an associated data validation control. 0.0%
The red triangles represent the tracking of the cell. 0.0%
The red triangles signify that the cell is a hidden cell. 0.0%
Josh is to create a technical write-up comprising short paragraphs with double line spacing. Each paragraph is to be separated from the other by a single line space. He writes a paragraph, selects ...
He sets the Line Spacing on the formatting toolbar to 1.0. 0.0%
He selects the double-spaced paragraphs and clicks on Paragraph.Then under Indents and Spacing, he sets the Spacing "Before" and "After" options to zero. 100.0%
He uses the Shift and Enter keys at the same time to create a new paragraph. 0.0%
He selects the double-spaced paragraphs and clicks on Paragraph. Then under Indents and Spacing, he sets the Spacing "Before" and "After" options to Auto. 0.0%
Refer to the image above and identify which Home tab group these commands belong to?
Move 0.0%
Quick Steps 100.0%
Respond 0.0%
Tags 0.0%
Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?
Office Database connections 0.0%
Online Analytical Processing (OLAP) Queries 0.0%
Online Analytical Processing (OLAP) Cube Files 100.0%
Suppose there are some files in a folder named 'demo', which were archived to a file named demo.pst. Now you want to restore this archive to a folder named 'demo1'. Which option in the File tab wil...
Info 0.0%
Open 100.0%
Options 0.0%
None of these 0.0%
Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it i...
Share 'report.xlsx' by saving it to SkyDrive. 0.0%
Share 'report.xlsx' by saving it to a SharePoint site. 100.0%
Share 'report.xlsx' by sending it through email. 0.0%
Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?
In the Insert tab 0.0%
In the Design tab 0.0%
In the View tab 0.0%
In the Review tab 100.0%
The default chart colors are determined by what?
Slide Design Effects 0.0%
Slide Background Graphics 0.0%
Slide Fill Shading 100.0%
Slide Color Scheme 0.0%
The image given above is that of the Recording toolbar, which appears when you Rehearse Timings. What does the part of the toolbar marked 'A' in the image refer to?
It displays the slide time. 100.0%
It displays the total presentation time. 0.0%
It displays the time taken by the first slide. 0.0%
None of the above 0.0%
To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
References" > "Style". 0.0%
References" >"Insert Citation" >"Add New Source. 100.0%
References" >"Insert Citation" >"Add New Placeholder. 0.0%
None of the above 0.0%
What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Digital signatures help authenticate the source of the messages. 0.0%
Both the sender and the receiver of a message can verify that the message has not been altered during transmission, if the message is digitally signed. 0.0%
Digitally signed e-mails meet legal requirements for admissibility and authenticity. 0.0%
All of the above. 100.0%
What does the Compare tool do?
Compares changes in two presentations 100.0%
Compares one image to another to indicate differences 0.0%
Compares file size 0.0%
Compares presentations for backward compatibility 0.0%
What is one thing the Compress Pictures feature does?
Changes all pictures from color to black and white 0.0%
Decreases the contrast of all pictures in the presentation 0.0%
Permanently deletes cropped areas of pictures 100.0%
Condenses the pictures to one area of the slide 0.0%
What is one way to ensure that the sound icon doesn't show in the presentation?
By choosing Hide During Show from the Audio Tools Playback tab of the Ribbon 0.0%
By applying a transparent picture fill effect to the sound icon on the slide 0.0%
By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show 100.0%
All of the above 0.0%
What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
It helps you mitigate integrity threats. 0.0%
It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires. 100.0%
It enables you to specify cryptographic settings for encrypting documents. 0.0%
It is a security tool that enables users to designate safe documents. 0.0%
What view must be used when inserting a subdocument?
Print Layout 0%
Web Layout 0%
Outline 0%
Full Screen Reading 0%
What will happen if the Junk E-mail filter of Microsoft Outlook 2010 does NOT consider a message to be spam but considers it to be phishing?
It will shift the message to the Spam folder. 0.0%
It will disable all the links in the e-mail. 100.0%
It will disable the Reply and Reply All commands. 0.0%
It will delete the e-mail. 0.0%
When using the booklet-printing feature, the term "gutter" refers to the space between page content and the fold in the middle of the paper where you would normally bind pages together.
Which among the following chart types do not have axes?
Bar charts 0.0%
XY (Scatter) charts 0.0%
Doughnut charts 100.0%
Area charts 0.0%
Which among the following command-line switches starts up Microsoft Outlook 2010 with the Reading Pane turned off?
/noextensions 0%
/nocustomize 0%
/nopreview 0%
/profiles 0%
Which among the following settings is the default macro security setting?
Disable all macros without notification. 0.0%
Disable all macros except digitally signed macros. 0.0%
Disable all macros with notification. 100.0%
Enable all macros. 0.0%
Which level of junk e-mail protection available in Microsoft Outlook 2010 will you apply, if you want all such e-mails to be treated as junk whose senders are neither on your Safe Senders List nor ...
No Automatic Filtering 0.0%
Low 0.0%
High 0.0%
Safe Lists Only 100.0%
Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?
Update records 0.0%
Create new records 0.0%
Delete records permanently 100.0%
Move records to the Deleted Items folder 0.0%
Which of the following actions from the Delete group not only moves all the existing messages but also the future messages in the selected Conversations to the Deleted Items folder?
Ignore 100.0%
Clean Up 0.0%
Delete 0.0%
Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?
One by one 100.0%
As one object 0.0%
Dim after animation 0.0%
By 1st Level Paragraphs 0.0%
Which of the following are included in a digitally signed e-mail message?
Certificate 100.0%
CAPTCHA image 0.0%
Public key 0.0%
Sender's full name 0.0%
Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Report Filter 0.0%
Row Labels 0.0%
Values 100.0%
Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Automatic 33.0%
Cell midpoint 0.0%
Cell right 33.0%
Cell left 33.0%
Which of the following defines the correct purpose of using a poster frame image?
To add still image introduction to the video 100.0%
To add visual effect to the narration 0.0%
To insert a picture on any part of the screen 0.0%
To create or edit a presentation based on a set of pictures 0.0%
Which of the following delegate permission levels allows you to change and delete the items that the manager created?
Author 0.0%
Editor 100.0%
Reviewer 0.0%
Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?
Excel displays data corresponding to the pivot report value on the same sheet. 100.0%
Excel creates a new sheet with data corresponding to the pivot report value. 0.0%
Excel creates a new workbook with data corresponding to the pivot report value. 0.0%
Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?
There is no logon password for the Outlook program itself. The password you set protects only your Outlook data file (.pst) that is used in Outlook. 0.0%
If you are running Outlook with a Microsoft Exchange account, your data for that account, including password access, is automatically managed by Microsoft Exchange. 0.0%
You can set a password for individual folders within the .pst. 100.0%
None of the above 0.0%
Which of the following is not a category of transition?
Subtle 0.0%
Exciting 0.0%
Dynamic Content 100.0%
Emphasis 0.0%
Which of the following is NOT an option when inserting a Cross-reference?
Numbered item 0.0%
SmartArt 100.0%
Heading 0.0%
Equation 0.0%
Table 0.0%
Which of the following is true regarding Microsoft Excel 2010 Web App?
It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library. 33.0%
It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access. 33.0%
Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access. 0.0%
A shared workbook can be loaded in the browser. 33.0%
Which of the following methods will you use to insert a hyperlink in a message in Microsoft Outlook 2010, if the format of the mail is set to Rich Text?
Type the hyperlink in the body of the message. 0.0%
Drag a hyperlink into the body of the message. 0.0%
Click on the Insert tab-> Go to the Links group-> Add Hyperlink. 0.0%
Any of the above methods can be used. 100.0%
Which of the following record types of Business Contact Manager for Microsoft Outlook 2010 allows you to plan and track communication activities to accomplish a business result, such as increasing ...
Opportunity 0.0%
Marketing Activity 0.0%
Business Project 100.0%
Business Contact 0.0%
Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
An offline cube file stores data in the form of an OLAP cube. 0.0%
The file format for an offline cube file is .ocf. 100.0%
An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable. 0.0%
Which of the following statements regarding images in Microsoft Excel 2010 are true?
Microsoft Excel 2010 validates images which are in the form of external and active content. 0.0%
Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency. 50.0%
Microsoft Excel 2010 supports 3D rotation of images. 50.0%
Which of the following tag is not available in Microsoft Outlook 2010?
Unread/read 100.0%
Follow Up 0.0%
Categorize 0.0%
Show in Favorites 0.0%
Which of the following types of tabs is displayed in the tab row when an object, such as an image, is selected or highlighted in the application workspace, in Microsoft Outlook 2010?
Standard ribbon tabs 100.0%
Modal tabs 0.0%
Contextual tabs 0.0%
Which of the following types of worksheets will not load in Microsoft Excel Services?
Worksheets with ActiveX controls 100.0%
Worksheets with tables 0.0%
Worksheets with hyperlinks 0.0%
Worksheets with Organization Charts and Diagrams 0.0%
All of the above 0.0%
Which picture format maintains transparency in MS 2010 Powerpoint?
.png 0.0%
.gif 100.0%
.jpg 0.0%
.wmf 0.0%
Which standard form is used to record actions which relate to specific contacts and put the action in a Timeline view?
Post 0.0%
Journal Entry 100.0%
Appointment 0.0%
Task Request 0.0%
Why would you use content controls in a document?
To get information from another source and have it appear at a specific place in a document.For example, the customer data automatically appears when you create a new invoice. 0.0%
To create a document and restrict what people can do with it. For example, you create a document that contains legal language, and you want to ensure people don't accidentally change or delete any of its text. 0.0%
To create structured regions of a document that people fill out. For example, the cover page of the proposal can't be changed except by filling out the title and author. 0.0%
All of the above 100.0%
None of the above 0.0%
With which chart type(s) is the "Depth Gridlines" option available?
Bubble chart 0.0%
Line chart 0.0%
True 3D chart 100.0%
All of the above 0.0%
You added a custom tab in the Microsoft Excel Ribbon and exported this Ribbon Toolbar customization into a file named 'custom.exportedUI'. After a few days, you import this Ribbon Toolbar customiza...
All prior customizations will be retained. 0.0%
All prior customizations will be merged. 0.0%
All prior customizations will be lost. 100.0%
You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the fo...
Scenarios 0.0%
Data tables 100.0%
Goal Seek 0.0%
You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?
Fill color, More Fill Colors 100.0%
Background Color 0.0%
Texture 0.0%
Pattern 0.0%
You customized the navigation pane with a lot of folders and shortcuts but now you want to remove all of them. What command line switch would you use with outlook.exe to remove the folders you added?
/profiles 0.0%
/resetfolders 0.0%
/resetnavpane 100.0%
/recycle 0.0%
You have just created a new document based on the normal template and have created a custom style. You now want to make that custom style easily available in all future documents. In order to do th...
"Add to Quick Style List" in the Styles pane. 0.0%
"New documents based on this template" under modify style option. 100.0%
Copy the style to each document manually each time you want to use it. 0.0%
You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Through 0.0%
Square 0.0%
In Front of Text 0.0%
In Line with Text 100.0%