Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE help me figure out the formula to find the percent of total sales I cannot figure out how to find it. AutoSave Off He

PLEASE help me figure out the formula to find the "percent of total sales" I cannot figure out how to find it.

image text in transcribed

AutoSave Off He Fray_Excel_1F_Balance_Sales O Search (Alt+Q) Jennifer Fray JF File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert Calibri 11 - AP Percentage y WE o 2 Fm = = = 20 ab Wrap Text Es Merge & Center v IN DX Delete Paste BI U A $ % 0 ) Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter - Select Editing Analyze Sensitivity Data Clipboard Font Alignment Number Cells Analysis Sensitivity F4 fic G H | J K L M N O 1 2 3 4 Balance Pillow 5 Slide Board 6 Foam Roller 7 Rebounder 8 Stability Ball 9 Balance Board 10 Balance Pad 11 Total Sales for All Products B D E F Pro Fit Marietta Balance and Stabilization Sales Product Number Quantity Sold Retail Price Total Sales Percent of Total Sales BP-3 275 22.95 6311.25 SB-8 382 99.95 38180.9 FR-2 251 39.5 9914.5 RB-4 162 139.95 22671.9 SB-5 380 51.5 19570 BB-6 206 84.95 17499.7 BP-8 220 75.99 16717.8 130866.05 12 13 14 15 16 17 18 19 20 21 Sheet1 + Enter We're starting the add-ins runtime, just a moment... 100% Type here to search o j > 0 W 241 11:53 AM 1/29/2022 F 4

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

Step: 3

blur-text-image

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago