WorksheetsUNIT 1 - Introduction to Data Analytics (Easy Notes)
Total questions: 94
Worksheet time: 47mins
What is Data? Data means ________.
information
confusion
noise
guess
Which of the following is an example of data? (Select all that apply)
Students' marks
Sales in a shop
Customer details
Weather reports
Fill in the blank: An example of 'Text' data is ________.
Name, City
12, 45
True, False
$100, $200
Fill in the blank: An example of 'Dates' data is ________.
10/03/2025
John Doe
$100.00
Blue
Fill in the blank: An example of 'Choices' data is ________.
Yes/No, Male/Female
Height in cm
Temperature in Celsius
Weight in kg
What is Data Analytics? Data Analytics is the process of ________.
collecting, analyzing, and interpreting data
creating visual art from data
ignoring data trends
randomly generating data
Fill in the blank: The first step in Data Analytics is ________ data.
Collecting
Analyzing
Visualizing
Reporting
Fill in the blank: Data Analytics helps us make smart decisions using ________.
data
guesses
luck
opinions
Which of the following is NOT a step in Data Analytics?
Collecting data
Organizing data
Ignoring data
Making good decisions
Fill in the blank: In Data Analytics, after collecting and organizing data, the next step is ________ (studying) data.
Analysing
Reporting
Visualizing
Summarizing
Data Analytics can help banks detect fraud and plan financial services.
True
False
Fill in the blank: In education, Data Analytics helps to improve teaching by analyzing ________ performance.
student
teacher
school
subject
Fill in the blank: The step in Data Analytics where you find patterns and trends is called _________.
Analyze Data
Collect Data
Visualize Data
Report Data
Fill in the blank: The tool used for basic analysis and charts and is easy for beginners is _________.
Excel
Photoshop
AutoCAD
Notepad
Which tool is similar to Excel and is used online?
Power BI / Tableau
Google Sheets
Python / R
Excel
Fill in the blank: For beginners, it is recommended to start with _________.
Excel
Photoshop
AutoCAD
MATLAB
Fill in the blank: Descriptive Analytics answers the question _________?
What happened?
Why did it happen?
What will happen?
What should we do?
Fill in the blank: Diagnostic Analytics answers the question _________
Why it happened?
What happened?
When did it happen?
Who was involved?
What will happen next? Fill in the blank: Next month ______ may increase.
sales
weather
colors
chairs
Type: Prescriptive Analytics What to do now? Fill in the blank: Increase ______ for next month.
stock
price
advertising
discounts
Fill in the blank: Data = ______
Information
Knowledge
Facts
Numbers
Fill in the blank: Data Analytics = Studying data to make ______ decisions.
better
random
slow
uninformed
guess
Excel is the best starting tool for beginners.
True
False
Which of the following is NOT a field where data analytics is used?
Banks
Hospitals
Business
Education
Cooking
What are the two main pieces of Excel's structure mentioned in the chapter?
Worksheets and cells
Charts and graphs
Formulas and functions
Rows and columns
What does the Ribbon in Excel provide?
Shortcuts to Excel commands
Access to the internet
Storage for files
Printing options
The Ribbon in Excel may look crowded and hard to understand at first, but it becomes easier to navigate as you learn more.
True
False
Fill in the blank: The Ribbon is made up by the App launcher, Tabs, Groups and ________.
Commands
Shortcuts
Widgets
Panels
What is the App launcher icon called in Office 365?
Navigation bar
Start menu
Ribbon
Taskbar
The App launcher allows you to access different parts of the Office 365 suite, such as Word, PowerPoint, and Outlook.
True
False
What is a tab in a spreadsheet application?
A) A button to do actions
B) A menu with sub divisions sorted into groups
C) A set of related commands
D) A cell reference
What separates groups in a spreadsheet application?
Thick horizontal line
Thin vertical line break
Bold text
Different colors
Commands are the buttons that you use to do actions.
True
False
The Sheet is a set of ______ and columns. Fill in the blank.
rows
cells
tables
pages
Values can be typed to cells.
True
False
What can values in spreadsheet cells be?
Only numbers
Only letters
Both numbers and letters
Only symbols
Each cell has its unique reference, which is its coordinates, this is where the columns and rows intersect.
True
False
What is the reference of the cell where 'Hello World' is typed?
B3
C4
D5
E2
Fill in the blank: The cell reference for the cell at the intersection of column D and row 7 is _______.
D7
7D
D-7
7-D
The first step to create two new sheets in a workbook is:
Click the 'Insert' tab and select 'New Sheet' twice.
Rename the existing sheets.
Delete all existing sheets before adding new ones.
Save the workbook before adding sheets.
What is the keyboard shortcut to create a new sheet in Excel?
Ctrl + N
Shift + F11
Alt + F4
Ctrl + S
What should you do to rename a sheet in Excel?
Right click on the sheet and select 'Rename'.
Double click anywhere on the Excel window.
Press Ctrl + R on your keyboard.
Go to File > Rename Sheet.
What is the third step after creating and renaming sheets in Excel?
Enter useful names for the three sheets.
Delete all the sheets.
Change the font color of the sheets.
Insert a chart in the first sheet.
What are the two main components of an Excel workbook?
A) Ribbon and Sheet
B) Cell and Row
C) Formula and Table
D) Chart and Graph
What is the Ribbon used for in Excel?
To enter data
To navigate and access commands
To format cells
To create charts
Chapter Summary: 3. The Sheet in Excel is made up of _________?
columns and rows
cells and formulas
charts and graphs
tables and images
Each cell in an Excel sheet has a unique reference, and you can add new sheets to your workbook and name them.
True
False
What does an Excel formula always begin with?
+
-
=
/
Excel formulas are important because they help to ________.
automate calculations
change font styles
insert images
print documents
Which of the following is NOT a reason why Excel formulas are important?
Efficiency
Data analysis
Increases internet speed
Accuracy
Fill in the blank: Excel formulas ensure consistent and ______ results, essential in fields like finance and accounting.
accurate
random
delayed
approximate
Which Excel formula is used to find the sum of a range of cells?
SUM()
AVERAGE()
COUNT()
MAX()
Name any two basic Excel formulas/functions mentioned in the passage.
SUM and AVERAGE
VLOOKUP and CONCATENATE
IF and INDEX
COUNTIF and MATCH
Excel formulas are only useful for technical users.
True
False
Fill in the blank: Excel offers ______ formula options to meet specific data handling needs.
customizable
limited
automatic
fixed
The SUM() function in Excel gives the total of the selected range of cell values. Based on the example provided, what is the result of =SUM(C2:C4)?
A) 1065
B) 1165
C) 1160
D) 1060
Based on the example provided, what is the formula to find the average of the total sales in cells C2, C3, and C4?
AVERAGE(C2, C3, C4)
SUM(C2, C3, C4)
AVERAGE(C2:C4)
TOTAL(C2, C3, C4)
What is the result of the formula =AVERAGE(C2,C3,C4) in the Excel sheet?
A) 388.3333333
B) 1165
C) 300
D) 3
What does the AVERAGE function in Excel do?
Counts the number of cells
Calculates the sum
Automatically calculates the average
Multiplies the values
Fill in the blank: The COUNT() function in Excel counts the total number of cells in a range that contains a _______.
number
formula
text
date
What is the result of the formula =COUNT(C1:C4) in the Excel sheet?
A) 3
B) 4
C) 388.3333333
D) 1165
As seen above, here, we are counting from C1 to C4, ideally four cells. But since the COUNT function takes only the cells with numerical values into consideration, the answer is ___ as the cell containing “Total Sales” is omitted here.
3
2
4
1
If you are required to count all the cells with numerical values, text, and any other data format, you must use the function ______.
COUNTA()
COUNT()
SUM()
AVERAGE()
Which Excel function is used to count the number of blank cells present in a range of cells?
COUNT()
COUNTA()
COUNTBLANK()
SUM()
Excel can import and export many different file types aside from the standard .xlsx format.
True
False
To export data from Excel to a format that can be interpreted by other programs, such as a text or CSV file, which steps should you follow?
True
False
COUNTA() does not count any ______ cells.
blank
numeric
text
formula
What does 'Text (Tab delimited)' mean? The cell data will be separated by a _______.
tab
comma
semicolon
space
What does 'CSV (Comma delimited)' mean? The cell data will be separated by a _______.
comma
semicolon
space
tab
What does 'Formatted Text (space delimited)' mean? The cell data will be separated by a _______.
space
comma
semicolon
tab
What option should you select if you want to choose a different file type when the Save As dialog box appears?
Save as Another File Type
Open Recent File
Print Document
Close Window
What should you do after specifying where you want to save the file in Excel?
Click Open
Click Save
Click Cancel
Click Close
After clicking Save, what should you do if a dialog box appears stating that some workbook features may be lost?
Click No
Click Cancel
Click Yes
Click Retry
To import data from external sources in Excel, first click the ______ tab on the Ribbon.
Data
Home
Insert
Review
To import data from external sources in Excel, after clicking the Data tab, what button should you click?
Get Data
Insert Table
Sort & Filter
Pivot Table
Which menu option should you select in Excel to import data from a Text/CSV file?
From Workbook
From Text/CSV
From XML
From JSON
What should you do if a security notice appears while importing external data, stating that it is connecting to an external source that may not be safe?
Click OK.
Ignore the notice and continue.
Disable your antivirus software.
Share your password with the source.
If you have data to import from Access, the web, or another source, what should you do in the Get External Data group?
Select one of those options in the Get External Data group instead.
Ignore the Get External Data group and enter data manually.
Delete the existing data before importing new data.
Use the Print option to import data.
Step 7: ______ the preview looks correct.
Verify
Ignore
Delete
Skip
Step 8: Click ______.
Load
Save
Exit
Refresh
Fill in the blank: Data cleaning in Excel involves preparing your data for analysis by ensuring it's in a ______ format.
usable
raw
corrupted
incomplete
Proper data cleaning is crucial in Excel because:
It ensures accurate analysis and results.
It makes Excel run faster.
It automatically creates charts.
It increases the number of rows allowed.
Which of the following is NOT a part of data cleaning in Excel?
Removing blank cells
Eliminating duplicates
Adding random data
Standardizing formats
Which Excel feature helps you remove duplicate entries from your data?
Data Validation
Remove Duplicates
Format Cells
Clean
What is the first step to remove duplicates in Excel?
Select the data range.
Click on the 'Sort' button.
Open a new worksheet.
Type 'Remove Duplicates' in a cell.
To standardize formats in Excel, which option should you choose after right-clicking the selected data range?
Remove Duplicates
Format Cells
Data Validation
Clean
Which Excel function removes leading and trailing spaces from text data?
CLEAN
TRIM
PROPER
FORMAT
The CLEAN function in Excel is used to ________.
Eliminate non-printable characters.
Remove duplicate values.
Format numbers as currency.
Sort data alphabetically.
What does the PROPER function do in Excel?
Capitalizes the first letter of each word.
Converts all text to lowercase.
Removes all spaces from the text.
Reverses the order of characters in the text.
Data validation in Excel can specify the type of data and the range of valid values that can be entered into a cell.
True
False
When filling missing values in Excel, you can calculate the ________ or median of surrounding data.
average
sum
maximum
mode
What is the purpose of using conditional formatting in Excel?
To highlight errors or anomalies in your data
To sort data alphabetically
To create charts
To merge cells
Which of the following can you do using conditional formatting in Excel?
Highlight blank cells
Identify invalid characters
Both A and B
None of the above
Power Query is a tool in Excel that can be used to ______ and transform your data.
clean
encrypt
delete
