Handbooktik8 - KisifinaltestTIK8gen

Kisi final testTIK8gen

Part 1 History of GSS

1. When was Google Sheets first released?

A) 2004

B) 2006

C) 2012

D) 2006
Answer: D) 2006

2. Google Sheets was initially part of which service?

A) Google Docs

B) Google Drive

C) Google Workspace

D) Google Apps
Answer: A) Google Docs

3. What was the original name of Google Sheets when it was launched?

A) Google Tables

B) Google Spreadsheet

C) Google Data

D) Google Cells
Answer: B) Google Spreadsheet

4. Google Sheets was created as a response to which popular software?

A) Microsoft Excel

B) Lotus 1-2-3

C) Apple Numbers

D) openoffice Calc
Answer: A) Microsoft Excel

5. Which company did Google acquire to enhance the spreadsheet capabilities in Google Sheets?

A) Tonic Systems

B) 2web Technologies

C) jotspot

D) Keyhole
Answer: B) 2web Technologies

6. In what year did Google Sheets become a part of the Google Drive suite?

A) 2010

B) 2012

C) 2008

D) 2009
Answer: B) 2012

7. What feature was added to Google Sheets in 2014 that allowed for live collaboration?

A) Offline editing

B) Conditional formatting

C) Real-time collaboration

D) Macros
Answer: C) Real-time collaboration

8. Google Sheets introduced offline editing in which year?

A) 2011

B) 2010

C) 2013

D) 2014
Answer: C) 2013

9. Before Google Sheets, what was Google’s main focus in productivity software?

A) Spreadsheets

B) Presentations

C) Word processing

D) File storage
Answer: C) Word processing

10. Google Sheets became part of which rebranded productivity suite in 2020?

A) Google Workspace

B) Google Suite

C) Google Office

D) Google Apps for Work
Answer: A) Google Workspace

11. What significant competitor to Google Sheets was released in 2009?

A) Microsoft Excel

B) Apple Numbers

C) Zoho Sheet

D) libreoffice Calc
Answer: B) Apple Numbers

12. Which of the following features was introduced to Google Sheets in 2016?

A) Machine learning-based Explore tool

B) Add-ons

C) Pivot tables

D) Charting tools
Answer: A) Machine learning-based Explore tool

13. The first version of Google Sheets allowed how many users to edit simultaneously?

A) 50 users

B) 100 users

C) 25 users

D) Unlimited users
Answer: B) 100 users

14. Google Sheets was initially developed using which programming language?

A) javascript

B) Python

C) Java

D) Ruby
Answer: C) Java

15. Which of these was a key selling point for Google Sheets over Excel when it first launched?

A) Better formulas

B) Larger file size support

C) Cloud-based accessibility

D) More data processing power
Answer: C) Cloud-based accessibility

16. Google Sheets fully integrated with Google Drive in which year?

A) 2011

B) 2012

C) 2010

D) 2009
Answer: B) 2012

17. Which major update to Google Sheets was rolled out in 2018?

A) Integration with Google Assistant

B) Introduction of macros

C) Support for Excel file types

D) Enhanced security features
Answer: B) Introduction of macros

18. What feature was introduced in 2019 that allowed Sheets to handle larger datasets?

A) big query integration

B) Macros

C) Enhanced filtering

D) Machine learning tools
Answer: A) big query integration

19. Google Sheets allows users to import and export which of the following file types?

A) CSV, XLSX, ODS

B) DOCX, PDF, HTML

C) JPEG, PNG, GIF

D) MP3, WAV, AAC
Answer: A) CSV, XLSX, ODS

20. Which of these features has been a key differentiator for Google Sheets since its early days?

A) Offline access

B) Mobile editing

C) Real-time collaboration

D) Data visualization tools

Answer: C) Real-time collaboration

21. Google Sheets introduced pivot tables in which year?

a) 2008
b) 2010
c) 2011
d) 2010 *

