Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXCEL CONDITIONALS AND CONDITIONAL FORMATTING HELP Can someone please tell me how to write the formulas for the following given the data in the photo?

EXCEL CONDITIONALS AND CONDITIONAL FORMATTING HELP

Can someone please tell me how to write the formulas for the following given the data in the photo? I keep getting errors or it gives me 0, I tried to use IF and ISNUMBER and SEARCH but I think I am putting them together incorrectly.

1) Conditional formatting (use formulas inside Conditional Formatting)

a) Apply yellow fill to the Seasons where the ratio between Podiums and Wins is greater than 2

b) Apply red fill to the Countries with more than 10 Poles

2) Statistical Data

b) Number of Years with Wins less than 10 and Margin greater than 15

c) Average Podiums for United Kingdom, with Fastest Laps greater than 3, and Points greater than 45

d) Total Poles for Dunlop or Goodyear tyres

e) Total Podiums for Ford engine and Goodyear tyres

image text in transcribed

3 Season Country Poles Wins Podiums Fastest Laps Points Construct Engine Tyre Vanwall Vanwall Dunlop 1958 United Kingdom 1959 United Kingdom 1960 United Kingdom 4 Cooper Climax Dunlop Ferrari Ferrari Dunlop BRM BRM Climax 1962 United Kingdom 1963 United Kingdom 1964 Ital 1965 United Kingdom 1966 United Kingdom 1967 United Kingdom 1968 United Kingdom 1969 France 1970 United Kingdom 1971 United Kingdom 1972 United Kingdom 1973 United Kingdonm 1974 United Kingdom 1975 Italy 1976 Italy 1977 Italy 1978 United Kingdom 1979 Italy 1980 United Kingdom 1981 United Kingdonm 1982 Italy 1983 Italy 1984 United Kingdom 1985 United Kingdonm 1986 United Kingdom 1987 United Kingdom 1988 United Kingdom FerrariFerrari Dunlop Climax Dunlop Brabham Repco Goodyear Brabham RepcoGoodyear 4 Firestone Matra Firestone Go Firestone Goodyear Goodyear Tyl Ford Lotus McLarenFord FerrariFerrari Goodyear FerrariFerrari Goodyear Ferrari Ferrari Goodyear Go Ferrari Ferrari Michelin Williams Ford Williams Ford Ferrari Ferrari Goodyear FerrariFerrari Goodyear McLaren TAG McLaren TAG Williams Honda Goodyear WilliamsHonda Goodyear McLaren Honda Goodyear Goodyear Goodyear 120 Goodyear 137 1990 United Kingdom 1991 Un 1992 United Kingdom Goodyea Goodyean Goodye Goodyea 1994 United Kingdom 1995 United Kingdom 1996 United Kingdom 1997 United Kingdonm 1998 United Kingdom 1999 Italy 2000 Italy 2001 Ital 2002 Italy Williams Renault Goodyear Benetton Renault Goodyear 137 175 123 Renault Goodyean 105 Williams Renault Goodyear McLaren Mercedes Bridgestone FerrariFerrari Bridgestone FerrariFerrari Bridgestone 010 Ferrari Ferrari Bridgestone FerrariFerrariBridgestone 128 262 143 2004 Italy 2005 France 2006 France 2007 Italy 2008 Italy 2009 United Kingdom 2010 Austria 2011 Austria 2012 Austria 2013 Austria 2016 Germany 2014 Germany 2015 Germany FerrariFerrari Bridgestone 15 Renault Renault Michelin Renault Renault Michelin FerrariFerrari Bridgestone 11 Ferrari Ferrari Bridgestone Braw Red B Renault Bridgestone 15 Red Bull Renault Pirelli Red Bull Renault Pirelli Red Bul Renault Pirelli Mercedes Mercedes Pirelli Mercedes Mercedes Pirelli Mercedes Mercedes Pirelli 52 204 103 172 498 650 460 596 765 701 n Mercedes Bridgestone 153 236 297 296 275 32

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

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago