TCS Subject NQT Computer Skills MS Excel Quiz- 1

Question 1

Time: 00:00:00
Which command is used to clear formatting from Excel sheets?

Ctrl + \

Ctrl + \

Ctrl + /

Ctrl + /

Ctrl + |

Ctrl + |

Ctrl + `

Ctrl + `

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Which shortcut key combination can be used to insert the current time into a cell?

Ctrl+D

Ctrl+D

Ctrl+Shift+; (Control+Shift+semicolon)

Ctrl+Shift+; (Control+Shift+semicolon)

Ctrl+; (Control+semicolon)

Ctrl+; (Control+semicolon)

Ctrl+Shift+D

Ctrl+Shift+D

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which shortcut key combination can be used to insert the current date and time into a cell?

Ctrl+D

Ctrl+D

Ctrl+Shift+; (Control+Shift+semicolon)

Ctrl+Shift+; (Control+Shift+semicolon)

Ctrl+; (Control+semicolon)

Ctrl+; (Control+semicolon)

Ctrl+Alt+Shift+;

Ctrl+Alt+Shift+;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which command is used to paste format only?

Ctrl + V

Ctrl + V

Ctrl + Shift + V

Ctrl + Shift + V

Ctrl + Alt + V

Ctrl + Alt + V

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Which command is used to paste values only?

Ctrl + V

Ctrl + V

Ctrl + Shift +V

Ctrl + Shift +V

Ctrl + Alt +V

Ctrl + Alt +V

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which shortcut key is used to align text in the centre?

Ctrl + Shift + E

Ctrl + Shift + E

Ctrl + Shift + L

Ctrl + Shift + L

Ctrl + Shift + P

Ctrl + Shift + P

Ctrl + Shift + R

Ctrl + Shift + R

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Which shortcut key is used to show all formulas?

Ctrl + ^

Ctrl + ^

Ctrl + ‘

Ctrl + ‘

Ctrl + `

Ctrl + `

Ctrl + ;

Ctrl + ;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Shortcut key to merge and centre the cells in an excel sheet:

Alt + H + M + C

Alt + H + M + C

Alt + H + M + M

Alt + H + M + M

Ctrl + M

Ctrl + M

Alt + H + M + A

Alt + H + M + A

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Shortcut key to unmerge the cells in an excel sheet:

Alt + H + M + C

Alt + H + M + C

Alt + H + M + M

Alt + H + M + M

Alt + H + M + A

Alt + H + M + A

Alt + H + M + U

Alt + H + M + U

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Shortcut key to merge the cells in an excel sheet:

Alt + H + M + C

Alt + H + M + C

Alt + H + M + M

Alt + H + M + M

Alt + H + M + A

Alt + H + M + A

Alt + H + M + U

Alt + H + M + U

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%

Comments