Beginner
Exercise 1
In the first exercise, we will focus on variables and some calculations using arithmetic operators.
Expand | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
|
Exercise 2
In this exercise it is recommended to use the Record macro-feature available in VBA, although you don't necessarily have to.
Expand | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||
Make a macro that deletes all but the first sheet. The macro should not take into consideration if any sheets are written on. Some pictures showing before and after running the desired macro are presented below.
|
BibTeX Display Table |
---|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
|
Beginner
Exercise 1
In the first exercise, we will focus on variables and some calculations using arithmetic operators.
title | Exercise: Calculate BMI |
---|
width | 60 |
---|
Body mass index (BMI) is a value derived from the mass (weight) and height of a person. It is a convenient rule of thumb used to broadly categorize a person as underweight, normal weight, overweight, or obese.
The BMI is defined as
Your task is to create a sheet where you can calculate your BMI by entering your name, height and weight. The calculated BMI should be displayed by the click of a button. A draft to a finished solution is shown below.width | 40 |
---|
Commonly accepted BMI ranges are:
BMI [kg/m2]
title | Solution: BMI |
---|
Info |
---|
There are as always a number of ways to solve the task, so don't be alarmed if your answer differentiates from our solution. |
Further documentation on functions used:
Expand | ||
---|---|---|
| ||
|
Exercise 2
In this exercise it is recommended to use the Record macro-feature available in VBA, although you don't necessarily have to.
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Make a macro that deletes all but the first sheet. The macro should not take into consideration if any sheets are written on. Some pictures showing before and after running the desired macro are presented below.
|
BibTeX Display Table |
---|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
|
Beginner
Exercise 1
In the first exercise, we will focus on variables and some calculations using arithmetic operators.
title | Exercise: Calculate BMI |
---|
width | 60 |
---|
Body mass index (BMI) is a value derived from the mass (weight) and height of a person. It is a convenient rule of thumb used to broadly categorize a person as underweight, normal weight, overweight, or obese.
The BMI is defined as
Your task is to create a sheet where you can calculate your BMI by entering your name, height and weight. The calculated BMI should be displayed by the click of a button. A draft to a finished solution is shown below.width | 40 |
---|
Commonly accepted BMI ranges are:
BMI [kg/m2]
title | Solution: BMI |
---|
Info |
---|
There are as always a number of ways to solve the task, so don't be alarmed if your answer differentiates from our solution. |
Further documentation on functions used:
Expand | ||
---|---|---|
| ||
|
Exercise 2
In this exercise it is recommended to use the Record macro-feature available in VBA, although you don't necessarily have to.
Expand | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||
Make a macro that deletes all but the first sheet. The macro should not take into consideration if any sheets are written on. Some pictures showing before and after running the desired macro are presented below.
|
BibTeX Display Table |
---|