Daily Archives: September 25, 2015

Microsoft Word 2010 Test

1. Which among the following is not true regarding the use of a pie chart? Answers: A pie chart could be used when there is only one data series to be plotted. A pie chart could be used when the data points in a pie chart are displayed as a percentage of the whole pie. [...]

By | September 25th, 2015|Upwork Computer Skills|0 Comments

Microsoft PowerPoint 2010 Test

1. What does the Set Transparent Color Wand do? Answers: Makes pictures and clip art transparent Makes text transparent Makes one color in a picture or clip art transparent Makes the slide background transparent 2. Suppose you have 5 slides in your presentation and you want to print specific slides 3 to 5. Which of [...]

By | September 25th, 2015|Upwork Computer Skills|0 Comments

Microsoft OutLook 2007 Test

1. For which of the given features does Outlook contain a logging option? Answers: Reminders Offline Address Book Calendar modifications All of the above 2. Which of the following items cannot be archived? Answers: Calendar Contacts Notes Tasks 3. Refer to the given image. When does this Warning message appear? Answers: When you attempt to [...]

By | September 25th, 2015|Upwork Computer Skills|0 Comments

Microsoft Excel 2010 Test

1. 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? Answers: All cloned copies of that slicer are also updated instantly. Only the original slicer [...]

By | September 25th, 2015|Upwork Computer Skills|0 Comments

Microsoft Access 2010 Test

1. Which of the following Microsoft Access 2010 components can pose security risks in an untrusted database? Answers: Action queries (queries that insert, delete, or change data) Macros Forms VBA code 2. Which of the following are reserved for use by SharePoint and is not supported on the Web? Answers: Solutions Docs Lists UserInfo Reports [...]

By | September 25th, 2015|Upwork Computer Skills|0 Comments

Knowledge of Microsoft Office Skills Test

1. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010? Answers: Automatic Cell midpoint Cell right Cell left 2. Which of the following is true regarding Microsoft Excel 2010 Web App? Answers: It is possible to work with sparklines and slicers on an [...]

By | September 25th, 2015|Upwork Computer Skills|0 Comments

Knowledge of SQL Server 2008 Skills Test

1. Which of the following statements using GROUP BY clause are allowed in SQL Server 2008? Answers: SELECT Column1 + Column2 FROM Table GROUP BY Column1, Column2 SELECT Column1, Column2 FROM Table GROUP BY Column1 + Column2 SELECT Column1 + constant + Column2 FROM Table GROUP BY Column1 + Column2 SELECT Column1 + Column2 FROM [...]

By | September 25th, 2015|Upwork .Net Technology|0 Comments

Knowledge of Net Framework 4.0 Skills Test

1. How will you count the odd numbers from the array shown below using LINQ in .Net framework 4.0? int[]numbers={5,4,1,3,9,8,6,7,2,0}; Answers: int findoddNumbers = numbers.Count(n => n % 2 == 1); int findoddNumbers = numbers.Count( n % 2 == 1); int findoddNumbers = (from number in numbers where numbers%2==1 select Count()); int findoddNumbers = (from [...]

By | September 25th, 2015|Upwork .Net Technology|0 Comments

Dot Net 3.5 using C# Test

1. Which of the following are static methods of the System.Reflection Activator class? Answers: CreateComInstanceFrom< CreateInstanceFrom GetInstance CreateInstance All of the above 2. Which of the following are true about Extension methods? Answers: They must be declared static They can be declared either static or instance members They must be declared in the same assembly [...]

By | September 25th, 2015|Upwork .Net Technology|0 Comments