Ivy: Pharma College Excel Assessment

Full Name

Email ID

Phone No.

Which symbol specifies that rows/columns/cell is fixed?

• 
  $

• %

• &

• #

We need to find the product of the numbers in table. Which formula in B2 cell will work correctly when dragged horizontally and vertically?

• =$A2*B$1

• =A2*$B1

• =$A$2*$B1

• =A$2*$B1

What are the benefits of using Pivot Tables in Excel?

• Pivot Tables make data analysis more complicated

• Pivot Tables are only useful for small datasets

• Pivot Tables help in summarizing and analyzing large datasets, reorganizing data for better insights, and identifying trends and patterns efficiently.

• Pivot Tables cannot be customized to fit specific needs

Your manager asks you to create a pivot table showing Category (in rows) and Region (in columns) and then show Category wise pecentage of sales in each Region. You need to use:

• Show Value As --> % of Row Total

• Show Value As --> % of Column Total

• Show Value As --> % of Grand Total

• Show Value As --> % Running Total In

In order to get YoY growth of sales in each region which features of Pivot Table will be used?

• First create a column of Year based on order date then drop Region and Year. Do YoY calculation outside Pivot Table.

• After dropping Region and Order Date use grouping and do YoY calculation outside Pivot Table.

• After dropping Region and Order Date use grouping and show value as.

• None of them

The Sum function is applied on numeric values by default in a pivot table. How can I change this so that the values are automatically counted and not summed?

• Insert the Count formula =count() into the Pivot Table

    

• In the calculations group, change the option of Summarize Values By to Count

• Change the format of the values in the Pivot Table to General Numbers

• All the above options listed are correct.

Which formulas would be used to find the Sum of Sales for 'Clothing' Category?

• =SUMIFS(B2:B9,"Clothing",D2:D9)

• =SUMIFS(D2:D9,C2:C9,"Clothing")

• =SUMIFS(C2:C9,"Clothing",D2:D9)

• =SUMIFS(D2:D9,B2:B9,"Clothing")