PlanSource EDI Analyst Interview Questions and Answers

To get the average of marks in Excel, use the AVERAGE function.

• Select the range of cells containing the marks

• Type =AVERAGE(

• Select the range of cells again

• Close the parentheses and press Enter

• The average of the marks will be displayed

To get roll numbers of same subjects, filter the data by subject and extract roll numbers.

• Filter the data by subject using a loop or filter function

• Extract roll numbers of filtered data using map or forEach function

• Store the roll numbers in an array of strings