ICT DUMAN TELMAN

What are Google Forms add-ons, and how do they enhance the functionality of Google Forms for users?

Google Forms add-ons are third-party extensions that add advanced features to Google Forms.

What is the first step to create a chart in Google Sheets?*

Highlight the data you want to include in the chart.

What is the primary advantage of using the cloud version of Microsoft PowerPoint over the desktop version?

It allows for real-time collaboration and access from any internet-connected device.

What is the benefit of using the "Filter views" feature in Google Sheets?

It allows you to create custom charts.

What does the AVERAGE function do when applied to a range of numbers in a spreadsheet?

It computes the mean or average value of the numbers.

What happens when you use the "Make a copy" option for a Google Doc?

It creates a new Google Doc with the same content

What is an absolute cell reference in a spreadsheet?

It refers to a cell by its fixed position in the spreadsheet, indicated by a dollar sign ($) before the column and row references.

How does applying a filter in Google Sheets affect the data in your spreadsheet?

It temporarily hides rows that do not meet the filter criteria, allowing you to focus on specific data.

What does the VLOOKUP function in spreadsheet software allow you to do?

It vertically searches for a value in a specified table and returns a related value from the same row

The name of function that returns us the number of characters in a given cell

LEN

________ function returns the largest numeric value that meets one or more criteria in a range of values

Maxifs()

Google Slides is most similar to which of the following programs?*

Microsoft PowerPoint

Google Docs is most similar to which application?

Microsoft Word

Which file format can be uploaded as an image in Google Docs?

.jpg

Which of the following formulas can be used to combine two or more text values in Google Sheets?

=CONCATENATE

What is an animation in Google Slides?*

A way to animate individual elements on a slide

What is a transition in Google Slides?*

A way to switch from one slide to another

What does the "Cite as footnote" option in Google Docs do?

Adds a citation as a footnote at the bottom of the page

Which of these statements is correct about dropdown?*

Allow people to pick an item from a list that you create

Which of the following is NOT a type of special character you can insert in Google Docs?

Animations

Most functions contain one or more ________ in parentheses.

Arguments

Which type of chart is commonly used to compare values across different categories or groups by using vertical or horizontal bars?

Bar chart

How do you typically begin applying a function to a cell in spreadsheet software?

By typing the function name followed by the cell reference within parentheses.

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

Which function would you use to combine the contents of two or more cells in Google Sheets?

CONCATENATE

How can you see who has access to a Google Sheets file?

Click on the "Share" button in the toolbar.

Which Google Docs feature allows you to suggest edits to a document without making direct changes?

Commenting

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

What is the primary purpose of Google Forms?

Conducting surveys and collecting data

How can you easily and safely share a Google Sheets file with specific people?

Enter their email addresses in the "Share" dialog box and select their access level.

Which of the following features allows you to narrow down the data in your worksheet?

Filters

What does conditional formatting in Google Sheets allow you to do?

Format cells based on specified rules and criteria

What is a pivot table in Google Sheets primarily used for?*

Summarizing and analyzing large sets of data

Which of the following is a common use case for the SUMIFS function in Google Sheets?

Summing up sales amounts for a specific product category within a given time period.

True or False: If you already have a Google account, you can use the same account to access Google Docs.

TRUE

What is the benefit of using add-ons in Google Docs?*

They allow you to add extra functionality to your documents.

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.

In which situation would you typically use a line chart?

To show trends or changes in data over time.

True or False: You can share a Google Slides project without allowing other people to edit it.

True

What is the maximum number of response options you can have for a multiple-choice question in Google Forms?

Unlimited

What feature in Google Docs allows you to see the revision history and revert to previous versions of a document?

Version History

In Google Docs, what is a "Table of Contents"?

a summary of the document's pages

Formulas should always begin with a(n) ________.

equals sign

Inserting a header at the top of a page will make it appear on ________.*

every page

Which operating systems is Keynote primarily designed for?

macOS and iOS

What is the purpose of the Activity Dashboard?*

to show the collaboration activity on a document

Which of these options is correct about PIVOT TABLE?*

type of specialized spreadsheet function used for creating charts and graphs

Which presentation software is particularly known for its innovative zooming and panning transitions that create a dynamic and non-linear presentation experience?

Prezi

What does the "Go to Section Based on Answer" feature in Google Forms allow you to do?

Redirect respondents to different sections of the form based on their answers to specific questions

What does the AVERAGE function do?*

Returns the average of a range of values

Which function adds up numbers in a range in Google sheets?*

SUM

Which function calculates the sum of a range based on one or more true or false conditions?

SUMIFS

What does the "Sort sheet by column" feature in Google Sheets allow you to do?

Sort data by column header