# The Arcade Trivia September 2024 Week 3

## **Overview**

Welcome to The Arcade Trivia September 2024! Give your career a boost with hands-on experience with different Google Cloud and partner services.

Click **Start Lab** to begin.

P.S. You don't need the GCP Console for this, but you do need to keep this quiz open for a minimum of 3 minutes.

## **Quiz**

1. **In Google Sheets, what function is commonly used to find the average of a range of numbers?**
    
    Select **ONE** answer that would be relevant
    
    * Remove
        
    * Add
        
    * Divide
        
    * Average
        
2. **What feature in Google Sheets allows you to sort data in ascending or descending order?**
    
    Select **ONE** answer that would be relevant
    
    * Delete
        
    * <mark>Sort</mark>
        
    * Separate
        
    * Sum
        
3. **Which Google Sheets tool can be accessed from the menu to provide a way to summarize data in your spreadsheet, automatically aggregating, sorting, counting, or averaging the data while displaying the summarized results in a new table?**
    
    Select **ONE** answer that would be relevant
    
    * Average Table
        
    * <mark>Pivot Table</mark>
        
    * Calc Table
        
    * Summarize
        
4. **To create a Pivot Table, which menu option do you select in Google Sheets?**
    
    Select **ONE** answer that would be relevant
    
    * Extensions
        
    * Data
        
    * Tools
        
    * <mark>Insert</mark>
        
5. **Which Google tool allows users to create surveys and questionnaires online?**
    
    Select **ONE** answer that would be relevant
    
    * Google Drive
        
    * VM
        
    * <mark>Google Forms</mark>
        
    * Compute Engine
        
6. **What feature in Google Forms allows you to analyze data visually?**
    
    Select **ONE** answer that would be relevant
    
    * Columns
        
    * None of the above
        
    * Rows
        
    * <mark>Charts and tables</mark>
        

---

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1726123482827/e3685c49-ba52-4ed9-a2da-021382337423.png align="center")