DATABASE FUNDAMENTALS
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: -Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. With Office 365, you are able to download the application to your hard drive and will also have access to the online version.