Microsoft Office Skills Online Test-1

Question-1.

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

Automatic

Cell midpoint

Cell right

Cell left

Question-2.

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.

It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.

Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.

A shared workbook can be loaded in the browser.

Question-3.

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.

Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency.

Microsoft Excel 2010 supports 3D rotation of images.

Question-4.

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

Worksheets with ActiveX controls

Worksheets with tables

Worksheets with hyperlinks

Worksheets with Organization Charts and Diagrams

All of the above

Question-5.

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.

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.

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.

All of the above

EXAMRADAR.COM

For Solo Learner Computer science

Microsoft Office Skills Objective MCQs Based Online Test-1

Test-summary

Information

Results

Categories