辅导DICE ROLLING、辅导c++、讲解Pseudocode formulas、讲解Java，Python语言

Homework 1

Automating Business Processes

Module 1 – Lesson 1 & Lesson 2

EXERCISE 1 - DICE ROLLING

Reproduce this Lucky 7 Dice Rolling Worksheet in a sheet called “Dice Rolling” in a Workbook named LastNameABPM1L1L2DiceRolling.xlsx.

1.What are the Outputs?

2.What are the Inputs?

3.Planning the Logic Flow

Here are the 6 different Die Layouts:

First, list the numbers (1-6) Second, create “Pseudocode formulas” for displaying a dot

that have dots in each(This just means write in words the conditions to display a dot)

of the 9 cells

2,3,4,

5,6If a 2,3,4,5 or 6 then show a dot

(or if between 2 and 6 then show a dot)

4.Create the Excel worksheet to roll these two die using the following hints:

HINTS:

Cells E5 and I5 contain a "hidden" formula that randomly generates the roll of the die (number between 1 and 6).  It is "hidden" by changing the font color to white

Wingdings font, 30 point, lowercase L (l) will display a solid circle

Cell D1 contains the formula: =IF(AND(E5>=2,E5<=6),"l","")

Cell B2 should say "WINNER" if dice total is 7 and "TRY AGAIN" otherwise

Password Protect with "DiceRoll" so the user will not mess up the formulas. (First “Lock” cells under Home, Format.  Then Review, Protect Sheet, password: DiceRoll)

EXERCISE 2 – Excel functions

Open Homework1SalesData and complete the highlighted tabs.

To do this, you will need to utilize functions learned in class as well as creating 2 pivot tables.

Tabs that should be completed:

Sales Summary Solution

Item Pivot Table  Create an Items Pivot Table to help fill in the Sales Summary Solution tab

Month Pivot Table  Create a Month Pivot Table to help fill in the Sales Summary Solution tab

EXERCISE 3 – VB Code

Create a workbook named "LastNamesABPM1L1L2Functions" and save it as macro-enabled!! Also save often!!

1)Name a sheet Full Name.

a)Create a function called "FullName".

b)The inputs should be first name, last name.

c)The output should join the names and separate them with a space.

d)Test the function twice in this worksheet.

2)Name a sheet Text Numbers.

a)Create a function called “TextNumbers.”

b)This function should allow the user to enter a single parameter that is a number.  If the number is not 1, 2, 3, or 4, it should return “Invalid Entry.”  If the number is in the correct range, it should return the text label for the number.  For example, 1 should return “one” and 2 should return “two”, etc.

c)Test the function for the numbers 1, 2, 3, 4, 5, and 0 in this worksheet.