Power BI

What is PowerBI and its components

What are the advantages and dis advantages of PowerBI

Difference between Dashboards and Reports

Explain Building Blocks of Power BI

Power BI DAX

Explain power Bi DAX function

Discuss the different data sources used in Power BI. Also explain the process to import data from

the sources.

Explain the Power BI Architecture in detail.

Digital marketing

Differences between Traditional Marketing & Digital Marketing:

What is Social Media Marketing?

Characteristics of a Successful Social Media Marketer:

Google AdWords and types of advertising are possible in google ad words?

How online businesses use e-mail to engage customers and what Measuring the Success of Email

Marketing:

Explain types of email marketing?

What steps will you take to creating and launching a successful E-Mail Marketing 2.0 Campaign.

Advantage of Email marketing

Disadvantage of email marketing?

Discuss the characteristics of Digital Marketing

What is Search Engine Advertising? Discuss the objectives of Search Engine Advertising.

Excel

Problem 1) Given the worksheet as follows

all subjects ,percentage of marks and result respectively. Where result is PASS when total is 240 or

more otherwise FAIL.

Problem 2) The following data has been entered in a worksheet.

Write step to find TAX in cell C2 to calculate tax as follows :

SALESTAX

First Rs. 100005%

Next Rs. 150008% + 500

Excess10% + 1200 +500

Problem 8) The following is in a worksheet

Fill the Commission with 5% of sales provided the sales is greater than 100000.Otherwise

it is 2.5% of sales.

(b) Fill the total salary with the addition of fixed salary and commission.

(c) Give the row heading as TOTAL in the seventh row. Fill the row with the addition of the

respective

Problem 3)

Salesmans name and his total sales have been entered in columns A and B respectively for 25

salesman. First row contain headings and next 25 rows contain data. Write steps to compute

commission and bonus to be paid to salesman in column C and D respectively using the following

policy. Commission is 1% of sales up to Rs 50,000 and 2 % on balance sales. Bonus is 2.5 % of

sales exceeding Rs 1, 50,000 only when sales exceed 1,50,000 otherwise it is 0.

Problem 4)

In a worksheet, name are entered in column A and corresponding Basic pay is entered in Column B

for 30 person the first row contain heading ad the rest of rows contain data. Write the steps to obtain

in Column C, D and E the HRA, DA, and total Pay where HRA is @33% of Basic pay or Rs.12000

whichever is more, and SA is 40 of basic pay wherever basic is less then 2000 otherwise it is 30% of
basic pay

Problem 5)

The following data has been entered in a work sheet

1) How to find the NUMBER OF PEOPLE NAMED raj in cel A10

2) FIND THE TOTAL ON AMOUNT FOR THE PERSON NAME RAJ in Cell A12

Problem 6)

Prepare a worksheet containing the Name and marks in 3 subjects in columns A, B, C and D

respectively from columns 1 to column 31, the first row contains the headings and the remaining

rows contain data. Use your own data. Carry out the following operations on this worksheet.

Obtain the total marks of each student in column E.

Construct the 3D Pie diagram for the totals.

Construct a line chart for subject 1 and subject 3.

Display only those students details that have total marks exceeding 180.

Display only those students details whose name begins with R.

Problem 7)

Prepare a worksheet containing the Name and taxable income in columns A and B respectively from

rows 1 to 26, the first row contains the headings and the remaining rows contain the data. Use your

own data. Carry out the following operations on this worksheet.

1. Obtain the income tax in column C using the following income tax slabs.

Taxable Income(Rs)Rate

First 1,00,000Nil

Next 60,00010%

Next 70,00020%
Excess30%

2. Obtain the surcharge in column D, where surcharge is 3% of the income tax for those whose

taxable income is above Rs 5,00,000

3. Obtain the total tax in column E, as the sum of income tax and surcharge.

Problem 8)

Consider the following worksheet containing the amount spent for various items during the year.

Write steps to prepare scenarios where there is an increase as follow.

1)Machinery increases to 80000, carriage increase to 9000 and postage increases to 8000

2) Carriage increases to 10000, office equipment increases to 70000 and post increase to 9000

Problem 9) GOAL SEEK problem 1)

In the following worksheet the cost of education in 2014 under four categories is given. Write steps

to calculate the amount required in 2020 taking into account increase in fees by 50%, Hostel by

25%, food and clothing by 50% and miscellaneous by 30%. Find the total amt required in b6 & c6

respectively. further assuming that this target amt required in 2020 taking into account various

factors is say rs 450000 find using goal seek, the amount that has to be save each month in the next

6 year in the cell A8 to meet this target amt assuming no interest being recd on amount saved.

Problem 10)

Write the steps to find the GRADE cell C2,D2 and D2 using vlookup , hlookup and lookup functions.

Problem 11) SOLVER problem 1)

A company makes three products BATS, RACKETS and FOOTBALLLS whose sale price is Rs

300, Rs200 and Rs 150 respectively. For the company to break even, it has to achieve a total sale

of Rs 500000 in a year. Using solver write the steps to find out the number of units of each of these
three products that should be sold in order to meet the desire target sale.

Question 12 ) What do you mean by named ranges in Excel? Give procedure to create and used

named rages with a suitable example.

Question 13 ) What are Macro in Excel? Give procedure to record and to run a Macro.

Problem 14) Explain MATHEMATICAL & STATISTICAL FUNCTIONS

Problem 15) Explain STRING FUNCTIONS

Problem 16) Explain date and time function

Problem 17) Explain SOLVER WITH YOUR EXMPLE