22. Google Sheets was initially launched as a part of which suite of applications?

a) Google G Suite *
b) Google Workspace
c) Google Docs Suite
d) Google Office

23. In which year did Google Sheets introduce the Explore tool powered by machine learning?

a) 2015
b) 2016 *
c) 2014
d) 2017

24. In 2018, Google Sheets launched support for which scripting language?

a) Python
b) JavaScript *
c) PHP
d) Ruby

25. What was the primary purpose of Google Sheets when it was first released?

a) Presentation software
b) Cloud-based spreadsheet management *
c) Graphic design tool
d) Word processing

26. Which company was Google Sheets originally developed by?

a) Google
b) 2Web Technologies *
c) Microsoft
d) Netscape

27. Google Sheets supported how many languages upon its initial release?

a) 1
b) 5
c) 10
d) 5 *

28. In which year did Google Sheets add chart functionality to its features?

a) 2009
b) 2007 *
c) 2006
d) 2010

29. Which of the following is a feature that distinguishes Google Sheets from Microsoft Excel?

a) Offline access
b) Cloud-based collaboration *
c) Data visualization tools
d) Macro support

30. In what year did Google Sheets introduce the ability to create custom functions with Apps Script?

a) 2010
b) 2011
c) 2012 *
d) 2013

31. Google Sheets adopted which technology to improve processing speed and performance in 2017?

a) Quantum computing
b) Artificial intelligence
c) New rendering engine *
d) Blockchain

32. Which of the following integrations became available with Google Sheets in 2018?

a) Microsoft Office Suite
b) Google Data Studio *
c) SAP Analytics
d) Salesforce

33. Which feature introduced in 2017 allows users to automate repetitive tasks?

a) Macros *
b) Pivot Tables
c) Conditional Formatting
d) Filters

34. In 2019, Google Sheets introduced what function to help analyze large datasets?

a) BigQuery integration *
b) Enhanced Pivot Tables
c) Charting Templates
d) Data Modeling Tools

35. Google Sheets mobile app was first released for which platform?

a) Android *
b) iOS
c) Windows Phone
d) Blackberry OS

36. When did Google Sheets launch support for Excel file types (XLSX)?

a) 2014 *
b) 2013
c) 2015
d) 2012

37. The "Explore" tool in Google Sheets is powered by which technology?

a) Blockchain
b) Cloud computing
c) Machine learning *
d) Data analytics

38. What was the original file storage system called before Google Drive was introduced?

a) Google Cloud Storage
b) Google Docs List *
c) Google Storage
d) Google Files

39. Google Sheets transitioned to which new user interface in 2014?

a) Material Design *
b) Classic Sheets
c) Google Dark Mode
d) Sheets Simple UI

40. Which of these was a direct competitor to Google Sheets in the cloud-based spreadsheet market?

a) LibreOffice
b) Quip *
c) Excel 365
d) Zoho Sheets

41. Google Sheets added support for which advanced feature in 2018?

a) AI-powered suggestions *
b) Data auditing
c) External connectors
d) Formulas autocomplete

42. In which year did Google rebrand G Suite to Google Workspace?

a) 2021
b) 2020 *
c) 2019
d) 2018

43. The Google Sheets mobile app was first made available in which year?

a) 2012 *
b) 2010
c) 2013
d) 2014

44. Google Sheets introduced an auto-save feature early in its development. When was it first rolled out?

a) 2008 *
b) 2006
c) 2010
d) 2007

45. What was a major advancement made by Google Sheets in 2017 for handling larger datasets?

a) Pivot table optimization
b) Enhanced query performance *
c) Custom chart templates
d) Built-in SQL support

46. In 2019, Google Sheets improved upon which data-handling feature?

a) Data validation
b) Pivot table capabilities *
c) Chart formatting
d) Real-time collaboration

47. Which Google product provides data insights directly integrated with Google Sheets?

a) Google Trends
b) Google Data Studio *
c) Google Analytics
d) Google Search Console

