Answer:
Visual Basic for Applications runs as an internal programming language in Microsoft Office applications such as Access, Excel, PowerPoint, Publisher, Word, and Visio. VBA allows users to customize beyond what is normally available with MS Office host applications by manipulating graphical-user-interface (GUI) features such as toolbars and menus, dialogue boxes, and forms. You may use VBA to create user-defined functions (UDFs), access Windows application programming interfaces (APIs), and automate specific computer processes and calculations. Macros can automate just about any task—like generating customized charts and reports, and performing word- and data-processing functions. Programmers,like replicating large pieces of code, merging existing program functions, and designing specific languages. VBA can also work in non-Microsoft settings by using a technology called "COM interface," which allows commands to interact across computer boundaries. Many firms have implemented VBA within their own applications, both proprietary and commercial, including AutoCAD, ArcGIS, CATIA, Corel, raw, and SolidWorks.
<em>(Hope this helps/makes sense!)</em>
The answers true hope this helped :)
Outlook is used for mainly emails. It also keeps track of your calendar, has contact and tasks.
Answer:
In cell B6, formula =INDEX(INDIRECT($B$3),A6)
CallCenter Worksheet Details:
The image of the CallCenter Report worksheet for reference to the question asked is attached below.
Explanation:
Firtsly, an absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. To do this,we put a $ dollar sign ( =A$1,) before the row coordinate to lock only the row.
A relative reference in Excel is a cell address without the $ sign in the row and column coordinates example A1.
Having known what absolute and relative reference are, we wlil write the below formula in cell B6 that will later be copied to cell B9:
: =INDEX(INDIRECT($B$3),A6)
