Computer Skills

Computer Skills - Upwork

Question: With which chart type(s) is/are the “Depth Gridline” options available?
A
Bubble chart.

B
Line chart.

C
True 3-D chart.

D
All

Note: Not available
1. Report
Question: Which among the following macro settings is mean for developers only?
A
Disable all macros with notification.

B
Disable all macros with notification.

C
Enable all macros.

D
Trust access to the VBA project object model.

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

First Prev 6 7 8 9 10 Next Last

Question: With which chart type(s) is/are the “Depth Gridline” options available?

Question: Which among the following macro settings is mean for developers only?

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?