Operation on functionDirection Solve the FollowingIf you answer this all worksheet Im gonna give you brainly answer ​

1. Operation on functionDirection Solve the FollowingIf you answer this all worksheet Im gonna give you brainly answer ​

Answer:

1. a

2. b

do we need the solution?

2. B. Direction: State five (5) common Excel Functions. Write their use in worksheet operations.1. 2. 3. 4. 5.​

Answer:

1.VLookup Formula.

2.Pivot Tables.

3.Remove Duplicates.

4.Text to Columns.

5.Concatenate Formula.

3. Complete the worksheet below with what have you learned regarding operations on functions. Write your own definition and steps on performing each functions operation. You may give your own example to better illustrate your point. Addition Subtraction Multiplication Division Composition​

OPERATION ON FUNCTION

1. Addition

Assume we have two functions, f(x) and g(x) . The sum of these two functions is defined as,

(f + g)(x) = f(x) + g(x)

Example:

Consider f(x) = 3x + 1 and g(x) = x + 3

(f + g)(x) = f(x) + g(x)f(x) + g(x) = 3x + 1 + x + 3f(x) + g(x) = 4x + 4

2. Subtraction

Assume we have two functions, f(x) and g(x) . The differentiation between these two functions can be expressed as follows:

(f - g)(x) = f(x) - g(x)

Example:

Consider f(x) = 3x + 1 and g(x) = x + 3

(f - g)(x) = f(x) - g(x)f(x) - g(x) = 3x + 1 - (x + 3)f(x) - g(x) = 3x + 1 - x - 3f(x) - g(x) = 2x - 2

3. Multiplication

Assume we have two functions, f(x) and g(x) (x). The product of these two functions is defined as,

(f . g)(x) = f(x) . g(x)

Example:

Consider f(x) = 3x + 1 and g(x) = x + 3

(f . g)(x) = f(x) . g(x)f(x) . g(x) = (3x + 1)(x + 3)  f(x) . g(x) = 3x·x + 3x·3 + 1·x + 1·3f(x) . g(x) = 3x² + 9x + x + 3f(x) . g(x) = 3x² + 10x + 3

4. Division

Assume we have two functions, f(x) and g(x) (x). The division of these two functions is defined as,

(f / g)(x) = f(x) / g(x), where g(x) ≠ 0

where x belongs to both f and g's domains We must specify g(x) ≠ 0 because we cannot divide by zero.

Example:

Consider f(x) = 3x + 1 and g(x) = x + 3

(f / g)(x) = f(x) / g(x)f(x) / g(x) = (3x + 1)/(x + 3)  

Learn more about Function Composition here:

brainly.ph/question/6112926

#SPJ2

4. B. Directions: Choose only the letter of the correct answer.1. An application program designed to perform basic mathematical andarithmetic operations.a. MS Excelb. Electronic spread sheet c. Arguments2. It can be a form of numbers, cell references, or texts.a. Functionsb. Argumentsc. Formulas3. Are combinations of functions, operands, and operators. These areused when you are manually calculating.a. Formulasb. Functionsc. MS Excel4. It is a calculation that return a result.a. Electronic spread sheet b. Formulasc. Functions5. It is one example of the most commonly used computerizedworksheetsa. Formulasb. Functionsc. MS Excel​

Answer:

1.a

2.b

3.a

4.b

5.c

Explanation:

not sure

5. Complete the worksheet below with what have you learned regarding operations on functions Write your own delinition and steps on performing each functions operation You may give your own example lo better illustrate your point Addittion Subtruction Multiplication Division Composition​

Answer:

ADDITION

Their sum, denoted by +, is the function denoted by (+)()=()+().

ex.(+)()=()+()

=(x +10) +(3+2)

=4x+12

SUBTRACTION

Their difference, denoted by -, is the function denoted by (-)()=()-().

ex.(-)()=()-()

=(5x+8)-(4x+6)

=X+2

6. Given the worksheet below, Use the necessary Excel function to compute for the following. Write formulas you used and the answer on the blanks​

Answer:

Formula used:

Count

Explanation:

Count the numbers of values entered in row 4?

Answer:

Basahin mo mamamammammammaammama

7. Add charts and graCan print the spreadsheets created.ing Task No. 2: Arrange the jumbled letters to form the correct answer in each1. It is designed with functions and formulas that will make calculating numericaleasier and convenient for you. (REEHTSSEAPDS)______2. These are calculations that return a result. (TNIOUNFSC)visual representation of data in worksheet of the spreadsheet program. It3. It is visual representation of data in worksheet of the spreadsheet program. It makes easy to study and interpret data. (RCTAH)4. This is used to calculate the mean or average of a series of numbers (REEAGVA)5. These are combinations of functions, operands, and operators (MLOURFA)​

Answer:

SpreadsheetsFunctionsChartAverageFormula

Explanation:

