CAT G11 Module 27 MB Quiz

If I want to add a part to a Mail Merge letter, like <<last name>> or <<birthday>> where would I need to click?

• Greeting Line

• Merge Field

• Start Mail Merge

• Address Block

The ______ is the file that contains all the addresses you want to use when creating a Mail Merge envelope.

• Merge Field

• Data Source

• Address Block

• Merged document

A ________ is a document file that contains predefined settings and can be used to create documents such as : invoices, receipts and budgets.

What chart is mainly used to compare data and plots the data in rectangular bars horizontally?

• Column chart

• Line chart

• Bar chart

• Pie chart

A ____ chart is used to spot trends over a period. 

• Pie

• Column

• Line

• Bar

To add or modify the legend, data labels or axis on a chart you can navigate to the Chart Design tab and...

• Select the 'Add Chart Elements' button

• Select the 'Format' button

• Select the 'Change Chart Items' button

• Select the 'Layout' button

An ______ cell reference is a cell within a spreadsheet that remains constant even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet.

• relative

• constant

• linked

• absolute

Which function calculates the sum of values in a range based on a true or false condition,  specific cells in a range can be added if they meet the criteria?

• COUNTIF

• TOTAL

• IF

• SUMIF

From which tab menu can you import data into MS Excel?

• File

• Insert

• Data

• Review