LCA Italian study plan

Identify every toolbar group and menu entry in the Writer interface by name and location

Apply character and paragraph formatting (font, size, bold, italic, alignment, spacing) to a two-page document without using the mouse

Insert and format bulleted and numbered lists, then adjust list indentation and numbering restart

Configure page setup: margins, orientation, paper size, and headers/footers with page numbering

Insert and resize images, tables, and text frames, and wrap text around each object

Build a table with merged cells, repeated header row, and applied cell borders and shading

Create and modify paragraph and character styles, then apply them consistently across a document

Generate a table of contents from heading styles and update it after edits

Run spell check, find-and-replace with regular expressions, and word count

Enter formulas using relative, absolute, and mixed references and verify recalculation after copying

Build formulas with SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, and IF across multiple ranges

Sort and filter a data range, then apply conditional formatting driven by a formula

Create a chart from a data range and change its type, labels, and axis titles

Apply number, currency, percentage, and date formats and explain how each changes display versus value

Freeze rows and columns, split a window, and print a selected range with repeated title rows

Use VLOOKUP or INDEX/MATCH to pull values from a second sheet and handle not-found errors

Create and name cell ranges, then reference them in formulas and data validation

Build a 6-slide deck from scratch using layouts, placeholders, and the outline view

Apply a master slide with consistent fonts, bullet levels, and a footer with slide numbers

Insert and animate text, images, and a chart, setting entrance effects and transition timing

Add speaker notes and rehearse timings, then export the deck to PDF

Draw and align shapes using snap-to-grid, guides, and the alignment and distribution tools

Group, layer, and position objects precisely using the position and size dialog

Create a flowchart with connectors that stay attached when shapes move

Export a drawing to PNG and PDF at a specified resolution and verify the output

Create a table with defined field types, a primary key, and at least two related tables

Build a form for data entry and a query with at least two filter criteria and one sort

Design a report grouping records with totals and a page header

Import a CSV file into a table and confirm field types were interpreted correctly

Enter and edit formulas using cell references, operators, and built-in functions with correct syntax

Solve and graph linear equations and systems, adjusting axis scale and chart type

Compute statistics (mean, median, standard deviation) over a data set and interpret each result

Format a formula-heavy sheet so results are readable and errors are explained