True/False
A worksheet has the following data in it: Cell range A2 to A10 in column A lists the categories of food items in a store: Vegetables and Fruits.Cell range B2 to B10 in column B lists the types of food items for each category: Cucumbers,Corn,Pears,Lettuce,Potatoes,and Scallions.Cell range C2 to C10 in column C lists the sale of each item during the month.If we insert the formula =SUMIFS(A2:A10,B2:B10,=P* )in cell A11,it will give us the total sale of products that begin with the letter P.
Correct Answer:
Verified
Correct Answer:
Verified
Q2: Right-click the pivot item,then click Expand to
Q3: To hide the PivotTable Field list,right click
Q4: Edwin wants to insert a Pivot Chart
Q5: A worksheet has the following data in
Q6: Warren creates a table listing the height
Q8: The score of a student in two
Q9: Alejandro wants to change the color of
Q10: To add fields to a PivotTable,one can
Q11: The score of a student inserted in
Q12: Chastity wants to rename her pivot table