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
Share
Share
Share
by
Enandoconsultin
Secondary
Computing
Data Modelling with Spreadsheets
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Quiz
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
)
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?
