MS Excel, Computer Skills

MS Excel

Question: Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.
A
Content that people with disabilities might find difficult to read.

B
Checking features not supported by earlier versions of Excel.

C
Both a and b

Note: Not available
1. Report
Question: 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
60

D
90

Note: Not available
1. Report
Question: Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?
A
Gradient Fill

B
Texture Fill

C
Crystal Fill

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: 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?
A
The value of cell D9 will be 24

B
The value of cell D9 will be 42

C
The value of cell D9 will be #VALUE!

Note: Not available
1. Report
Question: 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?
A
The red triangles represent the comment associated.

B
The red triangles signify an associated data validation control.

C
The red triangles represent the tracking of the cell.

D
The red triangles signify that the cell is a hidden cell

Note: Not available
1. Report
Question: What is the filename extension of Excel workbooks which are saved as ' Excel Templates ' ?
A
.xlsx

B
.xslt

C
.xltx

D
.slk

Note: Not available
1. Report
Question: 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.

Note: Not available
1. Report
Question: Suppose you have created a report in Excel named 'report.xlsx'. Now you want that 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?
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.

Note: Not available
1. Report
Question: 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)

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.

Question: 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))

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

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

Question: 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?

Question: 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?

Question: What is the filename extension of Excel workbooks which are saved as ' Excel Templates ' ?

Question: Which among the following settings is the default macro security setting?

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