Excel and PowerPoint Functions Quiz

What does the SUM function do?

• Adds all numbers in a selected range

• Counts the number of cells with numbers

• Finds the highest number in a range

• Multiplies all numbers in a range

Which of the following is the correct formula to sum the values in cells B2 to B10?

• =SUM(B2+B10)

• =SUM(B2:B10)

• =ADD(B2:B10)

• =TOTAL(B2:B10)

What does the COUNTIF function do?

• Counts all numbers in a range

• Counts cells based on a specific condition

• Sums all values in a range

• Finds the maximum value in a range

Which formula correctly counts the number of cells in A1:A10 that contain values greater than 50?

• =COUNT(A1:A10, ">50")

• =COUNTIF(A1:A10, ">50")

• =COUNTIF(A1:A10, "<50")

• =COUNTA(A1:A10, ">50")

In Excel, what will the formula =SUM(A1:A5, B1:B5) do?

• Add only values in A1:A5

• Add only values in B1:B5

• Add all values in A1:A5 and B1:B5

• Display an error

Which function would you use to count the number of non-empty cells in a range?

• COUNT

• COUNTA

• COUNTIF

• SUM

If you want to count the number of times "Apple" appears in range A1:A10, which formula should you use?

• =COUNT(A1:A10, "Apple")

• =COUNTIF(A1:A10, "Apple")

• =SUMIF(A1:A10, "Apple")

• =COUNTA(A1:A10, "Apple")

What is a transition in PowerPoint?

• A movement effect applied to individual objects

• A special effect applied when changing from one slide to another

• A type of animation

• A type of chart

What is the purpose of animation in PowerPoint?

• To apply movement effects to text or objects on a slide

• To add background music to slides

• To change slide designs

• To insert images

What does the Morph transition do in PowerPoint?

• Creates a smooth transformation between two slides

• Applies a fade effect between slides

• Moves objects in a circular path

• Duplicates a slide without changes