MODULE 1 QUESTIONS AND ANSWERS
Part A – Short Answer Questions
1. Define spreadsheet software. Give two examples.
Spreadsheet software allows users to organize, analyze, and store data in tabular form.
Examples: Microsoft Excel, Google Sheets.
2. What is the difference between a workbook and a worksheet in Excel?
A workbook is the entire Excel file containing one or more worksheets. A worksheet is a single page
or tab within the workbook.
3. Write the cell address of the intersection of column C and row 7.
Answer: C7
4. Mention any two advantages of Google Sheets.
1. Real-time collaboration.
2. Cloud-based automatic saving.
5. What is the use of the Name Box in Excel?
It displays the address of the active cell and allows navigation to a named range.
6. State the shortcut to insert a new row in Excel.
Shortcut: Ctrl + Shift + +
7. What does “Wrap Text” do in a cell?
It displays text on multiple lines within a cell so all content is visible.
8. Give two examples of number formatting options in Excel.
1. Currency format
2. Percentage format
Part B – Long Answer Questions
9. Explain the key features of Microsoft Excel and Google Sheets.
Excel: Advanced data analysis, PivotTables, charts, VBA macros.
Google Sheets: Cloud-based, real-time collaboration, accessible from any device.
10. Describe the main components of the Excel interface.
Ribbon, Rows, Columns, Cells, Formula Bar, Name Box, and Worksheet Tabs.
11. Differentiate between .xlsx, .xlsm, and .csv file formats with suitable examples.
.xlsx – Standard Excel file
.xlsm – Excel file with macros
.csv – Comma-separated plain text file
12. Explain different navigation techniques in an Excel workbook using mouse and keyboard.
Mouse: Clicking, scrolling, switching tabs.
Keyboard: Arrow keys, Ctrl + Arrow, Ctrl + Home, Ctrl + Page Up/Page Down.
13. Describe the steps to insert and delete rows and columns in Excel with examples.
To insert: Right-click → Insert. Example: Insert row above row 5.
To delete: Right-click → Delete. Example: Delete column C.
14. Explain the importance of formatting in Excel. How do you format text, numbers, and dates?
Importance: Improves readability and understanding.
Text: Change font, color, alignment.
Numbers: Currency, decimals, percentages.
Dates: Custom formats (DD-MMM-YYYY).
Part C – Application / Problem-Solving Questions
15. Suppose you have marks of 5 students in columns A and B. Write the steps to calculate total
marks in column C using a formula.
In C2, type =A2 + B2 → Press Enter → Drag down to copy the formula.
16. You entered a date as 22/09/2025 in a cell. Show how to display it as Monday, September 22,
2025.
Right-click → Format Cells → Custom → Type: dddd, mmmm dd, yyyy.
17. Create a data range from A1:C5 containing sales data and explain how you would create a bar
chart from it.
Select A1:C5 → Insert → Chart → Bar Chart → Add titles and labels.
18. If cell A1 = 10 and B1 = 15, write the formula to add them and display the result in C1.
Formula: =A1 + B1
19. A business wants to prepare a budget sheet. Explain how spreadsheet software can help in this
case.
It allows automatic calculations, visual charts, and organized financial tracking using formulas and
formatting tools.
