Gathering data is similar to gathering ingredients for a recipe. If you want to create an excellent dish, you’ll want to start with the right ingredients, which means you’ll have to make a bunch of decisions beforehand.

After you’ve decided what type of survey you’re going to use, you need to figure out what kinds of questions to include. The type of question determines what level of data can be collected, which in turn affects what you can do with the data later on. For example, if you ask about age and you record it as a number (e.g., 21, 34, 42), you’ll have numeric data that you can perform mathematical operations on. If you instead ask for a person’s age group (e.g., 18-24, 25-34, 35-44), you’ll have ordered categorical data: you’ll be able to count how many people were in each group, but you won’t be able to find the mean age of your respondents. Before you create your survey, it’s important to consider how you want to analyze your final results so you can pick question types that will give you the right kind of data for those analyses.

There are two ways to refer to other cells in Formulas, “Absolute” and “Relative” references

Excel allows you to enter ‘Logical’ operators in cells.

 

These are listed below

 

            IF( formula1, formula2, formula3 )

 

            AND( formula1, formula 2 )

 

            OR( formula1, formula 2 )

 

There are a few preliminary steps that must be taken before you can start writing VBA macros.

 

For you must add the “Developer” option to the Excel main menu. This option is not turned on by default.

Most macros will have at least one parameter. This is the list of names after the word ‘Function’ and the name of the function.

Most Watch

Last Comments