IC3-2 Demo and Sample
Note: Answers are below each question.
Samples are taken from full version.
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:
However, Excel is treating the formula as a text and displaying it in the following format:
What is the most likely cause?
Show Formula is enabled in the workbook.
Manual Calculation is enabled in the workbook.
The document is in the Page Layout view.
A blank space is inserted before the equal sign (=) in the formula.
The most likely cause of the issue is that a blank space is accidentally inserted before the equal sign. As a blank space is the first character, Excel is treating the expression as a text. While creating a formula, a user should make sure that equal sign (=) must be the first character in the cell. To resolve the issue, you will have to delete the space before the equal sign.
You work as an Office Assistant for BlueSoft Inc. All computers in the company have Microsoft Office 2007 installed. You are working in an Excel 2007 worksheet. You enter the following formula in a cell:
Which of the following types of cell references are used in the formula? Each correct answer represents a complete solution. Choose two.
Relative cell reference
Absolute cell reference
Answer: C, A
The absolute cell reference and the relative reference are used in the formula
=$D$14+E10. $D$14 is an absolute cell reference. E10 is the relative cell reference. Answer: D is incorrect. A circular reference occurs when a formula refers back to its own cell, either directly or indirectly. For example, if the formula in the cell A7 is
=SUM(A1:A7), a circular reference error message will be displayed. Answer: B is incorrect. There is no such reference as mixed reference.
You work as an Office Assistant for Blue Well Inc. You are creating a report in a worksheet in Excel. You have prepared a table as shown below:
You want to increase the height of each row in such a manner that all rows have the same height. Which of the following steps will you take to accomplish the task easily?
Select all rows in the table. Drag the border of one of the selected rows to the required height.
Select all rows in the table.
Click the Format option in the Cells group on the Home tab. Click Row Height. In the Row Height dialog box, provide the required value.
Select all rows in the table. Right-click on the selected rows and click the Row Height option. In the Row Height dialog box, provide the required value.
Select individual rows. Drag the border of rows to the required height.
According to the question to increase the height in such a manner that all rows have the same height. Furthermore, you have to choose the easiest way to accomplish the task. In order to fulfill the requirements of the question to take the following steps: Select all rows in the table. Drag the border of one of the selected rows to the required height. Excel provides this facility to quickly change the height of more than one row to the same height. Answer: B and C are incorrect. Although these steps will accomplish the task, it will involve more administrative burden. However, these steps will be appropriate in a situation where precise height is required. Answer: D is incorrect. Individually increasing the height of each row will require more effort than performing the same step with all the selected rows.
John prepares a document. He wants to create a multilevel list in it. Mark the icon that he should choose to create the multilevel list.
Multilevel list is a type of list format in which the list is prepared in levels.
State whether the following statement is true or false. "Section break divides a document in various sections so that different types of formatting can be applied to different pages."
Section break divides a document in various sections so that different types of formatting can be applied to different pages, e.g., if the document is typed in portrait orientation and
the image is to be inserted in landscape orientation then the section break is used.
You work as an Office Assistant for BlueSoft Inc. All computers in the company have Microsoft Office 2007 installed. You insert a picture in a Word 2007 document. You need to change the shape of the picture as shown in the image given below:
You select the picture and click on the Format tab. Mark the button on which you will click to accomplish the task.
You will click the Picture Shape button to change the shape of the picture.
After clicking the Picture Shape button, select the desired shape from the sub-menu that appears.
You work as an Office Assistant for BlueSoft Inc. All computers in the company have Microsoft Office 2007 installed. You are in the process of creating a presentation in PowerPoint 2007. You need to change the layout of a slide. Mark the tab that contains the option to accomplish the task.
You will click the Home tab to open it. The Home tab contains the option to change the layout of a slide. You can choose from the nine built-in slide layouts.
From the Home tab, click Layout, and then select the desired layout from the sub-menu that appears.
Read more Details »