E
Which function adds numbers based on one condition?
A) SUMIF
B) COUNTIF
C) SUM
A) SUMIF
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
In Excel, a Slicer can be connected to multiple Pivot Tables at the same time. True or False?
True
This formula, =COUNTIF(A1:A10, ">0") counts cells greater or Lower than 0?
Greater
In Excel, =TODAY()+7 gives what?
A. Next week date
B. Today's date
C. Last week date
A. Next week date
In PowerPoint, hyperlinks to external websites will not work in presentation mode unless you have an internet connection. True or False?
True
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
Which Excel chart is better to show trends over time?
A. Column Chart
B. Line Chart
C. Pie Chart
B. Line Chart