Auto Sum (and outline)

What is the average amount of giving and the average number of years of giving for corporations, foundations, and volunteers?
Features: AutoSum (and outline).
Instructions:  Return to Sheet 1, click on any cell containing data and select Data and Sort, and sort by column A, Donor Type.  To automatically insert subtotals, select Data, Outline, Subtotal, and check off the years of giving and giving columns, and uncheck other columns.  You can see the averages for each donor type by selecting Use Function:  Average (above the column checkboxes.)
To view subtotals only (which is essentially an outline of your data), you can click on the small 2 in the upper left corner of your spreadsheet.  To expand a particular section of your outline, such as volunteers, click on the + sign next to that subcategory.
To return to the outline view, click on the - sign next to the subtotal for that category.  Return to level 2 outline view.  Modify the spreadsheet so that your data will print on a single page.  Save the file as 301AutoSum.
Copy your spreadsheet showing only the data that answers the question.
Return to the original data by selecting Data, Subtotals, Remove All.

Answer Detail

Get This Answer

Save Time & improve Grades

  • Questions Asked 685087
  • Experts 5361
  • Total Answered 659177

Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!

Our Amazing Features

  • Plagiarism Free Work

    Our experts provide 100 % original and customized work On time Delivery

  • 24*7 Customer Support

    We provide 24*7 online customer supports via online chat or email

  • Cover All Subject

    JQA is one stop solution for all subject’s Assignment. We can provide assignment help for almost all subjects.

  • Best Industry experts

    We have 1000+ PHD and Post Graduate experts.

Refer Just 5 Friends to Earn More than $1000

  • Your Approx Earning

    USD 2350/year

Your Custom Referral Link:

Hire a tutor

Assignment hero

USA

I am an experienced tutor of 7+ years in all math, physics, and Spanish, SAT, and ACT tutoring. I love working with students and seeing them improve on and grasp concepts!

Guru

USA

Need help in Maths and science ? Look no further . contact me so i can help you . i have been a academic tutor for 10 years . Hire me for help in assignments.

Vikas

USA

After 13 years of working with students across the country, we have the experience and knowledge to provide the best possible academic support for your academics.

Rgaurav

India

I have experience teaching AP Calculus AB and BC, Algebra I, Algebra II, Trigonometry, SAT Math Preparation, and Geometry. I have tutored students ranging from 8th grade to college students.

Invite Tutor