(EXCEL) Create a user-defined function called Hexagon that takes one argument called side and returns the...

(EXCEL) Create a user-defined function called Hexagon that takes one argument called side and returns the area of a regular hexagon given the length of the side. Show that the function works in a worksheet by inserting the formula somewhere.

Solutions

Expert Solution

Step 1 : Open EXCEL and press ALT + F11 to get into visual basic editor.

Step 2 : Choose Insert -> Module in the editor.

Step 3 : Here we need to type the programming code

We take argument side as double type
and, area = (3 *sqrt(3) *a^2)/2 i.e area of regular hexagon
square root can be return in form of power 1/2.
Then we save the function and return to excel.

Step 4: Click the Insert Function button on the Formulas tab to display the Insert Function dialog box.

Then , click on the function you created , i.e AreaOfRegularHexagon

Step 5 : Then , input the length of the side

For example , side = 6 and click OK.

Finally , its done . This value appears on the sheet.

venereology answered 1 year ago

Next > < Previous

Related Solutions

Create a function called time2Greeting. It takes a time (in military time) and returns a string...

Create a function called time2Greeting. It takes a time (in military time) and returns a string with the right greeting. Good Morning 4AM to before noon. Good Afternoon Noon to before 5PM Good Evening from 5PM to 11PM What are you doing up at this hour? between 11 and 4AM For illegal values, say: That is not a valid time. Example: What is your name? John What time is it? 1315 Good afternoon, John. C++ programming

In C: Write a function definition called PhoneType that takes one character argument/parameter called phone and...

In C: Write a function definition called PhoneType that takes one character argument/parameter called phone and returns a double. When the variable argument phone contains the character a or A print the word Apple and return 1099.99 When phone contains anything else return a 0.0

Rewrite the grade program from Question 2.2 using a user-defined function called computegrade that takes a...

Rewrite the grade program from Question 2.2 using a user-defined function called computegrade that takes a score as its parameter and returns a grade as a string. (15 points) USING PYTHON LANGUAGE >= 0.9 A >= 0.8 B >= 0.7 C >= 0.6 D < 0.6 F Run the program repeatedly as shown below to test the various different values for input. Enter score: 0.95 A Enter score: perfect Bad score Enter score: 10.0 Bad score Enter score: 0.75 C...

Write a python function image compress() that takes one argument called filename, which is the name...

Write a python function image compress() that takes one argument called filename, which is the name of a file that contains a N × N (N-pixel by N-pixel) “grayscale bitmap image”. A “grayscale bitmap image” is an image of the following form where every pixel contains a grayscale color value between 0 − 255 (inclusive). Colour value 0 means that pixel should appear completely black and color value 255means completely white. Any other value in between stands for different shades...

In C++, create a function exchangesl that takes an argument of an array of integers (...

In C++, create a function exchangesl that takes an argument of an array of integers ( for C++ use implement void exchangesl(vector<int>& a) . Those integers need to be changed so that the smallest and largest values in the array are exchanged. Assume that there is at least one element, if the largest value occurs more than once then exchange the first instance, if the smallest value happens more than once then exchange the last instance.

In C++, create a function exchangesl that takes an argument of an array of integers (...

python practice! 1. Create a function that takes a user choice and one number as parameters...

python practice! 1. Create a function that takes a user choice and one number as parameters and returns the operation result. -Square: print the number square -Sqrt: print the square root of the number -Reverse: reverse the sign of the number (pos or neg) and print it Note: Detect invalid choices and throw an error message – Number can be anything. 2. Create a function that takes a user choice and two numbers (start and end) as parameters. For example,...

Write a MATLAB function named numberWords() that takes a whole number as an argument and returns...

Write a MATLAB function named numberWords() that takes a whole number as an argument and returns a string containing the number word for the whole numbers 0 - 999. For example: numberWords(234) would return 'two hundred thirty-four' If the input value is not a whole number between 0 - 999 then the function should return a string equivalent to 'ERROR'.

Create a function that takes a vector of vectors as an argument. Each inner vector has...

Create a function that takes a vector of vectors as an argument. Each inner vector has 2 elements. The first element is the numerator and the second element is the denominator. Return the sum of the fractions rounded to the nearest whole number. Examples: sum_fractions({{18, 13}, {4, 5}}) ➞ 2 sum_fractions({{36, 4}, {22, 60}}) ➞ 9 sum_fractions({{11, 2}, {3, 4}, {5, 4}, {21, 11}, {12, 6}}) ➞ 11 Notes Your result should be a number not string. Code in C++...

Write a function in C that takes one argument, an array of 50 elements. Your function...

Write a function in C that takes one argument, an array of 50 elements. Your function should print out the index and value of the smallest element in the array.

Subjects