What is linking of workbook in excel 2007?

Q. What is linking of workbook in excel 2007?Ans. When you link worksheets, you connect them together in such a way that onedepends on the other. The workbook that contains the link formulas (also knownas external reference formulas) is called the dependent workbook. The workbookthat contains the information used in the external reference formula is called the source workbo...

read more "What is linking of workbook in excel 2007?"

Explain How to enter data in multiple spreadsheets at the same time? (Excel-2007)

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 she...

read more "Explain How to enter data in multiple spreadsheets at the same time? (Excel-2007)"

How to use templates in Excel 2007?

Q. How to use templates in Excel 2007?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...

read more "How to use templates in Excel 2007?"

How to create a template in excel 2007?

Q. How to create a template in excel 2007?Ans. Steps to creating a template in Excel 2007 1.     Enter all of the necessary data.2.    Add or remove rows and columns as needed.3.    Create formulas, charts and other options.4.    Apply all formatting options. To save the template once all changes have been made to your spreadsheet:...

read more "How to create a template in excel 2007?"

What is a template in Excel 2007?

Q. What is a template in Excel 2007?Ans. A template in Excel is a spreadsheet file containing common data and formatting options that is used as a model for other spreadsheets. ·   Formatting can include font and layout changes, conditional formatting, color changes, and any other available options. Charts can added to the template file as can formulas, functions, look up tables,...

read more "What is a template in Excel 2007?"

Explain briefly the use of Find and Replace option in Excel 2007?

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. ...

read more "Explain briefly the use of Find and Replace option in Excel 2007?"

How to clear formatting of a range of cells in Excel 2007?

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 ta...

read more "How to clear formatting of a range of cells in Excel 2007?"

How to clear number formatting of a range of cells in Excel 2007?

Q. How to clear number formatting of a range of cells in Excel 2007?Ans. You can clear number formatting by applying General format appearing in number group of Home t...

read more "How to clear number formatting of a range of cells in Excel 2007?"

What is the use of Styles group on the home tab in Excel 2007?

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,...

read more "What is the use of Styles group on the home tab in Excel 2007?"

What is the use of number group on the home tab in Excel 2007?

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...

read more "What is the use of number group on the home tab in Excel 2007?"

What is the use of alignment group on the home tab in Excel 2007?

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....

read more "What is the use of alignment group on the home tab in Excel 2007?"

What is the use of Font group on the home tab in Excel 2007?

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 c...

read more "What is the use of Font group on the home tab in Excel 2007?"

Pointer Shapes (Excel-2007)

Pointer ShapesAs 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 ...

read more "Pointer Shapes (Excel-2007)"

Explain how to Check Your Spelling in Excel 2007?

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...

read more "Explain how to Check Your Spelling in Excel 2007?"