AI Computer Science Academy · Faisalabad

IT Professional

Use one header per column

Task 22 of 56 IT Professional Excel and Google Sheets
All tasks
Read first Task 22

Use one header per column

A clean table uses one record per row and one field per column. Store dates, numbers and text in suitable cells; avoid merged headers and blank rows inside data. Practice: Build an expense table with Date, Item, Category and Amount columns; apply date and currency display formats. Try this in the application, check the result, then save your work in your IT Practice folder. If an option is unavailable on your device, use the equivalent Microsoft or Google app and record what you observed.

Definition and example

Use one header per column means A clean table uses one record per row and one field per column. Store dates, numbers and text in suitable cells; avoid merged headers and blank rows inside data. Practice: Build an expense table with Date, Item, Category and Amount columns; apply date and currency display formats. Try this in the application, check the result, then save your work in your IT Practice folder. If an option is unavailable on your device, use the equivalent Microsoft or Google app and record what you observed For example, How should a spreadsheet represent each expense? Do this in the named application, inspect the result, and save a clearly named copy. This makes the skill repeatable in school, work and everyday online tasks.

IT Professional Excel and Google Sheets

Read this lesson, then create a free account to mark it complete and continue in order.

Sign in to use up to 8 optional task skips in this course.

Next task (mark this task read first)