NEW
Font size
WorksheetsICT Диастын коз жасы (Duman Telman)
Total questions: 55
Worksheet time: 28mins
How can you enable AI features in Notion
by pressing space
by pressing enter
by pressing -
by pressing cntrl+X
what advantage does Google Docs offer in terms of document storage
It provides cloud-based storage accessible from any device with internet connectivity
IT limits the number of documents that can be stored
It provides 3 access types such as t view , edit and comment
it stores documents locally on the user's device only
Which of the following is a feature of the Table of Contents tool in Google Docs
It can be used to automatically generate a table of contents based on headings in the document
It can be used to create documents outline
It can be used to insert and format tables into a document
It can be used to insert footnotes and endnotes into a document
Which of the following isa way to prevent respondents from submitting multiple responses to a Google Form?
This feature is not available in google form
Restricting access to the form
Enabling the "Response validation" setting
Adding a limit t othe number of responses
As a language teacher, you have a list of students and their language proficiency certifications like IELTS. How would you utilize Google Sheets to count the number of students who possess an IELTS certificate with a score of 7 or above?
Input the student details into Google sheets. Utilize a COUNTIF function to tally the number of students with an IELTS of 7 or higher by specifying the criteria in the formula
Enter student records into Google sheets. Apply the SUMIF function, specifying the conditions for IELTS scores to count the number of students who obtained a score of 7 or higher.
Add student information to Google sheets. Use a formula like COUNTIFS to filter and count students possessing an IELTS certificate with a score of 7 or greater by setting the criteria within the function
Enter student records into Google Sheets. Apply the Conditional formatting function, specifying the conditions for IELTS scores to highlight the number of students who obtained a score of 7 or higher
Inserting a header at the top of a page will make it appear on ________.
the first page only
the last page only
every other page
every page
Which function adds up numbers in a range in Google sheets?
ADD
SUM
SUMIF
SUMRANGE
What does the "Sort sheet by column" feature in Google Sheets allow you to do?
Sort data by column header
Sort data by column letter
Sort data by row header
Sort data by row number
True or False: You can share a Google Slides project without allowing other people to edit it.
True
False
Which is true about conditional formatting?
Conditional formatting lets you format cells so that their appearance changes dynamically according to the value they contain, or to values in other cells
Conditional formatting in Google Sheets can only be applied to text data
Conditional formatting doesn't support custom formulas for creating specific formatting rules.
Conditional formatting can be used to permanently alter the underlying data in a cell.
Which of the following features allows you to narrow down the data in your worksheet?
Relative cell references
Merge cells
Sorting
Filters
Which file format can be uploaded as an image in Google Docs?
.jpg
.mp3
.txt
Google Docs is most similar to which application?
Microsoft Word
Microsoft Outlook
Microsoft PowerPoint
Adobe Creative Suite
Which of these options is correct about PIVOT TABLE?
type of specialized spreadsheet function used for creating charts and graphs.
an interactive way to quickly summarize large amounts of data
primarily used for data entry and data validation tasks in Excel
to create a pivot table, you can simply select your data and click the "Pivot Table" button without specifying any specific criteria or fields.
What is a transition in Google Slides?
A way to switch from one slide to another
A way to import slides from other presentations
A type of graphic element
A special effect used to animate text
Formulas should always begin with a(n) ________.
hashtag
equals sign
dollar sign
header
Which of these statements is correct about dropdown?
Dropdowns in Google Sheets can only contain numbers, not text.
You can't change the options in a dropdown list once it's created.
Dropdowns are a feature available only in the paid version of Google Sheets.
Allow people to pick an item from a list that you create
What is the advantage of using Google Fonts in Google Docs?
They are compatible with multiple devices.
They are easy to use.
They are free.
all of these things
What is an animation in Google Slides?
A way to add sound to a slide
A way to animate individual elements on a slide
A way to change the size of a slide
A way to change the order of the slides
Which function calculates the sum of a range based on one or more true or false conditions?
ADD
SUM
SUMIF
SUMIFS
How can you easily and safely share a Google Sheets file with specific people?
Copy and paste the file's URL and send it to them, since anyone can automatically access the link.
Post the file's URL on social media or a website.
Grant public access to the file
Enter their email addresses in the "Share" dialog box and select their access level.
What is the benefit of using the "Filter views" feature in Google Sheets?
It allows you to filter by color.
It allows you to hide certain rows.
It allows you to sort data faster.
It allows you to create custom charts.
Google Slides is most similar to which of the following programs?
Adobe Photoshop
Microsoft PowerPoint
Microsoft Word
Microsoft Project
How can you see who has access to a Google Sheets file?
Click on the "Settings" button in the toolbar.
Click on the "Share" button in the toolbar.
Open the file and look at the list of collaborators in the sidebar
Hover over the file's name in Google Drive and select "Share."
What happens when you use the "Make a copy" option for a Google Doc?
It creates a new Google Doc with the same content.
It saves a copy of the document to your computer.
It shares the document with another user.
It creates a PDF copy of the document.
In Google Docs, what is a "Table of Contents"?
a summary of the document's metadata
a summary of the document's sections
a summary of the document's pages
a summary of the document's styles
What is the benefit of using add-ons in Google Docs?
They are required to use Google Docs.
They allow you to add extra functionality to your documents.
They can be used to format text.
They allow you to share documents with others.
What does the AVERAGE function do?
Divides a range of values
Returns the average of a range of values
Multiplies a range of values
Adds a range of values
True or False: If you already have a Google account, you can use the same account to access Google Docs.
True
False
What is the purpose of the Activity Dashboard?
to show the number of times a document has been viewed or edited
to show a list of all the versions of a document
to show the collaboration activity on a document
to show who has access to a document and their permission level
Which presentation software is particularly known for its innovative zooming and panning transitions that create a dynamic and non-linear presentation experience?
Canva
Microsoft PowerPoint
Prezi
Google Slides
________ function returns the largest numeric value that meets one or more criteria in a range of values
Max()
Maxa()
Maxifs()
Max(And())
What does the VLOOKUP function in spreadsheet software allow you to do?
It counts the number of cells containing a specific value.
It vertically searches for a value in a specified table and returns a related value from the same row
It creates vertical bars or lines to separate data in a table.
It merges cells in a column to combine their contents.
Which type of chart is commonly used to compare values across different categories or groups by using vertical or horizontal bars?
Pie chart
Line chart
Bar chart
Area chart
What is an absolute cell reference in a spreadsheet?
It refers to a cell that cannot be changed or edited.
It refers to a cell by its fixed position in the spreadsheet, indicated by a dollar sign ($) before the column and row references.
It refers to a cell with a dynamic position that changes as you copy the formula to different cells.
It refers to a cell using a descriptive label or name instead of coordinates.
What does the "Cite as footnote" option in Google Docs do
Adds a citation as a footnote at the bottom of the page
Creates a hyperlink to the source within the text
Generates an in-text citation within parentheses
Adds a citation in the header of the document
What is the maximum number of response options you can have for a multiple-choice question in Google Forms?
5
10
20
Unlimited
Which of the following formulas can be used to combine two or more text values in Google Sheets?
=SUM
=AVERAGE
=CONCATENATE
=if
Which of the following is NOT a type of special character you can insert in Google Docs?
Mathematical symbols
Emojis
Foreign language characters
Animations
Which Google Docs feature allows you to suggest edits to a document without making direct changes?
Spell check
Commenting
Track Changes
Auto-correct
How does applying a filter in Google Sheets affect the data in your spreadsheet?
It permanently deletes rows that do not meet the filter criteria.
It temporarily hides rows that do not meet the filter criteria, allowing you to focus on specific data.
It automatically sorts the data in ascending order based on the filter criteria.
It converts the filtered data into a new sheet.
What are Google Forms add-ons, and how do they enhance the functionality of Google Forms for users?
Google Forms add-ons are decorative templates for forms.
Google Forms add-ons are third-party extensions that add advanced features to Google Forms.
Google Forms add-ons are built-in tools provided by Google for calculations
Google Forms add-ons are built-in tool to auto-generate questions
What is the primary advantage of using the cloud version of Microsoft PowerPoint over the desktop version?
It offers more advanced design templates
It provides offline access to presentations.
It allows for real-time collaboration and access from any internet-connected device.
It supports a wider range of fonts and formatting options.
What is the primary purpose of Google Forms?
Sending emails
Creating spreadsheets
Conducting surveys and collecting data
Conducting surveys and collecting data
. What is a pivot table in Google Sheets primarily used for
Creating charts and graphs
Calculating basic arithmetic operations
Summarizing and analyzing large sets of data
Inserting text boxes and images
What feature in Google Docs allows you to see the revision history and revert to previous versions of a document?
Version Control
Time History
Revision Tracker
Version History
What is the first step to create a chart in Google Sheets
Click on the "Tools" menu and select "Create Chart."
vClick on the "Tools" menu and select "Create Chart
Highlight the data you want to include in the chart.
Type the chart title in a cell.
What does conditional formatting in Google Sheets allow you to do?
Create new spreadsheets
Add conditional statements to cells
Format cells based on specified rules and criteria
Merge and split cells
Which presentation software is known for its wide range of templates and design elements, making it suitable for creating various types of visual content beyond presentations?
Canva
Microsoft PowerPoint
Keynote
Google Slide
Which operating systems is Keynote primarily designed for?
Windows and macOS
macOS and iOS
Windows and Linux
macOS and Android
How do you typically begin applying a function to a cell in spreadsheet software?
By clicking on the cell and selecting the desired function from a menu.
By typing the function name followed by the cell reference within parentheses
By right-clicking on the cell and choosing "Apply Function."
By dragging and dropping the function from a toolbar onto the cell.
In which situation would you typically use a line chart?
To display a single data point in relation to a target value.
To compare values across different categories.
To show trends or changes in data over time.
To represent data with distinct categories.
What does the AVERAGE function do when applied to a range of numbers in a spreadsheet?
It calculates the total sum of the numbers.
It finds the smallest value in the range
It returns the highest value in the range.
It computes the mean or average value of the numbers.
Which of the following is a common use case for the SUMIFS function in Google Sheets?
Finding the sum value in a dataset.
Calculating the total sum of a single column.
Summing up sales amounts for a specific product category within a given time period.
Counting the total number of rows in a spreadsheet.
What does the "Go to Section Based on Answer" feature in Google Forms allow you to do?
Automatically submit the form for the respondent.
Redirect respondents to different sections of the form based on their answers to specific questions.
Generate a summary report of all responses.
Customize the form's appearance and design.
