Worksheet on MS Excel 2019 for Class 5

 

Worksheet on MS Excel 2019 

Part A: Theory Questions (Q&A)

  1. What is Microsoft Excel?
    Microsoft Excel is a spreadsheet software used to organize, calculate, and analyze data in rows and columns.

  2. What is a Workbook in Excel?
    A workbook is a file in Excel that contains one or more worksheets.

  3. What is a Worksheet in Excel?
    A worksheet is a single sheet in a workbook made up of rows and columns where data can be entered and analyzed.

  4. What are Rows and Columns in Excel?

    • Rows: Horizontal lines in a worksheet, identified by numbers (1, 2, 3, ...).
    • Columns: Vertical lines in a worksheet, identified by letters (A, B, C, ...).

  5. What is a Cell in Excel?
    A cell is the intersection of a row and a column. It is identified by its cell address, such as A1 (column A, row 1).

  6. What is a Cell Address?
    A cell address is the unique name of a cell formed by combining its column letter and row number (e.g., B3).

  7. What is a Formula in Excel?
    A formula is an equation used to perform calculations, starting with an equal sign (=). Example: =A1+B1.

  8. What is a Function in Excel?
    A function is a pre-defined formula in Excel that performs a specific calculation. Example: =SUM(A1:A5) adds the numbers in cells A1 to A5.

  9. Name any three functions in Excel.

    • SUM()
    • AVERAGE()
    • MAX()

  10. What is the use of the Fill Handle in Excel?
    The Fill Handle is a small square at the bottom-right corner of a cell that helps copy data or formulas to adjacent cells.

Part B: Practical Questions

  1. Identify the Cell Address:
    Write down the cell address for:
    a. The intersection of column C and row 5.
    b. The intersection of column D and row 10.
    (Answer: C5, D10)

  2. Simple Data Entry Task:
    Enter the following data in Excel:

    NameMathScienceTotal
    John8590
    Sarah7888
    Maria9289

    Use a formula to calculate the Total for each student.

  3. Formatting Exercise:

    • Bold the names in the table above.
    • Change the font color of the “Total” column to blue.
    • Highlight the highest score in Math using a yellow background.

  4. Using AutoSum:
    Create the same table and use the SUM() function to calculate the Total for each student.

  5. Sorting Task:
    Arrange the students' names in alphabetical order using the Sort feature.

  6. Create a Chart:
    Using the data in the table above, create a Bar Chart to compare the Math and Science scores of the students.

Part C: Activity-Based Questions

  1. Fill in the Missing Formulas:
    In the following table, write the formulas for Total and Average.

    ProductPriceQuantityTotalAverage Price
    Pen105
    Book502

    Formulas:
    a. Total = Price * Quantity
    b. Average Price = =AVERAGE(B2:B3)

  2. Find Errors in the Formula:
    Identify the error in this formula: =SUM(A1-A5).
    (Answer: The correct formula should be =SUM(A1:A5) because SUM requires a range separated by a colon :.)

  3. Design Your Own Table:
    Create a table showing your favorite fruits, their prices, and quantities you bought. Use a formula to calculate the total cost for each fruit.

Part D: Fun Challenges

  1. Crossword Puzzle (Excel Terms):
    Create a crossword puzzle with the following clues:

    • Horizontal:
      1. The horizontal part of a worksheet (Row).
    • Vertical:
      1. A file in Excel that contains worksheets (Workbook).
      2. A pre-defined formula in Excel (Function).

  2. Color Coding:
    Color code the cells with:

    • Red for scores below 80.
    • Green for scores 80 and above.


Part E: Additional Theory Questions

  1. What is the Ribbon in Excel?
    The Ribbon is the toolbar at the top of the Excel window that contains commands grouped under tabs like Home, Insert, and Page Layout.

  2. What is the purpose of the Name Box?
    The Name Box shows the address of the selected cell. It can also be used to navigate to a specific cell.

  3. What is the Formula Bar in Excel?
    The Formula Bar displays the content or formula of the currently selected cell.

  4. What are Ranges in Excel?
    A range is a group of selected cells. It is written as the address of the first cell and the last cell separated by a colon (e.g., A1:B5).

  5. What is Sorting in Excel?
    Sorting is a feature used to arrange data in a specific order, such as ascending or descending.

  6. What is Filtering in Excel?
    Filtering is used to display only the rows that meet specific criteria.

  7. What is Conditional Formatting?
    Conditional Formatting allows you to change the appearance of cells based on certain conditions, such as highlighting all values greater than 50.

  8. What are Charts in Excel?
    Charts are graphical representations of data in Excel, such as bar charts, pie charts, and line charts.

  9. What is the purpose of the Undo and Redo buttons?

    • Undo: Reverses the last action.
    • Redo: Reapplies the last action that was undone.

  10. What is a Shortcut Key in Excel? Give one example.
    Shortcut keys are key combinations that perform specific tasks. Example:

    • Ctrl + S: Save the workbook.

