NEW
Font size
WorksheetsAdvanced ICT Concepts Exam Reviewer
Total questions: 50
Worksheet time: 18mins
What is the first step in the provided list for creating a Pivot Chart in Excel?
Select where you want the PIVOT CHART to appear
Select a cell in your table
Select the fields to display in the menu
Select INSERT and choose PIVOT CHART
Which specific element of Conditional Formatting changes the visual appearance of cells, such as adding data bars, color scales, or icons, based on rules?
The cell formatting options
The What-If Analysis toolset
The Recalculation engine
Pivot Tables
What feature in Excel allows users to visually represent data trends over time using a graphical format?
Tables
Conditional Formatting
Charts
Data Validation
In Excel, which function would you use to calculate the average of a range of cells?
MAX
SUM
AVERAGE
COUNT
What is the purpose of the VLOOKUP function in Excel?
To create a chart from data
To sum a range of cells
To find a value in the first column of a table and return a value in the same row from a specified column
To format cells based on their values
Which What-If Analysis tool is used to save and easily switch between a 'best-case' and a 'worst-case' financial outcome on a single worksheet?
Data Tables
Pivot Charts
Scenario Manager
Goal Seek
In the context of What-If Analysis, what is a Scenario?
A set of values that Excel saves and can substitute automatically in cells.
A tabular presentation of formula outputs based on two changing variables.
A formula that is too complex for standard calculation.
A calculated output value needed to achieve a profit goal.
What advantage do Data Tables offer regarding data freshness if automatic recalculation is enabled for the workbook?
The data immediately recalculates, ensuring users always have fresh data.
The data must be manually refreshed by the user.
The results are only updated when the worksheet is closed and reopened.
The data becomes static and cannot be changed after creation.
A Pivot Table’s purpose is best described as summarization and analysis. What specific capability allows it to show different data perspectives (e.g., totals, averages, counts)?
Its reliance on external databases.
Its function to rearrange fields.
Its use of Conditional Formatting.
Its ability to sort data in alphabetical order.
The Goal Seek feature helps determine the input value needed when the desired output (result) of a formula is already what?
Unknown or impossible to achieve.
A value of zero.
The result of a complex statistical model.
Known or predefined by the user.
Which element of Dynamic Visual Storytelling involves drawing a unique, customized path that a graphic object will follow on the slide during a presentation?
Custom Motion Paths
Standard Entrance Effects
Slide Transitions
Hyperlinks
Embedding and editing video and audio is a key part of which presentation content area?
Slide Master Design
Hyperlinking and Document Sharing
Multimedia Integration and Editing
Custom Animation and Motion Paths
What is the term for an AI system that is a hypothetical concept, possessing cognitive abilities similar to a human across many domains?
Superintelligence
General AI (AGI)
Narrow AI (ANI)
Machine Learning
Which core component of AI is described as the 'recipe' or set of instructions that tells the AI how to use the data to perform a task?
Natural Language Processing (NLP)
Data
Algorithms
Hardware
Which type of AI is exemplified by Netflix's movie recommendations and chatbot applications?
Robotics
Narrow AI (ANI)
General AI (AGI)
Superintelligence
Which AI technique specifically allows computer programs to understand human language as it is spoken and written?
Natural Language Processing (NLP)
Deep Learning
Machine Learning
Computer Vision
What is the primary application of AI in the field of Transportation?
Creating personalized movie recommendations.
Analyzing financial market trends for investment strategies.
Predicting the spread of infectious diseases.
Enabling self-driving cars and delivery drones.
The use of GPUs (Graphics Processing Units) is crucial in AI because they fall under which component, described as the 'oven' that efficiently processes massive amounts of data?
Algorithms
Hardware
Data
NLP
What is the purpose of a Recommendation Engine?
To control robots that perform tasks autonomously.
To convert spoken language into text.
To predict and suggest contents for the user.
To interpret and understand the visual world.
AI Ethics is defined as the principles that guide AI development to ensure it benefits all of humanity and avoids what negative outcome?
Replacing human programmers.
Being too slow in processing complex data.
Creating new jobs in manufacturing.
Leading to unfairness and causing harm.
Which Responsible AI Principle is focused on ensuring all individuals and groups are treated equitably?
Fairness
Accountability
Transparency
Superintelligence
What is the cause of bias in AI when the past data used for training is unrepresentative or reflects historical discrimination?
Bias from the Algorithms
Bias from the Humans
Bias from the Data
Bias from the Hardware
Which Responsible AI Principle establishes who is responsible for the AI system's impacts?
Fairness
Narrow AI
Transparency
Accountability
What is the fundamental concept that the Internet of Things (IoT) is built upon?
A network of supercomputers processing big data.
The replacement of human labor with autonomous robots.
Physical objects with sensors and connectivity for data collecting.
Connecting all devices that use Wi-Fi to a central server.
Which core IoT component includes physical methods like Wi-Fi, Bluetooth, and Cellular for data transmission?
Data Processing/Cloud
Sensors/Actuators
Connectivity/Network
User Interface/Application
Streetlights adjust brightness based on traffic is an example of which IoT application field?
Smart City
Wearables
Smart Industry
Smart Home
In an IoT system, what is the function of an Actuator?
To perform a physical action, such as turning on a light.
To analyze stored data and make complex decisions.
To provide the user with a control dashboard.
To collect data from the physical environment.
Which type of IoT application includes fitness trackers that monitor heart rate and sleep patterns?
Wearables
Smart Industry
Smart City
Smart Home
The large-scale collection of personal data (location, sleep, conversations) by IoT devices that could be exploited or sold is primarily what kind of IoT risk?
Recalculation Failure
Security Issue
Privacy Issue
Connectivity Issue
Which core component of the IoT system is referred to as the 'brain' where data is analyzed and decisions are made based on predefined rules?
The User Interface
Data Processing/Cloud
The Actuators
The Sensors
A project manager wants to analyze monthly spending. They need a tool to instantly change the row color of any expense exceeding $\$5,000$ to red. Which Excel tool must they use?
Conditional Formatting
Pivot Tables
Scenario Manager
Goal Seek
A student has a formula for their final grade. They want to see how their final score changes if they receive an A, B, or C on the last assignment. Which What-If Analysis tool is best for comparing these three fixed, distinct scenarios?
Pivot Tables
Scenario Manager
Data Tables
Goal Seek
To create an effect where a graphic object appears to move across a complex, winding path that is not available in the preset animation options, what specific animation feature would a designer need to apply?
Synchronizing animations
The Slide Master
Custom Motion Paths
Multimedia Integration
An autonomous vehicle uses its sensors and on-board computers to read and understand the text on a street sign in real-time. This specific ability to process the text is an application of which AI technique?
Recommendation Engines
Computer Vision
Natural Language Processing (NLP)
Speech Recognition
An AI developed to play a specific video game mastered it perfectly but is completely unable to perform a simple Google search or read a novel. Based on the lesson, this AI is classified as what?
Narrow AI (ANI)
Superintelligence
General AI (AGI)
Robotics
A government uses an AI-powered surveillance system that is highly effective but keeps its decision-making criteria completely secret, meaning no one can examine how it targets individuals. This system primarily violates which Responsible AI Principle?
Transparency
Accountability
Fairness
Narrow AI
An algorithm finds subtle, non-obvious correlations in training data (e.g., shoe size is related to job success) and overemphasizes them, leading to skewed or prejudiced outcomes. This source of bias is most specifically categorized under which element?
Bias from the Humans
Bias from the Algorithms
Algorithmic Bias (as a final outcome)
Bias from the Data
A homeowner is worried that a security vulnerability in their unsecure smart security camera could allow hackers to gain access to their password-protected home Wi-Fi. This is primarily a concern about the camera's Security because:
The camera collects sensitive personal video footage about the homeowner's life.
The camera's data might be sold to third-party marketing companies.
The homeowner cannot see the data processing steps used by the device.
The device's weak security credentials allow it to become a 'doorway' for hackers.
A team is training an AI for medical image analysis. They notice their training data is heavily skewed toward male patients. To minimize bias and ensure Fairness, what immediate action related to the data should they prioritize?
Ensure that the human programmers who wrote the code have diverse backgrounds.
Increase the computing power (Hardware) used to train the model, as this will automatically correct any data flaws.
Prioritize the collection of data for female patients to balance the initial input set.
Use the Scenario Manager to compare different versions of the final AI model.
Evaluate the sequence of events in a simple Smart Home system: A motion sensor detects movement → The data is sent via Wi-Fi → The server decides to activate the light → The Actuator turns on the light. If the central Data Processing/Cloud server suddenly crashes, where in this process will the system fail?
The system will fail because the Wi-Fi connection is no longer stable without the server.
The system will fail when the actuator attempts to turn on the light, as the actuator hardware is dependent on the server.
The system will fail before the motion sensor detects movement, as the sensor requires a signal from the cloud to start operating.
The system will fail after the data is sent via Wi-Fi, as the server will not be available to analyze the data and make a decision.
Which AI technology is primarily used for recognizing and interpreting visual information from the world, such as identifying objects in images?
Natural Language Processing (NLP)
Computer Vision
Machine Learning
Robotics
What is the primary function of a Sensor in an IoT system?
To perform actions based on received commands.
To provide a user interface for interaction.
To collect data from the environment.
To process and analyze data.
In the context of AI ethics, which principle emphasizes the need for AI systems to be fair and not discriminate against individuals or groups?
Robustness
Fairness
Accountability
Transparency
What is the primary function of the SUMIF function in Excel?
To create a conditional format for cells.
To sum a range of cells based on a specified condition.
To count the number of cells that meet a certain criterion.
To find the average of a set of values.
In the context of AI, what does Natural Language Processing (NLP) primarily focus on?
Understanding and generating human language.
Recognizing and interpreting visual data.
Controlling robotic movements and actions.
Analyzing large datasets for patterns.
Which Excel feature allows users to create a visual representation of data relationships through a diagram?
SmartArt
Charts
Tables
Conditional Formatting
What technology enables devices to communicate and exchange data over the Internet without human intervention?
Cloud Computing
Machine Learning
Internet of Things (IoT)
Blockchain
Which IoT application is designed to monitor and manage energy consumption in homes and buildings?
Wearables
Smart Home
Smart Industry
Smart City
In AI, which term refers to the ability of a system to learn from data and improve its performance over time?
Natural Language Processing
Data Mining
Deep Learning
Machine Learning
In Excel, which feature allows users to create a dynamic summary of data that can be easily manipulated and analyzed?
Conditional Formatting
Data Table
Pivot Table
Data Validation
