FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Use a function to calculate the average of the Movie Scores column where the Movie Genre is Horror.
A
=AVERAGE
B
=AVERAGEIF
C
=SUM
D
=SUMIF
Explanation: 

Detailed explanation-1: -Multiply the number of individuals selecting each rating by the corresponding rating value (1 – 5) Add the results of those calculations together. Divide that result by the total number of responses to the question.

Detailed explanation-2: -The AVG() function returns the average value of a numeric column.

Detailed explanation-3: -There are many short animations and documentaries that are not classified as short films by IMDb; The average length for action, adventure, comedy, drama, fantasy, horror and romance movies is around 92 minutes, while for animations and documentaries is approximately 74 minutes.

Detailed explanation-4: -The “empirical method” identifies the genre of a film by comparing it to a list of films already deemed to fall within a certain genre.

There is 1 question to complete.
Previous
Next