MS Office shortcuts

201.Which Excel chart shows values as vertical bars?

1. A. Bar chart
2. B. Column chart
3. C. Line chart
4. D. Pie chart

202.Which Excel chart shows the relationship between two sets of numbers as dots?

1. A. Scatter (XY) chart
2. B. Pie chart
3. C. Column chart
4. D. Area chart

203.A small chart inside a single Excel cell is called what?

1. A. Data bar only
2. B. Thumbnail
3. C. Mini chart
4. D. Sparkline

204.Which Word feature lets several people comment on a document?

1. A. Macros
2. B. Mail Merge
3. C. Styles
4. D. Comments

205.Which Word feature compares two versions of a document?

1. A. Compare (in the Review tab)
2. B. Mail Merge
3. C. Track Changes only
4. D. Navigation Pane

206.Which Word pane lets you jump between headings and pages?

1. A. Reviewing Pane
2. B. Styles Pane
3. C. Clipboard Pane
4. D. Navigation Pane

207.Which Word feature creates a list of sources at the end of a document?

1. A. Index
2. B. Bibliography
3. C. Glossary
4. D. Table of Contents

208.Which Word feature creates an alphabetical list of terms with page numbers at the end of a book?

1. A. Index
2. B. Footnotes
3. C. Table of Contents
4. D. Bibliography

209.Which Word feature splits text into newspaper-style columns?

1. A. Tabs
2. B. Columns
3. C. Sections only
4. D. Tables

210.A break that lets different parts of a Word document have different layouts is called what?

1. A. Line break
2. B. Column break
3. C. Page break
4. D. Section break

211.Which Word view shows the document as a web page?

1. A. Draft
2. B. Print Layout
3. C. Outline
4. D. Web Layout

212.Which Word feature reads the document aloud?

1. A. Immersive Reader only
2. B. Narrator
3. C. Dictate
4. D. Read Aloud

213.Which Word feature lets you type by speaking?

1. A. Translate
2. B. Dictate
3. C. Editor
4. D. Read Aloud

214.Which PowerPoint feature suggests slide designs automatically?

1. A. Designer (Design Ideas)
2. B. Rehearse Timings
3. C. Slide Master
4. D. Morph

215.Which PowerPoint transition smoothly moves objects between two slides?

1. A. Push
2. B. Wipe
3. C. Morph
4. D. Fade

216.Which PowerPoint feature hides a slide during the show without deleting it?

1. A. Hide Slide
2. B. Slide Sorter
3. C. Delete Slide
4. D. Section

217.Which PowerPoint feature groups slides into named parts?

1. A. Sections
2. B. Masters
3. C. Layouts
4. D. Themes

218.Which PowerPoint view shows the speaker's notes and next slide to the presenter?

1. A. Slide Sorter
2. B. Normal View
3. C. Presenter View
4. D. Reading View

219.In Microsoft Access, a question asked of the database is called what?

1. A. Query
2. B. Table
3. C. Report
4. D. Form

220.In Microsoft Access, a screen for entering data is called what?

1. A. Query
2. B. Form
3. C. Report
4. D. Macro

221.In Microsoft Access, a formatted printout of data is called what?

1. A. Table
2. B. Form
3. C. Report
4. D. Query

222.In a database, a field that links to the primary key of another table is called what?

1. A. Primary key
2. B. Composite key
3. C. Foreign key
4. D. Index

223.The file extension of a modern Microsoft Access database is what?

1. A. .xlsx
2. B. .accdb
3. C. .mdb only
4. D. .dbf

224.In Outlook, an email you have written but not sent is saved in which folder?

1. A. Drafts
2. B. Inbox
3. C. Outbox
4. D. Sent Items

225.Which Outlook feature sends an automatic reply when you are away?

1. A. Quick Steps
2. B. Signatures
3. C. Automatic Replies (Out of Office)
4. D. Rules

226.Which Outlook feature automatically sorts incoming mail into folders?

1. A. Signatures
2. B. Quick Parts
3. C. Categories
4. D. Rules