yan po sorry po kung mukhang kinopya ko po :(

8. 9. It is the function that is most frequently used in worksheet.A. Multiplication B. Division C. Sum FunctionD. Formulas​

Answer:

C is the best answer

Explanation:

sana makatulong

#CarryOnLearning

Answer:

C. Sum

Explanation:

This is my answer,

9. arrange the letter:(MUS TIONFUCNC)_______it is the function that is most frequently used in worksheet.​

Answer:

Sum Function, not sure

Explanation:

hope it helps. keep safe

SUM FUNCTION

➢ Sum Function is the function that is most frequently used in worksheet .

#CarryOnLearning

10. Activity 4. Cell Structure & Function Worksheet. ​

Answer:

goodnight sleepwell sweetheart

11. answer this worksheet

Answer:

I- How- IM NOT KINDERGARTEN

12. Worksheet no.7YOPIC: MULTIPLICATION OF FUNCTIONS.​

Answer:

I am not a grade 11 student

Step-by-step explanation:

sorry

13. An application program that simulates the function of a paper worksheet​

Answer:

Spreadsheet software allows users to perform calculations using spreadsheets. They simulate paper worksheets by displaying multiple cells that make up a grid.

Explanation:

I hope it's help

14. 7. The following statements are true *except a. Entering values with different mathematical operators is not the same as entering formulas b. Worksheets use formulas to perform calculations on the data you enter c. The = sign indicates that what follows is a function d. Formulas typically consist of one or more cell addresses and/or values and a mathematical operator unlun in cell 73 what operation​

Answer:

a. po

Explanation:

Sana Maka tulong

Answer:

b.

Explanation:

pa brainly nalang po thank you

15. WORKSHEET 5 A. Directions: Write True if the statement is correct and False if it is not. Write your answer o the space provided. 1. Microsoft Excel or MS Excel is one example of the most commonly used computerized worksheets. 2. There are only five functions in MS Excel. 3. Average is used to add two or more numbers together. 4. Formulas are combinations of functions, operands and operators. 5. Without an equal sign, Excel will not calculate result.​

Answer:

1. true

2. True

3. True

4. False

5.False

Explanation:

Correct me if I'm wrong

16. how can you use these functions to improve your worksheet?

A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

#Amazing Learning

#Learn On Brianly

#Carry On Learning

Pls mark me as brianliest answer

Pls I really need a brianliest answer

Thank you

STAY SAFE AND GOD BLESS YOU

17. Worksheet no.4TOPIC: ADDITION OF FUNCTIONS.​

123456789012347906321

18. Directions: Match the part of the male reproductive system to its function. Write the letter of your answers on the worksheets provided.

Answer:

Hello! Just wanted to ask where is the question? This is just the direction of an activity. I would like to help though.

19. true or false Formula is an equation that performs operation on worksheet dataempowerment po to ​

Answer:

True

Explanation:

The answer is TRUE

pa follow and heart thank you

20. Briefly discuss the following buit -in functions and terms used formatting a worksheet​

Answer:

asan yung sasagutan need ko pic

21. Cell Structure & Function WorksheetPart ll. ​

Answer:

ikaw na po bahala mag label at saan part sya nakalagay like nucleus ikaw Napo bahala kung saan sya part ilalagay

#IHOPEITSHELP

22. it is the tab used when adding formulas and function to a spreadsheet or checking a worksheet for formula errorsAnswer to mark as the brainliest☆​

Answer:

Formula Tab is the answer.

Yes


Explanation:

sana makatulong

23. Differentiate the functions of a worksheet, database, and chart.​

Answer:

A spreadsheet is a computer software that simulates a paper worksheet. We use it to tabulate data and create graphs based on the data. A database is a collection of related data that can be accessed quickly. A database is meant to hold a large amount of data and some databases routinely do. Wile chart is  a graphical representation of data.

Explanation:

24. WORKSHEET 5 A. Directions: Write True if the statement is correct and False if it is not. Write your answer on the space provided. 1. Microsoft Excel or MS Excel is one example of the most commonly used computerized worksheets. 2. There are only five functions in MS Excel. 3. Average is used to add two or more numbers together. 4. Formulas are combinations of functions, operands and operators. 5. Without an equal sign, Excel will not calculate result.​

Answer:

WORKSHEET 5 A. Directions: Write True if the statement is correct and False if it is not. Write your answer on the space provided. 1. Microsoft Excel or MS Excel is one example of the most commonly used computerized worksheets. 2. There are only five functions in MS Excel. 3. Average is used to add two or more numbers together. 4. Formulas are combinations of functions, operands and operators. 5. Without an equal sign, Excel will not calculate result.

Explanation:

[tex] \rule{1pt}{999999pt}[/tex]

25. 6. The file responsible for starting MS Excel is a. MS.EXCE. C.MS.EXE b. EXCELEXE. d. EXCELCOM 7. An Excel Workbook is a collection of a.charts. c. worksheet b.work books d. worksheets & charts 8. The formula in Excel are made up of ... a. arithmetical operators and functions b.only arithmetic operators c. only functions d.only symbols 9. Data can be arranged in a worksheet in an easy to understand manner using ... a. auto formatting c. applying styles b.changing fonts. d. all of these 10. Excel can display up to fields of a data form a 16 b. 32 c. 64 d. 128​

Answer:

6B.7A.8D.9C.10D.

Explanation:

mark pls

Answer:

6. C

7. B

8. D

9. A

10. A

Explanation:

Ure welcome :) pls follow

