Page: 1
/ 5
Total 61 questions
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.
Answer : 
Explanation:
In order to accomplish the task, select the Inspect Document option. The Inspect
Document option is a feature of Excel 2007 to prepare a document before sharing it with others. A workbook may contain several hidden information that can reveal details about a user or his organization. Hidden information may include information that you deliberately designate as hidden. A user might not want to share such details as user comments, document properties, etc. The Inspect Document ensures that such hidden information is deleted from a workbook before the workbook is shared.
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:
Answer : 
Explanation:
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.
Reference. Microsoft Excel 2007 Help, Contents: "Add or delete WordArt"
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:
The list includes Zones and Months columns. You want to summarize sales data on the basis of these columns. Which of the following steps will you take to accomplish the task with least administrative burden?
- A. Select the list. Click the Create from Selection option in the Defined Names group on the Formulas tab.
- B. Click the Consolidate option in the Data Tools group on the Data tab.
- C. Add subtotal rows manually at the required places.
- D. Use the outline feature.
Answer : D
Explanation:
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
Zones.
An outline is used to quickly display summary rows or columns, or to reveal the detail data for each group. Users can create an outline of rows, an outline of columns, or an outline of both rows and columns.
Answer option C is incorrect. Although it will accomplish the task, it will involve a lot of administrative burden.
Answer option B is incorrect. The Consolidate option is used to combine values from multiple range to a new range.
Answer option A is incorrect. These steps will only define the name of the list.
Reference. Microsoft Excel 2007 Help, Contents: "Outline a list of data in a worksheet"
You work as a Sales Manager for Tech Perfect Inc. You have created a report in Excel
2007 as shown below:
You saved the workbook with the name Sales Report. You want to share the workbook so that your colleagues can insert comment or edit data in the workbook. When you try to enable sharing, the Excel disallows you. What is the most likely cause?
- A. There is an error in a formula used in the workbook.
- B. The workbook contains macros.
- C. The data is in the form of data table.
- D. The workbook is not protected.
Answer : C
Explanation:
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.
Answer options D, A, and B are incorrect. Any of these conditions will not prevent a workbook from being shared.
Reference. Microsoft Excel 2007 Help, Contents: "Use a shared workbook to collaborate"
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.
Answer : 
Explanation:
You can accomplish the task by using the data validation feature of MS Excel 2007. Data validation is a feature provided by MS Excel 2007. It helps users in maintaining the integrity of data in a worksheet. Data validation can be configured by clicking the Data Validation option in the Data Tools group on the Data tab.
In many worksheets created, different users enter data on it to get the desired calculations and results. The owner of the worksheet must ensure valid data entry for maintaining integrity of data. He can restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered. The data validation feature provides immediate help to instruct users and displays 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?
- A. Normal
- B. Page Layout
- C. Full Screen
- D. Page Break Preview
Answer : B
Explanation:
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.
Answer option A is incorrect. The default view of the Excel is the Normal view. Entering data in a document is done in this view.
Answer option D is incorrect. The Page Break Preview view is used to view a preview of where pages will break when the document is printed. In this view, you can also set the breaks by dragging break lines.
Answer option C is incorrect. The Full Screen view changes a worksheet view to the full screen mode. In this mode all tabs, ribbons, etc., get hidden and only worksheet is displayed in the screen of a computer.
Reference: Microsoft Excel 2007 Help, Contents: "Use Page Layout view to fine-tune pages before printing"
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?
- A. Select all rows in the table. Drag the border of one of the selected rows to the required height.
- B. Select individual rows. Drag the border of rows to the required height.
- C. 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.
- D. 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.
Answer : A
Explanation:
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.
As soon as she clicks on the view menu, all toolbars and menus disappear. She wants to restore her worksheet status back to the Normal view quickly in minimum steps.
Which of the following steps will she take to accomplish the task?
- A. Click the Restore Down button in the Control menu.
- B. Use the keyboard shortcut Alt + W + P.
- C. Click the Minimize button on the Control menu, and then click the minimized Excel workbook in the task bar.
- D. Use the keyboard shortcut Alt + W + L.
Answer : A
Explanation:
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.
This will quickly restore the view status of the Excel sheet to its previous view.
Answer options B and D are incorrect. The keyboard shortcuts for changing views will not work in the full screen view of the worksheet.
Answer option C is incorrect. Although these steps will accomplish the task, using the
Restore Down button is more efficient option.
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?
- A. Use the Wrap text option.
- B. Use the Shrink to fit option.
- C. Use the Justify alignment.
- D. Use the Auto Selection command.
Answer : A
Explanation:
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:
1.Select the cell that has to be formatted using the Wrap text option.
2.Choose Format > Cells from the menu bar.
3.The Format Cells dialog box will open. Click the Alignment tab, and then select the Wrap text check box under the Text control.
Answer option B is incorrect. The Shrink to fit option under the Text control reduces the size of text font to fit the text within the cell.
Answer option D is incorrect. The AutoFit Selection command in Microsoft Excel is used to fit the cell contents in a column by changing the column width. This command adjusts the column width, which is actually needed to display the contents in the selected cells. If changes are made in the cell contents, the AutoFit Selection command has to be used again to fit the cell contents.
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:
All settings are set to default. You take the following steps:
Select the A9 cell.
Type 'Martha' in the cell.
Press the Tab key.
What will happen after you have taken the steps?
- A. The cell range A9:E9 will be added to the existing table.
- B. The row 9 will be added to the existing rows of the table.
- C. The cell A9 will be added to the existing column of the table.
- D. Nothing will happen; you will have to expand the table manually to include the new row of data.
Answer : A
Explanation:
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.
Answer option D is incorrect. The question clearly states that the settings are set to default.
By default, auto expansion is enabled in Excel 2007. If you have disabled the Table Auto
Expansion feature, only then you will have to expand the table manually.
Reference. Microsoft Excel 2007 Help, Contents: "Format an Excel table"
You work as a Sales Manager for Tech Perfect Inc. You have to create a report in Excel
2007 in the following format:
What is the most likely cause?
- A. Show Formula is enabled in the workbook.
- B. Manual Calculation is enabled in the workbook.
- C. A blank space is inserted before the equal sign (=) in the formula.
- D. The document is in the Page Layout view.
Answer : C
Explanation:
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?
- A. Use Page Layout > Page Setup > Background option to insert the picture
- B. Use Insert > Text > Headers & Footers
- C. Use Page Layout > Page Setup > Print Titles
- D. Use Insert > Illustrations > Picture to insert the picture
Answer : A
Explanation:
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.
Fact what is a sheet background? Hide
A sheet background is a feature of Microsoft Office Excel 2007. It enables a user to use a picture as a sheet background. It is used for display purposes only. A sheet background is not printed, and it is not retained in an individual worksheet or in an item that is saved as a
Web page. Use the Page Layout tab to configure the sheet background.
Note. A sheet background cannot be used as a watermark for printing purposes.
Answer option C is incorrect. Print Titles option is used to configure printing options of a worksheet.
Answer option B is incorrect. Headers & Footers can be used to insert background picture for printing purposes as a watermark.
Answer option D is incorrect. Through the Picture option in Illustrations, pictures can be inserted into the sheet. But this will not be configured as background image.
Reference. Windows Help, Contents: "Add or remove a sheet background"
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.
- A. Click the Translation option in the Editing group of the Home tab.
- B. Click the Thesaurus option in the Proofing group of the Review tab.
- C. Click the Translation option in the Proofing group of the Review tab.
- D. Click the Thesaurus option in the Proofing group of the Review tab.
- E. Click the Research option in the Editing group of the Home tab.
- F. Click the Research option in the Proofing group of the Review tab.
Answer : C,F
Explanation:
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.
Click the Research option in the Proofing group of the Review tab.
This will open a Research window. Provide the required entry to translate.
Excel provides machine translation facility. This is helpful for conveying the basic subject matter of the content and for confirming whether the content is relevant. However, machine translation may not preserve the full meaning and tone of the text.
Answer options E and A are incorrect. There is no such option available in the Editing group on the Home tab. Answer options D and B are incorrect. Translation cannot be performed through the Thesaurus option.
Reference. Microsoft Excel 2007 Help, Contents: "Translate text"
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?
- A. This facility is not available in excel.
- B. Digital certificate
- C. Both digital signature and digital certificate
- D. Digital signature
Answer : D
Explanation:
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:
You want to create a chart that will help you to compare the sales target achieved by each sales manager in each month. Which of the following charts will you insert to accomplish the task?
- A. Pie
- B. Line
- C. Bar
- D. Column
Answer : D
Explanation:
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.
Answer option A is incorrect. Excel provides a pie chart facility to display data that is arranged in one column or row on a worksheet. Pie charts display the size of items in one data series, proportional to the sum of the items.
The items in the pie chart are displayed as a percentage of the whole pie.
Answer option B is incorrect. Excel provides a column chart facility to display data that is arranged in columns or rows on a worksheet. Line charts are used to display continuous data over time, set against a common scale. In a line chart, category data is distributed along the horizontal axis, and all value data is distributed along the vertical axis. Line charts are ideal for showing trends in data at equal intervals.
A line chart should be used where category labels are text, and are representing evenly spaced values such as months, quarters, or years.
Answer option C is incorrect. A bar chart is a feature provided in excel to graphically display data that is arranged in columns or rows on a worksheet. Bar charts are used for illustrating comparisons among individual items.
Bar charts are useful where axis labels are long.
Reference. Microsoft Excel 2007 Help, Contents: "Available Chart Types"