NEW
Font size
WorksheetsPart V of the UPSKILL
Total questions: 50
Worksheet time: 25mins
Which Excel function is specifically designed to remove all spaces from a text string, except for single spaces between words?
CLEAN
REMOVE.SPACES
TRIM
SUBSTITUTE
What is the primary purpose of the CLEAN function in Microsoft Excel?
To remove all numerical characters from a text string.
To remove leading, trailing, and excessive spaces from text imported from another source.
To convert all text to lowercase.
To remove non-printable characters (control characters) from a text string, which often appear when importing data from external applications.
In the function =SUBSTITUTE(A1, "old", "new", 2), what does the argument 2 represent?
The total number of times the substitution should be made.
The cell column reference where the new text begins.
The instance number, indicating that only the second occurrence of 'old' should be replaced with 'new'.
The number of characters in the old text string.
Which of the following is the primary benefit of using Conditional Formatting in a spreadsheet?
To perform complex calculations based on multiple criteria.
To automatically sort and filter data based on user-defined labels.
To prevent users from entering invalid data into specific cells.
To apply visual styling (e.g., color scales, icon sets) to cells based on the value or a logical test, aiding in data visualization and analysis.
In a Pivot Table, which field area is typically used to display calculations, such as sums, averages, or counts?
Filters
Columns
Values
Rows
Which of the following accurately describes the function of the VLOOKUP function?
It calculates the total value of cells that meet a single specified criterion.
It retrieves a value from a table by searching vertically in the first column and returning a value from a specified column in the same row.
It creates a dynamic summary table from a large dataset.
It is used to join data from two different worksheets based on a common field.
When comparing the TRIM and CLEAN functions, which statement is true?
TRIM removes spaces, and CLEAN removes specific text strings.
TRIM is used for numerical data, and CLEAN is used for text data.
CLEAN removes non-printable characters, and TRIM removes excess spaces.
CLEAN removes all spaces, and TRIM removes only leading and trailing spaces.
What is the primary output of a well-designed Pivot Table?
A flat database that can be used directly for data entry.
A chart showing the trend of all individual data points over time.
A detailed, row-by-row list of all source data entries.
A dynamic, summarized view of the source data, aggregated by categories and metrics.
Which type of Conditional Formatting rule would you use to highlight the top 10 largest numerical values in a specific range of sales data?
Highlight Cells Rules
Color Scales
Top/Bottom Rules
Icon Sets
In the function =VLOOKUP(A2, B:D, 3, FALSE), what is the purpose of the final argument, FALSE?
It indicates that the lookup value must be text, not a number.
It tells Excel to search horizontally (HLOOKUP) instead of vertically.
It specifies that an exact match for the lookup value is required.
It forces the data in the lookup array (B:D) to be sorted in descending order.
What is the main purpose of the “Elements” tab in Canva?
To upload personal photos and files
To insert shapes, icons, lines, graphics, and charts into a design
To edit text formatting
To share your design with others
Which Canva tool allows you to add and customize written content in your design?
Text Tool
Elements Tool
Uploads Tool
Background Tool
What is the function of the “Uploads” feature in Canva?
To download completed designs
To import personal images, videos, or logos for use in a project
To search for free templates
To add shapes and icons
Which tool in Canva lets you adjust colors, transparency, and filters on an image?
File Manager
Edit Image Tool
Resize Tool
Animate Tool
The “Templates” section in Canva helps users by:
Providing ready-made design layouts for presentations, reports, and posters
Automatically analyzing data in spreadsheets
Creating animation effects
Converting text to charts
What is the function of the “Background” tool in Canva?
To insert icons and shapes into a project
To change the color, texture, or image behind your main design elements
To add text boxes and captions
To upload personal media files
Which Canva tool lets users move, resize, or rotate objects on the design canvas?
Position Tool
Adjust Tool
Animate Tool
Magic Resize Tool
In Canva, what does the “Animate” option do?
It applies motion effects to text or objects, making designs more dynamic
It automatically creates a video file from static images
It changes the background color
It adds hyperlinks to external websites
The “Share” button in Canva allows users to:
Print designs directly
Invite others to view or edit the design through links or email
Save designs only to local storage
Delete unwanted files
What is the purpose of the “Folders” feature in Canva?
To organize designs, images, and brand assets for easy access and management
To create new blank templates
To apply color filters
To export files in PDF format
Which Canva feature allows users to convert raw data into clear, visually appealing charts and graphs?
Magic Write
Data Visualization (Charts) Tool
Background Remover
Brand Kit
The “Brand Kit” feature in Canva is most useful for:
Creating consistent color schemes, logos, and fonts for all organizational designs
Storing raw analytical data
Generating automatic financial summaries
Converting slides to video presentations
Which Canva feature helps users quickly generate design layouts or visual concepts using text prompts?
Magic Design
Team Collaboration
File Manager
Smart Resize
In Canva, what is the advantage of using “Smart Resize”?
It automatically adjusts your design to different formats (e.g., reports, slides, posters) without manual editing
It changes the color theme to match your data
It compresses image file sizes for email
It translates text into multiple languages
When presenting analytical findings, which Canva feature allows teams to collaborate and comment on visuals in real time?
Version History
Real-Time Collaboration and Commenting Tools
Offline Editing Mode
Canva Assistant
How can Canva for Education best support planning officers in their analytical work?
By generating statistical computations automatically
By transforming analytical data into clear, visually appealing reports and presentations
By storing and securing confidential datasets
By conducting advanced data modeling
When creating an analytical report in Canva for Education, which design element helps communicate data most effectively?
Decorative icons and illustrations
Color-coded charts, graphs, and infographics
Long paragraphs of text explaining each data point
Complex animations and transitions
Which of the following best describes a professional use of Canva for Education for planning and analysis teams?
Designing visually enhanced dashboards, strategy briefs, and performance reports
Building databases for storing numerical data
Conducting real-time statistical regressions
Writing financial codes for audit systems
Canva for Education allows collaborative editing, which benefits planning officers by:
Letting multiple team members co-edit analytical visuals and reports in real time
Limiting access to one editor to prevent data loss
Replacing the need for spreadsheet collaboration
Generating automatic analysis summaries
To ensure data visualization in Canva for Education aligns with analytical best practices, planning officers should:
Use consistent color schemes, clear labeling, and simplified visuals to highlight key insights
Prioritize artistic effects over clarity
Include as much raw data as possible in one slide
Avoid using graphs or charts altogether
Which sentence demonstrates the correct use of subject-verb agreement when referencing enrollment data in a District Report?
Each of the 60 teachers were provided with a new Learning Resource Management System (LRMS) tablet.
Neither the principal nor the supervisors has reviewed the liquidation report yet.
The number of absent learners are slightly higher this month than the last.
The latest set of achievement test scores confirms the learning gaps in Math.
In the context of an official DepEd memo, which sentence is the most precise and concise, avoiding unnecessary wordiness?
It is incumbent upon us to make certain that the mandatory health protocol is followed by all personnel.
In the final analysis, we have come to the conclusion that a remedial session is needed for the Grade 4 students.
All personnel must ensure strict compliance with the mandatory health protocol.
The reason why the budget was exceeded is due to an unexpected surge in maintenance costs.
Which sentence uses the Active Voice to clearly establish accountability for the action in a School Improvement Plan (SIP) progress report?
A complete inventory of school supplies has been successfully conducted.
The new financial report was signed by the School Head yesterday.
The Curriculum Implementation Division (CID) reviewed and approved all submitted action research papers.
Significant improvements were noted in the classroom assessment tools.
Which sentence contains a dangling modifier, creating an ambiguous or illogical connection between the analysis and the finding?
While checking the physical facilities, the school canteen was found to need repair.
Guided by the DepEd Order, the school established its child protection policy.
To accurately assess student literacy, the pre-test was administered by the Grade 7 adviser.
Having completed the validation process, the final list of beneficiaries was posted on the bulletin board.
Which sentence uses parallel structure correctly to list key data points or action items in a report, ensuring grammatical precision?
The team’s mandate included: analyzing the assessment results, to write a summary report, and presenting the findings to the committee.
The monitoring report highlights four areas for improvement: budget management, staffing issues, being effective with time, and communication protocols.
Three critical interventions were implemented: (1) providing remedial classes, (2) strengthening parental involvement, and (3) monitoring student attendance.
We need to either update the curriculum or to procure new textbooks for the K to 12 program.
Which option is the most effective and informative caption for a chart showing a School’s Monthly Enrollment (SY 2024-2025)?
Data showing how many students are in school from June to November.
Enrollment for the current school year.
Figure 1. Comparison of total learner enrollment by month, showing an overall increase from June to November (SY 2024-2025).
Figure 1. Enrollment Data.
When labeling a bar chart in a Division Report, which choice represents the most appropriate and standardized label for the vertical axis (y-axis)?
No. of Teachers (in hundreds)
Total Count of Permanent Teaching Personnel
How many teachers are working?
Teachers
Which principle is most critical when writing slide notes for a presentation to the Regional Office about student performance data?
The slide notes should include definitions of all technical terms (like NAT, Phil-IRI) and elaborate on the key data insights shown visually.
The slide notes should contain only references and citations.
The slide notes should contain every single word spoken during the presentation for reading verbatim.
Slide notes should be written in all capital letters to ensure visibility during the presentation.
A table in a report shows the budget utilization rate. Which label is least appropriate for a column showing the 'Percentage of Funds Disbursed'?
Funds Disbursed Ratio (Percent)
% Disbursed
BUDGET
Utilization Rate (%)
What is the primary purpose of including an explanatory Caption or Slide Note for a data visualization (chart, graph, or table) in a DepEd report?
To repeat the exact data points that are already visible in the chart.
To state the main takeaway or conclusion drawn from the data so the reader does not have to interpret the visual alone.
To provide the name of the person who created the visual.
To fill up space on the page or slide so it doesn't look empty.
1. Which of the following is a correct formula for a filter formula if you want filter enrollment data only for SDO Naga City? (Table name: “BOSY2425”; Column Name: “Division”)
=FILTER(BOSY2425[Division]=“Naga City”,BOSY2425)
=FILTER(BOSY2425,BOSY2425[Division]=“Naga City”)
=FILTER(BOSY2425,[Division]=“Naga City”)
=FILTER(BOSY2425=“Naga City”,BOSY2425)
Which of the following tools can quickly filter data for your dashboard?
Slicers
Conditional Formatting
Sort
Find duplicates
If you want to show the comparison of male and female enrollment in relation to its totality, which of the following charts is most appropriate?
Line graph
Stock
Funnel
Pie Chart
Which of the following formula will give you a running total of filtered enrollees in the range C2:C500?
=SUM(C2:C500)
=SUMIF(C2:C500,C2)
=SUBTOTAL(9,C2:C500)
=SUBTOTAL(C2:C500,9)
When you click your dashboard’s slicer, only 1 pivot chart changes while the rest are static. Which of the following will most likely solve this issue?
Delete the slicer and add new from the other pivot tables
Add a separate slicer for each pivot chart
Right click on the slicer, click “report connections” and check all pivot tables
None. This issue cannot be resolved due to MS Excell’s limitations
In your Pivot table, you want to show the total enrollment by municipality. In the PivotTable Fields pane, there are four areas where you can drag columns from your data source. In which area should you drag the “Municipality” field?
Filters
Coumns
Rows
Values
In your Pivot table, you want to show the total enrollment by municipality. In the PivotTable Fields pane, there are four areas where you can drag columns from your data source. In which area should you drag the “Enrollment” field, which contains the actual enrollment values?
Filters
Columns
Rows
Values
In your Pivot table, you want to show the total enrollment for Key Stage 2, which is the sum of enrollment from grade 4 to grade 6. However, there is no specific column from your data source for key stage 2, but there are specific enrollment data for each grade level. Which of the following will most likely give you this column in your pivot table?
Calculated field
Filter Connections
Refresh data
Relationships
Analyze the formula:
=IFERROR(GETPIVOTDATA("K12 Total",Pivot_Sector!$A$3,"Sector","Public"),"")
Which of the following is the feature of this formula?
The cell will be blank if there is no data available
The cell will return #REF if there is no data available
The cell will show “None” if there is no data available
The cell will hide the formula if there is no data available
In your dashboard, you want to show a list of schools based on the active filters. You want your list to look like a proper table with complete borders. But you also don’t want to show blank table cells if the filters lead to a smaller number of schools to be shown. Which of the following will most likely make you achieve this?
Borders and Shading
Conditional Formatting
Fill cell color
Cell styles