48. Google Sheets started offering which advanced analytics tool in 2018?

a) Google Analytics
b) BigQuery *
c) Firebase
d) Looker

49. When did Google Sheets introduce the Add-ons feature, allowing third-party integrations?

a) 2014 *
b) 2013
c) 2015
d) 2016

50. What significant feature was launched by Google Sheets in 2016 to enhance productivity?

a) The Explore feature *
b) Macros
c) Custom Functions

d) Data Cleanup

Essay
1. Q: What is Google Sheets?

A: Google Sheets is an online spreadsheet program where you can organize, calculate, and share data.

2. Q: Who created Google Sheets?

A: Google created Google Sheets.

3. Q: When was Google Sheets first launched?

A: Google Sheets was launched in 2006.

4. Q: What is a spreadsheet?

A: A spreadsheet is a table made of rows and columns where you can add numbers, text, and formulas.

5. Q: Why did Google make Google Sheets?

A: Google made it so people could create and edit spreadsheets online and share them with others.

6. Q: What was Google Sheets called at first?

A: It was called Google Spreadsheets when it first came out.

7. Q: What is special about Google Sheets?

A: Many people can work on the same file at the same time from anywhere!

8. Q: Do you need to install Google Sheets on your computer?

A: No! You can use it on the internet with a browser.

9. Q: Is Google Sheets free to use?

A: Yes, it is free for anyone with a Google account.

10. Q: Can you use Google Sheets on a phone or tablet?

A: Yes! You can use it with the Google Sheets app.

Part 2 Menu of GSS

1. Which menu option allows you to insert a chart in Google Sheets?

A) Data

B) Insert

C) View

D) Edit
Answer: B) Insert

2. How do you apply conditional formatting to a range of cells?

A) Data > Conditional Formatting

B) Insert > Conditional Formatting

C) Format > Conditional Formatting

D) View > Conditional Formatting
Answer: C) Format > Conditional Formatting

3. Which function calculates the sum of a range of cells?

A) =ADD

B) =TOTAL

C) =SUM

D) =COUNT
Answer: C) =SUM

4. To freeze a row in Google Sheets, you go to which menu?

A) View > Freeze

B) Data > Freeze

C) Format > Freeze

D) Tools > Freeze
Answer: A) View > Freeze

5. Which function returns the average of a set of numbers?

A) =MEDIAN

B) =MEAN

C) =AVERAGE

D) =MODE
Answer: C) =AVERAGE

6. Which menu allows you to filter data in Google Sheets?

A) Data > Filter

B) View > Filter

C) Edit > Filter

D) Insert > Filter
Answer: A) Data > Filter

7. What function would you use to count cells that contain numbers?

A) =COUNT

B) =COUNTA

C) =COUNTIF

D) =COUNTBLANK
Answer: A) =COUNT

8. How do you insert a new sheet into a workbook?

A) Data > Insert Sheet

B) View > Insert Sheet

C) Insert > Sheet

D) Edit > New Sheet
Answer: C) Insert > Sheet

9. To apply a border to a cell, which menu do you use?

A) Format > Cell Borders

B) Insert > Cell Borders

C) Data > Borders

D) View > Cell Borders
Answer: A) Format > Cell Borders

10. Which function would return the current date?

A) =TODAY()

B) =DATE()

C) =NOW()

D) =CURRENT DATE()
Answer: A) =TODAY()

11. How do you sort a range of data alphabetically?

A) Data > Sort A to Z

B) Insert > Sort

C) View > Sort

D) Tools > Sort Data
Answer: A) Data > Sort A to Z

12. What does the =VLOOKUP function do?

A) Searches for a value in a vertical table

B) Filters data by a specific column

C) Combines text from multiple cells

D) Counts the number of vertical cells
Answer: A) Searches for a value in a vertical table

13. Which menu allows you to insert a comment in Google Sheets?

