Sree's Excel Basics Challenge

What is the shortcut key to add a new line in a cell in Excel?

• Alt + Enter

• Shift + Enter

• Alt + N

• Ctrl + N

How can Avni change the font color of a cell in Excel?

• Navigate to the 'Home' tab, select the cell, choose font color from the 'Font' group

• Click on the cell and press 'Ctrl + C'

• Use a third-party software to change the font color

• Change the font color in Word and paste it into Excel

Arnav is calculating the total sales of his products in Excel. What is the formula to sum the values in cells A1 to A10?

• =SUM(A1:A9)

• =SUM(A1:A11)

• =SUM(A1:A10)

• =SUM(A1,A10)

Which chart type is best suited for comparing sales performance across different regions in Excel?

• Pie chart

• Bar chart

• Line chart

• Scatter plot

What is the shortcut key to filter data in a spreadsheet program?

• Ctrl + F

• Alt + F

• Shift + F

• Ctrl + Shift + L

What feature in Excel allows you to prevent users from making changes to specific cells or ranges?

• Protect Sheet

• Block Editing

• Secure Range

• Lock Cells

What is the shortcut key to insert a new worksheet in Excel?

• Shift + F11

• Shift + W

• Alt + W

• Ctrl + N

What is the function to find the highest score in a list of test results?

• MIN(scoreList)

• AVERAGE(scoreList)

• SUM(scoreList)

• MAX(scoreList)

Which chart type is best for showing the proportion of each student's score to the total in a classroom?

• Scatter plot

• Bar chart

• Pie chart

• Line chart

How can you split a list of student names in Excel into separate columns?

• Right-click on the cell containing the list of student names you want to split, select 'Format Cells', go to the 'Alignment' tab, and check the 'Wrap text' box

• Go to the 'Data' tab, click on 'Text to Columns', choose the delimiter for splitting the student names, and follow the wizard

• Select the list of student names you want to split, press 'Ctrl + X' to cut it, then right-click on the destination cell and select 'Paste Special' with 'Transpose' option

• Use the 'Split' function in a new column to separate the student names based on a specific character or pattern