Odia govt jobs   »   Computer(MS Office) One-liner Questions for All...

Computer(MS Office) One-liner Questions for All Competitive Exams

A one-liner computer is a concise, single line of code designed to perform a specific function or calculation efficiently. These compact commands are often used in scripting and automation to simplify complex tasks.Here are the top 20 one-liner questions on use of MS Access with answers:

One Liner Questions with answer on MS Office

 

Q1: Which MS Word feature helps in automatically numbering pages?
Q2: How do you remove all hyperlinks from a Word document?

Q3: What function is used to create a chart in Excel?

Q4: How do you lock a cell in Excel to prevent editing?
Q5: What is the shortcut key for creating a new presentation in PowerPoint?

Q6: How do you insert a table in PowerPoint?

Q7: In MS Excel, which function is used to calculate the average of a range?

Q8: How do you check the spelling and grammar in Word?

Q9: What feature in Excel helps to summarize data in a dynamic table format?

Q10: How can you merge cells in Excel?
Q11: Which MS Word tool allows you to add a citation in your document?

Q12: How do you apply a filter in Excel?

Q13: How do you insert a picture in a PowerPoint slide?

Q14: What is the shortcut to undo an action in MS Office programs?

Q15: In Word, how do you create a bulleted list?
Q16: How can you change the theme of a PowerPoint presentation?

Q17: What feature in Excel helps to find duplicates in a dataset?
Q18: How do you insert a hyperlink in MS Word?
Q19: How do you add a footnote in Word?
Q20: In PowerPoint, how do you apply an animation to an object?

Answers

S1. Ans: Page Number feature.
S2. Ans: Use “Ctrl + A” to select all text and press “Ctrl + Shift + F9”.
S3. Ans: Insert > Chart.

S4. Ans: Right-click the cell > Format Cells > Protection > Check “Locked” and protect the sheet.

S5. Ans: Ctrl + N.

S6. Ans: Insert > Table.
S7. Ans: =AVERAGE(range).

S8. Ans: F7 or Review > Spelling & Grammar.

S9. Ans: PivotTable.

S10. Ans: Select the cells > Right-click > Merge Cells.

S11. Ans: References > Insert Citation.

S12. Ans: Data > Filter.

S13. Ans: Insert > Pictures.

S14. Ans: Ctrl + Z.

S15. Ans: Home > Bullets.

S16. Ans: Design > Themes.

S17. Ans: Conditional Formatting > Highlight Cells Rules > Duplicate Values.

S18. Ans: Insert > Hyperlink.

S19. Ans: References > Insert Footnote.
S20. Ans: Select object > Animations > Choose Animation.

RRB NTPC CBT-1 2024-25 | 20 Digital Test Papers with Smart Answer Key (English Printed Edition) By Adda247

Foundation Batch (Prelims + Mains) For Odisha LTR Teacher Exams 2024-25 | Online Live Classes by Adda 247
Computer(MS Office) One-liner Questions for All Competitive Exams_5.1