Excel Essentials Quiz: Formulas & Charts

Test

Parties jouées 0

Créer une copie

Tests key Excel functions and chart types

Yasmeen Salah

Egypt

Il n'y a toujours pas de résultats pour ce jeu. Soyez le premier à apparaître dans le classement! Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

Imprimez votre jeu

Excel Essentials Quiz: Formulas & Charts


Excel Essentials Quiz: Formulas & ChartsVersion en ligne Tests key Excel functions and chart types par Yasmeen Salah 1 Which formula returns the largest value in a range A2:A10? a MAX(A2:A10) b LARGEST(A2:A10) c MAX(A2:A9) d MAXIMUM(A2:A10) 2 Which function counts numeric entries in A2:A10, ignoring text? a COUNTIF(A2:A10, "*" ) b COUNTA(A2:A10) c COUNT(A2:A10) d SUM(A2:A10) 3 To sum values in B2:B15, which formula is used? a SUMIF(B2:B15, ">=0") b TOTAL(B2:B15) c ADD(B2:B15) d SUM(B2:B15) 4 Which function counts non-blank cells in C2:C20? a COUNT(C2:C20) b COUNTBLANK(C2:C20) c COUNTA(C2:C20) d SUM(C2:C20) 5 What does IF(D2>100, "High", "Low") return when D2=75? a Low b TRUE c 75 d High 6 Which chart type best shows parts of a whole, like sales by category? a Scatter chart b Line chart c Bar chart d Pie chart 7 Which chart type shows trends over time with data points connected? a Pie chart b Scatter chart c Column chart d Line chart 8 Which chart is ideal for comparing categories side by side with vertical bars? a Line chart b Pie chart c Scatter chart d Column chart 9 Which chart is best to show relationships between two numeric datasets? a Column chart b Line chart c Scatter chart d Pie chart 10 If you want to count only cells in E2:E50 that are greater than 10, which formula? a COUNTIF(E2:E50, "<10") b COUNTIF(E2:E50, ">10") c SUMIF(E2:E50, ">10") d COUNT(E2:E50)