TLE 6 LESSONS

  Utilizing Functions and Formulas in Electronic Spreadsheets for Advanced Calculations By Pj Miana ( TLEIE6-0f-12)   1. Understanding Functions and Formulas:   - Functions and formulas are essential tools in electronic spreadsheets for performing calculations and data analysis. - Functions are predefined formulas built into spreadsheet software that perform specific tasks or calculations. - Formulas are user-defined expressions that use operators, cell references, and functions to perform calculations.   2. Common Functions Used in Spreadsheets:   - SUM Function: Adds up a range of cells to calculate their total. - AVERAGE Function: Computes the average of a range of cells containing numerical data. - MAX and MIN Functions: Identify the maximum and minimum values within a range of cells. - IF Function: Allows for conditional calculations based on specified criteria. - COUNT Function: Counts the number of cells in a range that contain numbers.   3. P

 [Q3] TLE 6 Q3 PT REVIEWER Test I. Direction: Encircle the letter of the correct answer. 1) What are the basic materials needed to make an AC extension cord? A) Hammer, nails, and wood B) Scissors, paper, and glue C) Electrical wire, plug, and socket D) Thread, needle, and fabric   2) Which of the following is NOT a step in making an AC extension cord? A) Cut the wire to the desired length. B) Strip the ends of the wire. C) Connect the wires to the plug and socket. D) Cover the wire with paint.   3) Who can make an AC extension cord? A) Only licensed electricians B) Anyone who has the right materials and knows the steps C) Only adults over the age of 30 D) Only people with a college degree   4) Where can you buy the materials needed to make an AC extension cord? A) At the grocery store B) At the toy store C) At the hardware store D) At the clothing store   5) What is the purpose of making an AC extension cord? A) To have a new toy to