Functions ini Excel

What software do we use to create spreadsheets?

• Word

• PowerPoint

• Sway

• Publisher

• Excel

SUM, AVERAGE, MAX, MIN, COUNT, and IF are examples of what?

• Functions
• Tables
• Formulae
• Statistical tools

This function finds the highest number in the range of cells

• =SUM( )
• =AVERAGE( )
• =MAX( )
• =MIN( )

This function finds the lowest number in the range of cells.

• =SUM( )
• =AVERAGE( )
• =MAX( )
• =MIN( )

Which of the following operators do you use to begin typing a formula?

• *
• +
• =
• /

A4 is an example of...

• Cell Address
• Cell Range
• Formula
• Function

What function can be used to find the average total in a range of numbers?

• =MIN
• =MAX

• =AVERAGE
• =SUM

If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')

• pass

• fail

• 60

If function allows to choose between two actions based on whether the condition is true or ..................

• false

• 1

• Yes

• -1

A1:D4 is an example of a cell...

• Range
• Selection
• Highlight
• Choice