Question

_______ option is not available in 'Cells' groups of Home tab in MS Excel 2007.
1. Insert
2. Format
3. Sort
4. Delete

Answer 1

Correct Answer - Option 3 : Sort

The correct answer is Sort.

• Sort Tab
  • The Excel Sort function sorts the contents of a range or array.
  • Values can be sorted by one or more columns.
  • Sorting of Value can be done by selecting any cell in the data range and on the Data tab, in the sort and filter group, click sort.
• Home tab
  • The home tab contains the most frequently used commands in Word.
  • The Ribbon is located close to the top of the Word window.
  • The Ribbon is organized into a set of task-oriented tabs, and each tab on the Ribbon contains groups of commands.

• Insert tab
  • The Insert tab is right next to the Home tab in word.
  • The insert tab is used to insert different features such as tablets, pictures, clip art, shapes, charts, page numbers, word art, headers, and footers into a document.
• Format Tab
  • It allows the user to specify the format of the file or files being read from.
• Delete Tab
  • It allows the users to delete the sheet.
  • It is located on the home tab, in the cells group.
• MS-Excel
  • It is a spreadsheet program for data analysis and documentation.
  • It contains a number of rows and columns, where the intersection of a column and cell and a row is a "cell".
  • Each cell contains one point of data.
  • It is developed by Microsoft.
  • It features calculation, graphing tools, pivot tables.