SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 01 Nov 2017 My Price 10.00

Center cells across A1:E1. Font: Broadway, Size: 28

Hello

 

I need help with the following project attached. It is

EXCEL

 

Read through all of the instructions before starting.

 

You have conducted a survey and have asked people what their soda preferences are.  Follow the instructions below to complete the exam.

 

1.    Open the file X5-Data.xlsx and save the file as yourname_Q5.

2.    Rename Sheet 1 as Survey Results. Color the tab RED

3.    Center cells across A1:E1. Font: Broadway,  Size: 28

4.    Bold Titles in Row 3   Bold Totals in cell A16.

5.    Place a double line border around every cell in the table.

6.    Center all columns

7.    Calculate the following

a.    % 1st preference  [percent = 1st preference / total surveyed]

                                          i.    Be sure to set the format to % and 1 decimal point

b.    % 2nd preference[percent = 2ndpreference / total surveyed]

                                          i.    Be sure to set the format to % and 1 decimal point

8.    Use conditional formatting to highlight the drink, that is greater than or equal to 10% in the % 1st preference column.  DO NOT forget to put the % sign

a.    Format the cells RED with a bold white colored font

9.    Insert a clipart image to the right of the table.

10. Graph the 2nd preference % and their corresponding drink

a.    Use a column chart and ensure that there are data labels on the chart.

b.    Place the graph under the table.at row 18

11. Change Page Setup to Landscape

12. Adjust columns widths and row heights

13. Change the document properties to include

a.    Your Name

b.    Course number/ID

c.    Keywords (more than 2)

14. Save your changes, close the worksheet and submit it.

on Excel just by following what it says...

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 01 Nov 2017 07:11 AM My Price 10.00

-----------  ----------- Â-----------  -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e

Not Rated(0)