Scribd
Upload
6 views2 pages

Module 1 Answer Key

The document provides an answer key for a module on spreadsheet software, detailing short and long answer questions about features, functions, and formatting in Microsoft Excel and Google Sheets. Key topics include the differences between workbooks and worksheets, navigation shortcuts, and the importance of formatting for readability. Additionally, it covers practical applications such as creating formulas and charts.

Uploaded by

muhammedashiqc889
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

Module 1 Answer Key

The document provides an answer key for a module on spreadsheet software, detailing short and long answer questions about features, functions, and formatting in Microsoft Excel and Google Sheets. Key topics include the differences between workbooks and worksheets, navigation shortcuts, and the importance of formatting for readability. Additionally, it covers practical applications such as creating formulas and charts.

Uploaded by

muhammedashiqc889
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MODULE 1 ANSWER KEY

Part A – Short Answer Questions

1. Spreadsheet software allows users to organize, analyze, and store data in tabular form.
Examples: Microsoft Excel, Google Sheets.

2. Workbook = entire file; Worksheet = single page/tab within a workbook.

3. Cell address: C7

4. Advantages of Google Sheets:


- Real-time collaboration
- Cloud storage and autosave

5. Name Box displays active cell address or defined name.

6. Shortcut to insert new row: Ctrl + Shift + +

7. “Wrap Text” displays text on multiple lines within a cell.

8. Examples of number formatting:


- Currency
- Percentage

Part B – Long Answer Questions

9. Key Features:
Excel: Data analysis tools, PivotTables, charts.
Google Sheets: Cloud-based, real-time collaboration.

10. Excel Interface:


Ribbon, Rows, Columns, Cells, Formula Bar, Name Box, Worksheet Tabs.

11. File Formats:


.xlsx – Standard file
.xlsm – With macros
.csv – Text-based data file

12. Navigation:
Mouse and keyboard shortcuts (Ctrl + Home, Ctrl + PgDn, etc.).

13. Insert/Delete Rows/Columns:


Right-click → Insert/Delete → Confirm.

14. Formatting Importance:


Improves readability and understanding.
Text – Font, Color
Numbers – Currency, Decimal
Dates – Custom formats

Part C – Application / Problem Solving Questions

15. Formula for totals:


In C2, type =A2 + B2 → Press Enter → Drag to copy.
16. Display date as Monday, September 22, 2025:
Format Cells → Custom → Type: dddd, mmmm dd, yyyy.

17. Create Bar Chart:


Select A1:C5 → Insert → Charts → Bar Chart.

18. Formula:
=A1 + B1

19. Budget Sheet Uses:


Formulas for totals, visual charts, easy data updates, and financial tracking.

You might also like