Survey Maker Survey Templates Contact Privacy & Security

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+~

Shortcut key to use Flash Fill function

Ctrl+E

Ctrl+D

Ctrl+Shift+F

Ctrl+A

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)

What attribute / key / Function is used for Cell Referencing in Excel?

Shortcut key to calculate Sum of set data

Ctrl+

Alt=

SUM+

Shift=

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

{"name":"Know Your Excel", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsMultiple choice and open-ended formatsLearn while you play!","img":"https:/images/course5.png"}