FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you apply a function to specific data, you eliminate the time involved in manually constructing a formula and help to ensure the accuracy of the results.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -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-2: -The TRIM function is used to “normalize” all spacing. TRIM automatically strips space at the start and end of a given string and leaves just one space between all words inside the string. It takes care of extra spaces caused by empty cells.

Detailed explanation-3: -The accuracy KPI is simply calculated as 1 – % Total Error (MAE, RMSE etc.). For example, if your MAE is 20%, then you have a 20% error rate and 80% forecast accuracy.

There is 1 question to complete.
Previous
Next