Excel Basics
This is the bar at the top of Excel, where all of the buttons and menus can be found.
The ribbon
This function in Excel allows multiple literals or field values to be combined.
=concatenate()
This function in Excel would give you the ability to add a range of cells, then divide by the number of cells in a single step, giving you the mean.
=AVERAGE()
OOP stand for this.
Object Oriented Programming
Visual Basic is this kind of programming language.
Object oriented programming.
This is what the fill handle duplicates.
The pattern of the cell.
This Excel function gives you the specified number of characters at the beginning of a string value.
=LEFT()
This Excel function allows you to add the values of cells or a rage of cells.
=SUM()
In programming, a IDE is...
Integrated Development Environment
The IDE used for Visual Basic is ...
Visual Studio
All formulas and function must start with this.
=
Equal sign
This Excel function would return the specified number of characters from a specified starting point in a value.
=MID()
This Excel function would allow you to find the highest value in a range of cells.
=MAX()
All objects in OOP are this.
Container(s)
In VB buttons, forms, labels, text boxes, variables, and any other item found in the ToolBox are all...
Objects
Note**
Not all objects have a visual component, like variables and timers for example.
These are examples of...
(A:A)
(B1:D3)
a range (or ranges)
A range is a continuous set of cells in Excel.
This function in Excel is useful for finding a value in a range of cells.
=MATCH()
This function will test if a field only contains digits.
=ISNUMBER()
These are the basic functionality requirements of a program.
Input, Storage, Process, Output
Activating the code Me.Close() on the start-up form would do this, with the default VB settings.
Yes, it will close the form, but more importantly, it will EXIT THE PROGRAM entirely.
This integrated programming language can be used in Excel to create forms or extend functionality.
Visual Basic our Applications (VBA)
This Excel function returns the number of populated cells in a range, including those with text values.
=COUNTA()
This Excel function returns the number of populated cells in a range, whose values are numeric.
=COUNT()
These are the aspects of an object that we work with.
Properties, Events, Methods
This VB function allows for a pop-up window that displays text and has buttons automatically.
MSGBOX()