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
Question
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
Solution
A11. The =PRODUCT formula in Excel is used for multiplication.
A12. The COUNT function in Excel is used to count the number of numeric entries.
A13. There are 4 types of alignment in MS Excel: General, Left, Center, and Right.
A14. Statistical calculations and preparation of tables and graphs can be done using Excel.
A15. All of the options provided (SUM, MAX, AVG, MIN) are functions in MS Excel.
A16. Functions in MS Excel must begin with an Equal Sign.
A17. The IF function in Excel checks whether a condition is true or not.
A18. The process of arranging the items of a column in some sequence or order is known as Sorting.
A19. The Auto fill feature of MS Excel quickly completes a series of data.
A20. The keys used to open the print tab in Ms Excel are Ctrl + P.
Similar Questions
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.
Q41. What is displayed in the formula Bar? Error messages The calculated value of a formula. The formula of the Active Cell Smart tagsQ42. = Power (2, 5 ) function returns ........ 16 32 64 128Q43. Which one is not an example of Mathematics functions? =mod() =int() =floor() =trim()Q44. Pivot table option are located in .............. menu. Data Tools Insert FormatQ45. Which of the following functions is used to add two or more arguments? Exact Concatenate Trim None of theseQ46. Which of the following option is used to convert the horizontal table in a vertical table? H lookup V lookup Transpose Both a and bQ47. What is the use of macro in Excel? Create menu Toolbar Create Shortcut Key None of theseQ48. Where is the Freez Panes option located? Format - Window Window - Freeze Panes View - Freeze Panes None of theseQ49. Word text can be made italic by.... Ctrl + I Ctrl + B Ctrl + U None of theseQ50. Which of the following application is also known as semi accounting package? MS-Word MS-Excel MS-PowerPoint MS-Access
Which one is not a function of Excel?SUMAVGMINMAXIf
The =CEILING formula in Excel works best when used with what other formulas?Logical Excel formulas, such as =VLOOKUPMath Excel formulas, such as =SUMSyntax Excel formulas, such as =COUNTIF
At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.