Q1. You are creating a spreadsheet that contains data about a volunteer theater production. You ask the volunteers which tasks they have already completed, then add that data to the spreadsheet. Next, you will use the information provided by the volunteers to figure out which tasks still need to be done. This is an example of which phase of analysis?

• Getting input from others
• Organizing data
• Transforming data

Q2. You are working with three datasets about voter turnout in your county. First, you identify relationships and patterns between the datasets. Then, you use formulas and functions to make calculations based on your data. This is an example of which phase of analysis?

• Organizing data
• Getting input from others
• Transforming data

Q3. You are working with a dataset from a local community college. You sort the students alphabetically by last name. This is an example of which phase of analysis?

• Transform data
• Get input from others
• Organize data

### Quiz- 2

Q1. Fill in the blank: A data analyst uses _____ to decide which data is relevant to their analysis and which data types and variables are appropriate.

• database relationships
• database references
• database organization
• database normalization

Q2. You are working with a dataset that lists student-athletes at a school. The Sport column designates the sport each athlete plays. Which of the following SQL queries would return only the athletes who play volleyball?

• WHERE Sport = “Volleyball”
• SPORT(“Volleyball”)
• WHERE Sport = Volleyball
• SPORT = “Volleyball”

### Quiz- 3

Q1. Which spreadsheet menu function is used to sort all data in a spreadsheet by the ranking of a specific sorted column?

• Sort Data
• Sort By Rank
• Sort Range
• Sort Sheet

Q2. In spreadsheets, data analysts can sort a range from the Data tab in the menu or by typing a function directly into an empty cell.

• True
• False

Q3. An analyst uses =SORT to sort spreadsheet data in descending order. What do they type at the end of their sort function?

• FALSE
• DESCEND
• LEFT
• REVERSE

### Quiz- 4

Q1. A data analyst is writing a SQL query to sort data in a column in ascending order. The column is called column_title. What is the correct syntax for their query?

• ORDER column_title ASC
• ORDER BY column_title
• ORDER BY column_title DESC
• ORDER column_title

Q2. You want to sort a database table of newly released young adult novels. Which statement sorts action novels by word count in descending order?

• WHERE genre = “Action” ORDER BY word_count DESC
• WHERE word_count DESC ORDER BY genre = “Action”
• WHERE genre = “Action” WHERE word_count DESC
• WHERE genre = “Action” SORT BY word_count DESC

Q1. In the data analysis process, which of the following refers to a phase of analysis? Select all that apply.

• Visualize the data
• Organize data into understandable sections
• Get input from others
• Format data using sorts and filters

Q2. During which phase of analysis can you find a correlation between two variables?

• Get input from others
• Organize data
• Transform data

Q3. You are performing a calculation during your analysis of a dataset. Which phase of analysis are you in?

• Transform data
• Get input from others
• Organize data

Q4. Typically, a data analyst uses filters when they want to expand the amount of data they are working with.

• True
• False

Q5. A data analyst is sorting spreadsheet data. They want to make sure that, when they rearrange the data, data across rows is kept together. What technique should they use to sort the data?

• Sort Column
• Sort Sheet
• Sort Together
• Sort Rows

Q6. A data analyst uses a function to sort a spreadsheet range between cells H1 and K65. They sort in ascending order by the first column, Column H. What is the syntax they are using?

• =SORT(H1:K65, 1, TRUE)
• =SORT(H1:K65, A, FALSE)
• =SORT(H1:K65, A, TRUE)
• =SORT(H1:K65, 1, FALSE)

Q7. A data analyst is querying a database that contains data about dental equipment inventory. They are only interested in data related to cleaning products. Which of the following sections of an SQL statement would return the correct result?

• WHERE “Cleaning”
• WHERE product = “Cleaning”
• ORDER BY “Cleaning”
• ORDER BY product = “Cleaning”

Q8. A data analyst would write the following section of a SQL query to sort Golden Retrievers, ordered by birth date, in ascending order:

``````WHERE Breed = "Golden Retriever" ORDER BY Birth_date
``````
• True
• False

### Quiz- 1

#### L2 Convert and format:

Q1. A spreadsheet cell contains the coldest temperature ever recorded in New Zealand: -22 °Celsius. What function could be used to display that temperature in Fahrenheit?

