Font size
WorksheetsGoogle Docs and Forms Quiz
Total questions: 90
Worksheet time: 45mins
Which feature in Google Docs allows you to view all edits made to a document, including who made them and when?
Track Changes
Revision History
Version History
Change Log
Edit Timeline
What is the maximum number of people who can edit a Google Docs document at the same time?
50
100
200
500
Unlimited
Which Google Docs feature allows you to work on a document without an internet connection and sync changes later?
Cloud Sync
Offline Mode
Incognito Mode
Background Save
Drive Autosave
How can you prevent specific users from editing your Google Docs document while still allowing them to add comments?
Set document access to "Viewer"
Enable "Suggesting" mode for them
Set document access to "Commenter"
Enable Track Changes
Use "Restrict Editing" mode
Which shortcut allows you to move an entire paragraph up or down in Google Docs?
Ctrl + Shift + Up/Down (Windows) or Command + Shift + Up/Down (Mac)
Alt + Up/Down
Ctrl + Alt + Arrow Keys
Shift + Drag
There is no shortcut for this
Which tool in Google Docs can be used to assign tasks to specific people?
Tasks Panel
Assignments Tool
Comment Mentions (@)
Google Keep Integration
Document Lock
Which setting in Google Forms prevents users from submitting multiple responses?
Enable CAPTCHA
Require sign-in and limit to 1 response
Turn on "Answer Validation"
Restrict Form Access
Enable "Form Timer"
How can you automatically send form responses to a Google Sheets file?
Click "Export as CSV"
Enable "Link to Google Sheets" in form settings
Copy and paste the data manually
Enable "Data Sync"
Use a Google Apps Script
Which type of question in Google Forms allows users to rank options in order of preference?
Multiple Choice
Checkbox Grid
Dropdown
Ranking
Linear Scale
What happens if you enable the "Shuffle question order" setting in Google Forms?
The questions appear in a random order for each respondent
The responses are randomized after submission
The questions are automatically reordered based on difficulty
Only multiple-choice questions are shuffled
It prevents duplicate responses
Which add-on allows you to set a time limit for completing a Google Form?
FormLimiter
Form Timer
Google Countdown
AutoClose Form
TimerSync
Which function returns the number of numeric values in a range?
COUNT
COUNTA
COUNTIF
SUM
AVERAGE
Which function finds the highest value in a range that meets a condition?
MAX
SUMIF
MAXIFS
VLOOKUP
AVERAGEIF
What does the SUMIF function do?
Finds the sum of all numbers in a range
Adds values based on a specified condition
Counts the number of non-empty cells in a range
Finds the highest value in a range
Returns the average of selected values
How can you apply a formula to an entire column without dragging?
Use the FILL function
Manually copy the formula to each cell
Use an ArrayFormula
Use conditional formatting
Apply absolute referencing
Which function counts the number of blank cells in a range?
COUNT
COUNTA
COUNTIF
COUNTBLANK
SUMIF
Which function finds an approximate match in a lookup table?
HLOOKUP
VLOOKUP with TRUE as the last argument
INDEX
MATCH
FILTER
What does LEFTB function do?
Extracts the last character from a text string
Converts a text string to uppercase
Extracts a specific number of bytes from the left of a text string
Replaces a portion of a text string
Combines multiple text strings into one
Which function returns the number of days between two dates?
DATEDIF
DATEVALUE
TODAY
NOW
TIME
if you apply conditional formatting with a formula using "=$A$1>50"?
It highlights all cells greater than 50
It highlights only A1 if it is greater than 50
It highlights all cells where A1 is greater than 50
It applies formatting to empty cells
It deletes all values greater than 50
Which option in Google Sheets allows you to save a filter for future use?
Sort
Filter View
Data Validation
Pivot Table
Conditional Formatting
Which function would you use to count the number of times a specific word appears in a range?
COUNT
COUNTIF
SUMIF
AVERAGEIF
LEN
Which function counts the number of cells that meet a specific condition?
COUNT
COUNTIF
COUNTA
SUMIF
AVERAGEIF
How can you save a specific filter view in Google Sheets?
Use Data → Sort range
Click "Filter views" and save the filter
Create a Pivot Table
Use a script to save sorting
Apply conditional formatting
What does the TODAY() function return?
The current time
The current date
The last modified date of the sheet
The difference between two dates
A timestamp with time and date
What is Canva primarily used for?
Video editing
Graphic design
Cloud storage
Database management
Which tool is best suited for creating interactive prototypes and user interfaces?
Figma
Wix.com
Piktochart
Canva
What is the main purpose of Wix.com?
Team collaboration
Website building
Creating infographics
Cloud-based storage
Which of the following tools is commonly used for team collaboration and brainstorming?
Canva
Miro
Piktochart
Wix.com
Which tool allows you to create visually appealing infographics quickly?
Canva
Miro
Piktochart
Figma
What is the main feature of Figma?
Collaborative design in real-time
Presentation templates
Data visualization tools
Drag-and-drop website creation
Which platform includes ready-made templates for presentations, posters, and social media posts?
Wix.com
Piktochart
Canva
Figma
What is the key advantage of using Miro?
It is offline and desktop-based
It is optimized for large data analytics
It supports online whiteboarding for collaboration
It focuses on creating infographics
Which tool is best suited for building personal portfolios or blogs?
Canva
Wix.com
Miro
Piktochart
What type of projects can be created using Piktochart?
Code-based applications
Video animations
Infographics, reports, and presentations
Website prototypes
Which menu allows you to insert page numbers in Google Docs?
Insert
Format
Tools
Edit
View
How can you check word count in Google Docs?
Tools → Word Count
File → Document Details
Edit → Count Words
View → Document Statistics
Format → Word Counter
Which feature allows you to add a comment in Google Docs?
Right-click → Add Comment
Click the comment icon in the toolbar
Select text and press Ctrl + Alt + M (Windows) / Command + Option + M (Mac)
All of the above
You cannot add comments in Google Docs
Which function allows multiple users to edit a Google Docs file at the same time?
Real-time collaboration
Offline mode
Read-only mode
Track Changes
Version History
How can you restore an earlier version of a Google Docs document?
File → Version history
Edit → Undo
File → Revert Changes
Tools → Restore File
There is no way to restore a previous version
Which question type allows users to select multiple answers?
Checkbox
Multiple choice
Short answer
Paragraph
Dropdown
How can you create a required question in Google Forms?
Enable "Required" in the question settings
Use "Must Answer Mode"
Add an asterisk (*) in the question
Use "Auto-Complete"
Set a time limit
Which feature allows users to upload a file in Google Forms?
File Upload
Attachment Mode
Response Saver
Google Drive Sync
Custom File Entry
Which question type allows users to rank items in order?
Multiple Choice Grid
Dropdown
Ranking Question
Priority Selection
Drag & Drop Mode
Which setting allows only users from a specific domain to respond to a Google Form?
"Restrict to users in [domain]"
"Private Mode"
"Single-Use Form"
"Password Protection"
"Domain Filtering"
Which function counts the number of non-empty cells in a range?
COUNT
COUNTA
COUNTIF
COUNTBLANK
SUMIF
How can you make a cell reference absolute?
Add "$" before the column and row
Use "ABS()" function
Enable "Absolute Mode"
Convert the value to a constant
Use "LOCK()" function
Which function returns the highest value in a range?
MIN
MAX
SUM
COUNT
AVERAGE
Which function returns the average of numbers that meet a condition?
SUMIF
COUNTIF
AVERAGEIF
MAXIFS
MINIFS
What does the IF function do?
Evaluates a condition and returns different results based on TRUE or FALSE
Finds a value in a table
Counts the number of blank cells
Returns the maximum value
Sorts data automatically
Which function allows you to search for a value in the first column of a table?
HLOOKUP
INDEX
MATCH
VLOOKUP
FILTER
Which function returns the number of days between two dates?
TODAY
DATEVALUE
DATEDIF
NOW
DAYS
What does the LEFT function do?
Extracts the leftmost characters from a text string
Extracts the last characters from a text string
Converts a text string to uppercase
Finds a word in a text string
Splits text into columns
How can you freeze the first row in Google Sheets?
View → Freeze → 1 row
Format → Lock Row
Data → Fix Row
Edit → Hold First Row
Sheets → Pin Header
How can you create a dropdown list in Google Sheets?
Data → Data Validation
Insert → List
Format → List Options
Tools → Dropdown Manager
Conditional Formatting
Which function counts the number of blank cells in a range?
COUNT
COUNTA
COUNTBLANK
SUMIF
COUNTIF
Which feature in Google Sheets allows you to save a filter for future use?
Filter View
Sort Data
Auto-Filter
Advanced Sorting
Data Lock
Which chart type is best for showing proportions of a whole?
Line Chart
Bar Chart
Pie Chart
Histogram
Scatter Plot
Which function counts the number of cells that meet a specific condition?
COUNT
COUNTIF
COUNTA
SUMIF
AVERAGEIF
What does the TODAY() function return?
The current time
The current date
The last modified date of the sheet
The difference between two dates
A timestamp with time and date
What is the primary purpose of Canva?
Coding websites
Graphic design for marketing materials
Brainstorming with teams
Creating prototypes
Miro is best described as:
A graphic design tool
A collaborative online whiteboard
A data visualization tool
A website building platform
Which platform specializes in creating infographics and data reports?
Canva
Wix.com
Piktochart
Figma
What makes Wix.com different from the other tools?
Website development without coding
Creating infographics
Designing social media content
Team collaboration
Which of these tools is widely used for UX/UI prototyping?
Wix.com
Piktochart
Figma
Miro
What is a unique feature of Canva?
Creating interactive prototypes
Providing infographic templates
Offering pre-designed templates for marketing materials
Website hosting
Which tool is often used for mapping workflows or visualizing ideas?
Piktochart
Miro
Wix.com
Canva
Which platform allows users to create and share infographics efficiently?
Figma
Piktochart
Wix.com
Miro
What is the key feature of Wix.com?
Drag-and-drop web design
Interactive brainstorming tools
High-quality infographic templates
Real-time collaboration for designs
Figma allows multiple users to work on a design simultaneously. This feature is called:
Real-time feedback
Live editing
Collaborative design
Prototyping mode
Which tool in Google Docs allows you to automatically insert a table of contents?
Table
Page numbering
Table of contents
Header and footer
Image
How can you enable suggestion mode in Google Docs, allowing collaborators to propose changes?
Select 'Collaborate Mode'
Switch to 'Suggesting' mode
Enable 'Review Mode'
Add comments
Turn on Track Changes
Which feature allows you to work on a Google Docs document even without an internet connection?
Offline mode
Airplane mode
Incognito mode
Draft mode
Cloud sync
Which feature allows multiple people to edit a Google Docs file at the same time?
Version History
Collaboration Mode
Real-time Editing
Track Changes
Lock Editing
Which of the following allows you to prevent others from editing a section of text in Google Docs?
Use the 'Restrict Editing' option
Apply 'Suggesting' mode
Use 'Protect Sheet'
Highlight text in bold
Enable 'Track Changes'
Which tool in Google Docs can be used for translating text?
Auto-replace
Google Translate
Translator in the 'Tools' menu
Manual translation
Grammarly extension
Which question type in Google Forms allows the user to select multiple answers?
Short answer
Checkboxes
Dropdown list
Multiple-choice
Linear scale
How can you restrict access to a Google Form to specific users only?
Set a password
Send the form only via email
Enable domain-restricted responses
Enable CAPTCHA
Require manual approval
How can you duplicate a Google Form?
Select 'Save As'
Click 'File' → 'Make a copy'
Download as PDF and upload again
Manually copy and paste the questions
Use Google Drive Sync
Which question type allows users to upload files in Google Forms?
Short answer
Paragraph
File upload
Multiple-choice
Date
How can you enable automatic grading in Google Forms?
Add a formula in Google Sheets
Turn on 'Answer keys' in Form settings
Use Google Apps Script
Manually check responses
Use Google Classroom
Which function calculates the sum of a range of cells?
AVERAGE
COUNT
SUM
MAX
IF
Which function returns the smallest value in a range?
MIN
MAX
COUNT
VLOOKUP
SUMIF
Which function finds the average of numbers in a range?
SUM
AVERAGE
COUNT
LEFTB
DATEDIF
Which symbol is used for absolute reference in Google Sheets?
#
&
$
%
@
Which function counts the number of non-empty cells in a range?
COUNT
COUNTA
COUNTIF
SUMIF
DATEDIF
Which function is used to search for a value in a table?
IF
VLOOKUP
MAX
SUMIF
AVERAGEIF
Which function calculates the difference between two dates?
DATEDIF
DATE
IF
TODAY
LEFTB
How can you freeze the first row and column in Google Sheets?
View → Freeze → 1 row & 1 column
Format → Lock Cells
Use a script
Apply conditional formatting
Create a table
Which tool allows you to highlight orders older than 30 days?
Conditional formatting
Filter views
Absolute reference
Dropdown list
