Enter Title

E

5

1. Which function adds numbers based on one condition?
   A) SUMIF
   B) COUNTIF
   C) SUM

A) SUMIF

10

In Excel, a Slicer can be connected to multiple Pivot Tables at the same time. True or False?

True 

15

In Excel, =TODAY()+7 gives what?

A. Next week date

B. Today's date

C. Last week date

A. Next week date

20

In PowerPoint, applying an animation to a SmartArt graphic can be set to animate each shape individually or as one object?

A. Both

B. All as one object

C. Individually 

A. Both 

F

5

1. Which function is best to find a value and return a result from any column, left or right?
   A) HLOOKUP
   B) VLOOKUP
   C) XLOOKUP
   
   
   
   

C) XLOOKUP

10

This formula, =COUNTIF(A1:A10, ">0") counts cells greater or Lower than 0?

Greater

15

1. In PowerPoint, hyperlinks to external websites will not work in presentation mode unless you have an internet connection. True or False?

True

20

Which Excel chart is better to show trends over time? 

A. Column Chart

B. Line Chart 

C. Pie Chart 

B. Line Chart