1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
cupoosta [38]
3 years ago
12

Spreadsheet feature that can be used to arrange data from highest to lowest based on average​

Computers and Technology
1 answer:
Juliette [100K]3 years ago
8 0

Answer:

RANK.AVG

Explanation:

Required

Arrange data in descending order based on average

The feature to do this is to use the RANK.AVG() function.

By default, the function will return the ranks of the selected data in descending order (i.e. from highest to lowest); though, the sort order can be changed to ascending order.

The syntax is:

=RANK.AVG (number, ref, [order])

Where

number \to The number to use as rank

ref \to The cell range

order \to 0 represents descending order while 1 represents ascending order

You might be interested in
What does modulate your voice mean
alexandr1967 [171]
To modulate your voice is to modify or gain more control of your voice. It basically means to change or adjust the pitch or tone.
7 0
4 years ago
Read 2 more answers
The procedure in which a film simulation of a skilled performance is stopped and the person is asked to indicate the outcome of
astraxan [27]
Your answer is:
temporal occlusion procedure

I hope this helps! :)
6 0
3 years ago
Which shortcut brings up the Print screen?
sashaice [31]

The answer is alt + prt sc

5 0
3 years ago
Read 2 more answers
What are the features of MS Excel​
Contact [7]
Then here are the excel features that you need to get a hold of:

Learn to use shortcuts. Once you are able to live without the mouse, you get the speed that counts. There are two types of shortcuts - one where you press a set of keys sequentially - like Alt>H>O>I to adjust column width. And the second where you simultaneously press a combination of keys - like Ctrl+Shift+L for applying filters or Ctrl+1 for the format numbers dialog box. It takes repetition to get the speed but once you are there, you get an edge.
Learn excel functions and apply them to build formulas. Start with easy ones like SUM, COUNT, SUMIF, COUNTIF, IF etc, then move to VLOOKUP, SUMIFS, COUNTIFS, HLOOKUP, INDEX, MATCH, then move to building nested complex formulas like IF inside an IF, VLOOKUP with HLOOKUP, INDEX+MATCH and so on.
Learn about data analysis and data aggregation. This includes tools like Pivot table, solver, goal seek, data tables, descriptive statistics, regression.
Learn about conditional formatting. Style and colour your spreadsheets.
3 0
3 years ago
I have the assembly for the max. can someone change the variables of it and make it min. I mean, the assembly for finding the mi
tatyana61 [14]
Bruh i honeselty dont know
4 0
4 years ago
Other questions:
  • Someone who wants the credentials of skilled training, but in less time than a four-year degree should consider
    11·1 answer
  • Why do you need to back up important data?
    5·2 answers
  • Egovernment involves the use of strategies and technologies to transform government by improving the delivery of services and en
    7·1 answer
  • Pls give me some suggestion of good Computer Science reference books for XI CBSE. <br> PLS!!
    10·2 answers
  • Which of the following is NOT a possible duty for a professional working in the Web and Digital Communications pathway?
    7·1 answer
  • Which characteristic describes the troposphere?
    10·1 answer
  • Which king, after finding the decree of Cyrus giving the Jews permission to return and build the Temple, ordered the end of oppo
    11·2 answers
  • CSc 2720 - Data Structures: Assignment 1 [100 points] How to Submit: Turn the .java file in Folder Assignment 1 in iCollege no l
    11·1 answer
  • 1k bits equals to how many bits
    12·1 answer
  • 8. Software ____ are individual programs that can be purchased, installed, and run separately, but extract data from the common
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!