B.com Final Quiz

Which feature allows data to automatically fill adjacent cells based on a pattern?

• A. Flash Fill
  

• B. Auto Fill
  

• C. Smart Fill
  

• D. Quick Fill

Which function is used to count only numeric values in a range?

• A. COUNTA

• B. COUNT

• C. COUNTIF

• D. SUM

What is the use of the Ctrl + +(Plus symbol) shortcut in Excel?

• Formats the selected cells in Excel.
• Inserts new rows or columns in Excel.
• Copies the selected cells in Excel.
• Deletes existing rows or columns in Excel.

In Excel, a cell is identified by:

• A. Row number only

• B. Column letter only

• C. Column letter and row number (e.g., A1)

• D. Cell name

What does =IF(A1>100, "High", "Low") return if A1 = 120?

• Very High
• Medium
• Critical
• High

What helps with dynamic filtering in Dashboards?

• a) Slicers

• b) Cells

• c) Gridlines

• d) Macros

What is commonly used in dashboards?

• a) Pivot Tables

• b) Charts

• c) Slicers

• d) All of the above

What is a Dashboard in Excel?

• a) A function

• b) A table

• c) A visual summary of data

• d) A formula

What function would you use to find the average of a set of numbers in Excel?

• A. AVERAGE

• B. MEAN

• C. SUM

• D. MEDIAN

Which of the following is a way to create a chart in Excel?

• a) Insert Tab

• b) Data Tab

• c) View Tab

• d) Home Tab