Excel Functions and Features Overview

This video tutorial by Mike provides a comprehensive guide to preparing for the Excel 2019 or MO-200 exam. It covers six projects, each focusing on different Excel skills such as basic navigation, advanced formatting, data analysis, chart customization, data importing, and using named ranges. The tutorial includes practical tasks and tips to help learners understand and apply Excel functions effectively, ensuring they are well-prepared for the exam.

What is the main purpose of this video tutorial?

• To help pass the MO-200 or Excel 2019 exam

• To teach basic Excel functions

• To demonstrate advanced Excel techniques

• To provide an overview of Excel features

How do you navigate to a specific range in Excel?

• Use the status bar

• Use the name box

• Use the formula bar

• Use the ribbon

Which function is used to join values from two different columns in Excel 2019?

• JOIN

• CONCAT

• MERGE

• COMBINE

What is the purpose of the 'Freeze Panes' feature in Excel?

• To split the worksheet into multiple panes

• To hide rows or columns

• To keep specific rows or columns visible while scrolling

• To lock the worksheet

How do you remove all formatting from a worksheet in Excel?

• Use the Clear All option

• Use the Clear Rules option in Conditional Formatting

• Use the Remove Formatting option

• Use the Erase Formatting option

What is a multi-sort in Excel?

• Sorting a column in multiple ways

• Sorting data by multiple criteria

• Sorting multiple worksheets at once

• Sorting multiple columns at the same time

Which function is used to display 'Yes' if a value is greater than 10 and 'No' otherwise?

• AVERAGE

• COUNT

• SUM

• IF

How do you create a clustered column chart in Excel?

• Use the Home Tab and select Chart

• Use the Insert Tab and select Column Chart

• Use the Insert Tab and select Line Chart

• Use the Data Tab and select Clustered Chart

What is the purpose of the LEFT function in Excel?

• To extract the last characters from a text string

• To extract the first characters from a text string

• To combine text strings

• To find the length of a text string

How do you apply conditional formatting using traffic lights in Excel?

• Use the Data Tab and select Conditional Formatting

• Use the Insert Tab and select Traffic Lights

• Use the View Tab and select Icon Sets

• Use the Home Tab and select Icon Sets