Peer to Peer Training- Excel 2
Master Excel with Peer to Peer Training
Engage in our Excel 2 quiz designed for aspiring Excel users looking to enhance their skills through peer training. Test your knowledge of essential Excel formulas, fun
Join us for a challenge that covers:
- Core Excel Fun
ctions - Data Analysis Techniques
- Formula Accuracy
- Pivot Table Creation
Which of the following formulas below is correct?
=SUM(B2-B7)
=SUM(B2B7,B6)
=SUM(B2:B7)
Which of the following formulas below is correct?
=SUM(B2-B7)
=SUM(B2B7,B6)
=SUM(B2:B7)
Which of the following formulas gives 9 as a results?
0%
0
=SUMIF(B3:B7,">2")
0%
0
=SUMIF(A3:A7,"I*",B3:B7)
0%
0
=SUMIF(A3:A7,"*a",B3:B7)
Which of the following formulas gives 3 as a results?
0%
0
=SUMIFS(B2:B6,B2:B6,">3",B2:B6,"<5")
0%
0
=SUMIFS(B2:B6,A2:A6,"*a*",A2:A6,"I*")
0%
0
=SUMIFS(B2:B6,A2:A6,"<>I*",A2:A6,"<>T*")
Which of the following formulas gives the last 8th digit of IATA number of 7 digit?
=MOD(C34,7)
=MOD(C34,8)
=MOD(C34,0)
Which of the following formulas is correct?
0%
0
=AND(A4="Greece",B4<50,000,000)
0%
0
=AND(A5="Greece",B5<50,000,000)
0%
0
=AND(A6="Greece",B6=20,902,509)
Which of the following formulas gives me the KLM.COM IL Yo2Y IdX =34?
0%
0
=VLOOKUP("KLM.COM IL",A1:C4,2,)
0%
0
=VLOOKUP("KLM.COM IL",A2:C5,2,0)
0%
0
=VLOOKUP("KLM.COM IL",A3:C6,3,0)
Which of the following formulas gives as a results "IL"?
0%
0
=RIGHT(A2,2)
0%
0
=RIGHT(A3,2)
0%
0
=RIGHT(A4,2)
Which of the following formulas gives as a results "RIGHT"?
0%
0
=IF(B3>B4,"RIGHT","WRONG")
0%
0
=IF(C4<C2,"RIGHT","WRONG")
0%
0
=IF(B3>B2,"RIGHT","WRONG")
What is indispensable in the dataset to create a pivot?
Column Headings- you need a column heading for each column which must be different ( neither blank heading or blank column)
The data table must be organizd in at leas more than 5 columns
There can be no double values in the data range
If I want to add an index YoY in a pivot table how can I do?
0%
0
I click on Analyze and create a calculated field
0%
0
I click on Analyze and create a calculated item
0%
0
I click on the value in the pivot table and then click on value field settings
{"name":"Peer to Peer Training- Excel 2", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Engage in our Excel 2 quiz designed for aspiring Excel users looking to enhance their skills through peer training. Test your knowledge of essential Excel formulas, functions, and best practices, all while learning in an interactive format.Join us for a challenge that covers:Core Excel FunctionsData Analysis TechniquesFormula AccuracyPivot Table Creation","img":"https:/images/course8.png"}
More Quizzes
On-Boarding Training Day 1 : Basics of Excel - Part 1
10512
Mathematics Test of Chapter 3 (Data Handling)
10531
Natureside 2017 - Feature Poll
1050
We tight or nah pt 2
16826
CNA Practice Test - Free Online With Answers
201024592
Seinfeld Trivia Questions - Ultimate for Fans
201030148
Total Drama - Island & Action Trivia Test
201018501
Prosperity Test - Discover Your Wealth Mindset (Free)
201020808
Luxury Brand - Free Knowledge Assessment
201019129
Free California Real Estate Practice Exam - Online
201020027
Otherkin - Which Kintype Are You?
201019129
Dog Anatomy - Common Veterinary Structures
201022643