Microsoft Excel 2010 Skills Online Test-1

Question-1.

How would you assign a macro to a graphic?

On the Developer tab, in the Code group, click on Macros.

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.

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.

Question-2.

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 ($).

True

False

Question-3.

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

Online Analytical Processing (OLAP) Queries

Online Analytical Processing (OLAP) Cube Files

All of the above

Question-4.

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

Excel Calculation Services (ECS)

Excel Web Access (EWA)

Excel Web Services (EWS)

Question-5.

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

.xlsx

.xslt

.xltx

.slk

EXAMRADAR.COM

For Solo Learner Computer science

Microsoft Excel 2010 Skills Objective MCQs Based Online Test-1

Test-summary

Information

Results

Categories