Category Archives: Upwork Computer Skills

Upwork Computer Skills

Microsoft Excel 2010 Test 2016

Published by:

1. Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true?

Answers:

  1. All cloned copies of that slicer are also updated instantly.
  2. Only the original slicer reflects the changes being made.
  3. An error is displayed because no updations are allowed in slicers having cloned copies.
  4. None of the above.

2. How would you assign a macro to a graphic?

Answers:

  1. On the Developer tab, in the Code group, click on Macros.
  2. 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.
  3. 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.

3. State whether following statement regarding cell references in Microsoft Excel 2010 is true or false:
A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).

Answers:

  1. True
  2. False

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

Answers:

  1. Office Database connections
  2. Online Analytical Processing (OLAP) Queries
  3. Online Analytical Processing (OLAP) Cube Files
  4. All of the above

5. Which of the following tools is used to format Excel worksheet data, as shown in the figure above?

Answers:

  1. Slicer
  2. SmartArt
  3. Macros

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

Answers:

  1. It will select the whole sheet.
  2. It will close and save this particular worksheet of the workbook.
  3. Nothing will happen.
  4. It will hide this particular worksheet.

7. Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?

Answers:

  1. Excel Calculation Services (ECS)
  2. Excel Web Access (EWA)
  3. Excel Web Services (EWS)

8.What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?

Answers:

  1. .xlsx
  2. .xslt
  3. .xltx
  4. .slk

9. State whether following statement regarding images in Microsoft Excel 2010 is true or false:
Microsoft Excel 2010 supports 3D rotation of images.

Answers:

  1. True
  2. False

10. In the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data.
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?

Answers:

  1. The value of cell D9 will be 24
  2. The value of cell D9 will be 42
  3. The value of cell D9 will be #VALUE!

11. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?

Answers:

  1. PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.
  2. PowerPivot does not allow access to slicers when working on data in PowerPivot.
  3. Version control and tracking are NOT supported by PowerPivot.

12. With reference to the screenshot given, which of the following formulae CANNOT be used to calculate the average of the column ‘Marks’ in the cell ‘E17’?

Answers:

  1. =AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)
  2. =AVERAGE(E6:E15)
  3. =(SUM(E6:E15)/COUNT(E6:E15))
  4. =AVERAGE(E6 to E15)

13. Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?

Answers:

  1. The worksheet grid in Excel Web Access on SharePoint Foundation 2010 Server is limited to 20 columns and 75 rows.
  2. It is possible to select contiguous and noncontiguous cells on a worksheet using mouse and keyboard.
  3. It is not possible to use the CTRL+Enter keyboard combination on formulas entered in multiple cells in a worksheet.

14. State whether the following is true or false:

Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook

Answers:

  1. True
  2. False

15. What does the icon marked with a red square in the figure above signify?

Answers:

  1. It signifies that a macro is enabled.
  2. It signifies that the document contains digital signatures.
  3. It signifies that a macro is disabled.
  4. It signifies that a webcam has been detected.

16. Excel keeps the changed history of a workbook for ________ days by default.

Answers:

  1. 10 days
  2. 20 days
  3. 25 days
  4. 30 days

17. Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?

Answers:

  1. Gradient Fill
  2. Crystal Fill
  3. Texture Fill

18. Suppose you create a workbook in Microsoft Excel 2010 and run the ‘Check Accessibility’ option. This option is used to check the workbook for ____________.

Answers:

  1. Content that people with disabilities might find difficult to read.
  2. Checking features not supported by earlier versions of Excel.
  3. Both a and b

19. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?

Answers:

  1. Automatic
  2. Cell right
  3. Cell left

20. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?

Answers:

  1. It helps you mitigate integrity threats.
  2. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
  3. It enables you to specify cryptographic settings for encrypting documents.
  4. None of the above

21. Microsoft Excel Services is a component of:

Answers:

  1. Microsoft SharePoint Technology
  2. Microsoft Server Technology
  3. Microsoft Virtualization Technology

22. Which of the following statements is NOT true regarding import of data into PowerPivot?

Answers:

  1. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.
  2. The data being imported into PowerPivot can be filtered before the import.
  3. The PowerPivot Import Wizard provides you with an SQL Query builder.