• =CONVERT(-22, C, F)
• =CONVERT(-22, F, C)
• =CONVERT(-22, “C”, “F”)
• =CONVERT(-22, “F”, “C”)

Q2. A data analyst wants to ensure spreadsheet tools continue to run correctly, even if someone enters the wrong data by mistake. Which data-validation menu option should they select?

• Deny Help Text
• Reject Invalid Inputs
• Forbid Entry
• Remove Validation

Q3. A data analyst clicks on the Format Cells If drop-down menu and selects the option Text Is Exactly November. This changes the color of all the cells that contain the word November. What spreadsheet tool is the analyst using?

• Conditional formatting
• CONVERT
• Filtering
• Data validation

### Quiz- 2

#### L3 Combine multiple data sets:

Q1. You are working on a project related to rental properties in the United States. You write the following query:

``````SELECT * FROM rentals.us_housing_units
``````

How can you instruct the database to retrieve only the first 10 results?

• RETRIEVE 10
• LIMIT 10
• RETURN 10
• FIRST 10

Q2. What function can be used to confirm that spreadsheet cell B8 contains exactly 20 characters?

• LEN = B8,20
• =LEN(20)
• LEN = B8
• =LEN(B8)

Q1. An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. What spreadsheet tool can help them select the right format?

• CURRENCY
• Format as Currency
• EXCHANGE
• Format as Dollar

Q2. You are creating a spreadsheet to help you with your job search. Every time you find an interesting job, you add it to the spreadsheet. Then, you want to indicate two possible options: Need to Apply or Applied. What spreadsheet tool will save you time by enabling you to create a dropdown list with Need to Apply and Applied as the possible options?

• Data validation
• FIND
• Conditional formatting

Q3. You are using a spreadsheet to keep track of your newspaper subscriptions. You add color to indicate if a subscription is current or has expired. Which spreadsheet tool changes how cells appear when values meet each expiration date?

• CONVERT
• Data validation
• Conditional formatting

Q4. A data analyst wants to write a SQL query to combine data from two columns and into a new column. What function can they use?

• CONCAT
• JOIN
• COMBINE
• GROUP

Q5. You are querying a database of ice cream flavors to determine which stores are selling the most mint chip. For your project, you only need the first 80 records. What clause should you add to the following SQL query?

``````SELECT flavors FROM ice_cream_table WHERE flavor = "mint_chip"
``````
• LIMIT = 80
• LIMIT_80
• LIMIT,80
• LIMIT 80

Q6. A data analyst is working with a spreadsheet that has very long text strings. They use a function to count the number of characters in cell G11. What is the correct syntax?

• =LEN(G,11)
• =LEN(G11)
• =LEN(G:G11)
• =LEN(“G11”)

Q7. Spreadsheet cell L6 contains the text string “Function.” To return the substring “Fun,” what is the correct syntax?

• =RIGHT(3,L6)
• =LEFT(L6, 3)
• =RIGHT(L6, 3)
• =LEFT(3,L6)

Q8. Fill in the blank: When working with a database, data analysts can use the _____ function to locate specific characters in a string.

• IDENTIFY
• WHERE
• FIND
• FROM

### Quiz-1

#### L2 Avoid common VLOOKUP pitfalls:

Q1. To change a text string in spreadsheet cell F8 to a numerical value, what is the correct function?

• =VALUE(F8)
• =MATCH(F8)
• =NUM(F8)
• =CONVERT(F8)

Q2. What is the purpose of an absolute reference within a function, such as “\$C\$3”?

• To remove unnecessary instructions from a formula or function
• To lock rows and columns so they won’t change when a function is copied
• To represent missing values in a formula or function
• To make formulas and functions unconditional

Q3. In VLOOKUP, TRUE tells the function to search for exact matches, and FALSE tells the function to look for approximate matches.

• True
• False

Q4. The following is a selection from a spreadsheet:

To search for the population of Nigeria, what is the correct VLOOKUP syntax?

• =VLOOKUP(“Nigeria”, A2:C10, 2, false)
• =VLOOKUP(Nigeria, A2:C10, 3, false)
• =VLOOKUP(Nigeria, A2:C10, 3, true)
• =VLOOKUP(Nigeria, A2,C10, 2, true)

Q5. The following is a selection from a spreadsheet:

To search for the height of the building in Mecca, what is the correct VLOOKUP syntax?

