NEW
Font size
Worksheets1st Excel Assessment Gibburion Analytics
Total questions: 25
Worksheet time: 2mins
In a recent class project, Anika and Michael teamed up to dive into the fascinating world of data analysis from a local community survey. What do you think is their main goal in this exciting adventure?
Data destruction
Extracting useful information
Data collection
Ignoring patterns
In a lively group project, Daniel and Anika are brainstorming about the exciting steps involved in analyzing data. They can't help but wonder which of the following is NOT a part of the thrilling data analysis adventure?
Data Collection
Data Cleaning
Data Corruption
Data Visualization
During a lively class project, Scarlett and Liam were brainstorming about the types of data they could use for their exciting analysis. Which type of data do you think is typically used in data analysis?
Raw Data
Processed Data
Both A and B
None of the above
In a recent class project, Maya and Noah teamed up to dive into the exciting world of data analysis! They focused on which of the following activities?
Summarizing information
Generating insights from data
Both A and B
Only A
During a thrilling data adventure, Kai, along with her friends James and Luna, stumbled upon some data that was riddled with errors and inconsistencies. What exciting steps should they take to ensure their data is as accurate as possible?
Removing important data
Fixing errors or inconsistencies in data
Finding new data
All of the above
Hey there, Ibraheem Idris is embarking on an exciting journey into the world of data analysis! But before he dives in, he needs to know: What’s the very first step he should take in the data analysis process?
Data Visualization
Data Collection
Data Cleaning
Data Interpretation
In a thrilling group project, Noah and Priya teamed up to ensure their data sparkled with consistency and was completely free of errors. Can you guess during which phase they focused their superpowers on this task?
Data Cleaning
Data Collection
Data Visualization
None of the above
In an exciting class project, Avery and Rohan are on a mission to present their findings using vibrant charts and eye-catching graphs. What fun process are they using to bring their data to life?
Data Formatting
Data Visualization
Data Cleaning
Data Interpretation
In an exciting class project, Abigail, Liam, and Ngene Onyinyechi teamed up to dive into a fascinating dataset, eager to uncover hidden trends and relationships. Which process will help them explore these intriguing connections in the data?
Data Validation
Data Modeling
Data Analysis
Data Cleaning
Imagine Liam is diving into a thrilling project where he gets to analyze customer data! In this exciting journey, what does 'data transformation' mean for him?
Converting data into a different format for analysis
Deleting unneeded data
Changing the values of the data to random values
Reordering data points
During a lively group project, Lily and Zoe were brainstorming how to enter text, numbers, and formulas into their Excel spreadsheet. Can you guess the name of the magical feature they used to make it all happen?
Worksheet
Formula Bar
Ribbon
Cell Range
During a lively class project, Zoe and Abundance Agochukwu were brainstorming on how to best organize their data in Excel. They discovered that the magical spot where a row meets a column is called:
Formula Bar
Table
Cell
Function
In a thrilling group project adventure, Harper, Anika, and Scarlett are on a quest to master Excel! As they explore the interface, they discover magical tabs like File, Home, and Insert. Can you guess where these enchanting tabs are located in the window?
Status Bar
Ribbon
Worksheet
Formula Bar
In a thrilling group project, Liam and Ibraheem are diving into an Excel workbook. Which of the following keyboard shortcuts should they use to save their amazing progress?
Ctrl + C
Ctrl + Z
Ctrl + S
Ctrl + A
Hey there, Kai! If you want to jazz up your text in Excel with styles like bold or italic, where should you look for those options?
Ribbon > Home tab
File Menu
Formula Bar
Status Bar
During a lively group project in Excel, Benjamin and Liam were brainstorming about how to kick off their formulas. They were curious and excited to find out which symbol they should use to start writing their formulas.
+
$
=
%
In a lively group project, Ava, Oliver, Sophia, and James were brainstorming various Excel functions they could use. Can you spot which of the following is NOT an Excel function?
IF
SUM
CHART
AVERAGE
In a thrilling group project, Arjun and Noah are on a quest to uncover specific data hidden in their Excel spreadsheet. What magical Excel feature should they wield to find their treasures quickly?
Find and Replace
Data Filter
Both A and B
None of the above
In a lively classroom, Abigail and Rohan are having a spirited debate about how rows in a spreadsheet are labeled. Abigail insists that they are labeled with letters, while Rohan argues that they are labeled with numbers. What do you think?
Letters
Numbers
Both A and B
None of the above
In a lively group project, Zoe and her friend David were brainstorming creative ways to visualize their data. They were curious about which tab in Excel would let them insert eye-catching charts to showcase their findings.
Home
Insert
Data
View
Henry is on a quest to decide whether to invest in a thrilling new business venture! He’s curious if this investment will be a goldmine based on certain conditions. Can you help him understand what the IF function in Excel is used for?
Perform arithmetic calculations
Test a condition and return a value
Sort data
Find duplicates
In a lively group project, our friend Samuel is on a mission to ensure the team meets all the project requirements. Can you guess what the condition argument in their planning really specifies?
The specific tasks to complete
The logical test (True or False)
The resources needed for the project
The style of the presentation
Practical: Imagine our friend Mia is taking a test. If she scores 70 or above, she passes with flying colors; otherwise, she faces the dreaded fail! Which of the following is the correct IF function to help Mia determine her fate?
=IF(A1>=70,'Fail','Pass')
=IF(A1>=70,'Pass','Fail')
=IF(A1<70,'Pass','Fail')
=IF(A1>70,'Fail','Pass')
Hey there! Our friend Abigail is on a mission to tidy up her project data. She needs to swap out every instance of 'Male' with 'M' and 'Female' with 'F' in her data column. Which nifty Excel tool should she grab to make this happen?
IF function
Sort and Filter
Find and Replace
Conditional Formatting
Practical: Our friend Isla Johnson is on a mission to update a list of names in an Excel spreadsheet! Can you help her out? Which of the following steps correctly describe how to use the Find and Replace function in Excel?
Press Ctrl + F, type the text to find, click Replace, and enter the new text
Press Ctrl + R, type the new text, and click Replace All
Click the Data tab, select Replace, and input the text
Press Ctrl + Shift + F, select the Replace tab, and type the text
