Page 239 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills

Notes Page Range: To print the entire page range, be sure that the All button is darkened.
Click on the little button next to All, if necessary.
Print All, Odd, or Even: Use the drop-down Print list at the bottom of the Print dialog
box to specify Odd Pages or Even Pages.
Excel offers a new way to view worksheets: Page break preview mode. To enter in this mode,
choose the View > > Page Break Preview command. The worksheet displays changes and
user can see exactly what will be printed and where the page breaks occur.

Advanced Find and Replace for Microsoft Excel

dvanced Find & Replace for Microsoft Excel is a time-saving add-in that makes
search through multiple Microsoft Excel spreadsheets and workbooks easy, fast
Aand comfortable.
With this handy add-in you can search in values, formulas, comments and hyperlinks in
all opened workbooks at a time. No need to click “Find Next” time and again. With
Advanced Find & Replace you see all found data and their locations at a glance. The add-
in reduces the number of clicks to one and the search time to a second. It works fast and
flawlessly in Microsoft Excel 2007-2000.

Questions:
1. Explain the advance Replacing.
2. Give the steps to find any word in Excel.

11.6 Summary

• Excel is windows-based spreadsheet created by microsoft corporation, US.
• Excel includes several advanced utilities like the facility to include other objective
within a spreadsheet and pivot table and form designing.

232 LOVELY PROFESSIONAL UNIVERSITY