A) Tools > Comment

B) View > Comment

C) Edit > Insert Comment

D) Insert > Comment
Answer: D) Insert > Comment

14. How can you remove duplicate values from a column?

A) Data > Remove Duplicates

B) Tools > Clear Duplicates

C) Edit > Delete Duplicates

D) Format > Duplicate Removal
Answer: A) Data > Remove Duplicates

15. To merge cells in Google Sheets, you go to which menu?

A) Data > Merge Cells

B) Format > Merge Cells

C) Insert > Merge Cells

D) Tools > Merge Cells
Answer: B) Format > Merge Cells

16. What does the =IF function do?

A) Returns the sum of a condition

B) Checks a condition and returns one value if true and another if false

C) Combines text from different cells

D) Converts data types
Answer: B) Checks a condition and returns one value if true and another if false

17. Where can you create a pivot table in Google Sheets?

A) Insert > Pivot Table

B) Data > Pivot Table

C) Format > Pivot Table

D) Tools > Create Pivot
Answer: A) Insert > Pivot Table

18. Which function finds the largest number in a range of cells?

A) =MAX

B) =MIN

C) =LARGE

D) =BIG
Answer: A) =MAX

19. How can you protect a range of cells from editing?

A) Data > Protect Range

B) View > Lock Cells

C) Tools > Protect Range

D) Insert > Secure Cells
Answer: A) Data > Protect Range

20. What is the purpose of the =CONCATENATE function?

A) Combines text from two or more cells into one cell

B) Calculates the sum of values in two cells

C) Merges multiple sheets into one

D) Splits text from one cell into multiple cells

Answer: A) Combines text from two or more cells into one cell

21. To create a filter view, which menu would you access?

a) View > Filter View
b) Data > Filter View *
c) Tools > Filter View
d) Format > Filter View

22. Which function would you use to count blank cells in a range?

a) =COUNTIF
b) =BLANK
c) =COUNTA
d) =COUNTBLANK *

23. How do you format numbers as currency in Google Sheets?

a) Data > Currency
b) Format > Number > Currency *
c) Insert > Currency
d) Tools > Format as Currency

24. Which function rounds a number to the nearest whole number?

a) =CEILING
b) =FLOOR
c) =ROUND *
d) =TRUNCATE

25. How do you insert an image into a Google Sheets cell?

a) Insert > Image in cell *
b) Format > Add Image
c) Data > Insert Image
d) Tools > Image in Cell

26. What does the =IMPORTRANGE function do?

a) Imports data from a different sheet in the same workbook
b) Imports data from a URL
c) Imports data from another Google Sheet *
d) Imports data from a CSV file

27. To apply a filter to a range of cells, which menu do you use?

a) View > Filter
b) Data > Create Filter *
c) Insert > Filter
d) Format > Filter

28. Which function returns the number of cells that meet a specific condition?

a) =COUNTA
b) =COUNTIF *
c) =COUNT
d) =IF

29. How do you adjust the width of a column to fit its contents?

a) View > Resize Column
b) Format > Auto-Resize
c) Data > Resize
d) Right-click column header > Resize to fit *

30. What does the =INDEX function do?

a) Returns the value of a cell in a specified row and column *
b) Counts the number of unique values
c) Sorts a range of data
d) Returns the row number of a cell

31. How do you access Google Sheets add-ons?

a) Data > Add-ons
b) Insert > Add-ons
c) Extensions > Add-ons *
d) View > Add-ons

32. Which function would you use to find the smallest number in a range of cells?

a) =LITTLE
b) =MIN *
c) =LOW
d) =SMALL

33. How do you insert a hyperlink into a cell?

a) Insert > Hyperlink *
b) Data > Add Hyperlink
c) Format > Hyperlink
d) Tools > Link

34. Which menu allows you to add a note to a cell?

a) Insert > Comment
b) Format > Insert Note
c) Insert > Note *
d) View > Insert Note