• =VLOOKUP(Mecca, A2:D7, 2, false)
• =VLOOKUP(Mecca, A2:D7, 2, true)
• =VLOOKUP(Mecca, A2,D7, 3, true)
• =VLOOKUP(“Mecca”, A2:D7, 3, false)

### Quiz-2

#### L3 Use JOINS to aggregate data in SQL:

Q1. A data analyst wants to retrieve only records from a database that have matching values in two different tables. Which JOIN function should they use?

• INNER JOIN
• RIGHT JOIN
• LEFT JOIN
• OUTER JOIN

Q2. You are writing a SQL query to instruct a database to count distinct values in a specified range. Which function should you include in your query?

• COUNT DISTINCT
• COUNT RANGE
• COUNT VALUES
• COUNT

Q3. A data analyst wants to temporarily name a column in their query to make it easier to read and write. What technique should they use?

• Aliasing
• Tagging
• Filtering
• Naming

### Quiz-3

#### L4 Work with subqueries:

Q1. Which of the following queries contain subqueries? Select all that apply.

• `SELECT call FROM recordings ORDER BY call.employee_id, call.start_time`
• `SELECT first_name, last_name FROM customers WHERE customer_id NOT IN (SELECT customer_id FROM customers WHERE store = 704)`
• `SELECT employee_id FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000)`
• `SELECT price FROM sales WHERE price = (SELECT MAX(salary) FROM sales)`

Q2. Fill in the blank: A data analyst uses aliasing to make it easier to read and write a query. Aliasing involves temporarily _____ a table or column in a query.

• hiding
• removing
• naming
• copying

Q1. Fill in the blank: Data aggregation involves creating a _____ collection of data that originally came from multiple sources.

• modified
• summarized
• localized
• expanded

Q2. A data analyst uses the SUM function to add together numbers from a spreadsheet. However, after getting a zero result, they realize the numbers are actually text. What function can they use to convert the text to a numeric value?

• FIGURE
• DIGIT
• VALUE
• CONVERT

Q3. When using VLOOKUP, there are some common limitations that data analysts should be aware of. One of these limitations is that VLOOKUP can only return a value from the data to the left of the matched value.

• True
• False

Q4. Fill in the blank: When writing a function, a data analyst wraps a table array in dollar signs. This is an _____ , which is used to lock the array so rows and columns don’t change if the function is copied.

• arbitrary reference
• accurate reference
• absolute reference
• authentic reference

Q5. The following is a selection from a spreadsheet:

To search for the population of Pakistan, what is the correct VLOOKUP syntax?

• =VLOOKUP(Pakistan, A2:B10, 3, false)
• =VLOOKUP(“Pakistan”, A2:B10, 3, false)
• =VLOOKUP(Pakistan, A2*B10, 2, false)
• =VLOOKUP(“Pakistan”, A2:B10, 2, false)

Q6. When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?

• OUTER
• RIGHT
• INNER
• LEFT

Q7. A data analyst writes a query that asks a database to return only distinct values in a specified range, rather than including repeating values. Which function do they use?

• RETURN
• COUNT DISTINCT
• RETURN VALUES
• COUNT

Q8. Which of the following terms describe a subquery? Select all that apply.

• Inner select
• Nested query
• Inner query
• Small query

### Quiz-1

#### L2 Data calculations:

Q1. What is the correct spreadsheet formula for multiplying 50 and 233?

• 50×233
• =50×233
• =50*233
• 50*233

Q2. The following is a selection of a spreadsheet:

You are trying to determine what percentage of your monthly income is spent on big-ticket items, such as rent and groceries. To add together only the values from Column B that cost more than \$150, what is the correct syntax?

• =SUMIF(B2:B12,”<150″)
• =SUMIF(B2:B12,>150)
• =SUMIF(B2:B12,<150)
• =SUMIF(B2:B12,”>150″)

Q3. A data analyst is working with a spreadsheet from a cosmetics company.

You may click the link to create a copy of the dataset: Cosmetics Inc.

Which of the following is an example of an array in this spreadsheet?

• All cells with number values
• All cells with values greater than 100
• The values in cells B2 through B31
• Cells D7 and D14

### Quiz-2

#### L3 Pivot tables:

Q1. The following is a sample pivot table from a furniture company:

What is the purpose of the pivot table in this spreadsheet?