26. C. EVALUATIONLET'S ANSWER SOME QUESTION1. What is Excel Spreadsheet/worksheet?2. What are some important parts of an Excel Spreadsheet/worksheet?3. How do we use Excel Spreadsheet/worksheet?4. What is the importance of Excel Spreadsheet/worksheet?5. Which function in the Excel Spreadsheet/worksheet you find very helpful?Why?​

Answer:

1.The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

2.Components of a Spreadsheet

spreadsheet - a table in which you can enter and manipulate data.

cell - a table entry. ...

row - cells aligned horizontally. ...

column - cells aligned vertically. ...

range - the specification for a series of cells. ...

function - an operation applied to a range of cells, always beginning with an "=" sign.

3.A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

4Spreadsheets are an essential business and accounting tool. They can vary in complexity and can be used for various reasons, but their primary purpose is to organize and categorize data into a logical format. Once this data is entered into the spreadsheet, you can use it to help organize and grow your business.

5.The VLOOKUP function is one of the most commonly used and recognizable functions in Excel. It will look for a value in a table and return information from another column relating to that value. It is great for combining data from different lists into one or comparing two lists for matching or missing items.

27. what have you learned in your Microsoft excel lesson in Editing the Worksheet, Formulas and Functions and Page Layout and Printing the Worksheets.

Answer:

I learned the function is a predefined formula that performs calculations using specific values in a particular order. One of the key benefits of functions is that they can save you time because you do not have to write the formula yourself. Excel has hundreds of functions to assist with your calculations.

Explanation:

pa brainlest po pls

28. perform the operation please I need it grade 7 worksheet phs labas patulong naman​

Answer:

18. (8a+4) + (-3a+7)

= -24a² -68a -28

19. (12z²-11z) + (4z-6)

=48z³- 116z² +66z

20. (-20a² + 5ab + 4) + ( 3ab + 7a²)

=35a³b + 5a²b² + 12ab - 60a³ - 140a⁴ + 28a²

22. (-18x+3y) - (3x-5y)

= -54x² - 99xy + 15y²

23. (y³-2y+13) - (-5y³+7y-14)

= -5y^6 - 17y⁴ + 51y³ + 14y² + 63y + 182

24. (12m+4n-9) - (3n+6-13m)

= 88mn - 156m² - 12n² - 189m + 51n + 36

Step-by-step explanation:

18. (8a+4) + (-3a+7)

=(-24a-56) + (-12a-28)

= -24a² -56a -12a -28

=-24a² -68a -28

19. (12z²-11z) + (4z-6)

= (48z³ - 72z²) + (44z² +66z)

=48z³- 116z² +66z

20. (-20a² + 5ab + 4) + ( 3ab + 7a²)

= -60a³ - 140a⁴ + 5a²b² + 35a³b + 12ab +28a²

=35a³b + 5a²b² + 12ab - 60a³ - 140a⁴ + 28a²

22. (-18x+3y) - (3x-5y)

=(-54x² - 90xy) - ( 9xy-15y²)

= -54x² - 90xy -9xy + 15y²

= -54x² - 99xy + 15y²

23. (y³-2y+13) - (-5y³+7y-14)

= (-5y^6 -7y⁴ -14y³) - (10y⁴ -14y² + 28y) - (-65y³ - 91y - 182)

= -5y^6 - 7y⁴ - 14y³ - 10y⁴ + 14y² - 28y + 65y³ + 91y + 182

= -5y^6 - 17y⁴ + 51y³ + 14y² + 63y + 182

24. (12m+4n-9) - (3n+6-13m)

=(36mn - 72m - 156m²) - (12n² - 24n - 52mn) - (-27n -36 + 117m)

= 36mn - 72m - 156m² - 12n² + 24n + 52mn + 27n + 36 - 117m

= 88mn - 156m² - 12n² - 189m + 51n + 36

(Hilong-hilo ako katatype dito, ghad)

29. which function key is used to insert a chart instantly in worksheet​

Answer:

[tex]\bold\color{green}{\boxed{{\colorbox{white}{*✨ A N S W E R ✨*}}}}[/tex]

Press F11. Excel creates a chart on a new sheet using the default chart type.

Explanation:

[tex]\bold\color{green}{\boxed{{\colorbox{white}{*✨ C A R R Y O N L E A R N I N G ✨*}}}}[/tex]

30. these are built-in formula used in making the worksheet construction is here and in performing mathematical operation.​

Answer:A function is a built-in formula.

Explanation: