Table of Contents
ToggleA 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.