Formatting Basics
Cell Formatting Tools
Freeze Panes & Navigation
Printing & Layout
Tables & Data Organization
100

This format is used for hospital billing amounts

What is Currency?

100

This formatting tool makes headings darker and stronger

What is Bold?

100

This option keeps row headings visible while scrolling.

What is Freeze Top Row?

100

This page orientation is best for wide spreadsheets.

What is Landscape?

100

This converts a dataset into a structured format.

What is a Table?

200

This feature makes headings stand out.

What is Bold?

200

This tool adds colour to cells.

What is Fill Colour?

200

This option keeps patient ID columns visible.

What is Freeze First Column?

200

This feature selects exactly what will print.

What is Print Area?

200

This table feature automatically calculates totals.

What is Total Row?

300

This formatting tool allows long text to appear on multiple lines.

What is Wrap Text?

300

This feature combines cells into one centered title.

What is Merge & Center?

300

This Excel feature helps navigate large datasets easily

What is Freeze Panes?

300

This setting allows headings to appear on every printed page.

What are Print Titles?

300

This feature changes the appearance of tables quickly.

What is Table Style?

400

This feature combines cells into one centered title.

What is Merge & Center?

400

This tool displays long text on multiple lines in one cell.

What is Wrap Text?

400

This is especially useful when working with thousands of hospital records

What is Freezing Headings?

400

This feature adjusts worksheet appearance before printing

What is Page Layout?

400

This allows the table size to expand or shrink.

What is Resize Table?

500

This formatting tool adds lines around cells.

What are Borders?

500

This formatting tool adds lines around cells.

What are Borders?

500

This tab contains the Freeze Panes command.

What is the View Tab?

500

This setting helps fit all rows and columns onto one page.

What is Scaling/Fit to One Page?

500

This tab appears when a table is selected.

What is Table Design?