
Finance and Excel Quiz
Authored by Pedram M. Nourani
Other
University
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
44 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
What happens to portfolio risk when you add perfectly negatively correlated assets?
Risk increases
Risk decreases significantly
Risk stays the same
Risk becomes zero immediately
2.
MULTIPLE CHOICE QUESTION
1 min • 3 pts
If monthly returns have a standard deviation of 0.05, what is the annual standard deviation?
0.60
0.17
0.05
0.25
3.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Which data cleaning approach is best for a dataset with 80% missing values?
Use mean imputation
Remove the rows
Replace with zeros
Keep as is
4.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
What's the dimension of a variance-covariance matrix for a portfolio with 5 assets?
1x5
5x1
5x5
25x1
5.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Which chart type is best for comparing revenue across different company divisions?
Line chart
Bar chart
Scatter plot
Area chart
6.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
What happens when you multiply a 2x3 matrix by a 3x4 matrix?
Results in a 3x3 matrix
Results in a 2x4 matrix
Results in a 4x2 matrix
Not possible
7.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Which function would you use to count cells that meet multiple conditions?
COUNT
COUNTA
COUNTIF
COUNTIFS
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
40 questions
Personality_MBTI
Quiz
•
University - Professi...
45 questions
EE8702 POWER SYSTEM OPERATION AND CONTROL /MODEL NOV 2020
Quiz
•
University
43 questions
Earth Day Vocabulary
Quiz
•
KG - Professional Dev...
41 questions
TF CH 22 - MA
Quiz
•
University
40 questions
Famous Seconds and Famous Cats.
Quiz
•
KG - University
40 questions
GE6075-Professional Ethics in Engineering-MCQ Test
Quiz
•
University
40 questions
Lesson 1. Quiz
Quiz
•
University
45 questions
Quiz Pengolah Angka
Quiz
•
5th Grade - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Other
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University