Know Your Excel
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 fun
- 11 thought-provoking questions
- Multiple choice and open-ended formats
- Learn while you play!
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"}
More Surveys
Excel Training
5230
Data Intelligence Team Weekly Fair
9413
Shared tools
6321
Background of Attendees
8420
Skills
1169
Know about IoT
10522
CS FOLDER PROJECT
1589
Registaration Form for Certificate
12620
ITC Certification Course
1059
Behavioral & Structural Design Pattern Quiz Quiz
10517
Purchasing Document Menu Search Filter
3226
360 CEO
1268