Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example,AutoSaveOnpopularkids$\_$Adaiah...SavedSearchFile$\backslash$int x$\_(\{($:$[$ Insert $]),($ Function $)$:$\})$K $18\backslash$table$[[$Home$,$Insert,Page Layout,Fo$,$orm,Data,Review,View,Automate$],[,,,,$A$,,,,],[$AutoSum$,$Recently,Financial,Logical,Tent,Date Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example,AutoSaveOnpopularkids$\_$Adaiah...SavedSearchFile$\backslash$int x$\_(\{($:$[$ Insert $]),($ Function $)$:$\})$K $18\backslash$table$[[$Home$,$Insert,Page Layout,Fo$,$orm,Data,Review,View,Automate$],[,,,,$A$,,,,],[$AutoSum$,$Recently,Financial,Logical,Tent,Date Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example,AutoSaveOnpopularkids$\_$Adaiah...SavedSearchFile$\backslash$int x$\_(\{($:$[$ Insert $]),($ Function $)$:$\})$K $18\backslash$table$[[$Home$,$Insert,Page Layout,Fo$,$orm,Data,Review,View,Automate$],[,,,,$A$,,,,],[$AutoSum$,$Recently,Financial,Logical,Tent,Date Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades Populate the cells using formulas and table references or range names. For example,AutoSaveOnpopularkids$\_$Adaiah...SavedSearchFile$\backslash$int x$\_(\{($:$[$ Insert $]),($ Function $)$:$\})$K $18\backslash$table$[[$Home$,$Insert,Page Layout,Fo$,$orm,Data,Review,View,Automate$],[,,,,$A$,,,,],[$AutoSum$,$Recently,Financial,Logical,Tent,Date

Populate the cells using formulas and table references or range names. For example, in the cell that intersects Grades & $1$ in overall responses, using range names, enter: $=$ COUNTIF $($Grades$,1)$ and in the column that intersects Grades & $1$ in Girl's Responses, enter: $=$COUNTIFS $($Gender$,$ "Girl", Grades, $1)$

Insert three clustered column charts and six $3$D pie charts to transform the visual display of your data analysis. Use your own preferred chart titles, styles, colors, labels, etc. When you complete this step your Rank Analysis worksheet may look as follows:

See the powerpoint and video posted on Canvas for more information on how to complete the Rank Analysis. The Canvas examples use car model preferences $($Chevrolet$,$ Ford, $...)$ instead of popularity preferences $($Grades$,$ Sports, Looks, Money$).$

Submit completed Excel workbook and rubric$/$grade$-$sheet in Canvas.