WorksheetsGoogle Tools Quiz
Total questions: 60
Worksheet time: 30mins
Which library is commonly used for creating static, animated, and interactive visualizations in Python?
NumPy
SciPy
Matplotlib
TensorFlow
What function in Matplotlib is used to create a new figure?
plt.show()
plt.figure()
plt.plot()
plt.new()
In Pandas, which function is used to read a CSV file into a DataFrame?
read_table()
read_file()
read_csv()
load_csv()
Which Seaborn function is used to create a bar plot?
barplot()
bar()
plot_bar()
seaborn_bar()
How do you add a title to a plot in Matplotlib?
plt.title('Title')
plt.header('Title')
plt.name('Title')
plt.plot_title('Title')
Which function in Pandas is used to calculate the mean of DataFrame columns?
calculate_mean()
mean()
avg()
average()
What Seaborn function is used to plot pairwise relationships in a dataset?
pairplot()
pairwiseplot()
scatterplot()
lineplot()
In Matplotlib, what is the function to display the plot?
plt.display()
plt.show()
plt.plot()
plt.visualize()
Which method in Pandas will give the first 5 rows of the DataFrame?
start()
begin()
head()
first()
What function in Matplotlib is used to create a scatter plot?
scatterplot()
scatter()
plt.scatter()
plt.plotscatter()
How can you share a Google Docs document with others?
Download and email
Use the Share button
Upload to a cloud storage service
Print and distribute
Which of the following is not a text formatting option in Google Docs?
Bold
Italic
Strikethrough
Uppercase transformation
How do you add a comment in Google Docs?
Highlight text and press Ctrl+Alt+M
Go to Insert > Comment
Both a and b
Go to Tools > Comment
What is the purpose of the Explore tool in Google Docs?
To perform calculations
To suggest content and resources
To translate text
To draw shapes
Which option allows you to find and replace text in a Google Docs document?
Tools > Find and Replace
Edit > Find and Replace
Insert > Find and Replace
File > Find and Replace
How can you add a table of contents in Google Docs?
Insert > Table of contents
Insert > Index
Insert > Reference
Insert > Bibliography
Which menu allows you to adjust paragraph spacing in Google Docs?
Format > Paragraph spacing
Insert > Paragraph spacing
View > Paragraph spacing
Tools > Paragraph spacing
What is the purpose of using headers and footers in Google Docs?
To add background images
To add repeated text or page numbers
To insert diagrams
To change font styles
How do you check the word count of a Google Docs document?
Tools > Word count
View > Word count
Edit > Word count
File > Word count
How can you insert a link into text in Google Docs?
Format > Link
Insert > Link
Edit > Link
View > Link
Which function is used to calculate the sum of a range of cells in Google Sheets?
ADD
TOTAL
SUM
CALCULATE
How can you create a new Google Sheets spreadsheet?
File > New > Spreadsheet
Insert > New > Spreadsheet
View > New > Spreadsheet
Data > New > Spreadsheet
What is the shortcut for duplicating a sheet in Google Sheets?
Right-click the sheet tab and select 'Duplicate'
Ctrl+C, Ctrl+V
Shift+Tab
File > Duplicate
How do you freeze rows or columns in Google Sheets?
Data > Freeze
View > Freeze
Tools > Freeze
Format > Freeze
Which function would you use to find the average of a range of cells in Google Sheets?
MEAN
AVG
AVERAGE
CALCAVG
How can you create a chart in Google Sheets?
Insert > Chart
Data > Chart
View > Chart
Tools > Chart
What is the purpose of the FILTER function in Google Sheets?
To filter out errors in data
To sort data in ascending order
To create a new range that meets specified criteria
To highlight duplicate values
How do you merge cells in Google Sheets?
Format > Merge cells
Insert > Merge cells
Data > Merge cells
Tools > Merge cells
Which function would you use to concatenate text from multiple cells into one cell in Google Sheets?
JOIN
MERGE
CONCATENATE
UNION
How can you sort data in Google Sheets?
Data > Sort range
Format > Sort range
View > Sort range
Insert > Sort range
What is the shortcut for entering the current date in a cell in Google Sheets?
Ctrl+D
Ctrl+;
Ctrl+Shift+D
Ctrl+Shift+;
How can you protect a range of cells in Google Sheets?
Data > Protect sheets and ranges
View > Protect sheets and ranges
Insert > Protect sheets and ranges
Format > Protect sheets and ranges
Which function is used to lookup a value in the first column of a range and returns a value in the same row from a specified column in Google Sheets?
LOOKUP
FIND
SEARCH
VLOOKUP
How do you apply conditional formatting in Google Sheets?
Format > Conditional formatting
Data > Conditional formatting
Tools > Conditional formatting
View > Conditional formatting
How do you hide a column in Google Sheets?
Right-click the column header and select 'Hide column'
Format > Hide column
Data > Hide column
Tools > Hide column
How can you create a pivot table in Google Sheets?
Insert > Pivot table
Data > Pivot table
Format > Pivot table
Tools > Pivot table
Which function counts the number of cells that meet a criterion in Google Sheets?
COUNTIF
SUMIF
COUNT
IF
How do you insert a checkbox in Google Sheets?
Insert > Checkbox
Data > Checkbox
Tools > Checkbox
Format > Checkbox
How can you split text into columns in Google Sheets?
Data > Split text to columns
Format > Split text to columns
Insert > Split text to columns
Tools > Split text to columns
Which function in Google Sheets returns the largest value in a range?
MAX
LARGE
BIGGEST
HIGHEST
How do you remove duplicates in Google Sheets?
Data > Data cleanup > Remove duplicates
Format > Remove duplicates
Tools > Remove duplicates
View > Remove duplicates
What is the shortcut for inserting a new sheet in Google Sheets?
Shift + F11
Ctrl + F11
Shift + F10
Ctrl + F10
How can you insert a function in Google Sheets?
Insert > Function
Data > Function
Tools > Function
Format > Function
What is the purpose of the QUERY function in Google Sheets?
To perform complex data manipulation using SQL-like queries
To quickly sort data
To merge cells based on conditions
To format cells conditionally
How do you transpose data in Google Sheets?
Paste special > Transpose
Data > Transpose
Format > Transpose
Tools > Transpose
Which function returns the current date and time in Google Sheets?
NOW()
DATE()
TODAY()
CURRENT()
How do you apply a filter to a range in Google Sheets?
Data > Create a filter
View > Create a filter
Insert > Create a filter
Format > Create a filter
How do you highlight cells with specific text in Google Sheets?
Format > Conditional formatting
Data > Conditional formatting
Tools > Conditional formatting
Insert > Conditional formatting
Which function checks a condition and returns one value if true and another value if false in Google Sheets?
IF
CHECK
COND
EVAL
How do you hide a row in Google Sheets?
Right-click the row number and select 'Hide row'
Format > Hide row
Data > Hide row
Tools > Hide row
What function in Google Sheets would you use to return the smallest value in a range?
MIN
LOWEST
SMALLEST
TINY
How can you import data from another Google Sheets file?
File > Import
Data > Import data
Insert > Link to spreadsheet
View > Import range
What is the purpose of the SPARKLINE function in Google Sheets?
To create small charts within a cell
To filter data based on criteria
To merge multiple sheets
To highlight errors
How do you create a hyperlink in a cell in Google Sheets?
Insert > Link
Format > Hyperlink
Data > Insert link
Tools > Hyperlink
How can you apply a predefined formatting style to cells in Google Sheets?
Format > Conditional formatting
Data > Conditional formatting
Tools > Conditional formatting
View > Conditional formatting
Which function calculates the total of a range of cells and divides the result by the number of cells in the range?
SUM
DIVIDE
AVERAGE
COUNT
How can you set a custom date format for cells in Google Sheets?
Format > Number > Custom date and time
Data > Custom date and time
Insert > Custom date and time
Tools > Custom date and time
How do you share a Google Sheets file with others for collaboration?
File > Share
Data > Share
Insert > Share
Tools > Share
Which function would you use to find the position of a value within a range in Google Sheets?
POSITION
LOCATE
INDEX
FIND
How can you create a drop-down list in a cell in Google Sheets?
Data > Data validation
Format > Data validation
Insert > Data validation
Tools > Data validation
