Microsoft Word and Excel Quiz

What tab is used to find "Styles" in Microsoft Word?

• Insert

• Layout

• Home

• View

What component is required to generate a Mail Merge?

• Font style

• Image source

• Data source

• Header file

What does a macro do in Microsoft Word?

• Hides text

• Records and repeats actions

• Adds citations

• Checks grammar

Which of the following generates a clickable list of sections in Word?

• Mail Merge

• Macro

• Table of Contents

• Styles Pane

Which break allows different headers or footers in a document?

• Line Break

• Page Break

• Section Break

• Paragraph Break

Which of the following is NOT a valid Excel function?

• =SUM()

• =TOTAL()

• =AVERAGE()

• =IF()

Which Excel reference locks both column and row?

• A1

• $A$1

• A$1

• $A1

What is the use of the AutoSum button?

• To record macros

• To merge documents

• To quickly insert common functions

• To insert templates

What tool allows inserting <<First_Name>> in Word?

• Styles

• TOC

• Mail Merge

• Macro

What Excel operator is used for multiplication?

• x

• ^

• *

• /