23. Which among the following settings is the default macro security setting?

Answers:

  1. Disable all macros except digitally signed macros.
  2. Disable all macros with notification.
  3. Enable all macros.

24. Which of the following sorting options is NOT available under the Sort On option while sorting the data of a table in an Microsoft Excel 2010 worksheet?

Answers:

  1. Cell Color
  2. Font Color
  3. Font Style

25. State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false:

An Absolute cell reference consists of the column letter and row number.

Answers:

  1. True
  2. False

26. In the given screenshot, the contents of the ‘Name of User’ column have been oriented at an angle. How is this done?

Answers:

  1. By using the ‘Orientation’ button in the alignment group of the ‘Home’ tab.
  2. By using the ‘Orientation’ button on the ‘Page Layout’ tab.
  3. By using the ‘WordArt’ button on the ‘Insert’ tab.

27. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?

Answers:

  1. An offline cube file stores data in the form of an OLAP cube.
  2. If you delete the offline cube file for the report, still you can create a new offline cube file for the report.
  3. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

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

Answers:

  1. The red triangles represent the comment associated.
  2. The red triangles signify an associated data validation control.
  3. The red triangles represent the tracking of the cell.
  4. The red triangles signify that the cell is a hidden cell.

29. When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.

Answers:

  1. Table
  2. Worksheet
  3. Workbook

30. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

Answers:

  1. Digital signatures help authenticate the source of the messages.
  2. 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.
  3. Digitally signed e-mails meet legal requirements for admissibility and authenticity.
  4. All of the above.

31. Deleting a PivotChart report automatically deletes the associated PivotTable report.

Answers:

  1. True
  2. False

32. 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 following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?

Answers:

  1. Scenarios
  2. Data tables
  3. Goal Seek

33. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?

Answers:

  1. Cell midpoint
  2. Cell left
  3. Cell right

34. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?

Answers:

  1. Report Filter
  2. Row Labels
  3. Values

35. Analyze the syntax of LOOKUP function when used in vector form?

LOOKUP(lookup_value, lookup_vector, result_vector)

The values in the lookup_vector must be placed in ________ order.

Answers:

  1. Ascending
  2. Descending
  3. Either ascending or descending

36. You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?

Answers:

  1. 2-Color Scale
  2. 3-Color Scale
  3. 4-Color Scale
  4. Data Bar

37. Analyze the image shown. What would be the output when you use the following formula in an MS Excel 2010 worksheet?
=SUM(A2:CHOOSE(2,A3,A4,A5))

Answers:

  1. 67
  2. 80
  3. 90
  4. 60

38. Analyze the syntax of LOOKUP function when used in vector form?

LOOKUP(lookup_value, lookup_vector, result_vector)

Which of the following arguments of the LOOKUP function is optional?

Answers:

  1. lookup_value
  2. lookup_vector
  3. result_vector

39. Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?

Answers:

  1. One limitation of PowerPivot is that it does not allow access to Slicers when working on data in PowerPivot.
  2. A connection to a server running SQL Server Analysis Services is required to answer PivotTable queries by the PowerPivot engine.
  3. Version control and tracking is supported by PowerPivot.

40. Suppose you have created a report in Excel named ‘report.xlsx’. Now you want your team members to be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?

Answers:

  1. Share ‘report.xlsx’ by saving it to SkyDrive.
  2. Share ‘report.xlsx’ by saving it to a SharePoint site.
  3. Share ‘report.xlsx’ by sending it through email.

41. State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false:

A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).

Answers:

  1. True
  2. False

5,646 total views, 13 views today

Upwork Computer Skills

Microsoft Access 2010 Test 2016

Published by:

1. Which of the following Microsoft Access 2010 components can pose security risks in an untrusted database?

Answers:

  1. Action queries (queries that insert, delete, or change data)
  2. Macros
  3. Forms
  4. VBA code

2. Which of the following are reserved for use by SharePoint and is not supported on the Web?

Answers:

  1. Solutions
  2. Docs
  3. Lists
  4. UserInfo
  5. Reports

3. For what reason(s) can a digital signature or certificate be regarded as invalid?

Answers:

  1. The publisher is not a trusted publisher.
  2. The digital signature has expired.
  3. The certificate was not issued by a certified authority.
  4. All of the above.

4. Suppose you want to apply a calculated field on a TextBox control to concatenate the values of the firstName and lastName fields, with a space between them.Which of the following expressions will you enter in the Expression Builder?

Answers:

  1. [firstName] +” “+[lastName]
  2. [firstName] +” #”+[lastName]
  3. [firstName] &” “& [lastName]
  4. [firstName] &”,”& [lastName]

5. What is the purpose of Option Explicit?

Answers:

  1. It is a database object.
  2. Requires variable declarations.
  3. It contains all of the data access pages that are currently open in a Microsoft Access project.
  4. It contains all open standard modules and class modules in a Microsoft Access database.

6. Which of the following is not done when you compact a database?

Answers:

  1. Table records and objects are restructured and then stored in successive memory blocks.
  2. Databases linked to the compacted database are compacted and repaired.
  3. Table records are restored into their primary key order, if a primary key exists in the table.
  4. The physical size of the database is reduced by making an exact duplicate of the database.

7. How can you tell if a report has no records to display or print in Microsoft Access 2010?

Answers:

  1. By using the report’s Error event.
  2. By using the report’s ApplyFilter event.
  3. By using the report’s NoData event.
  4. By using the report’s Filter event.

8. How do you start a Microsoft Access application so that the user can’t see or use the Navigation Pane (or database container)?

Answers:

  • Set the Access Option to hide the navigation pane, and press CTRL+F11 special keys.
  • Set the Access Option to hide the navigation pane, and press ALT+F1 special keys.
  • Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11.
  • Set the Access Option to hide the navigation pane, and press CTRL+G special keys.

9. What is the advantage of a Class Module versus a Standard Module?

Answers:

  1. Encapsulation, Inheritance
  2. Data Abstraction
  3. Polymorphism
  4. Reusability

10. How can you share common objects between multiple projects in Microsoft Access 2010?

Answers:

  1. By customizing tabs.
  2. By creating Data Macros.
  3. By using a Web Browser Control.
  4. By creating Application Parts.

11. Consider the following tables:

Books
———
BookId
BookName
AuthorId
SubjectId
PopularityRating (the Popularity of the book on a scale of 1 to 10)
Language(such as French, English, German etc)

What is the query to determine which German books (if any) are more popular than all the French books?

Answers:

  1. Select bookname from books where language=’German’ and popularityrating =(Select popularityrating from books where language=’French’)
  2. Select bookname from books where language=’German’ and popularityrating > (Select popularityrating from books where language=’French’)
  3. Select bookname from books where language=’French’ and popularityrating > (Select max(popularityrating) from books where language=’German’)
  4. Select bookname from books where language=’German’ and popularityrating > (Select max(popularityrating) from books where language=’French’)

12. Which of the following is NOT possible when you link to an Excel worksheet from within Access?

Answers:

  1. You can append data to an existing table.
  2. You can create a database containing multiple linked tables.
  3. You can edit the Excel spreadsheet by making changes in to the linked table.
  4. By creating a linked table any changes that are made to the data in Excel are automatically reflected in the linked table.

13. What could be the problem when an error message “#Error” is received in a query?

Answers:

  1. The query is joining fields that have different data types.
  2. A field’s alias conflicts with a component of the expression for that field.
  3. The object or the database is damaged.
  4. The denominator of a calculated field is zero.

14. How do you create a report for a Crosstab Query if certain column values are missing?

Answers:

  1. Set the Value field in the Crosstab.
  2. Set the Column Heading field in the Crosstab.
  3. Set the Pivot list in the Crosstab.
  4. Set the report’s Crosstab property to True

15. Suppose you have a table named Cars with fields that store the name, year, price, and condition of used cars that you are considering for purchase. Also suppose that the table has become large and that you frequently include the Year field in queries. You can create an index on the Year field so that your queries return results more quickly. Which syntax will you use to achieve this?

