Excel Basic Check

What is the shortcut key to save an Excel workbook?

• A) Ctrl+S
  

• 
  B) Ctrl+A
  

• 
  C) Ctrl+P
  

• 
  
  D) Ctrl+Z

Which chart type is used to display trends over time in Excel?

• A) Pie Chart

• B) Bar Chart

• C) Line Chart

• D) Scatter Plot

Which keyboard shortcut is used to insert a new row in Excel?

• A) Ctrl+C

• B) Ctrl+V

• C) Ctrl+X

• D) Ctrl+Shift+=

What does the COUNT function do in Excel?

• A) Calculates the average of a range of cells

• B) Counts the number of cells in a range that meet a specific condition

• C) Returns the largest value in a range of cells

• D) Finds the sum of a range of cells

What is the function of the SUM formula in Excel?

• A) To find the average of a range of cells

• B) To count the number of cells in a range

• C) To calculate the total of a range of cells

• D) To find the highest value in a range

Which function is used to find the highest value in a range of cells in Excel?

• A) MAX

• B) MIN

• C) AVERAGE

• D) COUNT

What is the shortcut key to undo the last action in Excel?

• A) Ctrl+S

• B) Ctrl+Z

• C) Ctrl+A

• D) Ctrl+X

Which chart type is used to compare values across different categories in Excel?

• A) Pie Chart

• B) Bar Chart

• C) Line Chart

• D) Scatter Plot

Which option allows you to apply predefined formatting styles to cells in Excel?

• A) Sort

• B) Filter

• C) Conditional Formatting

• D) Merge Cells

What does the CONCATENATE function do in Excel?

• A) Sums a range of cells

• B) Finds the average of a range of cells

• C) Joins multiple text strings into one

• D) Counts the number of cells in a range