Workshop Cost Per Person Cost for each Number of participant participants Workshop ID Туре Total cost Kitchen Bathroom Bedroom 01-KT 25 41 33 19 1.025 660 380 02-BT 03-BD 04-LD Laundry Room 05-LR 06-GR 07-CL 08-WL 20 20 10 15 150 Living Room/Great Room Game Room Closet Intervention Wall Décor Lighting 25 25 625 15 13 195 10 28 280 15 14 210 TOTAL COSTS $ 3,315 Cost includes facility rental, food, beverages, workbook, promotional materials, staff time, samples, etc. No. Participants: l

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
AutoSave O Off
PB Financials.xlsx - Excel
Sign in
File
Home
Insert
Page Layout
Formulas
Data
Review
View
O Tell me what you want to do
A Share
P Comments
2 AutoSum -
Calibri
- 11 - A A"
22 Wrap Text
General
Fill -
$ - % 9 00 Conditional Format as Cell
Formatting Table
BIU - H - - A - EEE E E E Merge & Center -
Sort & Find &
Paste
Insert Delete Format
Styles
O Clear
Filter Select
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
C17
fe
A
В
G
H
K
M
N
P
R
V
X
Y
廟
Precision Building
1
2
Workshop Cost Per Person
3
Workshop
Cost for each Number of
ID
Туре
participant
participants
Total cost
Kitchen
$
$
01-KT
25
41
1,025
6
Bathroom
02-BT
03-BD
20
33
660
7
Bedroom
$
20
19
380
Laundry Room
Living Room/Great Room
Game Room
8
04-LD
10
15
150
05-LR
25
25
625
10
06-GR
15
13
195
11
07-CL
Closet Intervention
$
10
28
$
280
12
08-WL
IWall Décor Lighting
15
14
210
13
TOTAL COSTS $
3,315
14
Cost includes facility rental, food, beverages, workbook, promotional materials, staff
15 time, samples, etc.
16
17 No. Participants:
18
Task Instructions
19
20
In cell C17, create a nested formula using the INDEX and
21
MATCH functions that returns the Number of participants
Workshops
for the Bedroom workshop type.
Ready
国
Transcribed Image Text:AutoSave O Off PB Financials.xlsx - Excel Sign in File Home Insert Page Layout Formulas Data Review View O Tell me what you want to do A Share P Comments 2 AutoSum - Calibri - 11 - A A" 22 Wrap Text General Fill - $ - % 9 00 Conditional Format as Cell Formatting Table BIU - H - - A - EEE E E E Merge & Center - Sort & Find & Paste Insert Delete Format Styles O Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing C17 fe A В G H K M N P R V X Y 廟 Precision Building 1 2 Workshop Cost Per Person 3 Workshop Cost for each Number of ID Туре participant participants Total cost Kitchen $ $ 01-KT 25 41 1,025 6 Bathroom 02-BT 03-BD 20 33 660 7 Bedroom $ 20 19 380 Laundry Room Living Room/Great Room Game Room 8 04-LD 10 15 150 05-LR 25 25 625 10 06-GR 15 13 195 11 07-CL Closet Intervention $ 10 28 $ 280 12 08-WL IWall Décor Lighting 15 14 210 13 TOTAL COSTS $ 3,315 14 Cost includes facility rental, food, beverages, workbook, promotional materials, staff 15 time, samples, etc. 16 17 No. Participants: 18 Task Instructions 19 20 In cell C17, create a nested formula using the INDEX and 21 MATCH functions that returns the Number of participants Workshops for the Bedroom workshop type. Ready 国
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education