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
Podijeli
Podijeli
Podijeli
Autor
Enandoconsultin
Secondary
Computing
Data Modelling with Spreadsheets
Uredi sadržaj
Ispis
Postavi
Više
Zadatke
Top-lista
Pokaži više
Pokaži manje
Ova top-lista je trenutno privatna. Odaberite opciju
Podijeli
da biste je javno objavili.
Ovu top-listu onemogućio je vlasnik sadržaja.
Ova top-lista je onemogućena jer se vaš odabir opcija razlikuje od postavki vlasnika sadržaja.
Vrati opcije na početne postavke
Kviz
je otvoreni predložak. Ne generira rezultate za top-listu.
Prijava je obvezna
Vizualni stil
Fontovi
Potrebna je pretplata
Postavke
Promijeni predložak
Prikaži sve
Više formata prikazat će se dok budete igrali.
)
Otvoreni rezultati
Kopiraj vezu
QR kôd
Izbriši
Vrati automatski spremljeno:
?