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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

Question 7

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

Ctrl + ^

Ctrl + ^

Ctrl + ‘

Ctrl + ‘

Ctrl + `

Ctrl + `

Ctrl + ;

Ctrl + ;

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Good Job!

Oops!

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

Please login to submit your explanation

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

Please login to report

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%

Start Preparing
Detailed performance

Get over 200+ Courses under One Subscription

Get Prime Course List
mute
Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime

Don’t settle Learn from the Best with PrepInsta Prime Subscription

manish-prepinsta

Manish Agarwal

Ex- Accenture

Trained 3.2L+ students

Rushikesh-prepinsta

Rushikesh Konapure

Data Science & Full Stack Mentor

Trained 35k+ students

atulya-prepinsta

Atulya Kaushik

Ex- Google & Instamojo

Trained 3.2L+ students

Aashay-prepinsta

Aashay Mishra

Ex- Sapient

Trained 83k+ students

Janvi-prepinsta

Janvi Jain

Lead Verbal Mentor

Trained 46k+ students

Learn from Top 1%
Get Prime
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta
prepinsta

One Subscription, For Everything

The new cool way of learning and upskilling -

Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime →

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get Prime Course List
Get Prime Course List

Comments

February 19, 2021