At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is*3 pointsTo tell the person viewing that this is a function and it should be added together.To inform the computer that an arithmetic function will occur.To add all the data together using addition only.To calculate all the data correctly without any mistakes.

At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is

When you wrote incorrect functions, what did you learn about spreadsheet data?How do you think this knowledge of the SUM spreadsheet function will help you write other kinds of functions?

In Excel, what does the function "=A1*B1" do?a) It multiplies the values in cells A1 and B1.b) It adds the values in cells A1 and B1.c) It calculates the average of cells A1 and B1.d) It subtracts B1 from A1.

Q11. What happen when use formula =product ? Addition Subtraction Multiply DivisionQ12. Which function in Excel tells how many numeric entries are there ? NUM COUNT SUM CHKNUMQ13. How many types of alignment in ms excel ? 2 4 6 8Q14. Statistical calculations and preparation of tables and graphs can be done using. Adobe Photoshop Excel Notepad Power PointQ15. Which one is not a Function in MS Excel ? SUM MAX AVG MINQ16. Functions in MS Excel must begin with ___" An () sign An Equal Sign A Plus Sign A > SignQ17. Which function in Excel checks whether a condition is true or not ? SUM COUNT IF AVERAGEQ18. The process of arranging the items of a column in some sequence or order is known as : Arranging Auto fill Filtering SortingQ19. The ____ feature of MS Excel quickly completes a series of data Arranging Auto fill Auto Complete SortingQ20. Which keys are used to open print tab in Ms Excel? Ctrl + P Ctrl + Z Ctrl + U Ctrl + D

What is the use of Auto Sum in excel?