Shams Biswas

Excel Quiz 3

What does the AVERAGEIFS function do?

  1. Averages cells based on multiple conditions
  2. Averages non-numeric values
  3. Calculates the mean of blank cells
  4. Counts all cells that meet conditions

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

  1. Use the IMPORTRANGE function
  2. Manually copy and paste data every hour
  3. Use the VLOOKUP function
  4. Data cannot be imported from external sources

What is the primary purpose of a working sheet?

  1. Creating dashboards
  2. Managing and analyzing data
  3. Printing formatted reports
  4. Creating forms

Which feature enables real-time collaboration in Google Sheets?

  1. Manual refresh
  2. Multiple users editing simultaneously
  3. Scheduled sharing
  4. Sheet version history

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

  1. The cell range
  2. The criteria
  3. The sum range
  4. A mathematical operator

What is a working sheet in Google Sheets?

  1. A sheet for creating visualizations
  2. A tab within a Google Sheets workbook for entering and organizing data
  3. A template for automated tasks
  4. A sheet used only for printing purposes

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

  1. =AVERAGEIFS(A1:A10, B1:B10, “Red”)
  2. =AVERAGEIFS(A1:A10, “Red”)
  3. =AVERAGEIFS(A1:A10, B1:B10)
  4. =AVERAGEIFS(“Red”, A1:A10)

Which feature is often used to create compact tables?

  1. Conditional formatting
  2. Pivot Tables
  3. Named ranges
  4. Data validation

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

  1. Conditional Formatting
  2. Data Validation
  3. Goal Seek
  4. Text to Columns

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

  1. Google Slides
  2. Google Apps Script
  3. Data validation
  4. Google Calendar

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

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

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

  1. Slicer
  2. Filter
  3. Sort
  4. Subtotal

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

  1. Use conditional formatting
  2. Use Pivot Tables and filters
  3. Create separate sheets for each dataset
  4. Manually format each table

The COUNTIF function allows you to:

  1. Count cells based on one condition
  2. Sum cells based on a condition
  3. Count only text entries
  4. Count all empty cells

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

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

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

  1. They automatically update when new data is added
  2. They are used to summarize and analyze data
  3. They can only summarize numeric data
  4. They cannot show filters

What happens when you record a macro in Excel?

  1. Excel records the cell contents
  2. Excel stores a series of actions to be repeated later
  3. Excel takes a screenshot of your work
  4. Excel creates a chart automatically

What is the syntax for MAXIFS in Excel?

  1. =MAXIFS(criteria_range, sum_range, criteria)
  2. =MAXIFS(sum_range, criteria_range, criteria)
  3. =MAXIFS(criteria1, criteria2, sum_range)
  4. =MAXIFS(sum_range, criteria1, criteria_range)

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

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

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

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

What does the SUMIFS function allow you to do?

  1. Sum cells based on multiple conditions
  2. Count cells based on a single condition
  3. Sum cells in a fixed range
  4. Average cells based on conditions

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

  1. =SUMIFS(criteria_range, criteria, sum_range)
  2. =SUMIFS(sum_range, criteria_range1, criteria1)
  3. =SUMIFS(sum_range, criteria1, criteria2)
  4. =SUMIFS(criteria1, criteria2, sum_range)

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

  1. MAXIFS
  2. MAXIF
  3. SUMIFS
  4. COUNTIFS

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

  1. The total number of red cells
  2. The total number of cells in A1
  3. The number of cells containing the word “Red”
  4. An error

The AVERAGEIF function:

  1. Averages cells based on one condition
  2. Adds all cells in a range
  3. Returns the highest average
  4. Averages non-empty cells only

How many conditions can the SUMIFS function handle?

  1. One
  2. Two
  3. No limit
  4. Three

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

  1. Creating charts
  2. Formatting cells
  3. Generating Pivot Tables
  4. All of the above

What is a compact format table in Google Sheets?

  1. A table with minimal formatting
  2. A table that condenses data for easy reading
  3. A table with detailed formatting for each cell
  4. A table optimized for printing

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

  1. Sum
  2. Average
  3. Count
  4. Max

What is the difference between COUNTIF and COUNTIFS?

  1. COUNTIFS can handle multiple criteria
  2. COUNTIFS counts blank cells
  3. COUNTIF counts only numeric data
  4. COUNTIF handles multiple ranges

Here are the answers to the questions:

  1. What does the AVERAGEIFS function do?
    • A. Averages cells based on multiple conditions
  2. How can you import real-time data from an external source into Google Sheets?
    • A. Use the IMPORTRANGE function
  3. What is the primary purpose of a working sheet?
    • B. Managing and analyzing data
  4. Which feature enables real-time collaboration in Google Sheets?
    • B. Multiple users editing simultaneously
  5. In the formula =SUMIF(A1, “>5”), what does “>5” represent?
    • B. The criteria
  6. What is a working sheet in Google Sheets?
    • B. A tab within a Google Sheets workbook for entering and organizing data
  7. Which of the following is a valid use of the AVERAGEIFS function?
    • A. =AVERAGEIFS(A1, B1, “Red”)
  8. Which feature is often used to create compact tables?
    • B. Pivot Tables
  9. Which feature in Excel allows you to create a drop-down list in a cell?
    • B. Data Validation
  10. What tool would you use to automatically refresh data for real-time reports?
    • B. Google Apps Script
  11. How do you apply filters to a pivot table in Google Sheets?
    • B. Add a filter within the pivot table editor
  12. Which Pivot Table feature allows you to focus on specific data?
    • A. Slicer
  13. What’s an effective way to summarize large datasets in Google Sheets?
    • B. Use Pivot Tables and filters
  14. The COUNTIF function allows you to:
    • A. Count cells based on one condition
  15. What is the difference between a working sheet and a template?
    • A. Templates have predefined structures, while working sheets are blank or custom
  16. Which of the following is true about Pivot Tables in Excel?
    • B. They are used to summarize and analyze data
  17. What happens when you record a macro in Excel?
    • B. Excel stores a series of actions to be repeated later
  18. What is the syntax for MAXIFS in Excel?
    • B. =MAXIFS(sum_range, criteria_range, criteria)
  19. What is the key benefit of real-time reporting in Google Sheets?
    • A. It provides up-to-date information for decision-making
  20. 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
  21. What does the SUMIFS function allow you to do?
    • A. Sum cells based on multiple conditions
  22. Which of the following is the correct syntax for the SUMIFS function?
    • B. =SUMIFS(sum_range, criteria_range1, criteria1)
  23. Which function allows you to find the maximum value based on multiple conditions?
    • A. MAXIFS
  24. What will the formula =COUNTIF(A1, “Red”) return?
    • C. The number of cells containing the word “Red”
  25. The AVERAGEIF function:
    • A. Averages cells based on one condition
  26. How many conditions can the SUMIFS function handle?
    • C. No limit
  27. Which of the following can be automated using macros in Excel?
    • D. All of the above
  28. What is a compact format table in Google Sheets?
    • B. A table that condenses data for easy reading
  29. What is the default calculation applied to values in a Pivot Table?
    • A. Sum
  30. What is the difference between COUNTIF and COUNTIFS?
    • A. COUNTIFS can handle multiple criteria

Posted

in

by

Shams Biswas

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *