Free Printable ICT5 Quarter 2 Quiz no. 2 Review

Worksheets

ICT5 Quarter 2 Quiz no. 2 Review

Total questions: 40

Worksheet time: 2hrs 0mins

Name

Class

Date

Add Cells A1 and A2. Please write the correct formula.

(a)

Subtract Cells B1 and B2. Please write the correct formula.

(a)

Multiply Cells C1 and C2. Please write the correct formula.

(a)

Divide Cells D1 and D2. Please write the correct formula.

(a)

Calculate E1 raised to the power of E2 (Exponent). Please write the correct formula.

(a)

Add Cells F1 and F2. Please write the correct formula.

(a)

Subtract Cells: G1 and G2. Please write the correct formula.

(a)

Multiply Cells: H1 and H2. Please write the correct formula.

(a)

Divide Cells: I1 and I2. Please write the correct formula.

(a)

10.

Calculate J1 raised to the power of J2 (Exponent). Please write the correct formula.

(a)

11.

Find the sum of cells A1 to A12 and write the correct formula using a function.

(a)

12.

Find the average of cells B1 to B12 and write the correct formula using a function.

(a)

13.

Find the count of cells C1 to C12 and write the correct formula using a function.

(a)

14.

Find the maximum number in cells D1 to D12 and write the correct formula using a function.

(a)

15.

Find the minimum number in cells E1 to E12 and write the correct formula using a function.

(a)

16.

Find the sum of cells F1 to F12 and write the correct formula using a function.

(a)

17.

Find the average of cells G1 to G12 and write the correct formula using a function.

(a)

18.

Find the count of cells H1 to H12 and write the correct formula using a function.

(a)

19.

Find the maximum number in cells I1 to I12 and write the correct formula using a function.

(a)

20.

Find the minimum number in cells J1 to J12 and write the correct formula using a function.

(a)

21.

After creating a pie chart for renewable energy usage, how does Thea add a title to explain what it shows?

Use the Chart editor to write a title.

Click on the chart and select “Add Title.”

The title will show up automatically from the data.

22.

After making a pie chart about climate action projects, Amber needs to update it with new information. What can Amber do?

Change the data in the original list; the chart will update automatically.

Delete the chart and create a new one.

Right-click the chart and choose “Update Data.”

23.

After making a pie chart about food aid programs, Charlize wants to add labels to show the percentage for each slice. How can Charlize do this?

Click on the three dots on the chart and select “Edit chart.”

Click on each slice to add labels himself.

Right-click the chart and choose “Add Labels.”

24.

Alex wants to show the percentage distribution of expenses in a household budget. Which chart is most suitable?

A pie chart illustrating the percentage of each expense category.

A bar chart comparing total expenses over several months.

A line chart showing changes in expenses over time.

25.

Ava needs to analyze a dataset of product sales and wants to see only those above $100. What should she do?

Apply a filter to show only sales greater than $100.

Sort the sales data from highest to lowest.

Create a pie chart to visualize all sales.

26.

Before creating her pie chart, Shiloh wants to compare how different regions are affected by climate change. What should Shiloh do first?

Sort the data by region.

Change the chart to a line graph.

Filter to show only regions with serious climate issues.

27.

Emily wants to quickly find the top five salespeople in her report. What should she do?

Sort the sales data in descending order to see the top performers first.

Filter the data to hide all but the lowest performers.

Create a pie chart of all salespeople's performance.

28.

How do sorting and filtering differ in Google Sheets?

Sorting changes the order of rows; filtering conceals rows.

Sorting removes rows; filtering adjusts visibility.

Sorting is applicable only to text; filtering can be used with all data types.

29.

Jamie created a pie chart for the team’s project contributions, but it looks too cluttered. What can Jamie do?

Simplify the chart by limiting it to the top contributors.

Add more colors and patterns to distinguish each segment.

Convert it to a table format for clarity.

30.

Liam is reviewing a list of tasks and wants to prioritize the most urgent ones at the top. What action should he take?

Sort the tasks by their priority level in ascending order.

Filter out all tasks that are not marked as urgent.

Create a line chart to show the completion status over time.

31.

Morgan has survey data showing how people prefer to spend their leisure time. What type of chart should Morgan use?

A pie chart to represent the percentage of each leisure activity.

A scatter plot to show the correlation between activities.

A bar chart showing the total number of participants for each activity.

32.

Neo wants to make a pie chart to show different types of food given to people in need. What’s the first thing Neo should do?

Select the data and insert a chart.

Sort the food types.

Filter to show only healthy food types.

33.

Rylaind has a list of programs that help reduce poverty. How can Rylaind see only the programs that helped more than 1,000 people?

Filter the list to show only programs that helped more than 1,000 people.

Sort the list by name.

Make a pie chart with all the programs.

34.

Sean’ pie chart showing food distribution has too many pieces and is hard to read. What can Sean do to make it simpler?

Filter out the smaller food types before making the chart.

Sort the data.

Change the chart to a bar graph.

35.

Sophia has a dataset containing various product categories and their sales. She wants to focus only on electronics. What’s the best approach?

Use the filter to show only the electronics category.

Sort the dataset by sales figures to see electronics at the top.

Create a bar chart to display all product categories.

36.

Stella created a pie chart showing water projects. To change the color of the "Community Wells" part, what should Stella do?

Click on the slice and choose a new color.

Delete the chart and start again.

Change the funding amount in the data.

37.

Taylor needs to display how students voted on different lunch options for a class project. What’s the best approach?

Create a pie chart showing the percentage of votes for each option.

Use a bar chart to compare the total votes for each option.

Make a line chart to track voting trends over time.

38.

Which statement provides the best definition of a pie chart?

A circular chart segmented into parts, illustrating proportions of a whole.

A chart that employs bars to compare various categories of data.

A chart that connects data points with lines to indicate trends over time.

39.

While explaining a pie chart showing the breakdown of a company’s sales by product type, Jordan is asked about the significance of the smallest segment. What should Jordan say?

Even small segments can represent important niche markets.

It doesn’t matter; focus on the larger segments instead.

Small segments are only relevant in very large datasets.

40.

Zeque wants to show the top 5 countries using renewable energy. What should Zeque do?

Sort the countries by renewable energy use and then filter.

Pick the top 5 countries himself.

Make a pie chart with all the countries.

Reset

ICT5 Quarter 2 Quiz no. 2 Review

Total questions: 40

Worksheet time: 2hrs 0mins

Similar Resources on Wayground