**What does the AVERAGEIFS function do?**

- Averages cells based on multiple conditions
- Averages non-numeric values
- Calculates the mean of blank cells
- Counts all cells that meet conditions

**How can you import real-time data from an external source into Google Sheets?**

- Use the IMPORTRANGE function
- Manually copy and paste data every hour
- Use the VLOOKUP function
- Data cannot be imported from external sources

**What is the primary purpose of a working sheet?**

- Creating dashboards
- Managing and analyzing data
- Printing formatted reports
- Creating forms

**Which feature enables real-time collaboration in Google Sheets?**

- Manual refresh
- Multiple users editing simultaneously
- Scheduled sharing
- Sheet version history

**In the formula =SUMIF(A1:A10, “>5”), what does “>5” represent?**

- The cell range
- The criteria
- The sum range
- A mathematical operator

**What is a working sheet in Google Sheets?**

- A sheet for creating visualizations
- A tab within a Google Sheets workbook for entering and organizing data
- A template for automated tasks
- A sheet used only for printing purposes

**Which of the following is a valid use of the AVERAGEIFS function?**

- =AVERAGEIFS(A1:A10, B1:B10, “Red”)
- =AVERAGEIFS(A1:A10, “Red”)
- =AVERAGEIFS(A1:A10, B1:B10)
- =AVERAGEIFS(“Red”, A1:A10)

**Which feature is often used to create compact tables?**

- Conditional formatting
- Pivot Tables
- Named ranges
- Data validation

**Which feature in Excel allows you to create a drop-down list in a cell?**

- Conditional Formatting
- Data Validation
- Goal Seek
- Text to Columns

**What tool would you use to automatically refresh data for real-time reports?**

- Google Slides
- Google Apps Script
- Data validation
- Google Calendar

**How do you apply filters to a pivot table in Google Sheets?**

- Use the “Insert” menu
- Add a filter within the pivot table editor
- Right-click on the pivot table and select “Apply filter”
- Pivot tables don’t support filters

**Which Pivot Table feature allows you to focus on specific data?**

- Slicer
- Filter
- Sort
- Subtotal

**What’s an effective way to summarize large datasets in Google Sheets?**

- Use conditional formatting
- Use Pivot Tables and filters
- Create separate sheets for each dataset
- Manually format each table

**The COUNTIF function allows you to:**

- Count cells based on one condition
- Sum cells based on a condition
- Count only text entries
- Count all empty cells

**What is the difference between a working sheet and a template?**

- Templates have predefined structures, while working sheets are blank or custom
- Working sheets are automatically created, templates must be imported
- Templates are used for visuals, working sheets are for data
- There is no difference

**Which of the following is true about Pivot Tables in Excel?**

- They automatically update when new data is added
- They are used to summarize and analyze data
- They can only summarize numeric data
- They cannot show filters

**What happens when you record a macro in Excel?**

- Excel records the cell contents
- Excel stores a series of actions to be repeated later
- Excel takes a screenshot of your work
- Excel creates a chart automatically

**What is the syntax for MAXIFS in Excel?**

- =MAXIFS(criteria_range, sum_range, criteria)
- =MAXIFS(sum_range, criteria_range, criteria)
- =MAXIFS(criteria1, criteria2, sum_range)
- =MAXIFS(sum_range, criteria1, criteria_range)

**What is the key benefit of real-time reporting in Google Sheets?**

- It provides up-to-date information for decision-making
- It makes the data easier to read
- It enhances printing capabilities
- It allows only one user to work at a time

**How can you switch between different working sheets in Google Sheets?**

- Use the “Switch Sheet” option from the toolbar
- Click the tab of the sheet you want to view at the bottom
- Use the “View” menu
- Press “Ctrl + Shift + Tab”

**What does the SUMIFS function allow you to do?**

- Sum cells based on multiple conditions
- Count cells based on a single condition
- Sum cells in a fixed range
- Average cells based on conditions

**Which of the following is the correct syntax for the SUMIFS function?**

- =SUMIFS(criteria_range, criteria, sum_range)
- =SUMIFS(sum_range, criteria_range1, criteria1)
- =SUMIFS(sum_range, criteria1, criteria2)
- =SUMIFS(criteria1, criteria2, sum_range)

