Smart work with Power | Ceiling | Floor 🔢
This video describes three of the functions of Ms Excel which will enable you play with sheets full of numbers.
Excel Carols has accumulated these formulae which you might need as an Excel beginner, a data analyst, or and accountant. The POWER function returns a number raised to a given power. The POWER function is an alternative to the exponent operator (^). CEILING function rounds a number up to a given multiple. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. FLOOR function rounds a given number down to the nearest specified multiple. FLOOR works like the MROUND function, but FLOOR always rounds down.
Timestamp -
Entering Power formula - 00:30
Finding roots using power formula - 1:25
Entering Ceiling Formula - 2:30
Entering Floor Formula - 3:24
Please like and share the video if you find it useful. Excel Carols is always looking for scope of improvements, so please mention your feedback in the comments section below. In case, you want to learn about any other feature of Ms Excel, please mention that too in the comments section. Don't forget to subscribe to the channel and press the bell icon in order to get all the notifications.
Please follow the instagram handle in order to get all the updates : https://instagram.com/excelcarols?utm...
#ExcelCarols #MsExcel #ExcelShortcuts #KeyboardShortcuts #ExcelOptions #MsExcelOptions