Bissoy.com
Doctors Medicines MCQs Q&A

What is the shortcut to enable filtering of selected cells in MS-Excel?

What is the shortcut to enable filtering of selected cells in MS-Excel? Correct Answer Ctrl + shift + L

The correct answer is Ctrl + shift + L.

Ctrl + shift + L is the shortcut to enable filtering of selected cells in MS-Excel.

Additional Information

Shortcuts in Excel:

Close a workbook

Ctrl+W

Open a workbook

Ctrl+O

Go to the Home tab

Alt+H

Save a workbook

Ctrl+S

Copy

Ctrl+C

Paste

Ctrl+V

Undo

Ctrl+Z

Remove cell contents

Delete

Choose a fill colour

Alt+H, H

Cut

Ctrl+X

Go to the Insert tab

Alt+N

Bold

Ctrl+B

Center align cell contents

Alt+H, A, C

Go to the Page Layout tab

Alt+P

Go to the Data tab

Alt+A

Go to the View tab

Alt+W

Open context menu

Shift+F10, or

Context key

Add borders

Alt+H, B

Delete column

Alt+H, D, C

Go to the Formula tab

Alt+M

Hide the selected rows

Ctrl+9

Hide the selected columns

Ctrl+0

 

Related Questions

Three companies L, M, and N participated in campus recruitment in college Z. All three companies selected an equal number of candidates. Out of the total candidates selected, 60 were selected by both L and M. The number of candidates selected by both M and N was 68 less than twice the number of candidates selected by both L and M. There were 28 candidates who got selected by each L, M and N companies. This number was 50% less than the number of candidates selected by both L and N. The total number of candidates selected by both L and N was 92% less than a total number of candidates selected. The total number of students that got placed in exactly one company was what percent more than the ones that got placed in exactly two companies?
Which of the following statement(s) is/are CORRECT for antigen activated effector T cells?
P. CD4+ cells make contact with macrophages and stimulate their microbicidal activity.
Q. CD4+ cells make contact with B cells and stimulate them to differentiate into plasma cells.
R. CD8+ cells make contact with B cells and stimulate them to differentiate into plasma cells.
S. CD8+ cells make contact with virus infected cells and kill them.
In a survey of 100 students, 55 selected in IBPS Clerk, 36 selected in IBPS PO and 48 selected in SBI Clerk. 16 selected in IBPS Clerk and IBPS PO, 18 selected in IBPS PO and SBI Clerk and 15 selected in IBPS Clerk and SBI Clerk. Then, find the number students who are selected in all three exams (i.e IBPS Clerk, IBPS PO and SBI Clerk)?
A team of six members is to be selected from five men M1, M2, M3 M4, and M5, and five women W1, W2, W3, W4, and W5. W2 and W5 cannot be selected together. M1 and W3 have to be selected together. W3 and W4 cannot be selected with M2. W1 and M5 cannot be selected together. M3 and M4 cannot be selected together. Which of the following members may be selected?
A team of five members is to be selected from five boys B1, B2, B3, B4 and B5 and five girls G1, G2, G3, G4 and G5. B2 and G3 have to be selected together. G1 and B5 have to be selected together. B1 and G5 cannot be selected together. G2 and B4 cannot be selected together. G3 and B5 cannot be selected together. Which of the following members may be selected?
In the question two statements are given, followed by two conclusions, I and II. Read all the conclusions and then decide which of the given conclusions logically follow/s from the given statements. Statements: All white blood cells are red blood cells. Some blood cells are red blood cells. Conclusions: I. All blood cells are red blood cells, is a possibility. II. Some red blood cells are not blood cells.
A team is to be selected from 13 players P1, P2, P3, P4, P5, P6, P7, P8, P9, P10, P11, P12 and P13. There will be seven players in the team. P2 cannot be selected with P1, P6 or P4. P7 cannot be selected with P2, P10, P11 or P13. If P8 and P13 both are selected, then P5 must be selected. P4 cannot be selected with P2, P10, P12 or P11. Which of the following is a correct selection of the team?   
A group of four teachers is to be formed from amongst seven teachers T1, T2, T3, T4, T5, T6 and T7. Either T1 or T2 should be selected with T5. T4 and T7 cannot be selected together. Either T3 or T6 should be selected with T2. Either T7 or T5 should be selected with T6. Who among the following may be selected?
Some candidates were selected by a company after the hiring process. The ratio of selected to unselected was 4 ∶ 1. If 70 less had applied and 30 less selected, the ratio of selected to unselected would have been 6 ∶ 1. How many candidates were selected?
A, B, C, D and E play Hockey. 3 players from Hockey were selected to form Team 1. I. A is always selected. II. Exactly one among B and C is always selected III. D will not participate if B is selected. IV. E will not play with C Which among the given option is a possibility of team to be selected?