**Which function allows you to find the maximum value based on multiple conditions?**

- MAXIFS
- MAXIF
- SUMIFS
- COUNTIFS

**What will the formula =COUNTIF(A1:A10, “Red”) return?**

- The total number of red cells
- The total number of cells in A1
- The number of cells containing the word “Red”
- An error

**The AVERAGEIF function:**

- Averages cells based on one condition
- Adds all cells in a range
- Returns the highest average
- Averages non-empty cells only

**How many conditions can the SUMIFS function handle?**

- One
- Two
- No limit
- Three

**Which of the following can be automated using macros in Excel?**

- Creating charts
- Formatting cells
- Generating Pivot Tables
- All of the above

**What is a compact format table in Google Sheets?**

- A table with minimal formatting
- A table that condenses data for easy reading
- A table with detailed formatting for each cell
- A table optimized for printing

**What is the default calculation applied to values in a Pivot Table?**

- Sum
- Average
- Count
- Max

**What is the difference between COUNTIF and COUNTIFS?**

- COUNTIFS can handle multiple criteria
- COUNTIFS counts blank cells
- COUNTIF counts only numeric data
- COUNTIF handles multiple ranges

## Here are the answers to the questions:

**What does the AVERAGEIFS function do?****A. Averages cells based on multiple conditions**

**How can you import real-time data from an external source into Google Sheets?****A. Use the IMPORTRANGE function**

**What is the primary purpose of a working sheet?****B. Managing and analyzing data**

**Which feature enables real-time collaboration in Google Sheets?****B. Multiple users editing simultaneously**

**In the formula =SUMIF(A1****, “>5”), what does “>5” represent?****B. The criteria**

**What is a working sheet in Google Sheets?****B. A tab within a Google Sheets workbook for entering and organizing data**

**Which of the following is a valid use of the AVERAGEIFS function?****A. =AVERAGEIFS(A1, B1, “Red”)**

**Which feature is often used to create compact tables?****B. Pivot Tables**

**Which feature in Excel allows you to create a drop-down list in a cell?****B. Data Validation**

**What tool would you use to automatically refresh data for real-time reports?****B. Google Apps Script**

**How do you apply filters to a pivot table in Google Sheets?****B. Add a filter within the pivot table editor**

**Which Pivot Table feature allows you to focus on specific data?****A. Slicer**

**What’s an effective way to summarize large datasets in Google Sheets?****B. Use Pivot Tables and filters**

**The COUNTIF function allows you to:****A. Count cells based on one condition**

**What is the difference between a working sheet and a template?****A. Templates have predefined structures, while working sheets are blank or custom**

**Which of the following is true about Pivot Tables in Excel?****B. They are used to summarize and analyze data**

**What happens when you record a macro in Excel?****B. Excel stores a series of actions to be repeated later**

**What is the syntax for MAXIFS in Excel?****B. =MAXIFS(sum_range, criteria_range, criteria)**

**What is the key benefit of real-time reporting in Google Sheets?****A. It provides up-to-date information for decision-making**

**How can you switch between different working sheets in Google Sheets?****B. Click the tab of the sheet you want to view at the bottom**

**What does the SUMIFS function allow you to do?****A. Sum cells based on multiple conditions**

**Which of the following is the correct syntax for the SUMIFS function?****B. =SUMIFS(sum_range, criteria_range1, criteria1)**

**Which function allows you to find the maximum value based on multiple conditions?****A. MAXIFS**

**What will the formula =COUNTIF(A1****, “Red”) return?****C. The number of cells containing the word “Red”**

**The AVERAGEIF function:****A. Averages cells based on one condition**

**How many conditions can the SUMIFS function handle?****C. No limit**

**Which of the following can be automated using macros in Excel?****D. All of the above**

**What is a compact format table in Google Sheets?****B. A table that condenses data for easy reading**

**What is the default calculation applied to values in a Pivot Table?****A. Sum**

**What is the difference between COUNTIF and COUNTIFS?****A. COUNTIFS can handle multiple criteria**

## Leave a Reply