Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Use DSUM To summarize mailing daTa. a. On The Ma'lings sheet noTe ThaT number senT is locaTed in The Third column and response daTa

image text in transcribed
3. Use DSUM To summarize mailing daTa. a. On The Ma'lings sheet noTe ThaT number senT is locaTed in The Third column and response daTa is in The TourTh column. b. Click The CIiTeria sheeT Tab. SelecT cell I32 and Type Ian* To selecT daTa for The Landscape Design deparTment Click The Mailing Slais sheeT Tab and selecT cell I57. Use DSUM WiTh The range name Responses as The DaTabase argument Type 3 for The Field argument and use an absoluTe reference To cells 51:32 on The Crii'ea sheeT as The CriTerr'a argument e. Copy The formula To cell C? and ediT The Field argumenT To use The TourTh column. T. CompleTe crileria for The Two remaining deparTmenTs on The CIiTea sheeT. g. Click The Mailing Slais sheeT Tab and selecT cell BB. h. Use DSUM in cells 38:09 To calculate resulTs for The Two deparTmenTs. 9-9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools For Business Decision Making

Authors: Jerry J Weygandt, Paul D Kimmel, Jill E Mitchell

9th Edition

1119754054, 9781119754053

More Books

Students also viewed these Accounting questions

Question

1. Build trust and share information with others.

Answered: 1 week ago