Scribd
Upload
82 views5 pages

4a Ranges

This budget summary document contains 4 worksheets that track budgets for different departments on a quarterly and annual basis. It shows salaries, travel, supplies, facility costs, and total budgets for each quarter and the full year for the Operations, Marketing, and Manufacturing departments. The document also demonstrates how to create a range across multiple worksheets to apply formatting and how to use SUM to total the budgets across departments in the Totals worksheet.

Uploaded by

Ramkumar Raja
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
82 views5 pages

4a Ranges

This budget summary document contains 4 worksheets that track budgets for different departments on a quarterly and annual basis. It shows salaries, travel, supplies, facility costs, and total budgets for each quarter and the full year for the Operations, Marketing, and Manufacturing departments. The document also demonstrates how to create a range across multiple worksheets to apply formatting and how to use SUM to total the budgets across departments in the Totals worksheet.

Uploaded by

Ramkumar Raja
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Budget Summary

Q1 Q2 Q3 Q4 Year Total
Salaries 121,500 286,500 286,500 290,500 985,000
Travel 40,500 42,525 44,651 46,884 174,560
Supplies 59,500 62,475 65,599 68,879 256,452
Facility 144,000 144,000 144,000 144,000 576,000
Total 365,500 535,500 540,750 550,263 1,992,013

Salaries 985,000
Travel -
Supplies -
Facility -
Total 985,000
A group of one or more cells is a Range

A range can be created by selecting the cells, and then naming it in the Name Box (on the top left cell next to Formula bar)

This example shows how you can track budgets, with a separate worksheet for each deparment

Activate the Totals worksheet by clicking its tab


Select the range B3:F3
3. Press Shift and click the Manufacturing sheet tab. This step selects all worksheets
between the active worksheet (Totals) and the sheet tab that you click—in essence,
a three-dimensional range of cells. When multiple sheets are
selected, the workbook window’s title bar displays Group to remind you that you’ve
selected a group of sheets and that you’re in Group mode.
4. Choose Home ➪ Font ➪ Bold and then choose Home ➪ Font ➪ Fill Color to apply a
colored background. Excel applies the formatting to the selected range across the
selected sheets.
5. Click one of the other sheet tabs. This step selects the sheet and cancels Group
mode; Group is no longer displayed in the title bar.

Go to Cell B4. Delete the existing formula


Do =SUM(click worksheet Operations + hold Shift Manufacturing and place cursor in cell B4 of Manufacturing)
Operations

Q1 Q2 Q3 Q4 Year Total
Salaries 40,500 128,500 128,500 132,500 430,000
Travel 18,500 19,425 20,396 21,416 79,737
Supplies 16,000 16,800 17,640 18,522 68,962
Facility 23,000 23,000 23,000 23,000 92,000
Total 98,000 187,725 189,536 195,438 670,699
Marketing

Q1 Q2 Q3 Q4 Year Total
Salaries 40,500 120,000 120,000 120,000 400,500
Travel 10,000 10,500 11,025 11,576 43,101
Supplies 11,000 11,550 12,128 12,734 47,411
Facility 29,000 29,000 29,000 29,000 116,000
Total 90,500 171,050 172,153 173,310 607,013
Manufacturing

Q1 Q2 Q3 Q4 Year Total
Salaries 40,500 38,000 38,000 38,000 154,500
Travel 12,000 12,600 13,230 13,892 51,722
Supplies 32,500 34,125 35,831 37,623 140,079
Facility 92,000 92,000 92,000 92,000 368,000
Total 177,000 176,725 179,061 181,514 714,301

You might also like