Scribd
Upload
7 views8 pages

Excel Class Practice and Formulas

The document contains sales data for various shirt products across different months and countries, detailing sales revenue and product counts. It also includes revenue classifications for apps based on specified thresholds, along with a list of names and fruit counts. Additionally, there are product IDs and sales values for electronic items, along with instructions for data manipulation in spreadsheets.

Uploaded by

Koushal Ostwal
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
7 views8 pages

Excel Class Practice and Formulas

The document contains sales data for various shirt products across different months and countries, detailing sales revenue and product counts. It also includes revenue classifications for apps based on specified thresholds, along with a list of names and fruit counts. Additionally, there are product IDs and sales values for electronic items, along with instructions for data manipulation in spreadsheets.

Uploaded by

Koushal Ostwal
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/ 8

Month Product Country Sales Revenue Count products based on below

Jan Shirt White USA $546.00 Shirt White


Jan Shirt Blue USA $519.00 Shirt White Feb
Feb Shirt White USA $492.00 Shirt White Feb USA
Feb Shirt Blue USA $559.00
Feb Shirt White USA $591.00
Feb Shirt White USA $535.00 COUNTIFS OR
Feb Shirt Blue USA $550.00 Shirt White
Feb Shirt Yellow USA $517.00 Shirt Blue (Shift+ ctrl+Enter)
Feb Shirt Blue UK $449.00
Feb Shirt White $410.00 Count NOT EQUAL TO
Feb Shirt White UK $435.00 Shirt Yellow
Mar Shirt Yellow USA $468.00
Mar Shirt Blue USA $568.00
Apr Shirt White USA $432.00
Apr Shirt White USA $431.00
Apr Shirt Blue $479.00
Apr Shirt Yellow UK $471.00
May Shirt Yellow USA $534.00
May Shirt White UK $409.00
No of Shirt Month
9 9 By default AND

(Shift+ ctrl+Enter) 6
15000 15000
Good 20000
Revenue >15000
Revenue>15000 then and <20000 then
Apps Revenue "Good" "Good"
Fightrrr 11649
Kryptis 7718
Perino 15033 Good Good
Hackrr 18701 Good Good
WenCaL 14432
Blend 17990 Good Good
Sleops 11022
Accord 17760 Good Good
Misty Wash 30400 Good
Twenty20 20400 Good
Revenue >15000, and <20000 then Good,
Revenue>=20000 is Exceptional, Rest is value
11649
7718
Good
Good
14432
Good
11022
Good
Exceptional
Exceptional
Arnoid 5
Christine 7 4 17 21
Jackie 14
Jared 25
John 29
Kelly 34
Lucy 63
Megan 71
Sarah 86
Tim 96

First Name Last Name


Greg Williams
John Smith
Jullet Thompson
Karen Johnson
Karla Gonzalez
Lucy James
Mark Anderson
Rachelle Larson
Ricky Clark
23 24 35 75 86 (Sorting data Horizontally)
Fruit Number
Orange 24
Orange 87
Product IDProduct Sales
AN3025M TV ₹ 4,746.00 Dropdown list of Product
BW4512R AC ₹ 7,217.00 AC
ER85201T Fridge ₹ 5,858.00 LED Bulb
TB1203M Fan ₹ 4,918.00 Fridge
LE1234W LED Bulb ₹ 5,310.00 Fridge
OV4562H Oven ₹ 5,725.00 Fridge
AC1203U Air Cooler ₹ 7,016.00 Fridge
LM8965K Laptop ₹ 9,653.00 Fridge
MB6548R Mobile ₹ 7,650.00 Fridge

Fix Value can be entered


Fix the range of numerical values

You might also like