USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
flash fill
|
|
|
add multiple rows
|
|
|
program in non VBA
|
|
|
use currencys
|
Detailed explanation-1: -VBA is used to write programs for the Windows operating system and runs as an internal programming language in Microsoft Office (MS Office, Office) applications such as Access, Excel, PowerPoint, Publisher, Word, and Visio.
Detailed explanation-2: -VBA does not adjust in the way that formulae do when you move data from one worksheet to another, insert a column, delete rows, etc.
Detailed explanation-3: -Microsoft currently limits the amount of VBA controls to 1207 per project. An iFIX picture is considered a VBA project.
Detailed explanation-4: -Excel was not designed for creating forms and to get a usable form that collects and stores data is prone to issues and simply not worth the effort. You’re better off using a tool built for designing forms and handling data in a sensible way.