UPWORK Microsoft Excel Test Answers

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. A. Ascending B• Descending C• Either ascending or descending

A. Ascending

Which of the following statements is NOT true regarding import of data into PowerPivot? A. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query. B• The data being imported into PowerPivot can be filtered before the import. C• The PowerPivot Import Wizard provides you with an SQL Query builder.

A. Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.

Microsoft Excel Services is a component of: A. Microsoft SharePoint Technology B• Microsoft Server Technology C• Microsoft Virtualization Technology

A. Microsoft SharePoint Technology

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? A• All cloned copies of that slicer are also updated instantly. B• Only the original slicer reflects the changes being made. C• An error is displayed because no updations are allowed in slicers having cloned copies. D• None of the above.

A• All cloned copies of that slicer are also updated instantly.

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. A• Ascending B• Descending C• Either ascending or descending

A• Ascending

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? A• Scenarios B• Data tables C• Goal Seek

A• Scenarios

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)) A• 67 B• 80 C• 90 D• 60

B• 80

What would be the output when you use the following formula in an MS Excel 2010 worksheet? =SUM(A2:CHOOSE(2,A3,A4,A5)) A• 67 B• 80 C• 90 D• 60

B• 80

Which among the following settings is the default macro security setting? A. Disable all macros except digitally signed macros. B• Disable all macros with notification. C• Enable all macros.

B• Disable all macros with notification.

Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser? A.• Excel Calculation Services (ECS) B• Excel Web Access (EWA) C• Excel Web Services (EWS)

B• Excel Web Access (EWA)

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? A• Share 'report.xlsx' by saving it to SkyDrive. B• Share 'report.xlsx' by saving it to a SharePoint site. C• Share 'report.xlsx' by sending it through email.

B• Share 'report.xlsx' by saving it to a SharePoint site.

Which of the following tools is used to format Excel worksheet data, as shown in the figure above? A. Slicer B• SmartArt C• Macros

B• SmartArt

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. A• Table B• Worksheet C• Workbook

B• Worksheet

What is the filename extension of Excel workbooks which are saved as 'Excel Templates'? A• .xlsx B• .xslt C• .xltx D• .slk

C• .xltx

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? A• 2-Color Scale B• 3-Color Scale C• 4-Color Scale D• Data Bar

C• 4-Color Scale

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 2016 worksheet? A• 2-Color Scale B• 3-Color Scale C• 4-Color Scale D• Data Bar

C• 4-Color Scale

Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010? A• An offline cube file stores data in the form of an OLAP cube. B• If you delete the offline cube file for the report, still you can create a new offline cube file for the report. C• An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

C• An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010? A• Cell midpoint B• Cell left C• Cell right

C• Cell right

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? A• Cell Color B• Font Color C• Font Style

C• Font Style

How would you assign a macro to a graphic? A• On the Developer tab, in the Code group, click on Macros. B• 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. C• 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.

C• 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.

Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns? A• Report Filter B• Row Labels C• Values

C• Values

Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010? A• One limitation of PowerPivot is that it does not allow access to Slicers when working on data in PowerPivot. B• A connection to a server running SQL Server Analysis Services is required to answer PivotTable queries by the PowerPivot engine. C• Version control and tracking is supported by PowerPivot.

C• Version control and tracking is supported by PowerPivot.

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? A• lookup_value B• lookup_vector C• result_vector

C• result_vector

What are the benefits of digitally signing an e-mail in Microsoft Excel 2010? A• Digital signatures help authenticate the source of the messages. B• 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. C• Digitally signed e-mails meet legal requirements for admissibility and authenticity. D• All of the above.

D• All of the above.

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

• False

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

• False