WorksheetsAI & ML Intro
Total questions: 54
Worksheet time: 54mins
Name
Class
Date
1.
which of the given language is not commonly used for AI?
a)
LISP
b)
PYTHON
c)
PERL
d)
PROLOG
2.
Which type of learning can be used for clustering similar data points together?
a)
Supervised learning
b)
Unsupervised learning
c)
Reinforcement learning
d)
Semi-supervised learning
3.
What is the purpose of exploratory data analysis (EDA) in manufacturing datasets?
a)
To develop machine learning models
b)
To clean and preprocess data
c)
To understand the data and its characteristics
d)
To validate the data
4.
Who is known as the Father of AI?
a)
Alan Turing
b)
John McCarthy
c)
James Gosling
d)
Arthur Samuel
5.
When dealing with a large dataset, which approach can be used to improve data cleaning efficiency?
a)
Manual inspection of each data entry
b)
Using regular expressions to identify patterns in text data
c)
Utilizing data cleaning libraries and automation tools
d)
Ignoring the data cleaning process for faster analysis
6.
Which of the following techniques is commonly used in EDA for identifying missing values in manufacturing datasets?
a)
Data imputation
b)
Data smoothing
c)
Feature scaling
d)
Outlier detection
7.
Which of the following is a real-world application of AI/ML in the manufacturing industry?
a)
Inventory management
b)
Agricultural farming
c)
Historical research
d)
Weather forecasting
8.
Which function is used to add all the numbers in a range of cells?
a)
SUM
b)
AVERAGE
c)
COUNT
d)
MAX
9.
Which Excel feature is used to perform statistical analysis on a range of data?
a)
What-If Analysis
b)
Goal Seek
c)
Data Tables
d)
Analysis ToolPak
10.
Which of the following is used to plot a graph in Excel?
a)
Chart Wizard
b)
Data Manager
c)
Analysis ToolPak
d)
Conditional Formatting
11.
What is the purpose of a pivot chart in Excel?
a)
To create dynamic charts that change based on the source data
b)
To combine multiple charts into a single visual
c)
To create complex 3D visualizations
d)
To compare data points in separate worksheets
12.
What is feature engineering in the context of manufacturing data?
a)
The process of designing new products
b)
The process of creating new data
c)
The process of transforming raw data into informative features
d)
The process of organizing data in a manufacturing facility
13.
Which Excel function is used to find the standard deviation of a range of cells?
a)
SD
b)
STDEV
c)
STANDARD_DEVIATION
d)
VARIANCE
14.
Which of the following is a benefit of using a scatter plot in Excel?
a)
Showing trends over time
b)
Comparing different categories
c)
Displaying the relationship between two variables
d)
Presenting proportions of a whole
15.
Which technique is used to identify and handle outliers in a dataset?
a)
Deleting the entire row containing an outlier
b)
Replacing the outlier with the mean value
c)
Using the Z-score method or the interquartile range (IQR) method
d)
Ignoring the outliers during analysis
16.
Which Excel function is used to round a number to a specified number of digits?
a)
ROUND
b)
ROUNDDOWN
c)
ROUNDUP
d)
MROUND
17.
What is a common method for handling missing values in a dataset?
a)
Deleting the entire row with missing values
b)
Imputing the missing values with mean or median
c)
Replacing missing values with zero
d)
Ignoring the missing values during analysis
18.
Which Excel function is used to calculate the correlation coefficient between two data sets?
a)
CORREL
b)
COVAR
c)
PEARSON
d)
CORRELATION
19.
What is the purpose of dimensionality reduction techniques in feature engineering for manufacturing data?
a)
To decrease the dimensionality of data while preserving its relevant information
b)
To create new features
c)
To increase the dimensionality of data
d)
To eliminate all features
20.
How does AI contribute to predictive maintenance?
a)
AI enables real-time monitoring and data analysis for early fault detection
b)
AI automates manual tasks, eliminating the need for human intervention.
c)
AI reduces the need for spare parts inventory
d)
AI increases the time taken for maintenance activities
21.
Which of the following techniques is commonly used for building failure prediction models in predictive maintenance?
a)
Linear regression
b)
Decision trees
c)
Support Vector Machines (SVM)
d)
All of the above
22.
Which of the following is a key benefit of implementing AI in predictive maintenance?
a)
Increased downtime due to system complexities
b)
Reduced accuracy in fault detection
c)
Improved asset lifespan and reduced maintenance costs
d)
Higher reliance on traditional maintenance techniques
23.
Which AI technique is commonly used for predictive maintenance in condition monitoring?
a)
Natural Language Processing (NLP)
b)
Convolutional Neural Networks (CNN)
c)
Recurrent Neural Networks (RNN)
d)
Time Series Analysis
24.
Which of the following AI techniques is best suited for feature extraction in condition monitoring?
a)
Principal Component Analysis (PCA)
b)
K-Means Clustering
c)
Apriori Algorithm
d)
K-Nearest Neighbors (KNN)
25.
Which AI/ML application is used to optimize production schedules and minimize downtime in manufacturing plants?
a)
Natural language processing (NLP)
b)
Deep learning
c)
Predictive maintenance
d)
Reinforcement learning
26.
Which type of learning deals with data that has not been labeled, classified, or categorized?
a)
Supervised Learning
b)
Reinforcement Learning
c)
Unsupervised Learning
d)
Semi-supervised Learning
27.
AI stands for
a)
Artifiicial Inteligence
b)
Artificial Inteligance
c)
Artificial Intelligence
d)
Arteficial Inteligence
28.
When dealing with a large dataset, which approach can be used to improve data cleaning efficiency?
a)
Manual inspection of each data entry
b)
Using regular expressions to identify patterns in text data
c)
Utilizing data cleaning libraries and automation tools
d)
Ignoring the data cleaning process for faster analysis
29.
Which of the following is a typical application of machine learning in the manufacturing industry?
a)
Virtual reality gaming
b)
Quality control and defect detection
c)
Social media marketing
d)
Satellite communication
30.
Which of the following techniques is commonly used in EDA for identifying missing values in manufacturing datasets?
a)
Data imputation
b)
Data smoothing
c)
Feature scaling
d)
Outlier detection
31.
Which AI application is used to analyze complex data sets for identifying patterns and improving decision-making in the manufacturing process?
a)
Augmented reality
b)
Image recognition
c)
Blockchain technology
d)
Data analytics
32.
Which of the following is not a feature engineering technique commonly used for manufacturing data?
a)
One-Hot Encoding
b)
Principal Component Analysis (PCA)
c)
Image Classification
d)
Polynomial Features
33.
What is the primary purpose of using AI in predictive maintenance?
a)
Enhancing operational efficiency
b)
Reducing initial investment costs
c)
Replacing human workers
d)
Simplifying inventory management
34.
What is the main purpose of Power Map in Excel?
a)
Creating interactive dashboards
b)
Importing and cleaning large datasets
c)
Visualizing geographical and temporal data
d)
Analyzing complex financial data
35.
Which Excel function is used to predict a future value based on existing values and a regression line?
a)
FORECAST
b)
PREDICT
c)
PROJECTION
d)
PREDICTION
36.
What is the purpose of dimensionality reduction techniques in feature engineering for manufacturing data?
a)
To decrease the dimensionality of data while preserving its relevant information
b)
To create new features
c)
To increase the dimensionality of data
d)
To eliminate all features
37.
Which Excel function is used to calculate the slope of a linear regression line?
a)
TREND
b)
LINEST
c)
SLOPE
d)
INTERCEPT
38.
Which Excel feature allows you to identify relationships between two sets of values?
a)
Solver
b)
Data Tables
c)
Goal Seek
d)
Correlation Tool
39.
What is the primary objective of condition monitoring using AI techniques?
a)
To increase production speed
b)
To reduce energy consumption
c)
To predict equipment failure
d)
To improve employee satisfaction
40.
Machine Learning is a Subset of
a)
Cyber Security
b)
Deep Learning
c)
Artificial Intelligence
d)
PROLOG
41.
In which Type of AI agent has mainly four conceptual components
a)
Learning Agent
b)
Goal-based Agent
c)
Simple Reflex Agent
d)
Utility-based Agents
42.
In which learning method does an agent learn to make decisions by interacting with an environment and receiving rewards or penalties?
a)
Supervised learning
b)
Supervised learning
c)
Reinforcement learning
d)
Semi-supervised learning
43.
What does the function "COUNTA" do in Excel?
a)
Counts the number of cells in a range that contains numbers
b)
Counts the number of cells in a range that are not empty
c)
Counts the number of cells in a range that meets a certain condition
d)
None of the above
44.
What is the advantage of using AI-based failure prediction models in predictive maintenance over traditional time-based maintenance?
a)
Increased maintenance costs
b)
Reduced equipment uptime
c)
Better utilization of resources
d)
Inefficient data analysis
45.
What is the primary goal of implementing a failure prediction model in AI for predictive maintenance?
a)
To react to failures after they occur.
b)
To schedule maintenance at regular intervals
c)
To predict failures before they happen.
d)
To reduce the need for maintenance entirely.
46.
Which of the following statistical measures is useful for understanding the central tendency of data in manufacturing datasets during EDA
a)
Standard deviation
b)
Range
c)
Variance
d)
Mean
47.
Which type of learning uses labeled data for training?
a)
Unsupervised Learning
b)
Reinforcement learning
c)
Data learning
d)
Supervised Learning
48.
Suppose you have a dataset of customer information for a retail store. You want to predict whether a customer will make a purchase or not based on their previous purchase history, age, and gender. Which machine learning technique would be most suitable for this problem?
a)
Linear Regression
b)
Logistic Regression
c)
Decision Trees
d)
Support Vector Machines
49.
In Excel, which function is used to calculate the y-intercept of a linear regression line?
a)
INTERCEPT
b)
SLOPE
c)
LINEST
d)
TREND
50.
Which Excel Power Tool is primarily used for analyzing large datasets and creating sophisticated data models?
a)
Power Query
b)
Power Pivot
c)
Power Map
d)
Power View
51.
Which of the following is not a type of machine learning?
a)
Reinforcement Learning
b)
Supervised Learning
c)
Data Learning
d)
Unsupervised Learning
52.
What is the main benefit of performing data transformation during EDA for manufacturing datasets?
a)
To remove outliers from the dataset
b)
To convert categorical data into numerical data
c)
To standardize the range of features
d)
To make the data more normally distributed
53.
What does the function "VLOOKUP" do in Excel?
a)
Looks for a value in the leftmost column of a table and returns a value in the same row from a column you specify
b)
Adds the numbers in a range of cells
c)
Multiplies the numbers in a range of cells
d)
Divides the numbers in a range of cells
54.
Which Power Tool in Excel enables users to create interactive data visualizations and reports?
a)
Power Query
b)
Power Pivot
c)
Power Map
d)
Power View
100 %
