Post - Bootcamp - MS

What is the function of the "AutoSum" button in Excel?

• 1. Sorts data in ascending order

• 1. Adds numbers in a selected range

• 1. Formats text in bold

• 1. Finds duplicate values

If you want to combine first and last names in Excel, which function should you use?

• 1. =JOIN(A1,B1)

• 1. =MERGE(A1,B1)

• 1. =A1&B1

• 1. =CONCAT(A1,B1)

What is the use of the "VLOOKUP" function in Excel?

• 1. To create a new worksheet

• 1. To retrieve data from a table based on a specific value

• 1. To count the number of cells in a range

• 1. To find duplicate values in a column

How do you freeze the top row in an Excel sheet?

• 1. Use the Merge Cells option

• 1. Click "View" → "Freeze Panes" → "Freeze Top Row"

• 1. Apply Conditional Formatting

• 1. Sort the data in ascending order

How can you publish a Power BI report?

• 1. Using the "Publish" button in Power BI Desktop

• 1. Sending an Excel file via email

• 1. Exporting reports to PowerPoint

• 1. Using the "Format Painter" option

What is Power BI Service used for?

• 1. Designing reports offline

• 1. Sharing and collaborating on reports online

• 1. Writing SQL queries

• 1. Cleaning data in Power Query

If a report needs to update automatically, what should be enabled in Power BI?

• 1. Manual Refresh

• 1. Scheduled Refresh

• 1. Undo Function

• 1. PowerPoint Integration

Which feature helps in organizing a long presentation with multiple sections?

• 1. Slide Sorter View

• 1. Screen Recording

• 1. Merge Shapes

• 1. PowerPoint Designer

How can you apply a filter to a column in Excel?

• 1. Select the column → Click "Sort & Filter" → Choose "Filter"

• 1. Enter "FILTER" in the formula bar

• 1. Change the column formatting to "Filtered"

• 1. Use the "SUM" function on the column

What feature does the format painter support in Excel?

• Change color of the cell

• Highlight errors

• Copies the formatting of one cell to another

• All of the above