Suggest the Excel function which can be used for the following-
•To calculate the quarterly sales of a sales executive,if the sales data of all months are given.
Answers
Answered by
25
Answer:
Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.
Explanation:
Cool profile pic iceweb ✌ >_<
Answered by
10
Excel is a spreadsheet software developed by Microsoft. The answer to your question is as below:
For this purpose, pivot tables should be used.
Plvot tables are features present in most advanced spreadsheet softwares and are used to analyse data in an effective way.
Similar questions
World Languages,
2 months ago
Social Sciences,
2 months ago
English,
2 months ago
Math,
5 months ago
Math,
5 months ago
Math,
1 year ago
Math,
1 year ago