Excel Functions and Shortcuts

This video tutorial provides a comprehensive introduction to Excel, covering basic features such as Autofill, creating and filtering tables, using Flash Fill, and moving data. It also delves into data transposition, text formatting, and basic math operations. Advanced functions like calculating the least common multiple and logarithms are also explored, offering a well-rounded guide to Excel's capabilities.

What is the shortcut key to undo an action in Excel?

• Ctrl + X

• Ctrl + Z

• Ctrl + Y

• Ctrl + A

Which feature allows you to quickly fill a series of dates in Excel?

• Transpose

• Autofill

• Flash Fill

• Filter

How can you insert a new column in an Excel table?

• Right-click and select 'Insert'

• Press Ctrl + T

• Press Ctrl + C

• Use the Autofill handle

What is the purpose of the Flash Fill feature in Excel?

• To create a new worksheet

• To sort data alphabetically

• To automatically fill data based on examples

• To fill cells with a pattern

Which function would you use to combine text from multiple columns into one?

• CONCATENATE

• AVERAGE

• VLOOKUP

• SUM

How can you extract the first four characters from a text string in Excel?

• TEXTJOIN function

• LEFT function

• MID function

• RIGHT function

Which Excel function calculates the average of a set of numbers?

• MEDIAN

• AVERAGE

• SUM

• MODE

What is the result of using the LCM function on the numbers 4 and 6?

• 6

• 18

• 12

• 24

Which function would you use to find the square root of a number in Excel?

• POWER

• EXP

• SQRT

• LOG

What is the shortcut key to show all formulas in an Excel worksheet?

• Ctrl + F

• Ctrl + H

• Ctrl + Tilde

• Ctrl + P