USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Basic Calculations
|
|
|
Use of Functions
|
|
|
Graphing and Data Management
|
|
|
Create Video Presentations
|
Detailed explanation-1: -As a spreadsheet program, Excel can store large amounts of data in workbooks that contain one or more worksheets. However, instead of serving as a database management system, such as Access, Excel is optimized for data analysis and calculation.
Detailed explanation-2: -The next time you have to make a presentation that has more data than you know what do with in MS-PPT, you might consider giving Excel a try. Excel can provide hyperlinks to different sheets.
Detailed explanation-3: -Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas.
Detailed explanation-4: -Thus autocomplete is a feature in MS-Excel that automatically enters the remaining characters, if the first few characters entered the match with an existing entry in that column.