Full Name

Ivy: Pharma College Excel Assessment

Quiz
•
Other
•
Professional Development
•
Medium

Ivy Professional School
Used 3+ times
FREE Resource
18 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • Ungraded
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • Ungraded
Email ID
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
3 mins • Ungraded
Phone No.
Evaluate responses using AI:
OFF
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol specifies that rows/columns/cell is fixed?
$
%
&
#
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Create a free account and access millions of resources
Similar Resources on Quizizz
16 questions
Pretest Perempuan dan Anak

Quiz
•
Professional Development
20 questions
EVALUACIÓN SEGUIMIENTO DE EXCEL INTERMEDIO

Quiz
•
Professional Development
15 questions
Excel Functions Quiz

Quiz
•
Professional Development
15 questions
DPP UD 8

Quiz
•
Professional Development
20 questions
Batch 2 Post Test 1 Analyzing Data Using Ms. Excel

Quiz
•
Professional Development
20 questions
Sales and Order Quiz

Quiz
•
Professional Development
15 questions
FIBA Basketball Rule Knowledge Quiz

Quiz
•
Professional Development
14 questions
Excel II

Quiz
•
Professional Development
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade