Answered: plz provied ans in excel 13.1.…

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

See similar textbooks

Related questions

Concept explainers

Question

plz provied ans in excel

13.1. Using an MS Excel function, Create a List in J3 of countries in Cell J3 and display the GDP per capita in cell K3 for the country listed in cell J3.

13.2. In Cell K8, display the Country for which GDP per capita is the least using EXCEL INDEX and MATCH functions.

13.3. Please use IF function and the Table I given below to decide category for each country. E.g. Category I refers to countries with GDP per capita < 10,000 and Internet Users < 30. Write your answer in H2. Copy the same for all other countries.

13.1. Using an MS Excel function, Create a List in J3 of countries in Cell J3 and display the GDP per capita in cell K3 for
the country listed in cell J3
13.2. In Cell K8, display the Country for which GDP per capita is the least using EXCEL INDEX and MATCH functions.
13.3. Please use IF function and the Table I given below to decide category for each country. E.g. Category I refers to countries with
GDP per capita < 10,000 and Internet Users < 30. Write your answer in H2. Copy the same for all other countries.
TABLE I
Category GDP per capita
Category I< 10,000
Internet Users
< 30
Category II>= 10,000 but less than 40000
>=30 but less than 40
Category III>=40000
<90
OTHERS
ALL other Countries

Expert Solution

Step by step

Solved in 3 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.

Similar questions