Excel and PowerPoint Quiz

What is the first step to insert an Excel spreadsheet into PowerPoint?

• Open PowerPoint and go to the slide where you want to insert the spreadsheet.

• Click on Insert > Table.

• Open Excel and copy the data.

• Use Conditional Formatting.

How do you select a range of cells in Excel?

• Click and drag to select a range of cells.

• Right-click and choose Format Cells.

• Use Conditional Formatting.

• Click on Insert > Object.

Which tab do you use to insert a table in Excel?

• Insert

• Home

• View

• Data

What is the basic formula to sum values in cells A1 to A10?

• =SUM(A1:A10)

• =AVERAGE(A1:A10)

• =COUNT(A1:A10)

• =MIN(A1:A10)

How do you change the number format, font, border, and fill color of a cell?

• Right-click on the cell and choose Format Cells.

• Click on Insert > Table.

• Use Paste Special.

• Click and drag to select a range of cells.

What is the purpose of using open brackets in formulas?

• To start functions

• To end functions

• To format cells

• To insert tables

Which option allows you to create a new Excel worksheet in PowerPoint?

• Microsoft Excel Worksheet

• Format Cells

• Conditional Formatting

• Paste Special

Which function is used to find the average of values in cells B1 to B5?

• =AVERAGE(B1:B5)

• =SUM(B1:B5)

• =COUNT(B1:B5)

• =MAX(B1:B5)

What is the shortcut key to save an Excel workbook?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + X

How can you quickly adjust the width of a column to fit its content?

• Double-click the right border of the column header

• Right-click and choose Format Cells

• Use the Insert tab

• Click and drag the column header