Know Your Excel

A visually engaging image of a computer screen displaying various Excel fun<wbr>ctions and shortcuts, surrounded by charts and graphs, with a colorful and modern design.

Know Your Excel Quiz

Test your skills and knowledge of Excel with our engaging quiz designed for all levels! Whether you're a beginner or an advanced user, this quiz will challenge your understanding of Excel functions, shortcuts, and features.

11 thought-provoking questions
Multiple choice and open-ended formats
Learn while you play!

11 Questions3 MinutesCreated by TypingEagle735

Keyboard shortcut to standardise the date formatting in a set of data

Ctrl+Shift+1

Ctrl+1

Ctrl+Shift+3

Ctrl+~

Identify the correct formula for V-lookup function

=Vlookup(Lookup_value,Table_array,Col_index_num,Range_lookup)

=Vlookup(Lookup_value,Table_index_array,Col_num,Range_lookup)

Assume in a sheet with two column "First Name" & "Last Name". You have combine the both cells and make it one. What is the excel shortcut formula you will apply?

=Join(Cell1,Cell3,Cell2)

=Concatenate(Cell1,Cell2)

=Merge(Cell1:2)

=Concatenate(text1,text2)

What is the shortcut key to use Replace function in Excel?

Ctrl+H

Ctrl+R

Ctrl+F

Ctrl+Q

What is the shortcut key for Deleting a (Row, Column, or Cell) in Excel?

Ctrl+Del

Ctrl + -

Alt+Shift+Del

Delete

Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

Right-click column C, select Format Cells, and then select Best-Fit.

Double-click column C

Right-click column C and select Best-Fit

Double-click the vertical boundary between columns C and D

If cell A3 contains the text THE TALE OF TWO CITIES, what will the response if we apply function =PROPER(A3) and hit enter?

The tale of two cities

The tale of two Cities

THE TALE OF TWO CITIES

The Tale Of Two Cities

Know Your Excel

Know Your Excel Quiz

More Quizzes