• To organize all of the data into a smaller format
• To find the average price of each product
• To calculate purchase price data
• To summarize data about each product

Q2. The following is a sample pivot table from a furniture company:

How could the pivot table be adjusted to show the same data, but only for products categorized as beige?

• Add a filter to show only beige products
• Add a new column labeled beige
• Sort the current row by product color
• Summarize the values by product

Q3. The following is a sample pivot table from a furniture company:

The value added to the pivot table is the purchase price of the products.

• TRUE
• FALSE

Q4. The following is a sample pivot table from a furniture company:

Which spreadsheet tool should you use if you want to find an average value using values generated within a pivot table?

• A filter
• Conditional formatting
• A calculated field
• Data validation

### Quiz-3

#### L4 SQL calculations:

Q1. You are creating a query to request worker information from your database. You will use that information to calculate employees’ weekly pay. What clause would you include to store pay values in a new weekly_pay column?

``````SELECT Employee_ID, number_of_hours, Hourly_rate
FROM Wages_table
``````
• (number_of_hours * Hourly_rate) AS weekly_pay
• (weekly_pay * Hourly_rate) TO number_of_hours
• (weekly_pay * Hourly_rate) AS number_of_hours
• (number_of_hours * Hourly_rate) TO weekly_pay

Q2. In a SQL query, which calculation does the modulo (%) operator perform?

• It converts a decimal to a percent
• It finds the square root of a number
• It applies an exponent to a value
• It returns the remainder of a division calculation

Q3. You are working with a dataset with the column name “firstquarterexpenses.” How can you rename this column to make it more readable?

• Firstquarterexpenses
• first_quarter_expenses
• first+quarter+expenses
• first quarter expenses

### Quiz- 4

#### L5 Data validation:

Q1. The entire data validation process takes place before you begin your analysis.

• True
• False

Q2. You’re analyzing patient data for a healthcare company. During the data-validation process, you notice that the first date of service for some of the patients is later than the most recent date of service. Which type of data validation check are you completing?

• Data consistency
• Data structure
• Data type
• Data range

Q5. During analysis, you complete a data-validation check for errors in customer identification (ID) numbers. Customer IDs must be eight characters and can contain numbers only. Which of the following customer ID errors will a data-type check help you identify?

• IDs with text
• IDs that are repeated
• IDs in the wrong column
• IDs with more than eight characters

### Quiz- 5

#### L6 Using SQL with temporary tables:

Q1. When are temporary tables automatically deleted?

• After running a query in your SQL database
• After running a report from the table
• After completing all calculations in the table
• After ending the session in an SQL database

Q2. The following SQL query contains information about bike trips:

``````WITH 1_hr_trips AS (
SELECT *
FROM bigquery-public-data.new_york.citibike_trips
WHERE tripduration = 60
``````

What data will appear in the temporary table created through this query?

• The total number of bike trips
• Bike trips equal to or more than one hour
• A random subset of bike trips
• Bike trips that lasted exactly one hour

Q3. What benefit does a CREATE TABLE statement add to a temporary table?

• Access for anyone to use the table
• Automated calculations
• Specific naming conventions

Q1. You are analyzing sales data in a spreadsheet. Which of the following could you find out by using the MAX function?

• Total sales for the year
• Difference between two months of sales
• The month with the highest sales
• Sales per month over a year

Q2. A data analyst is working with a spreadsheet from a furniture company.

The analyst inputs a function to find the number of product prices that are less than \$150.00. Which formula will return that result?

• =SUMIF(G2:G30, “>150”)
• =COUNTIF(G2:G30, “<150”)
• =SUMIF(G2:G30, “<150”)
• =COUNTIF(G2:G30, “>=150”)

Q3. A data analyst is working in a spreadsheet and uses the SUMIF function in the formula below as part of their analysis.

`=SUMIF(A1:A25, "<10", C1:C25)`

Which part of this formula is the criteria or condition?

• “<10”
• A1:A25
• C1:C25
• =SUMIF

Q4. A data analyst is working in a spreadsheet and uses the SUMPRODUCT function in the formula below as part of their analysis.

`=SUMPRODUCT(A2:A10,B2:B10)`

How does the SUMPRODUCT function calculate the cell ranges identified in the parentheses?

• It multiplies the values in the first range, then multiplies the values in the second range.
• It adds the ranges, then multiplies them by the last value in the second array.
• It adds the values in the first range, then adds the values in the second range.
• It multiplies the ranges, then adds the sum of the products of the two ranges.

Q5. A data analyst creates a pivot table in a spreadsheet containing movie data.

If the analyst wants to summarize the data using the AVERAGE function in the Values menu, which spreadsheet columns could they add data from? Select all that apply.

• Box Office Revenue
• Budget
• Movie Title
• Genre

Q6. A data analyst uses the following SQL query to perform basic calculations on their data. Which types of operators is the analyst using in this SQL query? Select all that apply.

``````SELECT
Yes_Responses,
No_Responses,
Total_Surveys,
(Yes_Responses + No_Responses) / Total_Surveys AS Responses_Per_Survey
FROM
Survey_1
``````
• Subtraction
• Multiplication
• Division

Q7. A data analyst uses the following query to perform a calculation on a company’s inventory. Which of the following will be the return in the “Overstock” column for this query?

``````SELECT
Total_Inventory % Total_Stores AS Overstock
FROM
Shipment_1
``````
• The remainder when the values in “Total_Inventory” are divided by the values in “Total_Stores”
• The percentage of the “Total_Inventory” that is located in “Total_Stores”
• The difference between the values in “Total_Inventory” and the values in “Total_Stores”
• The combined total of the values in “Total_Inventory” and the values in “Total_Stores”

Q8. A data analyst completes a calculation in a SQL query using the AVG function. Which of the following best describes the return for this query?

``````SELECT
AVG (salary) AS avg_employee_salary
FROM
employees
WHERE
salary < 30000
``````
• The number of all salaries in the “employees” table
• A single average of all of the salaries less than \$30,000
• A single count of salaries that average less than \$30,000
• The annual salary for each employee

Q9. Use the following SQL query to answer the question:

``````SELECT
location,
SUM(customer_orders) AS total_orders
FROM
bulk_orders
``````

Which statement should you add after the FROM statement to organize rows by location?

• EXTRACT location
• WHERE location
• AS location
• GROUP BY location

Q10. Fill in the blank: The data validation process involves checking and rechecking the quality of your data to make sure that it is complete and _____. Select all that apply.

• cited
• accurate
• consistent
• secure

Share Data Through the Art of Visualization

Process Data from Dirty to Clean

Course 01: Foundations: Data, Data, Everywhere

Course 02: Ask Questions to Make Data-Driven Decisions

Course 03: Prepare Data for Exploration

Course 04: Process Data from Dirty to Clean

Course 05: Analyze Data to Answer Questions

Course 06: Share Data Through the Art of Visualization

Course 07: Data Analysis with R Programming

Course 08: Google Data Analytics Capstone: Complete a Case Study

##### Team Networking Funda

Welcome to the official Author Page of Team Networking Funda! Here, we are dedicated to unraveling the intricate world of networking, connectivity, and team dynamics. Our mission is to provide you with insightful, actionable advice and solutions that will help you build strong connections, foster collaboration, and achieve success in all aspects of your professional life.

🌐 Networking Insights: Dive into the art of networking with us, as we explore strategies, tips, and real-world examples that can elevate your networking game. Whether you're a seasoned pro or just starting, we have valuable insights to offer.

🤝 Team Synergy: Discover the secrets to creating high-performing teams. We delve into team dynamics, leadership, and communication to help you unlock the full potential of your team and achieve outstanding results.

🚀 Professional Growth: Explore the tools and techniques that can accelerate your professional growth. From career development to personal branding, we're here to guide you toward achieving your goals.

🌟 Success Stories: Be inspired by success stories, case studies, and interviews with experts who have mastered the art of networking and teamwork. Learn from their experiences and apply their insights to your journey.

💬 Engage and Connect: Join the conversation, leave comments, and share your own networking and team-building experiences. Together, we can create a vibrant community of like-minded professionals dedicated to growth and success.

Stay tuned for a wealth of resources that will empower you to excel in your professional life. We're here to provide you with the knowledge and tools you need to thrive in today's interconnected world.

We are Team Networking Funda, a group of passionate authors and networking enthusiasts committed to sharing our expertise and experiences in the world of networking and team building. With backgrounds in [Your Background or Expertise], we bring a diverse range of perspectives and insights to help you navigate the challenges and opportunities of professional networking and teamwork.

error: Content is protected !!