QUESTION NO: 1
Which of the following problems are the common hardware related problems of a PC? Each correct answer represents a complete solution. Choose all that apply.
Which of the following problems are the common hardware related problems of a PC? Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: A,B,C,D
Vote an answer
QUESTION NO: 2
You work as a Sales Manager for Tech Perfect Inc. You have to create a report in Excel 2007 in the following format:
You want to insert formulas in the cells in the First Quarter column. These cells will display the sum of values of respective columns in January, February, and March columns. For this, you insert the following formula in the E2 cell:
=sum(B2:D2)
However, Excel is treating the formula as a text and displaying it in the following format:
What is the most likely cause?
What is the most likely cause?
You work as a Sales Manager for Tech Perfect Inc. You have to create a report in Excel 2007 in the following format:
You want to insert formulas in the cells in the First Quarter column. These cells will display the sum of values of respective columns in January, February, and March columns. For this, you insert the following formula in the E2 cell:
=sum(B2:D2)
However, Excel is treating the formula as a text and displaying it in the following format:
What is the most likely cause?
What is the most likely cause?
Correct Answer: B
Vote an answer
QUESTION NO: 3
Which of the following is a dedicated computer with expanded storage capacity that provides access to the shared data resources to the entire network?
Which of the following is a dedicated computer with expanded storage capacity that provides access to the shared data resources to the entire network?
Correct Answer: D
Vote an answer
QUESTION NO: 4
Which of the following is a malware and is used by its creator to gather and transmit personal information, especially financial information, for the purpose of identity theft?
Which of the following is a malware and is used by its creator to gather and transmit personal information, especially financial information, for the purpose of identity theft?
Correct Answer: C
Vote an answer
QUESTION NO: 5
You work as an Office Assistant for Tech Perfect Inc. You have converted a data range into a data table as shown in the image below:
You want to add a total row in the table to calculate the total. The total row will include the sum of the Total First Quarter column. You want to perform this in the easiest and best possible way. Which of the following steps will you take to accomplish the task?
You work as an Office Assistant for Tech Perfect Inc. You have converted a data range into a data table as shown in the image below:
You want to add a total row in the table to calculate the total. The total row will include the sum of the Total First Quarter column. You want to perform this in the easiest and best possible way. Which of the following steps will you take to accomplish the task?
Correct Answer: C
Vote an answer
QUESTION NO: 6
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You create a report in a workbook in Excel 2007. A worksheet in the report contains a list. The fragment of the sheet is shown below:
The list contains the sales data of all sales managers of the company. You want to format all the cells that contain the value "Mark" in the Sales Manager column, so that they appear differently. You have to do it with the least administrative burden. Choose the required steps that you will take to accomplish the task.
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You create a report in a workbook in Excel 2007. A worksheet in the report contains a list. The fragment of the sheet is shown below:
The list contains the sales data of all sales managers of the company. You want to format all the cells that contain the value "Mark" in the Sales Manager column, so that they appear differently. You have to do it with the least administrative burden. Choose the required steps that you will take to accomplish the task.
Correct Answer:
QUESTION NO: 7
Which of the following is a UPS technology that provides line conditioning, surge suppression, and backup battery features within the same package?
Which of the following is a UPS technology that provides line conditioning, surge suppression, and backup battery features within the same package?
Correct Answer: A
Vote an answer
QUESTION NO: 8
Which of the following are the standard actions that can be performed on a GUI window? Each correct answer represents a complete solution. Choose all that apply.
Which of the following are the standard actions that can be performed on a GUI window? Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: B,C,D,E
Vote an answer
QUESTION NO: 9
Which of the following operations will be performed first in the formula given below?
2+11*4+10/5
Which of the following operations will be performed first in the formula given below?
2+11*4+10/5
Correct Answer: D
Vote an answer
QUESTION NO: 10
Which of the following is an application included with the Mac OS X operating system that allows users to modify various settings which are divided into separate panes?
Which of the following is an application included with the Mac OS X operating system that allows users to modify various settings which are divided into separate panes?
Correct Answer: D
Vote an answer
QUESTION NO: 11
All of the following are optimizing and cleaning software except for which one?
All of the following are optimizing and cleaning software except for which one?
Correct Answer: A
Vote an answer
QUESTION NO: 12
Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer having Microsoft Office 2007 installed on it. The computer contains a database named Sales which is reated in Microsoft Access 2007. The Sales database has a table named SalesData.
Andrew wants to enforce domain integrity on the SalesData table. Which of the following constraints will he use to accomplish the task?
Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer having Microsoft Office 2007 installed on it. The computer contains a database named Sales which is reated in Microsoft Access 2007. The Sales database has a table named SalesData.
Andrew wants to enforce domain integrity on the SalesData table. Which of the following constraints will he use to accomplish the task?
Correct Answer: C
Vote an answer
QUESTION NO: 13
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. The report worksheet will include the sales made by all the sales managers in the month of January.
In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. The report worksheet will include the sales made by all the sales managers in the month of January.
In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?
Correct Answer: A
Vote an answer
QUESTION NO: 14
James creates a presentation. He wants to format a certain text of the presentation to bold. For this, he selects the text and clicks on the bold icon. Mark the icon on which he clicks to accomplish the task.
James creates a presentation. He wants to format a certain text of the presentation to bold. For this, he selects the text and clicks on the bold icon. Mark the icon on which he clicks to accomplish the task.
Correct Answer:
QUESTION NO: 15
Which of the following software application is used to communicate person-to-person across a network?
Which of the following software application is used to communicate person-to-person across a network?
Correct Answer: A
Vote an answer