MS Excel Worksheet for Beginners

MS Excel Worksheet for Beginners

๐Ÿ“Š MS Excel Worksheet โ€“ Beginners

โœ๏ธ Name: ____________

๐Ÿ“… Date: ____________

๐ŸŸข Section 1: Fill in the Blanks

  1. __________ is a spreadsheet software.
  2. MS Excel is developed by __________.
  3. A box in Excel is called a __________.
  4. A group of cells in a horizontal line is called a __________.
  5. The shortcut to save a file is __________.

๐ŸŸก Section 2: Match the Following

Column AColumn B
1. Cella. Vertical line
2. Rowb. Box in worksheet
3. Columnc. Horizontal line
4. Ctrl + Sd. Save file

๐Ÿ”ต Section 3: True or False

Write True or False:

  1. MS Excel is used for calculations. ________
  2. A column is horizontal. ________
  3. A row is vertical. ________
  4. Excel cannot store numbers. ________
  5. We can create tables in Excel. ________

๐ŸŸฃ Section 4: Short Answer Questions

  1. What is MS Excel?
    ๐Ÿ‘‰ __________________________________________
  2. What is a cell?
    ๐Ÿ‘‰ __________________________________________
  3. Name any two uses of MS Excel.
    ๐Ÿ‘‰ __________________________________________

๐ŸŸ  Section 5: Practical Activity

๐Ÿ’ป Do this on a computer:

  1. Open MS Excel
  2. Enter numbers in cells A1 to A5
  3. Write any 5 numbers
  4. Save the file

๐Ÿ‘‰ Write the file name: __________________

๐ŸŸค Section 6: Activity Time

๐Ÿง  Answer these:

  1. What is the name of the first cell in Excel?
    ๐Ÿ‘‰ __________________________
  2. Which key is used to enter data in a cell?
    ๐Ÿ‘‰ __________________________

Answer Key โ€“ MS Excel Worksheet (Beginners)

๐ŸŸข Section 1: Fill in the Blanks

  1. MS Excel is a spreadsheet software.
  2. MS Excel is developed by Microsoft.
  3. A box in Excel is called a cell.
  4. A group of cells in a horizontal line is called a row.
  5. The shortcut to save a file is Ctrl + S.

๐ŸŸก Section 2: Match the Following

  1. Cell โ†’ b. Box in worksheet
  2. Row โ†’ c. Horizontal line
  3. Column โ†’ a. Vertical line
  4. Ctrl + S โ†’ d. Save file

๐Ÿ”ต Section 3: True or False

  1. MS Excel is used for calculations. โ†’ True
  2. A column is horizontal. โ†’ False
  3. A row is vertical. โ†’ False
  4. Excel cannot store numbers. โ†’ False
  5. We can create tables in Excel. โ†’ True

๐ŸŸฃ Section 4: Short Answers (Sample Answers)

  1. What is MS Excel?
    ๐Ÿ‘‰ MS Excel is a spreadsheet program used to store data and perform calculations.
  2. What is a cell?
    ๐Ÿ‘‰ A cell is a box where a row and column meet in Excel.
  3. Name any two uses of MS Excel.
    ๐Ÿ‘‰ Calculations and creating tables/charts.

๐ŸŸ  Section 5: Practical Activity

๐Ÿ‘‰ File name will vary (example: Data.xlsx)

๐ŸŸค Section 6: Activity Time

  1. What is the name of the first cell in Excel?
    ๐Ÿ‘‰ A1
  2. Which key is used to enter data in a cell?
    ๐Ÿ‘‰ Enter key