Unit 3
Chapter 5: Data Handling with Google Sheets
1. . What is Google Sheets?
Ans: Google Sheets is an online spreadsheet application that helps users organize,
analyze, and present data.
2. What are the main uses of Google Sheets?
Ans: Google Sheets is used for:
Organizing data in rows and columns in a structured way
Performing calculations such as addition, subtraction, and formulas
Sorting and filtering data to analyze information easily
Creating charts and tables to present data clearly
Managing personal tasks like budgeting, planning events, and tracking expenses
3. Write the advantages of Google Sheets.
Ans: The advantages of Google Sheets are:
It is free and can be used online without installation
Data is saved automatically in Google Drive
Multiple users can work on the same sheet at the same time
Easy sharing through email or links with access control
Reduces errors by using formulas and automated features.
4. . Name the key components of Google Sheets.
Ans. Menu bar, Toolbar, Formula bar, Sheet tabs.
5. What is Menu bar?
Ans: Menu Bar is located at the top of the Google Sheets interface. It contains options
such as File, Edit, View, and Insert, which are used to create, open, save, print, and
manage spreadsheets.
6. What is Tool bar and where it is located?
Ans: The Toolbar is located just below the Menu Bar. It includes icons and buttons used
for quick formatting of text, cell formatting, and inserting elements such as charts,
images, and links. It helps users work faster without opening menus repeatedly.
Unit 3
Chapter 5: Data Handling with Google Sheets
7. What is Formular bar?
Ans: The Formula Bar is located below the Toolbar. It displays the contents of the
selected cell and is used to enter or edit data and formulas. It helps users perform
calculations and view formulas easily.
8. What are Sheet Tabs? How are they useful in Google Sheets?
Ans: Sheet Tabs are located at the bottom of the Google Sheets window. They are used to
move between different sheets in a workbook and help organize data into multiple sheets.
Users can add, rename, or delete sheets using these tabs.
9. What is a To-Do list?
A To-Do List in Google Sheets is used to organize and manage tasks by listing activities
along with dates and status. It helps users track what work needs to be done and what has
already been completed
10. What is the use of checkbox in To Do list?
Ans: A checkbox is used to mark tasks as completed or pending in a To-Do List. When a
task is finished, the checkbox is ticked, which makes task tracking easier and more
organized.
11. What is the progress bar in To Do list?
Ans: A progress bar shows the completion level of tasks in a visual form. It automatically
updates when check boxes are selected and helps users quickly see how much work has
been completed.
12. How does a Progress Bar help in task management?
Ans: A progress bar helps users understand task progress at a glance. It saves time by
automatically calculating completed tasks and motivates users to finish remaining work.
13. What is Google Forms?
Ans: Google Forms is an online tool used to create surveys, quizzes, and forms to collect
information from users easily.
Unit 3
Chapter 5: Data Handling with Google Sheets
14. What is the purpose of using Google Forms?
Ans: Google Forms is used to collect responses such as opinions, feedback, or data from
many people in an organized and efficient way.
15. What types of questions can be added in Google Forms?
Ans: Different types of questions such as multiple-choice, short answer, and checkbox
questions can be added in Google Forms.
16. How does AI help users in Google Sheets?
Ans: AI helps users by automating repetitive tasks, improving accuracy, analyzing large
data sets, and saving time in data management.
17. How can AI be used to create an assignment tracker in Google Sheets?
Ans: AI can be used by giving a detailed prompt to generate a sheet with subject names,
due dates, status columns, colors, and drop-down menus, which can then be inserted into
Google Sheets