Question

Objective 4.3Perform basic mathematical tasks in a spreadsheet.34.Alexander lends some money to Niraj. Alexander maintains a worksheet that liststhe amount and the date when he lent money to Niraj, as displayed in the exhibit. He wants to calculate the total amount of money he lent to Niraj. The list is very long,and he wants to know ifthere is a button that he can click to calculate the total amount due.Which of the following toolbar buttons will Alexander click?A. AutoSum(Correct Answer)B. AutoCorrectC. AutoSummarizeD. AutoFormat

Answer 1

A. Auto Sum

Explanation:

In a spread sheet, if there are so many entries in form of numbers, whether in form of row or a column, it might be a pain staking job to sum all them individually. In spread sheet, the best option is to perform auto sum option, which as shown by its name, will add up all the entries given and produce the answer.

Now in given options of the question, auto correct, auto summarize and auto format are not usable because all of these options will either summarize or provide average or perform formatting, as they are not mathematical functions since, Alexander wants to add up all the amount he lent to Niraj, which means a mathematical task, so auto sum, as a mathematical command is best option.