MS-Excel

1)Specify any one type of charts available in spreadsheet. Answer: Bar graph, Column graph, Pie chart, Line graph, etc. 2)Give any one built-in function of spread sheet. Answer: SUM(range) : This function returns the sum of all the numbers in the list of arguments. Example: =SUM(A2:E2) 3)What are macros in ESS? Answer: Macro is a small program that caries out pre-defined series of steps by giving a few keyboard shortcuts. Macro is like a batch file created in dos. It contains a series of commands. When a macro is called and run, the instructions given in it are executed one by one. 4)Differentiate between MAX( ) and MIN( ) built-in functions in a spread sheet. Answer: MAX(num 1, num 2,……) : Returns the largest value in a set of values. Example: =MAX(15, 25, 8, 14) returns 25 MIN(num 1,num 2……) : Returns the lowest value in a set of values. Example: =MIN(15, 25, 8, 14) returns 8 5)Explain briefly built in func...