Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. 13

Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. 13

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
100%
Need help with step 13. The formula I entered was =B35*(1+B31) and I thought it was the correct formula, but it only worked for C35
ome Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 ν Α ab Wrap Tex Paste В I U v A v Merge & 5 v fx C D F City Manager 188,632 $ 185,492 $ 181,365 $ 184,733 $ 740,222 Community Services 154,025 158,964 162,475 160,333 635,797 Public Works 405,421 408,675 403,442 414,423 1,631,961 Finance 121,500 109,362 115,468 116,877 463,207 Fire and Safety Totals by Quarter 227,126 224,876 228,238 223,827 904,067 24 1,096,704 $ 1,087,369 $ 1,090,988 $ 1,100,193 $ 4,375,254 Annual Administration Expenses by Quarter $1,105,000 $1,095,000 $1,085,000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Expenses 5-Year Forecast Forecasted Increase 3.5% Year 2016 2017 2018 2019 2020 Projected Expenses 2$ 4,375,254 Administration Costs Chart Expenses Contracts County Partnership Ready li
Transcribed Image Text:ome Insert Draw Page Layout Formulas Data Review View O Tell me Calibri (Body) v 11 ν Α ab Wrap Tex Paste В I U v A v Merge & 5 v fx C D F City Manager 188,632 $ 185,492 $ 181,365 $ 184,733 $ 740,222 Community Services 154,025 158,964 162,475 160,333 635,797 Public Works 405,421 408,675 403,442 414,423 1,631,961 Finance 121,500 109,362 115,468 116,877 463,207 Fire and Safety Totals by Quarter 227,126 224,876 228,238 223,827 904,067 24 1,096,704 $ 1,087,369 $ 1,090,988 $ 1,100,193 $ 4,375,254 Annual Administration Expenses by Quarter $1,105,000 $1,095,000 $1,085,000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Expenses 5-Year Forecast Forecasted Increase 3.5% Year 2016 2017 2018 2019 2020 Projected Expenses 2$ 4,375,254 Administration Costs Chart Expenses Contracts County Partnership Ready li
Grader - Instructions Excel 2019 Pr Points Step Instructions Possib Format the Bounds of the Vertical (Value) Axis so that the Minimum is 1085000 and the Major unit is at 10000. Format the Fill of the Chart Area with a Gradient fill by applying the Preset gradient-in the first row, the third gradient. Format the Plot Area with a Solid fill using White, Background 1-in the first column, the first color. 12 Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. 13 10 14 Change the Orientation of this worksheet to Landscape, and then use the Scale to Fit options to fit the Height to 1 page. From the Page Setup dialog box, center the worksheet Horizontally, and insert a custom footer in the left section with the File Name element. 10 15 Display the Contracts worksheet. Using the data in A5:B7, insert a Funnel Chart. Move the chart so that the upper left corner aligns with the upper left corner of D1. Change the chart title to Contract Analysis and then change the Height to 2 inches and the Width to 4 inches. Make cell A1 the active cell. Change the Orientation to Landscape, center the worksheet, and insert a footer with the file name in the left section. 6 16 Display the County Partnerships worksheet. Select the range A4:B8 and then insert a Filled Map chart map. Change the Width to 4 and then move the chart so that its upper left corner aligns with the upper left corner of D1. For the chart title, type Partnership Analysis and then make cell A1 the active cell. Change the worksheet Orientation to Landscape. From the Page Setup dialog box, center this worksheet Horizontally, and insert a custom footer in the left section with the File Name element. 17 Save and close the file, and then submit for grading. Total Points 100
Transcribed Image Text:Grader - Instructions Excel 2019 Pr Points Step Instructions Possib Format the Bounds of the Vertical (Value) Axis so that the Minimum is 1085000 and the Major unit is at 10000. Format the Fill of the Chart Area with a Gradient fill by applying the Preset gradient-in the first row, the third gradient. Format the Plot Area with a Solid fill using White, Background 1-in the first column, the first color. 12 Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. 13 10 14 Change the Orientation of this worksheet to Landscape, and then use the Scale to Fit options to fit the Height to 1 page. From the Page Setup dialog box, center the worksheet Horizontally, and insert a custom footer in the left section with the File Name element. 10 15 Display the Contracts worksheet. Using the data in A5:B7, insert a Funnel Chart. Move the chart so that the upper left corner aligns with the upper left corner of D1. Change the chart title to Contract Analysis and then change the Height to 2 inches and the Width to 4 inches. Make cell A1 the active cell. Change the Orientation to Landscape, center the worksheet, and insert a footer with the file name in the left section. 6 16 Display the County Partnerships worksheet. Select the range A4:B8 and then insert a Filled Map chart map. Change the Width to 4 and then move the chart so that its upper left corner aligns with the upper left corner of D1. For the chart title, type Partnership Analysis and then make cell A1 the active cell. Change the worksheet Orientation to Landscape. From the Page Setup dialog box, center this worksheet Horizontally, and insert a custom footer in the left section with the File Name element. 17 Save and close the file, and then submit for grading. Total Points 100
Expert Solution
Step 1

Solution:

To solve this problem follow this steps:

First copy the annual total in the cell F10 and then go to the cell B35 and right click on the cell  and select the option Paste special.

  • It will open a Paste special menu window.
  • Click on the Paste special in menu
  • In Paste special, Select the radio button "Values & Number Formatting"
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Data Binding
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS