1.
In Microsoft Excel, Perform the following tasks in dataset
(56,43,24,67,87,45,69,97,54,24,45,68,85,14,10,92)
a) Calculate highest core using MAX
b) Calculate lowest score using MIN
c) Calculate the average score using AVG
d) Find the total sum of score using SUM
e) Sort score in ascending order and display it in column B.
f) Find the square root of the total sum using SQRT
Aim/ Principle/
Tabulation/Circuit/ Calculation Viva-
Apparatus required Record Total
Program/Drawing & Results Voce
/Procedure
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 1 of 4
2. Using Microsoft Excel, find the Mean, Median, Mode and Standard deviation, Variance,
Skewness, Kurtosis for the given data and represent them in histogram
164,153,102,75,268,86,17,75,187,178,198,187,94
Aim/Principle/Apparatu Tabulation/Circuit/ Calculation Viva-
Record Total
s required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 2 of 4
3. a) Import a Worksheet from One Workbook to Another in Excel
b) Export Excel data to CSV
c) Export ranges from Excel to CSV with any delimiter and any character encoding
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 3 of 4
4. In Microsoft Excel, normalize following data and display It in Bold, red color.
Student Height(cm)
Kim 152
John 155
Mary 168
Jason 175
Hillary 153
Michael 163
Lisa 158
Rachel 156
Bob 161
Alice 150
Mike 170
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 4 of 4
5. In Microsoft Excel, perform bi variate and multi variate analysis using scatter plot,
correlation efficient, simple linear regression on the following dataset:
Hours Score
1 75
1 66
1 68
2 74
2 78
2 72
3 85
3 82
3 90
3 82
3 80
4 88
4 85
5 90
5 92
6 94
6 94
6 88
7 91
8 96
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 5 of 4
6. Prepare data in Power BI Desktop using following tasks:
a) Set Power BI Desktop options
b) Get data from SQl server and CSV file
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
7. Apply various transformations, queries to load data to data model in Power BI Desktop
solutions.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 6 of 4
8. Configure many to many relationships between any two tables in Power BI Desktop
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
9. Create sales Exploration report in Power BI Desktop using following tasks:
a) Create scatter charts
b) Create visual to forecast values
c) Work with key Work with the key influencers visual
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 7 of 4
10. Enforce row-level security to ensure that sales person can only ever see sales made in their
assigned regions.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
11. In Microsoft Excel,
a) Enter “welcome” message in to sheet, format with Arial, Font, Bold and Blue color
Background
b) Calculate average of values (10,20,30,40,50, and 60) and display result in cell B1.
c) Round average value using ROUND function and display result in cell B2.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 8 of 4
12. Design report in Power BI Desktop with advanced design features such as Sync slicers, drill
through page, conditional formatting, bookmarks
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 9 of 4
13. Perform Z-Test,T-test in MS-Excel using TEST() function on given dataset:
(Data1 for Z-Test and Data1 and Data2 for T-test)
Data1 Data2
4 6
5 19
6 3
7 2
9 14
12 4
15 5
16 17
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 10 of 4
14. In Microsoft Excel, Create student mark sheet which contains five subject marks, total,
average grade and remarks.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
15. In Power BI Desktop, Create sales monitoring dashboard using following tasks:
a) Pin visuals to a dashboard
b) Use Q&A to create dashboard tiles
c) Configure a dashboard tile alert
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 11 of 4
16. Create calculated tables, calculated columns, measures using Data Analytics Expressions
(DAX)
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
17. Design three-page reports and publish report to Power BI Desktop then interact with report.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 12 of 4
18. Create relationships between tables and then configure table, column properties to improve
friendliness and usability of data model in Power BI Desktop.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
19. Create measures with DAX expressions involving filter context manipulations using
CALCULATE () and Intelligence functions in Power BI Desktop.
Aim/Principle/Apparat Tabulation/Circuit/ Calculation Viva-
Record Total
us required/Procedure Program/Drawing & Results Voce
20 30 30 10 10 100
INTERNAL EXAMINER EXTERNAL EXAMINER
Page 13 of 4
