Know Your Excel

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/QY3PIP7N5","txt":"Keyboard shortcut to standardise the date formatting in a set of data, Shortcut key to use Flash Fill function, Identify the correct formula for V-lookup function","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

Quiz Maker