Page 240 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 11: Operations of MS Excel

• In the Excel the sheets can be worksheets, chart sheets, macro sheets, or custom dialog Notes
boxes.
• The Excel read text files, dBASE files, and HEML documents.
• Excel includes an enormous collection of built in function.

• In Excel holds bettors to issue commands when clicked.
• The default data sheet that opens when you first create a char includes four column
and three rows, formulating data sheet number and etc.

11.7 Keywords

Access Internet documents: save document as HTML files and even create advanced analytical
tools— Goal seeking, a powerful Solver feature, and the also used to quickly give a name
to the selected range or cell.
Analysis application window: minimize, restore, and close.
Built-in functions: Excel includes an enormous collection of built-in functions.
Buttons change: one or more assumptions and observe the effects on dependent formulas.

Control buttons, which can be used to modify the window.
Excel’s Built-in Functions: Excel provides a bewildering number of built-in worksheet
Functions that can be used in formulae. These include common functions such as SUM,
AVERAGE, and SQRT as well as functions designed for special purposes such as statistics or
engineering Excel’s on-line help is excellent and extremely detailed.

File compatibility: Excel can read files produced by other spreadsheet programs.
Formula bar: Information and formulas when entered into Excel, appear in this.
Formulae: Provide the real power while doing analysis and modeling—creating functioning
spreadsheet systems.
Great charts: Excel’s charting features enable the user to modify and augment a hyperlinks
directly in spreadsheet documents. Information between worksheets in different workbooks.

Integrated mapping: This feature lets the user display the data in terms of a Interactive help
While working in Excel, the user can get help on-screen.
Internet support: Excel includes a variety of new features that make it easy to. It can also
read text files, dBASE files, and HTML documents line.
Linking Workbooks: Linking is the process of using references to cells in external workbooks
to get data.
List management: This feature makes it easy to sort, filter, summarize, and manipulate data
stored in the worksheet.

Menu bar: One way of issuing Excel commands is through the Menu bar.
Multiple document interface: This capability of Excel makes it easy to transfer.
Multisheet files: Excel’s files (called workbooks) can consist of any number.
Name box: Displays the name of the active cell in the current workbook.

Operators in Excel: Excel lets you use a variety of operators in your formulas.
Pivot tables: Using this feature, the user can view the data in summarized table required
to create a custom template.

LOVELY PROFESSIONAL UNIVERSITY 233