LBG B1 - Pre MS

What does ###### in a cell mean and how will you resolve it?

• a. There is an error in the formula in the cell which needs to be rectified

• b. There is a spelling error and spell check will resolve it

• c. The column is not wide enough to display the contents of the cell. Increase the column width to resolve this.

• d. None of the above

What is the purpose of slicers in Excel & Power BI?

• a. To add animations to reports

• 1. b. To filter data visually within dashboards

• 1. c. To create new datasets

• 1. d. To import images into reports

You are creating a spreadsheet that collects information, and you have a field in which the users have to select from a list of values. How will you achieve this?

• Use macros/VBA

• Data Validation

• Conditional formats

• Protect the cell

What is the purpose of "Conditional Formatting"?

• 1. To remove blank cells

• 1. To apply color-based rules to highlight specific data

• 1. To merge multiple rows together

• 1. To insert tables into the worksheet

What is the purpose of "Slide Master" in PowerPoint?

• 1. To add animations to slides

• 1. To apply consistent formatting to multiple slides

• 1. To insert a video into a presentation

• 1. To create a new slide layout

What is the primary purpose of Power BI?

• 1. Creating text documents

• 1. Analyzing and visualizing data

• 1. Designing presentations

• 1. Writing emails

Which visual is best for comparing sales trends over time?

• 
• 
• 
• 

What is the function of "Presenter View" in PowerPoint?

• 1. It hides slides from the audience

• 1. It provides speaker notes and a timer during the presentation

• 1. It enables live feedback from the audience

• 1. It automatically translates text into another language

Which functionality in Excel helps you achieve this result?

• Increase Row Height

• Word Wrap

• Justify

• Merge & Center

What does the "Morph" transition do in PowerPoint?

• 1. Creates a fade effect between slides

• 1. Smoothly animates objects between slides

• 1. Deletes unwanted slides automatically

• 1. Locks the layout to prevent edits