Excel Functions and Features

This video tutorial covers over 30 Excel functions, formulas, shortcuts, and tips. It includes detailed explanations of features like autofill, flash fill, concatenate, transpose, sorting, filtering, and freezing data. The tutorial also explores basic operations, statistical functions, VLOOKUP, conditional formatting, and graphing techniques. Viewers will learn how to efficiently use Excel for data management and analysis.

Which Excel feature allows you to automatically fill a series of cells with data based on a pattern?

• Quick Fill

• Flash Fill

• Pattern Fill

• Autofill

What function can be used to combine text from multiple cells into one cell in Excel?

• Text Merge

• Text Join

• Text Split

• Concatenate

How can you convert vertical data into horizontal data in Excel?

• Transpose

• Flip

• Switch

• Rotate

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

• To keep specific rows or columns visible while scrolling

• To highlight important data

• To sort data in a specific order

• To lock cells from editing

Which function would you use to count the number of cells that contain numbers in a range?

• Count

• CountA

• CountBlank

• Sum

What is the result of multiplying 15 by 97 in Excel?

• 1445

• 1450

• 1500

• 1455

Which function would you use to find the maximum value in a range of cells?

• =SUM

• =AVERAGE

• =MAX

• =MIN

What is the purpose of the VLOOKUP function in Excel?

• To calculate the average of a range

• To sort data in ascending order

• To look up a value in a table and return a corresponding value

• To perform arithmetic operations

How can you create a drop-down list in Excel?

• By selecting Data Validation and choosing List

• By using the SUM function

• By using the VLOOKUP function

• By typing directly into the cell

Which shortcut key combination is used to bold text in Excel?

• Ctrl + I

• Ctrl + S

• Ctrl + U

• Ctrl + B