Answers All the answers are done in a single excel sheet. that is attached with this. d) maded a customized ribbon called ABC h) answer is callcuated using pivot table. {other wise we can use SUMIF () to calculate Specific region =SUMIF(range,criteria,[Sum_range])}   All the Questions answers are in the excel workbook

uploaded DashBoard in drive  Created   dashboard Data Summary  Create a Macro for Data Formatting Create VBA Code to convert selected data into pdf Check Spelling mistakes in the workbook using VBA Code   Google Drive Link for project_2 :-https://drive.google.com/drive/folders/17WKuu7m6rgewFtzbNLHxsPz5oKYI5glL?usp=sharing

Project Uploaded in tableau Public. https://public.tableau.com/views/project1_16811450040000/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link

Published inTableau public also https://public.tableau.com/views/project2_16812361740690/LiteracyRateinTamilnadu?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link Twbx file is attached with this

Q1) CREATE SCHEMA ecommerce;USE ecommerce; Q2) imported csv file in the table using Table Data import Wizard> chooesn the path > next >create new table> next >next > finished SELECT *FROM users_data; Q3) DESC users_data; Q4) SELECT *FROM users_dataLIMIT 100; Q5) SELECT COUNT(DISTINCT country) , COUNT(DISTINCT…

Q1) CREATE DATABASE alumni; Q2) imported all csv files into database alumni SHOW TABLES; Q3) College_A_HS DESC college_a_hs; College_A_SE DESC college_a_se; College_A_SJ DESC college_a_sj; College_B_HS DESC college_b_hs; College_B_SE DESC college_b_se; College_B_SJ DESC college_b_sj; Q4) College_A_HS College_A_SE College_A_SJ…

 English Dictionary App import jsondef main(): print('Main menu') print('1 Add a new word') print('2 Find the meaning') print('3 Update a word ') print('4 Exit') def add(): word=input('Enter the word : ').lower() meaning=input('Enter the Meaning of the word : ') store[word]=meaning add_to_file()def find(): word =…

project file is uploaded below    

power point (ppt) and power bi(.PBIX ) Files are uploaded below please check power point name as Covid-19 Vaccination Trend Analysis (Project 1) power bi as project 1

Visualization (Project 2.pbix) file and presentation(Supply demand  Analysis (Project 2)) is uploaded below.