DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Paint
|
|
|
Notepad
|
|
|
Excel
|
|
|
Word
|
Detailed explanation-1: -Excel does this by adding the group of cells and then dividing by the total number of cells. To calculate the average of a group of numbers, enter =AVERAGE(range) into the Excel formula bar, where range represents the group of cells for which you wish to formulate an average.
Detailed explanation-2: -Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns.
Detailed explanation-3: -The main uses of Excel include: Data entry. Data management. Accounting.
Detailed explanation-4: -On the Home tab, in the Number group, click the dialog box launcher next to Number (or just press CTRL+1).