Test Excel

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

• Ctrl+F11
• Alt+F11
• Shift+F11
• Shift+Alt+F11

What is the function to sum a range of cells in Excel?

• ADD
• SUM
• SUMA
• SUMS

Which of the following is NOT a type of pivot table?

• Standard pivot table
• Pivot chart
• Timeline pivot table
• Slicer pivot table

Which of the following is NOT a way to filter data in Excel?

• AutoFilter
• Advanced Filter
• Slicer
• Data validation

Which of the following is NOT a type of data connection in Excel?

• OLE DB connection
• ODBC connection
• HTTPS connection
• Text file connection

Which of the following is NOT a type of reference in Excel?

• Absolute reference
• Unique reference
• Relative reference
• External reference

Which of the following is NOT a type of chart in Excel?

• Line chart
• Column chart
• Pie chart
• Open Matrix chart

How do you add a trendline to a chart in Excel?

• Right-click the chart and select "Add Trendline"
• Click the "Chart Tools" tab and click the "Trendline" button
• Click the "Insert" tab and click the "Trendline" button
• Click the "Data" tab and click the "Trendline" button

How do you filter a table in Excel based on cell values?

• Click the "Data" tab and click the "Filter" button
• Click the "Home" tab and click the "Filter" button
• Right-click the table and select "Filter"
• Press Ctrl + Shift + L

What is the keyboard shortcut to merge and center a selection of cells in Excel?

• Ctrl+M
• Ctrl+Shift+M
• Ctrl+C
• Alt+H+M+C