You work as a Sales Manager for Net Perfect Inc. You are preparing yearly sales report using Excel 2007. You collaborated this document with your team members so that they can also work on it. After finalization of the document, you have to share it with your sales team over the intranet. Before sharing it you want to ensure that the workbook does not contain items such as comments or ink annotations. You click Office button > Prepare.
Choose the required option to accomplish the task.
You work as an Office Assistant for Rainbow Inc. You are creating a report in a workbook in Excel 2007. You want to add a title to a worksheet in decorative text as shown in the image below:
You will have to choose the WordArt option to accomplish the task. WordArt is a collection of text styles provided by 2007 Microsoft Office system to create decorative effects, such as shadowed or mirrored (reflected) text for the text provided by a user. In order to insert a
WordArt text in an office document, take the following steps:
1. Click the WordArt option in the Text group on the Insert tab.
You work as a Sales Manager for Peach Tree Inc. You have created a report in a workbook in Excel 2007. The segment of a worksheet in the report is shown in the image given below:
Answer : D
According to the question, you have to summarize sales data on the basis of Zones and
Months columns. In order to accomplish the task, you will have to use the outline feature.
An outline in Excel refers to an arrangement of data where a list of data is grouped and summarized. Excel allows an outline of up to eight levels. The image given below displays a three-level outline data list. The list is grouped by Months and then it is again grouped by
You work as a Sales Manager for Tech Perfect Inc. You have created a report in Excel
2007 as shown below:
Answer : C
A workbook containing a data table cannot be shared. To share such a workbook, it is required to convert the table to a regular cell range. For this, take the following steps:
1. Click the table, and then click the Convert to Range option in the Tools group on the
Design tab. This will display a message box.
You work as an Office Assistant for Media World Inc. You are creating a report format worksheet in Excel 2007. This report will be used by many users over the network. You want to restrict the users from entering a certain range of dates, limiting their choices by using a list, and ensure that they enter only positive whole numbers in the report.
Mark the tool in the following tool bar that can provide immediate help to instruct users and clear messages when invalid data is entered.
You work as an Office Assistant for Tech Perfect Inc. You have created a report in a worksheet in Excel. Before printing the report, you want to see where pages begin and end in the printed format. You also want to view the placement of headers and footers on the page. Which of the following views will you choose to accomplish the task?
Answer : B
In order to accomplish the task, you will have to choose the Page Layout view. It displays a document as it will appear on the printed page.
The Page Layout view is used to see where pages begin and end. It can also be used to view any headers or footers on the page. In order to change the worksheet view to the
Page Layout view, click the Page Layout option in the Workbook Views group of the View tab.
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:
Answer : A
According to the question, you are required 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, you will have 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 options D 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 option B is incorrect. Individually increasing the height of each row will require more effort than performing the same step with all the selected rows.
Reference. Microsoft Excel 2007 Help, Contents: "Change the column width and row height"
Martha works as a Sales Manager for Tech Info Inc. She is creating a sales report on Excel
2007. After preparing the sales report she clicks on the Full Screen view menu.
Answer : A
In order to accomplish the task, Martha should click the Restore down button in the Control menu in the top-right corner of the sheet.
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?
Answer : A
The Wrap text option is used to adjust text into the next line in the same cell. This option automatically wraps the text to the next line.
Take the following steps to use the Wrap text option:
You have formatted the cell range A3:E8 in Excel 2007 as the data table. A fragment of the worksheet is shown in the image below:
Answer : A
When you add data to the row immediately below the last row in the table or a cell to the column immediately to the right of the table, the data is added to the table automatically, and the table expands itself by default. In this case, the cell range A9-E9 will be added to the existing table, and the data table will expand itself. After you enter the value and move out of the cell, the AutoCorrect Options tag will appear. You can click the Undo Table
AutoExpansion option if you wish to exclude the cells from the table.
Answer options B and C are incorrect. The whole row or individual cell is never added to the table. Only the cells that span the width of the table will be added to the table during the auto expansion of the table.
You work as a Sales Manager for Tech Perfect Inc. You have to create a report in Excel
2007 in the following format:
Answer : C
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.
Answer option A is incorrect. Although enabling Show Formula will display the exact result, as shown according to the image given in the question, Excel will not treat it as a text. The question clearly specifies that Excel is treating the formula as a text.
Answer option D is incorrect. The Page Layout view will not have any affect on the display of a cell containing the formula.
Answer option B is incorrect. Enabling Manual Calculation will not affect the display or resultant value of the formula.
Reference. Microsoft Excel 2007 Help, Contents: "Create or delete a formula"
Martha works as an Office Assistant for Tech Perfect Inc. She uses Excel 2007 for working on a report. She wants to add a picture as a background in her Excel worksheet. She does not want that picture to be printed while printing.
Which of the following steps will she take to accomplish the task?
Answer : A
In order to put a picture as a sheet background, Martha will click the Background option in the Page Setup group, on the Page Layout tab.
You work as a Sales Manager for Media Perfect Inc. You have received an Excel workbook from a branch office that is located at France. Some of the entries in a cell are written in
French. You open a file in Excel 2007. You are curious to know the meaning of some of the entries. Which of the following options can you use to accomplish the task?
Each correct answer represents a complete solution. Choose two.
Answer : C,F
According to the question, you want to know the meaning of some of the entries written in
French in an Excel workbook. For this, you are required to use the translation feature available in Excel 2007. In order to accomplish the task, you can choose any of the following two options:
Click the Translation option in the Proofing group of the Review tab.
Sam works as an Editor for Sam Tech Inc. He has to send an article that contains some important data tables for publishing. He creates those tables in Microsoft Excel. He wants to assure that the content has not been changed or tampered with. Which of the following features will he use to accomplish the task?
Answer : D
A digital signature is used to authenticate digital information such as documents, e-mail messages, and macros. Digital signatures are used to provide integrity, i.e. to assure that the data is not tampered or changed.
Answer option B is incorrect. Digital certificates vouches for authenticity while attaching a file, creating a macro, provide secure encryption or supplies a verifiable signature. To digitally sign a macro project, digital certificates should be installed.
Answer option C is incorrect. Using both features (digital signature and digital certificate) is not required in this scenario.
Answer option A is incorrect. This facility is available in Excel and is applicable.
You work as a Director (Sales) for Media Perfect Inc. You have created the first quarter sales report that includes data of sales target achieved by all your sales managers. The worksheet is shown below:
Answer : D
In order to accomplish the task, you will have to insert a column chart in the worksheet.
Excel provides column chart facility to display data that is arranged in columns or rows on a worksheet. In column charts, categories are organized along the horizontal axis and values along the vertical axis.
Column charts are used for showing data changes over a period of time or for illustrating comparisons among items.