Question

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. ​

Answer 1

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 ✌ >_<

Answer 2

$\huge\bold{\textbf{\textsf{{\color{cyan}{Answer}}}}}$

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.