2. In the Documentation worksheet, enter your name and the date. 3. Create a new custom cell style..

2. In the Documentation worksheet, enter your name and the
date.

3. Create a new custom cell style named ETitle with the
following formatting:

• Font size of 18-point bold with the Olive Green, Accent 3,
Darker 50% theme color

• Text centered horizontally

• Single thick bottom border in Olive Green, Accent 3,
Darker 50% theme color

4. Apply the ETitle cell style to cell B4 in the last five
worksheets of the workbook.

Q630

5. In the Data worksheet, create a custom table style named
ETable with the following formatting:

• A header row with white text on a dark olive background
(use

2. In the Documentation worksheet, enter your name and the
date.

3. Create a new custom cell style named ETitle with the
following formatting:

• Font size of 18-point bold with the Olive Green, Accent 3,
Darker 50% theme color

• Text centered horizontally

• Single thick bottom border in Olive Green, Accent 3,
Darker 50% theme color

4. Apply the ETitle cell style to cell B4 in the last five
worksheets of the workbook.

Q630

5. In the Data worksheet, create a custom table style named
ETable with the following formatting:

• A header row with white text on a dark olive background
(use the theme color) and a double

bottom border

• Banded rows five stripes high—the first set of stripes has
a light green background fill (using

the theme colors); the next set of stripes has a white
background

6. Apply the ETable table style to the Element Data table in
the Data worksheet. Display the filter

buttons in the header row.

Q631

7. Switch to the Sub-Orbital Blocks worksheet, which
indicates to which of four electron

sub-orbital groups each element belongs: S, D, P, and F. The
defined name Sub_Orbital_Blocks_

Data references all of the data in the table and the entries
in the legend. Create the following

conditional formatting rules to highlight the values in this
range:

• Highlight cells that contain the “S” character with a
medium orange fill color (the tenth

theme color).

• Highlight cells that contain the “D” character with a
medium turquoise fill color (the ninth

theme color).

• Highlight cells that contain the “P” character with a
medium lavender fill color (the eighth

theme color).

• Highlight cells that contain the “F” character with a
medium olive green fill color (the seventh

theme color).

8. Hide the cell text of all values in the
Sub_Orbital_Blocks_Data table.

Q632

9. In the Melting Point worksheet, which contains the
melting points of the elements from the

periodic table, use the defined name Melting_Point to select
the data values in the table, and

then display the values from this table using a color scale
ranging from a light red theme color

for the lowest melting points to a dark red theme color for
the highest melting points.

10. Use a gradient fill in cell H9 to indicate the range of
colors used in the table.

11. In the Boiling Point worksheet, repeat Steps 9 and 10,
using the orange theme color to indicate

low to high boiling points.

Q633

12. In the Human Body worksheet, create a conditional
formatting rule that displays a green circle

with a white checkmark for all cells in the table and a
legend in place of the value 1. Use the

Human_Body_Data defined name to select the appropriate cells
in the worksheet.

13. In the Documentation worksheet, insert the Picture
Caption List SmartArt graphic (located in the

first row and third column of the List category). Add the text
labels Sub-Orbital Blocks, Melting

Point, Boiling Point, and Human Body to the four blocks in
the list.

Q634

14. Apply the Brick Scene SmartArt style to the SmartArt
graphic.

15. Insert the graphic image files Table1.jpg, Table2.jpg,
Table3.jpg, and Table4.jpg located

in the ExcelD _ Review folder included with your Data
Files into the four blocks from the

SmartArt graphic.

16. Apply the Slice theme to the workbook.

17. Modify the theme to use the Garamond font for text
headings and the Trebuchet MS font for

body text.

Q635

18. Change the themes to the Median theme colors.

19. Save the revised workbook theme as ETheme in the
location specified by your instructor.

20. Change the color of the four graphic images in the
SmartArt graphic on the Documentation

worksheet as follows:

• Recolor the Sub-Orbital Blocks picture with the Gold,
Accent color 4 Dark color.

• Recolor the Melting Point picture with the Ice Blue Accent
color 1 Dark color.

• Recolor the Boiling Point picture with the Orange Accent
color 2 Dark color.

• Recolor the Human Body picture with the Brown Text color 2
Dark color.

Q636

21. Save the workbook, and then close it.

Case Problem 1

Data Files needed for this Case Problem: Big.xlsx, Water.jpg

Big Wave Water Park Robert Tru is an operations manager at
Big Wave Water Park, a popular

indoor/outdoor water park located outside of Greenville,
South Carolina. He is preparing an annual

report that contains the daily attendance figures at the
park and compares the total annual attendance

to that of previous years. He wants you to format the
workbook. Complete the following:

1. Open the Big workbook located in the ExcelD _
Case1 folder included with your Data Files, and

then save the workbook as Big Wave in the location specified
by your instructor.

Q637

2. In the Documentation worksheet, enter your name and the
date.

3. In the 2016 Attendance worksheet, create a color scale
for the daily attendance figures in the

range C7:AG18 that displays the days of lowest attendance
with a light blue fill and the days of

highest attendance with a dark blue fill.

4. Add conditional formatting to the daily attendance
figures that highlights the day of highest

attendance with a bold yellow font and a solid yellow
border.

Q638

5. Add a color scale to the monthly totals in the range
AH7:AH18 that displays the months of

lowest attendance with a light green fill and the months of
highest attendance with a dark

green fill.

6. Add conditional formatting to the monthly attendance
figures that highlights the month of

highest attendance with a bold yellow font and a solid
yellow border.

7. In the Yearly Attendance worksheet, replace the values in
the change column with an icon set

that displays a green up arrow for years the attendance
increased compared to the previous year,

a yellow horizontal arrow when the attendance was unchanged,
and a red down arrow for years

the attendance decreased. Center the arrows in the cells
both horizontally and vertically. (Hint:

Edit the rule to show the icon only.)

Q639

8. Create a new table style named Attendance. The header row
should be displayed in a white font

on a dark blue background with a double bottom border. The
contents of the table should be

displayed in banded rows, starting with a light blue fill
color on the first row and alternating with

rows with a white fill color.

9. Apply the Attendance table style to the Yearly Attendance
table. Do not display filter buttons in

the header row of the table.

Q640

10. Insert the picture file Water.jpg located in the ExcelD _
Case1 folder included with

your Data Files next to the yearly attendance table. Make
the following edits to the picture:

• Change the picture size to 2.67 inches high by 4 inches
wide.

• Recolor the picture with the Blue, Accent color 1 Light
color.

• Apply the Reflected Rounded Rectangle picture style
(located in the first row and fifth column

of the Pictures Styles gallery) to the graphic.

Q641

11. Save the workbook, and then close it.

Case Problem 2

Data File needed for this Case Problem: FPS.xlsx

FPS Productions Linda Thomas owns FPS Productions, a video
production company located in

St. Charles, Missouri, that specializes in creating short
videos for local businesses and government

agencies. The company just received a contract to create a
promotional video for the St. Charles

Civic Center. The video must be ready for distribution in
four weeks. To keep the project on schedule,

Linda wants to create a Gantt chart (a graphical
representation of a project with each phase

represented

as a horizontal bar, with vertical lines often superimposed
to indicate the current date

to show the progress of the project versus time). Linda asks
you to create the Gantt chart. Complete

the following:

1. Open the FPS workbook located in the ExcelD _
Case2 folder included with your Data Files, and

then save the workbook as FPS Productions in the location
specified by your instructor.

Q642

2. In the Documentation worksheet, enter your name and the
date.

3. In the Production Schedule worksheet, you’ll create the
Gantt chart. Linda already entered the

start and stop dates of the eight tasks involved in
producing the video. In the range B7:B14, enter

formulas to calculate the percentage of each task that has been
completed given the task’s start

and stop dates and the current date in cell E5. (Hint: The
percentage equals the number of days

from the current date shown in cell E5 to the task’s start
date in column D divided by the number

of days allotted to complete each task.)

Q643

4. Replace the percentages in the range B7:B14 with the 5
Quarters icon set.

Modify the icon set to display the full circle when the
cell’s value is greater than or equal to 1;

display the three-quarter circle when the cell’s value is
from 0.75 up to 1; display the half circle

when the cell’s value is from 0.5 up to 0.75; display the
quarter circle when the cell’s value is

from 0.25 up to 0.5; and display an empty circle when the
cell’s value is less than 0.25.

View less »

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more