Part F: True/False

  1. The intersection of a row and a column in Excel is called a cell. (True)
  2. The shortcut key to save a workbook is Ctrl + P. (False)
  3. A range of cells is written as A1-A10. (False)
  4. You cannot change the font style or size in Excel. (False)
  5. The SUM function is used to add numbers in Excel. (True)
  6. The Fill Handle helps copy the contents of a cell to other cells. (True)
  7. Charts in Excel are used to organize text. (False)
  8. Excel automatically saves your file every 5 seconds. (False)
  9. The default file extension for an Excel 2019 file is .xlsx. (True)
  10. You can merge cells in Excel to create a larger cell. (True)

Part G: Fill in the Blanks

  1. The software Microsoft Excel is a type of spreadsheet application.
  2. A cell is identified by its column letter and row number.
  3. To move to the next cell in a row, press the Tab key.
  4. A worksheet is made up of rows and columns.
  5. The formula to add numbers in cells A1, A2, and A3 is written as =SUM(A1:A3).
  6. The shortcut key to create a new workbook is Ctrl + N.
  7. The feature that allows you to sort data in ascending or descending order is called Sorting.
  8. The Name Box displays the address of the active cell.
  9. Charts are used to visually represent data in Excel.
  10. The toolbar at the top of the Excel window is called the Ribbon.

Comments

Post a Comment

Popular posts from this blog

Worksheet on The Internet for Class 5

WORKSHEET ON THE INTERNET  Part A: Questions and Answers What is the Internet? The Internet is a global network of computers connected to each other, allowing people to share information, communicate, and access resources. What is a Web Browser? Name any two examples. A web browser is software used to access the Internet. Examples include Google Chrome and Mozilla Firefox. What is a Search Engine? Name any two examples. A search engine is a tool that helps find information on the Internet. Examples include Google and Bing. What is a Website? A website is a collection of related web pages under one domain name, such as https://psbtrainingacademy.com/ What is a URL? A URL (Uniform Resource Locator) is the address of a web page. For example, https://psbtrainingacademy.com/ What is an Email? Email, or electronic mail, is a way to send and receive messages and files over the Internet. What is an IP Address? An IP Address is a unique set of numbers assigned to each device connected to th...
Read more

HCF (Highest Common Factor) Worksheet for CBSE/ICSE Students

Image
  Top HCF Worksheet for Competitive and School Exams 📗 Factors and Multiples (1–25) List all factors of 24. Write the first 5 multiples of 8. What is the smallest factor of 55 other than 1? Find the common factors of 18 and 60. List all the factors of 20. Is 20 a multiple of 3? Write the 5th multiple of 9. List the first 6 multiples of 6. Write all factors of 12. Write all factors of 65. What is the largest factor of 10? Is 24 a multiple of 5? Find all the factors of 3. List all the factors of 11. List all factors of 90. Is 1 a factor of 20? Is 3 a factor of 54? Are 3 and 15 both factors of 54? What is the smallest multiple of 12? Write all the common multiples of 6 and 15 up to 60. Is 351 divisible by 13? Find the smallest factor of 28. Find the highest factor of 36. List the multiples of 15 up to 90. Write 10 as a product of its factors in two different ways. 🔢 Prime and Composite Numbers (26–45) Is 2...
Read more

Convert Proper Fractions into Mixed Fractions

  🔹 Set 1: Convert Proper Fractions into Mixed Fractions (25 Questions) Note: Proper fractions have numerator < denominator, so here the idea is to convert proper fractions with numerators larger than denominators into mixed fractions , actually these are improper fractions. To clarify, proper fractions don’t convert to mixed fractions. So I assume you mean convert improper fractions (numerator > denominator) into mixed fractions. Corrected Task: Convert Improper Fractions into Mixed Fractions 7/4 = ______ 9/5 = ______ 11/6 = ______ 13/7 = ______ 15/8 = ______ 10/3 = ______ 14/5 = ______ 17/6 = ______ 20/9 = ______ 19/4 = ______ 21/8 = ______ 23/7 = ______ 16/5 = ______ 18/11 = ______ 22/9 = ______ 25/6 = ______ 24/7 = ______ 28/9 = ______ 27/8 = ______ 30/11 = ______ 32/10 = ______ 29/6 = ______ 26/7 = ______ 31/8 = ______ 33/9 = ______ 🔹 Set 2: Convert Improper Fractions into Proper Fraction...
Read more