Merge cells option can be applied from?AFormatting toolbarBNone of theseCBoth formatting toolbar and format cells dialog box alignment tabDFormat cells dialog box alignment tab

Two cells are to merged to make a single one. Which function is to be used from the ribbon? Options : wrap text wrap formatting none of the above

Which formatting toolbar is used change the alignment of the text to vertical, horizontal etc.

When a multi-row range is selected, this command creates multiple merged cells — one for eachrow.*Merge AcrossMerge CellUnmerge Cell

When a multi-row range is selected, this command creates multiple merged cells — one for eachrow.*Merge AcrossMerge CellUnmerge Cell2. It enables you to merge two or more cells*MergeWrapCombine3. It formats of cell like Zip code, Phone Number*CustomTextSpecial4. This displays cell as exponential like 5.6E+01.*ScientificNumberFraction5. This displays cell as number with separator*GeneralTextNumber6. It prints the down pages first and then the right pages.*Down, then OverOver, then DownAbove, then Down7. It is the information that appears at the top of each printed page*FooterFoot noteheader8. A small section at the bottom of each page within a sheet or document*FooterFootnoteHeader9. Check this to specify a different header or footer for the first printed page.*Different First PageDifferent Odd & Even PagesScale with Document10. Check this to specify a different header or footer for odd and even pages.*Different First PageDifferent Odd & Even PagesScale with Document11. Excel files are known as __.*Work SheetWorkbookSpreadsheet12. Each workbook hold one or more worksheets (also called a ___)*sheetbookspreadsheet13. Whenever we create a new Excel workbook, it will include one worksheet named __.*SheetSheet0Sheet114. It prints the down pages first and then the right pages.*RibbonQuick Access ToolbarTab15. It is on the top of worksheet, below the title bar or name of the excel file.*RibbonQuick Access ToolbarTab16. If checked, the font size in the header and footer will be sized*Scale with DocumentAlign with Page MarginsScale with sheets17. If checked, the left header and footer will be aligned with the left margin, and the right headerand footer will be aligned with the right margin.*Align with Page MarginsScale with DocumentDifferent Odd & Even Pages18. It keeps the headings visible while you’re scrolling through the worksheet*Freezing panesFixed HeadingsFixed Panes19. To freeze first row of worksheet.*Freeze PanesFreeze Top RowFreeze First Column20. To freeze first Column of worksheet.*Freeze First ColumnFreeze Top RowFreeze Panes21. It is a floating toolbar that appears above the shortcut menu when you right click a cell or otherobjects like a shape or chart.*ToolbarMini ToolbarAcces toolbar22. This displays the page in normal view.*Normal Layout viewPage Layout viewPage Break view23. This are numbered from 1 onwards and keeps on increasing as you keep entering data.*RowColumnSheets24. This is the default cell format of Cell.*GeneralNumberCurrency25. This displays pages exactly as they will appear when printed.*Page Layout viewNormal Layout viewPage Break view

How to keep value of merged cells in each cell?