Based on the given spreadsheet, the database function that needs to be entered into cell I6 to find the average salary of all full-time employees is =AVERAGEIFS(D5:D34,B5:B34,"FT",C5:C34,">=1")
<h3>What does the AverageIfs formula find?</h3>
You can use the AverageIfs formula to find the average of a specific group of numbers from a spreadsheet based on the shared categories that these numbers fall under.
After typing in the =AverageIfs function, you then input the range from which the category will be specified. In this case that is D5:D34. The next entry would be the range the category is picked from which is B5:B34. The function will be FT for Full time workers.
Then use C5:C34 to find out the number of dependents that are equal to or greater than 1.
The digit returned is the average salary of all full-time employees.
Find out more on the AverageIf function at brainly.com/question/13661607
#SPJ1
copy and paste
so you can keep the data in the current cell and add it to other cells that you want that data in as well
Answer:
E-publishing is also known as digital publishing or online publishing.It means to publish the content in electronic form.It is growing rapidly.It consist digital publication of e-books,digital magazines that can be read on a screen.
<u>Explanation:</u>E-publishing is very convenient.We do not have to keep large number of books on the shelves.E-books are best during travelling because we need not to carry heavy luggage of books.E-books are cheaper than paperbacks.
E-publishing can allow the authors to reach large number of readers.Electronic contents are very well updated.Electronic books are environment friendly.It saves wastage of papers and hence cutting of trees.
Besides above advantages there are some disadvantages of E-publishing:
There are more responsibilities in E-publishing.Chances of copyright infringement can be there.
Profits are very low in case of e-publishing.It is not easy to earn money through this method.
Quality of printed books is much better than e-books.
So we can say that e-publishing has it's own advantages and disadvantages.