Font size
WorksheetsGoogle Sheets
Total questions: 21
Worksheet time: 30mins
Google Sheets is a _______ application that enables users to create, update, and modify spreadsheets and share data online in real-time.
online
How can we open google sheets?
By clicking the 9 dots
By clicking the "new" button in Google Drive
By searching sheets.new
By typing in the search box the link: sheets.google.com
Google Sheets can be used for the following tasks, with the exception of?
Sharing and collaborating with other google application
Creating and editing graphs or charts
Which of the following is NOT a feature or function commonly found in Google Sheets?
Pivot Chart
Named Function
What do you mean by Pivot Tables?
These are the commands that help you to paste data in a spreadsheet, EXCEPT:
Ctrl+V
Ctrl+Shift+V
Ctrl+Alts+V
Ctrl+Fn+V
What does the "Number Format" feature in Google Sheets allow you to do?
Change the appearance of numbers in a cell
Format numbers as currency, percentages, or dates
It will display a portion of the data, although all the data will still be figured into formulas and functions.
Overflow
Wrapped
Clip
Extend
Why do we need to merge cells in Google Sheets?
To make your data more readable.
To extend a title or any content across multiple cells.
To put all the data in one cell (e.g., Numbers, Texts, Formulas and Functions).
What column comes next after column Z?
2A
ZA
They are used to visually display and analyze data, making it easier to understand trends, patterns, and relationships within the data.
(a)
It is a popular way to display and compare data across different categories or time periods.
(a)
Google Sheets provides options for customizing this charts, such as adding trendlines or regression lines to visualize the overall trend in the data. What type of chart is this?
(a)
It refers to a series of recorded actions or commands that can be played back to automate repetitive tasks within the spreadsheet application.
(a)
These are cell references that adjust automatically when you copy a formula to different cells. They are essential for efficiently working with datasets and performing calculations on multiple rows or columns of data.
(a)
Based on the table, what will be the average total cost of all the pencil? Round off your answer into nearest hundredths.
(a)
Get the final cost with tax of all the items. What is the average of the final cost with tax?
(a)
With the given conditions, use IF Function to identify the remarks of the final cost. How many values got a "Low Cost" remarks?
(a)
What value will result to '#NA'?
(a)
Based on the given data sets, what are the values included in the Vlookup Equivalent column?
Ex: 1,2,3,4,5
(a)
If you type "=AVERAGE(SCORES)" in cell H4, what will be the output? Round off your answer to the nearest whole number.
(a)
