Excel and PowerPoint Production Exam Submission -Weber Students

Insert column
Theme - Celestial
Merge & Center title and subtitle
Fill color - Purple, Accent 1, Lighter 80%
Font color - Purple, Accent 1, Darker 50%
Column headings – Heading 2; two lines; center and middle align
Currency, no decimals
AutoFit column width
Conditional formatting – Color scales for Italy
Header

Category of Cost in legend
Place on Y-axis
Title
No gridlines
No values on X-axis
Legend at right
Chart embedded between D10 and I20

Chart style 8
No legend
Data labels as Category name and Percentage
Labels outside of chart
Title
Italy Old City image added to middle of doughnut
Move chart and image below row 21 and between A and I
Rename Sheet 1 – Vacation Planning
Copy Sheet 1 to Sheet 2 and show formulas
Rename Sheet 2 – Formulas and have after Sheet 1

Ion Theme
Background – Solid fill; Purple, Accent 6, Darker 25% for all slides

Picture with Caption layout
Title and subtitle
Image of Italy Old City in right placeholder

Images in SmartArt circles
Plaque shape at left of SmartArt
Image of Italy Vineyard in shape
Crisscross Etching Artistic Effect

Comparison layout
Titles
Excel bar chart inserted in left pane; 3.5”
Excel doughnut chart inserted in right pane; 3.5”

Blank layout
Background – Italy Old City
Textbox across bottom of slide
Text centered, Forte font, 80 pt. in textbox
Shape fill – Blue-Gray, Accent 5, Darker 25%
Text fill – Gold, Accent 3, Lighter 40%

Blank layout
Snip of 4 slides on page; sized to fit in slide
Header and Footer on print preview