Certiport IC3 Computing Fundamentals - IC3_GS4_CF 模擬練習
You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in Excel
2007. You enter test data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following conditional formulas will return "True"?
2007. You enter test data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following conditional formulas will return "True"?
正解: A
Which of the following components are commonly installed as an internal device on a computer system's unit? Each correct answer represents a complete solution. Choose all that apply.
正解: A,B,C,D
Which of the following are the primary causes of file/folder unavailability? Each correct answer represents a complete solution. Choose all that apply.
正解: B,D
You work as an Office Assistant for BlueSoft Inc. You use Microsoft Word 2007 for creating documents. You have created a document and asked two reviewers to review it. Both the reviewers have made some changes in the document. You need to combine the changes made by both the reviewers. You have clicked the Review tab. Mark the button on which you will click to accomplish the task.
正解:

Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer has a database named Sales created in Microsoft Office Access 2007. Peter has to create a table named user, which will contain two fields as follows:
UserID
Password
Peter wants to ensure that data in the Password field will be displayed in the form of *. Which of the following properties will Peter use to accomplish the task?
UserID
Password
Peter wants to ensure that data in the Password field will be displayed in the form of *. Which of the following properties will Peter use to accomplish the task?
正解: A
You work as an Office Assistant for TechWorld Inc. You use Microsoft Word 2007 for creating documents. You have recently created a document for the sales of your company. You need to set a password for opening the document. You open the Save As dialog box and click the Tools button to display a menu. Mark the menu item on which you will click to set a password for the document.
正解:

You work as an Office Assistant for TechWorld Inc. You use Microsoft Word 2007 for creating documents. You have recently created a document for the sales of your company. You need to set a password for opening the document. You open the Save As dialog box and click the Tools button to display a menu. Mark the menu item on which you will click to set a password for the document.
正解:

Which of the following is a technology that emulates a telephone conversation over the Internet?
正解: A
Sam works as an Office Assistant. He uses Microsoft Excel XP to create reports. He creates a sales report as shown in the figure. Since text written in cell A1 is longer than the cell size, he wants to adjust it into the next line in the same cell. Which of the following options will he use to accomplish the task?


正解: B
Which of the following is also known as a six pin mini-DIN?
正解: B
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.
正解: A,B,C,D
Which of the following is an application of image editing techniques in order to create an illusion or deception through analog or digital means?
正解: B
You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in Excel
2007. You enter test data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following conditional formulas will return "True"?
2007. You enter test data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following conditional formulas will return "True"?
正解: A
Which of the following is the Windows feature on which the file management can be performed by a PC user?
正解: B