Excel displays a __________ to help you resolve errors.(Select the correct answer)Smart TagQuick Analysis buttontool tip#

Q41. What is displayed in the formula Bar? Error messages The calculated value of a formula. The formula of the Active Cell Smart tags

A red indicator in the top right corner of a cell indicates that a cell contains _____.Group of answer choicesa calculation errora filtera commenta spelling mistake

######Why has Excel displayed this in the cell?

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

Refer to your Excel sheet and go through the menu, such as File, Home, Insert Page Layout, Formulas, Data, Review and View. Write a summary of the functions of each of these tabs available in the menu.