Excel Training

What is the primary goal of Data Science?

• To develop software applications for data entry.
• To extract meaningful insights from data.
• To create complex algorithms for data storage.
• To visualize data without any analysis.

What is the first step in the Data Science process?

• Data Cleaning

• Data Collection

• Data Visualization

• Model Deployment

What is the purpose of Exploratory Data Analysis (EDA)?

• To clean the dataset

• To summarize main characteristics of the data

• To train machine learning models

• To create new programming languages

Which of the following is NOT a type of Data Analytics?

• Descriptive Analytics

• Predictive Analytics

• Prescriptive Analytics

• Random Analytics

What does "Big Data" refer to?

• Large-sized images

• A collection of small datasets

• Extremely large datasets that require specialized tools to process

• Handling Simple spreadsheets

What is the main purpose of Microsoft Excel?

• Creating websites

• Managing and analyzing data using spreadsheets

• Writing programming code

• Designing presentations

Which Excel function is used to find the average of a range of numbers?

• SUM()

• AVERAGE()

• COUNT()

• IF()

Which of the following is NOT a data visualization tool in Excel?

• Pivot Tables

• VLOOKUP

• Bar Charts

• Scatter Plots

What does the VLOOKUP function do in Excel?

• It looks up a value in a table and returns a corresponding value

• It finds the sum of values in a column

• It counts the number of rows in a table

• It creates pivot tables automatically

What is the shortcut key to auto-fill a series in Excel?

• Ctrl + A

• Ctrl + D

• Ctrl + C

• Ctrl + X