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
Question
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
Solution
A41. The formula bar displays the formula of the Active Cell. A42. = Power (2, 5 ) function returns 32. A43. =trim() is not an example of Mathematics functions. A44. Pivot table options are located in the Insert menu. A45. None of these functions is used to add two or more arguments. You would typically use the SUM function. A46. The Transpose option is used to convert the horizontal table into a vertical table. A47. The use of macro in Excel is to create Shortcut Key. A48. The Freeze Panes option is located in View - Freeze Panes. A49. Word text can be made italic by using Ctrl + I. A50. MS-Excel is also known as a semi accounting package.
Similar Questions
Q41. What is displayed in the formula Bar? Error messages The calculated value of a formula. The formula of the Active Cell Smart tags
Q42. = Power (2, 5 ) function returns ........ 16 32 64 128
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
Q43. Which one is not an example of Mathematics functions? =mod() =int() =floor() =trim()
In the expression, the ______followed by the values, cell address and functions are called as formula.
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.