Answers:

  1. CREATE INDEX YearIndex ON Cars (Year)
  2. CREATE Year INDEX ON Cars (Year)
  3. CREATE INDEX ON Cars (Year)
  4. Both b and c

16. Which of the following is true about a.accde file in Microsoft Access 2010?

Answers:

  1. It contains compiled VBA code to prevent users from viewing the code.
  2. It can be saved as a.accdb file in order to make design changes.
  3. It allows users to import forms and reports from other databases.
  4. It allows users to view, but not modify VBA code.

17. Suppose you want to use data from two tables in a query: tblCustomer and tblOrder. The two tables both have a field, CustomerID, that identifies a customer. Each record in the tblCustomer table may have one or more corresponding records in the tblOrder table, and the corresponding values can be determined by values in the CustomerID field. You now want to join the tables so that the query combines the records from the tables, excluding records from either table if there is no corresponding record in the other table. Which of the following FROM clauses will you use?

Answers:

  1. FROM [tblCustomer] LEFT JOIN [tblOrder] ON [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
  2. FROM [tblCustomer] RIGHT JOIN [tblOrder] ON [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
  3. FROM [tblCustomer] INNER JOIN [tblOrder] ON [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
  4. FROM [tblCustomer], [tblOrder]

18. If you want to encrypt a database by using a password, then the database must be opened in ________ mode.

Answers:

  1. Open Exclusive
  2. Open Exclusive Read-Only
  3. Open Read-Only
  4. Open Password-Enabled

19. Using which of the following Microsoft Access 2010 database file formats, can we use the Package and Sign tool?

Answers:

  1. .accdb
  2. .accdc
  3. .accde
  4. .mdb

20. When you run the Compatibility Checker in Microsoft Access 2010, in which of the following scenarios can you get the error- Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web?

Answers:

  1. Name of an order by element is not valid.
  2. Name of source table is not valid.
  3. Sort order is set to an option other than ascending or descending.
  4. The expression is not valid.
  5. All of the above

21. Using the Package and Sign tool, how many databases can you add to a package that you want to distribute to other users in Microsoft Access?

Answers:

  1. Unlimited
  2. 5
  3. 1
  4. 10

22. Microsoft Access uses indexes in a table to find data. Which of the following field types cannot be indexed?

Answers:

  1. OLE Object
  2. Attachment
  3. Memo
  4. Calculated

23. Which of the following is the correct way to enter the beginning or ending characters of the fields named (UnitPrice and CompanyName) in the AutoIndex onImport/Create field to create an Auto Index ?

Answers:

  1. unit.name
  2. unit;name
  3. unit,name
  4. ‘unit’,’name’

24. In a report with grouping, how can you display the count of records in each group?

Answers:

  1. Add a text box to the group’s footer section and set its control source to =Count(*).
  2. Set the report’s Group Count property to True.
  3. Add a label to the group’s header section and set the Caption property to Count Rows.
  4. Add a Summary control to the report’s footer section.

25. What is the purpose of the Application Parts option in Microsoft Access 2010?

Answers:

  1. It enables you to reduce coding errors and easily incorporate more complex logic to create robust applications.
  2. It integrates your Access reports using multiple data connections and information linked or imported from other sources.
  3. It integrates your Access data with live web content.
  4. It turns portions of your database into reusable templates.

26. Which one of the following correctly selects rows from the students table that have null in column1?

Answers:

  1. Select * from students where column1 is null
  2. Select * from students where column1 = null
  3. Select * from students where column1 EQUALS null
  4. Select * from students where column1 NOT null
  5. Select * from students where column1 CONTAINS null

27. Which of the following is true of the Ribbon interface?

Answers:

  1. Ribbons can be dragged and dropped to be on the side or the bottom of the screen.
  2. Ribbons can be minimized or collapsed.
  3. Ribbons can be replaced with command bars.
  4. New ribbons can be created using the Office Ribbon Generator.

28. What is the function of the icon marked as A (see image) when you are creating Macros in Microsoft Access 2010?

Answers:

  1. Close
  2. Delete
  3. Move up
  4. Move Down

29. What is the function of the ‘Single Step’ in Macros as shown in the image?

Answers:

  1. This command is saves expressions one at a time.
  2. This command executes an action one at a time.
  3. This command saves all queries in a single step.
  4. This command saves all reports in a single step.

30. Password protected databases offer:

Answers:

  1. Only one password with full rights.
  2. Different user rights for different logins/passwords.
  3. Integrated security with Active Directory.
  4. Integrated security with Windows Logins.

31. What will happen when you click on the icon marked as A (see image)?

Answers:

  1. Data Mode pop up will be opened.
  2. Print Preview of the expression that was typed in the text box of Repeat Expression will be displayed.
  3. Expression Builder will pop up.
  4. None of the above

32. A company has the following departments:

Marketing, Designing, Production, Packing

What will be the result of the following query?

Select department from table where department < ‘Marketing’

Answers:

  1. The query will return “Designing, Packing”
  2. The query will return “Designing, Production”
  3. The query will return “Production, Packing”
  4. The query will return “Designing”

33. Microsoft Access 2010 does not support more than ____________ fields in a table.

Answers:

  1. 55
  2. 155
  3. 200
  4. 255

34. Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in the descending order of the CurrentStock column.

Answers:

  1. Select * from Products order by CurrentStock, ProductGroup.
  2. Select * from Products order by CurrentStock DESC, ProductGroup.
  3. Select * from Products order by ProductGroup, CurrentStock.
  4. Select * from Products order by ProductGroup, CurrentStock DESC.
  5. None of the above.

35. Which of the following is incorrect about the Quick Access Toolbar?

Answers:

  1. You can move the Quick Access Toolbar from its default location.
  2. Toolbar can be minimized or collapsed.
  3. You cannot display the Quick Access Toolbar on multiple lines.
  4. You cannot increase the size of the buttons representing the commands by an option in Microsoft Office.

36. Which textbox property in Microsoft Access 2010 determines that the text box is bound, unbound or calculated?

Answers:

  1. RecordSource
  2. ControlSource
  3. CanGrow
  4. RowSource

37. A query that uses the BETWEEN operator for two numbers is identical to:

Answers:

  1. >= and <=
  2. > and <
  3. >= and <
  4. > and <=

38. Which of the given text field properties should you set in order to force a user to enter a date value specifically in MM-DD-YYYY format?

Answers:

  1. Indexed
  2. Validation Rule
  3. Input Mask
  4. Default Value

1,478 total views, 3 views today

Upwork Computer Skills

Knowledge of Microsoft Office Skills Test 2016

Published by:

1. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?

Answers:

  1. Automatic
  2. Cell midpoint
  3. Cell right
  4. Cell left

2. Which of the following is true regarding Microsoft Excel 2010 Web App?

Answers:

  1. It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library.
  2. It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.
  3. Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.
  4. A shared workbook can be loaded in the browser.

3. Which of the following statements regarding images in Microsoft Excel 2010 are true?

Answers:

  1. Microsoft Excel 2010 validates images which are in the form of external and active content.
  2. Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency.
  3. Microsoft Excel 2010 supports 3D rotation of images.

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

Answers:

  1. Standard ribbon tabs
  2. Modal tabs
  3. Contextual tabs

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

Answers:

  1. It will select the whole sheet, having the same effect as that of Ctrl+A.
  2. It will close and save this particular worksheet of the workbook.
  3. Nothing will happen.
  4. It will hide this particular worksheet.

6. Which of the following types of worksheets will not load in Microsoft Excel Services?

Answers:

  1. Worksheets with ActiveX controls
  2. Worksheets with tables
  3. Worksheets with hyperlinks
  4. Worksheets with Organization Charts and Diagrams
  5. All of the above

7. Why would you use content controls in a document?

Answers:

  1. 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.
  2. 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.
  3. 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.
  4. All of the above
  5. None of the above

8. Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?

Answers:

  1. Update records
  2. Create new records
  3. Delete records permanently
  4. Move records to the Deleted Items folder

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

Answers:

  1. True
  2. False

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

Answers:

  1. Fill color, More Fill Colors
  2. Background Color
  3. Texture
  4. Pattern

11. 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 this, you need to select:

Answers:

  1. “Add to Quick Style List” in the Styles pane.
  2. “New documents based on this template” under modify style option.
  3. Copy the style to each document manually each time you want to use it.

12. Which of the following delegate permission levels allows you to change and delete the items that the manager created?

Answers:

  1. Author
  2. Editor
  3. Reviewer

13. What is one way to ensure that the sound icon doesn’t show in the presentation?

Answers:

  1. By choosing Hide During Show from the Audio Tools Playback tab of the Ribbon
  2. By applying a transparent picture fill effect to the sound icon on the slide
  3. By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show
  4. All of the above

14. Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?

Answers:

  1. 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.
  2. If you are running Outlook with a Microsoft Exchange account, your data for that account, including password access, is automatically managed by Microsoft Exchange.
  3. You can set a password for individual folders within the .pst.
  4. None of the above

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

Answers:

  1. Office Database connections
  2. Online Analytical Processing (OLAP) Queries
  3. Online Analytical Processing (OLAP) Cube Files

16. With which chart type(s) is the “Depth Gridlines” option available?

Answers:

  1. Bubble chart
  2. Line chart
  3. True 3D chart
  4. All of the above

17. Which of the following tag is not available in Microsoft Outlook 2010?

Answers:

  1. Unread/read
  2. Follow Up
  3. Categorize
  4. Show in Favorites

18. By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?

Answers:

  1. It is linked
  2. It is embedded

19. 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: Continuous Section Break inserts a section break and starts the new section on the next page.

Which of the following options is correct?

Answers:

  1. Statement X is correct. Statement Y is incorrect.
  2. Statement X is incorrect. Statement Y is correct.
  3. Both Statements X and Y are correct.
  4. Both Statements X and Y are incorrect.

20. Which of the following is not a category of transition?

Answers:

  1. Subtle
  2. Exciting
  3. Dynamic Content
  4. Emphasis

21. 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 which needs to be applied to the annual report on which Dave is working. How can Dave achieve this?

Answers:

  1. 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.
  2. By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.
  3. Dave’s Boss is wrong. No such arrangement is possible in Microsoft Word 2010.
  4. 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.

22. How can you remove duplicate emails present in a particular folder?

Answers:

  1. By using the Clean Up Folder option.
  2. By repeatedly using the Send/Receive mails option.
  3. By applying filtration of the email according to groups, in a particular folder.
  4. By sorting the emails received in a particular folder.

23. How do you turn off the controls that show in the lower left corner of the screen during a slide show?

Answers:

  1. Right-click the controls in the slide show and choose Don’t Show
  2. Choose the menu Tools -> Options and uncheck Show Popup Toolbar on the View tab
  3. Choose the menu File -> Options -> Advanced and select Show Popup Toolbar
  4. Press F1 during the slide show

24. 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 following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?

Answers:

  1. Scenarios
  2. Data tables
  3. Goal Seek

25. 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 Microsoft Excel 2010?

Answers:

  1. lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.
  2. The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.
  3. 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.
  4. 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.

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

Answers:

  1. It displays the slide time.
  2. It displays the total presentation time.
  3. It displays the time taken by the first slide.
  4. None of the above

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

Answers:

  1. The red triangles represent the comment associated.
  2. The red triangles signify an associated data validation control.
  3. The red triangles represent the tracking of the cell.
  4. The red triangles signify that the cell is a hidden cell.

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

Answers:

  1. True
  2. False

29. Which of the following are included in a digitally signed e-mail message?

Answers:

  1. Certificate
  2. CAPTCHA image
  3. Public key
  4. Sender’s full name

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

Answers:

  1. Ignore
  2. Clean Up
  3. Delete

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

Answers:

  1. Type the hyperlink in the body of the message.
  2. Drag a hyperlink into the body of the message.
  3. Click on the Insert tab-> Go to the Links group-> Add Hyperlink.
  4. Any of the above methods can be used.

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

Answers:

  1. Even Page
  2. Odd Page
  3. Continuous

33. Which standard form is used to record actions which relate to specific contacts and put the action in a Timeline view?

Answers:

  1. Post
  2. Journal Entry
  3. Appointment
  4. Task Request

34. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?

Answers:

  1. Report Filter
  2. Row Labels
  3. Values

35. If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

Answers:

  1. Lock the field.
  2. Protect the field.
  3. Make the field hidden.
  4. Turn field shading off.

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

Answers:

  1. be spread across both cells.
  2. be deleted.
  3. remain intact in the first cell and the second cell will be empty.

37. How will you read comments that reviewers have added to your presentation?

Answers:

  1. On the View tab, in the Show/Hide group, click on Show Comments.
  2. On the Review tab, in the Comments group, click on Show Markup.
  3. Both a and b
  4. None of the above

38. Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?

Answers:

  1. One by one
  2. As one object
  3. Dim after animation
  4. By 1st Level Paragraphs

39. What is one thing the Compress Pictures feature does?

Answers:

  1. Changes all pictures from color to black and white
  2. Decreases the contrast of all pictures in the presentation
  3. Permanently deletes cropped areas of pictures
  4. Condenses the pictures to one area of the slide

40. Which of the following is NOT an option when inserting a Cross-reference?

Answers:

  1. Numbered item
  2. SmartArt
  3. Heading
  4. Equation
  5. Table

41. Refer to the image above and identify which Home tab group these commands belong to?

Answers:

  1. Move
  2. Quick Steps
  3. Respond
  4. Tags

42. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?

Answers:

  1. It helps you mitigate integrity threats.
  2. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
  3. It enables you to specify cryptographic settings for encrypting documents.
  4. It is a security tool that enables users to designate safe documents.

43. In MS Excel when your cursor is in the last cell of a table, what does Tab key do?

Answers:

  1. Adds a row at the bottom of the table
  2. Adds a row at the top of the table
  3. Adds a column to the right of the current cell
  4. Places your cursor on the next object on the slide

44. Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?

Answers:

  1. In the Insert tab
  2. In the Design tab
  3. In the View tab
  4. In the Review tab

45. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?

Answers:

  1. An offline cube file stores data in the form of an OLAP cube.
  2. The file format for an offline cube file is .ocf.
  3. An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

46. To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:

Answers:

  1. References” > “Style”.
  2. References” >”Insert Citation” >”Add New Source.
  3. References” >”Insert Citation” >”Add New Placeholder.
  4. None of the above

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

Answers:

  1. /profiles
  2. /resetfolders
  3. /resetnavpane
  4. /recycle

48. How would you write on the slides during a slide show?

Answers:

  1. 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.
  2. On the Slide Show tab, in the Set Up group, select a pen and then drag it to write.
  3. 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.
  4. All of the above

49. 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 market share, introducing a new product, or retaining customers?

Answers:

  1. Opportunity
  2. Marketing Activity
  3. Business Project
  4. Business Contact

50. The default chart colors are determined by what?

Answers:

  1. Slide Design Effects
  2. Slide Background Graphics
  3. Slide Fill Shading
  4. Slide Color Scheme

51. How would you assign a macro to a graphic?

Answers:

  1. On the Developer tab, in the Code group, click on Macros.
  2. 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.
  3. 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.
  4. You can use any of the above three techniques.
  5. You cannot assign a macro to a graphic.

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

Answers:

  1. It will shift the message to the Spam folder.
  2. It will disable all the links in the e-mail.
  3. It will disable the Reply and Reply All commands.
  4. It will delete the e-mail.

53. In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?

Answers:

  1. 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.
  2. 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.
  3. Both a and b
  4. None of the above

54. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

Answers:

  1. Digital signatures help authenticate the source of the messages.
  2. 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.
  3. Digitally signed e-mails meet legal requirements for admissibility and authenticity.
  4. All of the above.

55. Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?

Answers:

  1. Excel displays data corresponding to the pivot report value on the same sheet.
  2. Excel creates a new sheet with data corresponding to the pivot report value.
  3. Excel creates a new workbook with data corresponding to the pivot report value.

56. 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 is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?

Answers:

  1. Share ‘report.xlsx’ by saving it to SkyDrive.
  2. Share ‘report.xlsx’ by saving it to a SharePoint site.
  3. Share ‘report.xlsx’ by sending it through email.

57. How would you add a logo to all the slides in a presentation?

Answers:

  1. In the Normal editing View, paste the logo onto every slide in the presentation.
  2. In the Slide Master View, add the logo to the slide master and the title slide layout.
  3. In the Slide Master View, add the logo to the blank slide layout.
  4. None of the above

58. In Microsoft Word 2010, “Keep lines together” paragraph formatting:

Answers:

  1. works well for paragraphs within a table if “Allow row to break across pages” is also selected.
  2. automatically enables the text rows to break across pages.
  3. does not work for paragraphs within a table if “Allow row to break across pages” is also selected.
  4. always works for paragraphs within a table.

59. Which of the following defines the correct purpose of using a poster frame image?

Answers:

  1. To add still image introduction to the video
  2. To add visual effect to the narration
  3. To insert a picture on any part of the screen
  4. To create or edit a presentation based on a set of pictures

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

Answers:

  1. Through
  2. Square
  3. In Front of Text
  4. In Line with Text

61. Which among the following settings is the default macro security setting?

Answers:

  1. Disable all macros without notification.
  2. Disable all macros except digitally signed macros.
  3. Disable all macros with notification.
  4. Enable all macros.

62. What does the Compare tool do?

Answers:

  1. Compares changes in two presentations
  2. Compares one image to another to indicate differences
  3. Compares file size
  4. Compares presentations for backward compatibility

63. Which among the following chart types do not have axes?

Answers:

  1. Bar charts
  2. XY (Scatter) charts
  3. Doughnut charts
  4. Area charts

64. Format Painter will not normally work with pictures in which the text wrapping is set to:

Answers:

  1. Square
  2. Behind Text
  3. In Front of Text
  4. In Line with Text

65. 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 on your Safe Recipients List?

Answers:

  1. No Automatic Filtering
  2. Low
  3. High
  4. Safe Lists Only

66. Which picture format maintains transparency in MS 2010 Powerpoint?

Answers:

  1. .png
  2. .gif
  3. .jpg
  4. .wmf

67. How do you insert a new slide master into a presentation?

Answers:

  1. In Master View, click the Insert Layout button
  2. In Master View, click the Insert Slide Master button
  3. In Slide Sorter View, click the Insert Slide Design button
  4. In Normal editing View, click the Insert Slide Design button

68. In the Customize Ribbon dialog, choosing Reset All Customizations does what?

Answers:

  1. It restores the Ribbon to the default settings.
  2. It restores the Quick Access Toolbar to the default settings.
  3. It restores both the Ribbon and the Quick Access Toolbar to the default settings.

69. How many items can be maintained on the clipboard at one time?

Answers:

  1. One
  2. Up to 24
  3. Unlimited
  4. Up to 100

70. 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 customization file back to Microsoft Excel 2010. What will happen to the prior Ribbon Toolbar customizations made during this period?

Answers:

  1. All prior customizations will be retained.
  2. All prior customizations will be merged.
  3. All prior customizations will be lost.

71. How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?

Answers:

  1. By using the last backup .pst file.
  2. By scanning the .pst file with scanpst
  3. By re-logging into the mail account.
  4. The file cannot be repaired.

72. 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 will you use for this purpose, in Microsoft Outlook 2010?

Answers:

  1. Info
  2. Open
  3. Options
  4. None of these

73. 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 the text, points to Line Spacing on the paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The moment he clicks enter to start a new paragraph, it automatically gets double spaced. How can Josh achieve paragraphs separated by single line spaces from each other within the document?

Answers:

  1. He sets the Line Spacing on the formatting toolbar to 1.0.
  2. 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.
  3. He uses the Shift and Enter keys at the same time to create a new paragraph.
  4. 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.

74. In the given screenshot, the contents of the ‘Name of User’ column have been oriented at an angle. How is this done?

Answers:

  1. By using the ‘Orientation’ button in the alignment group of the ‘Home’ tab.
  2. By using the ‘Format Cells’ in the context menu.
  3. By using the ‘Orientation’ button on the ‘Page Layout’ tab.
  4. By using the ‘WordArt’ button on the ‘Insert’ tab.

3,725 total views, 9 views today