Spreadsheet Skills Quiz

Which chart is most appropriate to show the percentage breakdown of project costs?

• Line Chart

• Pie Chart

• Scatter Plot

• Histogram

Which function retrieves data from a specific column in a table based on a matching value in the first column?

• HLOOKUP

• VLOOKUP

• INDEX+MATCH

• XLOOKUP

Conditional formatting is best used for:

• Adding new columns

• Highlighting values above a threshold

• Protecting worksheet cells

• Removing duplicates

Pivot Tables allow users to:

• Modify cell formulas directly

• Summarize and analyze large datasets

• Create macros automatically

• Merge multiple sheets

Which financial function would you use to calculate the monthly payment for a loan?

• NPV

• IRR

• PMT

• FV

The IRR function in spreadsheets is used to:

• Calculate inflation rates

• Determine the internal rate of return for investments

• Compute loan payments

• Forecast future values

Which date function extracts the month from a full date?

• MONTH()

• DATE()

• DAY()

• TODAY()

What feature allows multiple users to edit a spreadsheet simultaneously in Google Sheets?

• Data Validation

• Track Changes

• Collaboration & Sharing

• Scenario Manager

Which “What-If Analysis” tool allows you to test different variable inputs and see outcomes?

• Solver

• Data Validation

• Goal Seek

• Scenario Manager

A strong password and sheet protection are examples of:

• Data Cleaning

• Spreadsheet Security

• Lookup Functions

• Financial Analysis