Q. Explain How to enter data in multiple spreadsheets at the same time?
Ans.In order to enter data in multiple sheets, an easier way to do this is to use the CTRL key: Start Excel. A new, blank workbook appears. Press and hold the CTRL key, and then click Sheet1, Sheet2, and Sheet3. Click in cell A1 in Sheet1, and then type data.This data will appear in each sheet.
Ans.Excel 2007 provides predesigned templates, worksheets for common uses. You can modify the templates to fit your needs. You can use the templates automatically installed with Excel 2007, or you can download free templates from the Microsoft Office Online Web site.
The following templates are automatically installed when you start using Excel 2007: Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, and Time Card. Many additional templates are available for downloading.
Using the installed templates
Steps to use one of the templates that comes installed with Excel 2007:
1.Click the Office button and then click New.
The New Workbookdialogbox appears.
2.Click Installed Templates under Templates in the pane on the left.
The middle pane displays thumbnails for each of the installed templates. A preview of the selected thumbnail appears in a preview pane on the right.
You can select an installed template to generate a new workbook.
3.Select the desired template from the middle pane and click Create.
Excel closes the dialog box and opens the selected template.
4.Customize the template as needed.
5.Save the file with a new name.
Downloading templates
If you have Internet access, you can easily check out and download any of the templates offered by Microsoft directly from the New Workbook dialog box.
Follow these steps to download a template from Microsoft Office Online:
1.Click the Office button and then click New.
2.Click the category of the template you want to download under Microsoft Office Online in the Navigation pane on the left.
The middle pane displays thumbnails for each of the items in that category. In some cases, you may need to select a subcategory in the middle pane before you see the thumbnails. A preview of the selected thumbnail appears in a preview pane on the right.
3.Select the thumbnail image for the template you want to download and then click the Download button.
The Download button appears near the bottom-right corner of the New Workbook dialog box.
4.If you see the Microsoft Office Genuine Advantage dialog box, click the Continue button.
This step verifies that you have a genuine copy of Microsoft Office. After Excel 2007 finishes downloading the template, the template file opens automatically.
Q. Explain briefly the use of Find and Replace option in Excel 2007?
Ans.The find and replace feature in excel lets you locate a specific text or number entry in a workbook, and then replace with another entry. You can also use find and replace to locate a specific format with in a cell and then replace it with another format.
Q. How to clear formatting of a range of cells in Excel 2007?
Ans. You can clear the formatting of range of cells without changing the contents of a cell using clear formats command from editing group of Home tab.
Q. What is the use of Styles group on the home tab in Excel 2007?
Ans. Styles group provides quick way of applying several formats at once. A style is a group of predefined formats such as font, color and borders. There are several cell styles and you can create your own styles.
You can format a range of cells as tables. You can use conditional formatting to highlight interesting cells, emphasize unusual values using data bars, color scales and icon sets.
Q. What is the use of number group on the home tab in Excel 2007?
Ans. Number group in the home tab can be used to format numbers in a cell or group of cells. Excel provides variety of number formats such as general format, number format, currency format, accounting format etc. You can format the number by increasing or decreasing number of decimal places by using increase decimal and decrease decimal button. % button Changes the formatting to Percentage. You can also insert comma (, ) to Change the formatting to include commas and two decimal places to a number cell. Tools in the number group do not provide the entire number format available. These are available in format cells dialog box, which can be accessed using launcher in this group.
Q. What is the use of alignment group on the home tab in Excel 2007?
Ans. The alignment group offers numerous buttons to change the cell alignment. The icon on each button gives a visual description of how the contents will look. You can use this group to align the contents to the left, right or center. You can vertically align the cell contents along the top, middle and bottom of the cell. By default excel aligns cells along the bottom of the cell. You can increase the margin between the border and the text in the cell(INDENT) using indent button. You can wrap long text in a cell to multiple lines so that the contents of the cell are fully displayed. You can change the orientation of text or number in a cell. You can merge cells( i.e you can create on cell out of many).
Q. What is the use of Font group on the home tab in Excel 2007?
Ans. The Font group in a home tab contains tools to format the contents of any cell, which may contain text, numbers or dates. Here you can change Font face, Font size and text enhancements such as bold face, italics and underline. You can also select borders, change font color or fill colors to the background of selected cell.
As with other Microsoft programs, the pointer often changes its shape as you work in Excel. Each pointer shape indicates a different mode of operation. This document provides a table describing the various pointer shapes you may see while working in Excel 2007/2008.
Shape
Context
Action
The default pointer shape; appears in most Excel workspace contexts
Moves cell pointer or selects a range of cells
Appears when the pointer is on the border of a window
Adjusts window size
Appears when the pointer is between a row or column divider
Adjusts height and width of rows and columns
Appears when you are editing cell contents
Provides a text insertion point
Appears when the pointer is on a column or row heading
Selects columns or rows
Windows:
Macintosh:
Appears when the pointer is placed over a cell border, graphic, or other object
Moves cells, graphics, or objects
Appears when the pointer is on the "fill corner" of a cell or cell range
AutoFills other cells with similar information
Windows only:
Appears when mouse is placed over the Ribbon
The standard Microsoft Windows pointer; selects Ribbon and menu options
Q. Explain how to Check Your Spelling in Excel 2007?
Ans.Microsoft Office Excel 2007 includes a built-in spell checker that can catch and get rid of spelling errors and typos in your worksheets. Excel 2007's spell checker normally looks for misspellings only in the current worksheet. If you have a multiple-sheet workbook, you can select the sheets you want to check before you start the spell checker. Also, you can check the spelling of just a particular group of entries by selecting the cells first.
To check the spelling in a worksheet, follow these steps:
1.Click the Spelling commandbutton in the Proofing group of the Review tab (or press F7).
Excel begins checking the spelling of text entries in the worksheet. When the program comes across an unknown word, it displays the Spelling dialogbox.
Use the Spelling `dialogbox in Excel 2007 to correct typos in a worksheet.
Excel suggests replacements for the unknown word shown in the Not in Dictionary text box with a likely replacement in the Suggestions list box. If that replacement is incorrect, you can scroll through the Suggestions list and click the correct replacement.
1.Select one or more of the following dialogbox options:
·Ignore Once or Ignore All: When Excel’s spell check comes across a word its dictionary finds suspicious but you know is viable, click the Ignore Once button. If you don’t want the spell checker to query you about this word again, click Ignore All.
·Add to Dictionary: Click this button to add the unknown word — such as your name — to a custom dictionary so that Excel won’t flag it again.
·Change: Click this button to replace the word listed in the Not in Dictionary text box with the selected word in the Suggestions list box.
·Change All: Click this button to change all occurrences of this misspelled word in the worksheet to the selected word in the Suggestions list box.
·AutoCorrect: Click this button to have Excel automatically correct this spelling error with the selected suggestion in the Suggestions list box (by adding the misspelling and suggestion to the AutoCorrect dialogbox).
Click OK when the spell check is complete.
If you began the spell check in a cell other than A1, you may see a dialogbox asking if you want to continue checking at the beginning of the sheet. Click Yes or No to continue or end the spell check.
The Excel spell checker not only flags words not found in its built-in or custom dictionary, but also flags occurrences of double words in a cell entry (such as total total) and words with unusual capitalization (such as NEW YORK instead of New York). By default, the spell checker ignores numbers and Internet addresses. If you want it to ignore all words in uppercase letters as well, click the Options button at the bottom of the Spelling dialogbox, and then select the Ignore Words in UPPERCASE check box before clicking OK.
