What function is used to find the highest value in a range of cells?, MAX, HIGH, TOP, PEAK, Which shortcut key is used to open the "Format Cells" dialog box?A) MAX, Ctrl + F, Ctrl + D, Ctrl + Shift + F, Ctrl + 1, What does the function =AVERAGE(A1:A10) do?, Adds the values in cells A1 to A10, Finds the median of cells A1 to A10, Calculates the average of cells A1 to A10, Multiplies the values in cells A1 to A10, Which function is used to count the number of cells containing numbers within a specified range?C) TOP, COUNT, SUM, TOTAL, TALLY, What does the formula =$A$1+B1 do when copied across multiple cells?D) PEAK, Adds the value in cell A1 to the value in the corresponding row of column B, Adds the value in cell B1 to the value in the corresponding row of column A, Adds the value in cell A1 to the value in cell B1, Multiplies the value in cell A1 by the value in cell B1, Which function is used to find the largest value in a range that meets a specific condition?, MAXIF, LARGE, MAXVALUE, MAXIFCONDITION, What is the keyboard shortcut to repeat the last action in Excel?, Ctrl + R, Ctrl + Y, Ctrl + Z, Ctrl + A, Which function is used to join text from multiple cells into one cell?, COMBINE, CONCATENATE, MERGE, JOIN.
0%
EXCEL
Del
Del
Del
af
Enandoconsultin
Secondary
Computing
Data Modelling with Spreadsheets
Rediger indhold
Trykke
Integrere
Mere
Tildelinger
Rangliste
Vis mere
Vis mindre
Denne rangliste er i øjeblikket privat. Klik på
Del
for at gøre det offentligt.
Denne rangliste er deaktiveret af ressourceejeren.
Denne rangliste er deaktiveret, da dine muligheder er forskellige fra ressourceejerens.
Indstillinger for gendannelse
Quiz
er en åben skabelon. Det genererer ikke resultater for en rangliste.
Log ind påkrævet
Visuel stil
Skrifttyper
Kræver abonnement
Indstillinger
Skift skabelon
Vis alle
Der vises flere formater, mens du afspiller aktiviteten.
)
Åbne resultater
Kopiér link
QR-kode
Slette
Gendan automatisk gemt:
?
