Excel Essentials Quiz: Formulas & Charts

Test

Jugadas 0

Crear copia

Tests key Excel functions and chart types

Yasmeen Salah

Egipto

Todavía no hay resultados para este juego. ¡Sé el primero en aparecer en el ranking! Inicia sesión para identificarte.

Crea tu propio juego gratis desde nuestro creador de juegos

Compite contra tus amigos para ver quien consigue la mejor puntuación en esta actividad

Crear reto

Imprime tu juego

Excel Essentials Quiz: Formulas & Charts


Excel Essentials Quiz: Formulas & ChartsVersión en línea Tests key Excel functions and chart types por 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)