MS Excel Honors #8

Match it! Select the correct answer from the pull down...Good luck!

Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?

Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?

Jill would like to use a function that will return “True” when only one of the arguments in the function is true. What function should she use?

In order to directly report the data, what must a PivotChart always be associated with?

Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?

Which command creates decorative text in a worksheet?

SUMIF and SUMIFS are in which category of functions?

In Sam’s spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?