MS Excel Basics
What is MS Excel primarily used for?
  • Word Processing
  • Spreadsheet Management
  • Photo Editing
  • File Compression
Explanation: MS Excel is primarily used for creating, organizing, and analyzing data in spreadsheets. It enables users to perform calculations, manage data, and create visualizations like charts and graphs.
What is the intersection of a row and column called?
  • Table
  • Chart
  • Cell
  • Grid
Explanation: The intersection of a row and a column in MS Excel is called a cell, where data is entered. Each cell is identified by a unique cell reference (e.g., A1, B2).
What is the shortcut key to create a new workbook?
  • Ctrl + N
  • Ctrl + W
  • Ctrl + O
  • Ctrl + A
Explanation: MS Excel is spreadsheet software used for organizing, analyzing, and visualizing data. It includes features like formulas, functions, charts, PivotTables, and Conditional Formatting, making data management efficient and user-friendly.
What does the AutoSum feature do?
  • Subtract numbers
  • Add numbers automatically
  • Multiply numbers
  • Create charts
Explanation: The AutoSum feature in MS Excel automatically adds a range of numbers, saving time by inserting the SUM formula for selected cells. Shortcut: Alt + =.
What is the default file extension for Excel 2016 and later?
  • .xls
  • .xlsx
  • .csv
  • .docx
Explanation: The default file extension for Excel 2016 and later versions is .xlsx, which supports advanced features like formulas, formatting, and charts. Older versions use .xls.
What is the shortcut key to select the entire row?
  • Ctrl + Space
  • Shift + Space
  • Ctrl + Shift
  • Alt + Space
How do you wrap text in a cell?
  • Format → Wrap Text
    • Explanation: To wrap text in a cell, go to the Home tab and click on Wrap Text in the Alignment group. This adjusts the text to fit within the cell.