corporate profits sum The sales purchases experses profit 4% tax I profit all compares) 1000 5000 8000 68000 77500 8000 75000 90000 3000 2000 19500 1500 19500 5 Isra 3 2700 53200| 48500 | nouns 4 12000 19500 480 6. 2000 19500 7 5 right | 66000 76000 8000 2000 19500 8 10 To find the lowest profit for companies, we use the following function: =MIN(G3:G7) 1 =MIN(D3:G3) =MIN(G1:65) =MIN(F3:F7) =MAX(G1:G5) all mentioned To find the tax for the Isra company at 4%*: we use the following equation 2 To find the total profit for all companies we use *: the following function =480*4% 3 =SUM(G1:65) = 12000/100*4 SAM(G3:G7) =12000/0.04 all mentioned O =SUM(G3:G7) =480*0.04 O =SUM(E3:E7) 19500/0.04= =SUM(F3:F7) all mentioned

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
I need the answer as soon as possible
H
1
corporate profits
sum
The
sales purchases expenses
profit
4% tax | profit all
2
compares)
3
AAadhope
5000
8000
1000
2000
19500
68000 77500 8000
75000 90000 3000
4
1500
19500
5 | Isra 3
12000
19500
480
2700 53200| 48500 | nouns 4
2000
19500
5 right | 66000 76000 8000
2000
19500
8.
9
10
To find the lowest profit for companies, we use the following function:
=MIN(G3:G7)
1
=MIN(D3:G3)
=MIN(G1:65)
=MIN(F3:F7)
=MAX(G1:G5)
all mentioned
To find the tax for the Isra company at 4% *: we use the following equation
2
To find the total profit
all companies we use *:
the following function
=480*4%
3
=SUM(G1:65)
12000/100*4
SAM(G3:G7)
=12000/0.04
all mentioned
=SUM(G3:G7)
=480*0.04
=SUM(E3:E7)
19500/0.04=
=SUM(F3:F7)
all mentioned
Transcribed Image Text:H 1 corporate profits sum The sales purchases expenses profit 4% tax | profit all 2 compares) 3 AAadhope 5000 8000 1000 2000 19500 68000 77500 8000 75000 90000 3000 4 1500 19500 5 | Isra 3 12000 19500 480 2700 53200| 48500 | nouns 4 2000 19500 5 right | 66000 76000 8000 2000 19500 8. 9 10 To find the lowest profit for companies, we use the following function: =MIN(G3:G7) 1 =MIN(D3:G3) =MIN(G1:65) =MIN(F3:F7) =MAX(G1:G5) all mentioned To find the tax for the Isra company at 4% *: we use the following equation 2 To find the total profit all companies we use *: the following function =480*4% 3 =SUM(G1:65) 12000/100*4 SAM(G3:G7) =12000/0.04 all mentioned =SUM(G3:G7) =480*0.04 =SUM(E3:E7) 19500/0.04= =SUM(F3:F7) all mentioned
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Single source shortest path
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education