Reference no: EM131296037
Instructions for the "Using Functions" sheet:
1 Review and understand the example. (Note: Always start a function with an = as the first character.)
2 Enter a column of 5 numbers, in cells B27 to B31 (Pick any numbers you wish.)
3 In cell B33, enter a formula to add the individual 5 cells one at a time.
4 In cell B34, enter a formula to calculate the SUM using the SUM function of cell range B27 through B31
5 In cell B35, enter a formula to calculate the average, but adding the 5 cells and dividing by 5.
6 In cell B36, enter a formula to calculate the AVERAGE using the AVERAGE function of cell range B27 through B31
7 Copy cells, B27 to B36 and paste them to B38 to B47.
8 Insert a row, between B39 and B40 and enter a new value in the cell.
9 Note how one sum value and one average value is now incorrect but the other is updated correctly.
10 Review the other functions in the example, in column J, such as MIN, MAX, COUNT and TODAY. MIN is the minimum value, MAX is the maximum value, COUNT is the number of items in the list and TODAY returns today's date.
11 In cells B50 through B52, enter the functions MIN, MAX, and COUNT using the cell range of your new list.
12 In cell B53, enter the function TODAY to show today's date.
13 In cell B54, enter another Excel function that you choose. You can press the Fx at the top of your spreadsheet to see what's available.
Note: If you see #### in a cell, your column is not wide enough. Be sure to make it larger before turning in your assignment.
Instructions for the "Cell Formatting" sheet:
1 Copy cell B10 to L10 then make it BOLD
2 Copy cell B11 to L11 then make it ITALIC
3 Copy cell B12 to L12 then make it UNDERLINED
4 Copy cell B13 to L13 then make the text BLUE
5 Copy cell B14 to L14 then make the background of the cell GREEN
6 Copy cell B15 to L15 then make the font 14 points
7 Copy cell B16 to L16 then choose the font Times New Roman
8 Type 12.34 in cell L17 and -45.56 in M17 then make for format Currency with negative values in RED
9 Type 123.4567 in cell L18 then reduce the number of decimals showing to 2
10 Type 5 in cell L19 and 90 in cell M19. Using conditional formatting on both have values greater than 10 appear with light red fill and dark red text.
Instructions for the "Graphs" sheet:
1 Create a table, like the one on the Cell Formatting sheet but with different items, with 3 rows and 3 columns. Put your table in cells A26 through D29.
2 Be sure to label the columns and rows and fill in the table with data.
3 Create three charts, like the examples on the Cell Formatting sheet. Be careful that the graphs are correct, including titles.
Instructions for the "Absolute and Relative" sheet:
1 Copy the table in cells A21:D26, into cells A34:D39.
2 Examine the formulas then copy cells F10:H10 to F35:H35
3 Update the tax amount, in H35 to 5%
4 Update cells C35:C39 to point at the new value using the absolute cell reference pointing to H35.
Instructions for the "Puppy Palace" sheet":
This sheet contains a number of errors.
The error might be that a formula is wrong, a word is spelled incorrectly, the chart is not pointing at the right data or something else. You need to find and correct at least 5 errors by making the changes in the Kitten Kingdom spreadsheet. List the errors you've corrected in cells B61:B65
Attachment:- excel20-20new20formulas20and20formatting200607.rar
|
How can knowing about another country help to solve
: How can knowing about another country or culture help to solve miscommunications? How can creative expressions be particularly useful in helping others to gain a new understanding and communicate more effectively?
|
|
Write a research paper about legalization of marijuana
: write an 5-7pages of research paper about legalization of marijuana.currently california proposition 64 has been voted yes. Please write it as pretending you are living in california.
|
|
Describe your distribution plan for a new product or service
: Decide a means of promotion for the product or service. Determine legal protection for a brand. Describe your distribution plan for a new product or service.
|
|
Does the decision made affect an individual or a community
: Is this short term or long term? Is this a short term or long term issue? Is this case of dispensing justice or dispensing mercy? Does the decision made affect an individual or a community?
|
|
Create three charts like the examples on the cell formatting
: Create a table, like the one on the Cell Formatting sheet but with different items, with 3 rows and 3 columns. Put your table in cells A26 through D29. Create three charts, like the examples on the Cell Formatting sheet. Be carefu..
|
|
Write essay indicate what you know about behavioral finance
: Please write a 2 pages reaction essay indicating what you have learnt, what surprised you and what else you would like to know about behavioral finance. The reaction essay will be based on the pdf and a youtube video.
|
|
Cultural change and project sponsorship
: Examine the primary reasons why project management causes a cultural change and the impact of that change on integrative information technology. Support your response with at least one (1) example of a cultural change that project management can c..
|
|
Medium-sized software development
: Suppose that you are currently employed as an Information Security Manager for a medium-sized software development and outsourcing services company.
|
|
What is a security policy
: 1) What is a security policy? what are the typical elements of a policy? 2) what are security controls and how do they relate to security architecture. Give a specific example.
|