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?
#
%
IF
$
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"}
Powered by: Quiz Maker