35. What does the =QUERY function do?

a) Queries a dataset and returns specified values *
b) Combines data from multiple ranges
c) Sorts and filters data
d) Analyzes the structure of the sheet

36. How can you create a data validation rule?

a) Data > Data Validation *
b) Tools > Data Validation
c) Format > Validation
d) View > Data Rules

37. Which function is used to search for a value in a horizontal table?

a) =LOOKUP
b) =HLOOKUP *
c) =VLOOKUP
d) =SEARCH

38. How do you hide a sheet in Google Sheets?

a) Format > Hide Sheet
b) View > Hide Sheet
c) Right-click the sheet tab > Hide Sheet *
d) Data > Hide Sheet

39. Which function removes all spaces from text except for single spaces between words?

a) =REMOVE
b) =TRIM *
c) =CLEAN
d) =SUBSTITUTE

40. How do you change the theme of a Google Sheet?

a) Format > Theme *
b) Data > Theme
c) Tools > Theme
d) View > Change Theme

41. What is the purpose of the =ARRAYFORMULA function?

a) Applies a formula to a range of cells at once *
b) Combines two arrays into one
c) Creates a visual chart from data
d) Splits text into multiple columns

42. Which menu allows you to create a dropdown list in Google Sheets?

a) View > Dropdown
b) Data > Data Validation *
c) Format > Dropdown
d) Insert > Dropdown List

43. What does the =TRANSPOSE function do?

a) Sorts data alphabetically
b) Flips the rows and columns of a range *
c) Combines data from multiple sheets
d) Changes the orientation of text

44. How do you add a checkbox to a cell in Google Sheets?

a) Insert > Checkbox *
b) Format > Add Checkbox
c) Data > Checkbox
d) Tools > Insert Checkbox

45. Which function extracts a substring from a text value?

a) =MID *
b) =LEFT
c) =RIGHT
d) =EXTRACT

46. How do you view the formula in a cell?

a) Data > Show Formula
b) View > Show Formula *
c) Insert > Display Formula
d) Format > Show Formula

47. What does the =SPLIT function do?

a) Separates a text string into columns based on a delimiter *
b) Divides a cell’s value by a number
c) Combines text from two cells into one
d) Merges two ranges into one

48. How do you add an alternate row color in Google Sheets?

a) Format > Alternate Colors *
b) View > Alternate Row Colors
c) Data > Row Color
d) Insert > Color Rows

49. Which menu allows you to apply a custom formula for conditional formatting?

a) Insert > Conditional Formatting
b) Data > Format Rules
c) Format > Conditional Formatting *
d) View > Conditional Formatting

50. What does the =UNIQUE function do?

a) Returns a list of unique values in a range *
b) Combines all values into one cell
c) Removes duplicates from a dataset
d) Analyzes a range for errors

Essay
1. Q: What is a formula in Google Sheets?

A: A formula is a math instruction that tells Google Sheets what to calculate.

2. Q: What symbol do all formulas start with?

A: All formulas start with an equals sign (=).

3. Q: What does the formula =2+3 do?

A: It adds 2 and 3 and shows the answer, which is 5.

4. Q: What does =A1+A2 mean?

A: It adds the number in cell A1 to the number in A2.

5. Q: What does =SUM(A1:A5) do?

A: It adds all the numbers from cells A1 to A5.

6. Q: What does =AVERAGE(B1:B3) do?

A: It finds the average (mean) of the numbers in cells B1, B2, and B3.

7. Q: What does =MAX(C1:C4) show?

A: It shows the biggest number in cells C1 to C4.

8. Q: What does =MIN(D1:D4) show?

A: It shows the smallest number in cells D1 to D4.

9. Q: What does =A1*B1 mean?

A: It multiplies the number in A1 by the number in B1.

10. Q: Can Google Sheets update formulas when numbers change?

A: Yes! If you change a number in a cell, the formula updates the answer automatically.

Page updated

Report abuse