Instructions:

Create one *.xlsx file and submit on Canvas.

Follow the instructions closely.

Assignment:

Create a software program in Microsoft Excel using the approach shown in class. The program should convert an integer written on a given base of a number system to another base. The program should be written in two parts, as follows:

Part	Input	Output
Part 1	1. An integer, n, up to ten digits long, representing an integer written on the base b_in 2. An integer, b_in, ranging between {2, 10}, which represents the base of the number system on which n is written	The integer, expressing how n would appear when written on base 10
Part 2	1. An integer, n, up to ten digits long, representing an integer on base 10 2. An integer, b_out, ranging between {2, 10}, representing the base of the number system on which n will be expressed at the output	An integer, expressing n on base b_out

Rules:

1. The input fields for each part should be filled with yellow.

2. The output fields for each part should be filled with green and the text boldfaced.

3. For each part, if the integer and the base are incompatible, a message should appear next to the cell containing the base, saying Incorrect input and that cell should then be filled with red. In all other cases, they cell should be empty and not filled with any color.

4. The intermediate calculations should be shown using the procedure demonstrated in class.

5. The program should be tested using the following input values and the results should be reported. For reporting, create the table below in a suitable section of the worksheet and report the results in the last column by repeatedly running the program.

Test#	Converting int, n	From base, b_in	To base, b_out	The result is:
1	36025	7	3
2	53451263	8	5
3	329	10	7
4	147265371	8	7
5	36025	8	3
6	36025	7	7
7	147265371	7	4
8	53451263	7	10