Mr Dowler

Physics 30 Unit 3 Test Solutions

Spreadsheet 2 (INF2080) 5.3: Prepare workbooks for distribution

Spreadsheet 2 (INF2080) 5.2: Protect and share workbook

Spreadsheet 2 (INF2080) 5.1.2: Convert file formats

Spreadsheet 2 (INF2080) 5.1.1: Save and publish as web pages

Spreadsheet 2 (INF2080) 4.4.3: Outline data

Spreadsheet 2 (INF2080) 4.4.2: Two component filter sort

Spreadsheet 2 (INF2080) 4.4.1: Two component simple sort

Spreadsheet 2 (INF2080) 4.3.1: Insert, move, and resize images

Spreadsheet 2 (INF2080) 4.2: modify and position chart elements

Spreadsheet 2 (INF2080) 4.1.2: Clustered column charts

Spreadsheet 2 (INF2080) 4.1.1: various chart types

3.3.3: rotate and align shapes and graphics (Google Slides version)

3.1.3: cropping, resizing, scaling and rotating a picture (Google Docs version)

5.2: use spell and grammar check (Google Docs version)

2.1.2: modify character spacing and scale (Google Docs version)

2.2.2: inserting symbols and characters (Google Docs version)

2.3.2: Inserting page breaks (Google Docs version)

2.2.1: using advanced cut and paste skills (Google Docs version)

3.2.1: Insert or delete rows and columns (Google Sheets version)

3.3.4 convert text to columns (Google Sheets version)

3.2.3: rotate, resize and recolour a photo (Google Slides version)

1.2.3: create and modify columns (Google Docs version)

Compelling argument (not proof) that a tangent to a circle is always perpendicular to the radius.

6.1.3: set print area (Google Sheets version)

2.1.2: edit text on a slide (Google Slides version)

3.1.2: adjusting image properties (Google Docs version)

2.2.4: modify fonts and font styles (Google Slides version)

6.1.2: change page orientation (Google Sheets version)

2.1.4: Setting indentations; e g , first line, hanging indent, negative, both sides (Google Docs)

2.2.3: add and modify text art on a slide; e g , word art (Google Slides version)

4.1.1: add, edit and delete comments (Google Slides version)

Spreadsheet 2 (INF2080) 2.1.3: Hide and Unhide Rows and Columns

1.1.6: Saving and editing a document (Google Docs version)

3.3.1: Edit, move and clear cell contents Google Sheets version

1.3.1: setting standard properties; e.g., keywords, author, title (Google Docs version)

2.3.2: work with breaks; e g , page, section, column (Google Docs version)

INF2100 1.3: Macros

4.1: insert tables and lists to organize content (Google Docs version)

2.2.1: copy, cut and paste text (Google Slides version)

2.3.1: copying and pasting elements from one slide to another (Google Slides version)

4.4.2: hiding slides (Google Slides version)

4.2: modify tables; e g , mergesplit cells, use shading, insert rows, columns (Google Docs version)

2.2: manipulate text; e g , cut, copy, paste (Google Docs version)

Spreadsheet 2 (INF2080) 3.4: IF Conditionals

3.2: insert and modify text boxes (Google Docs version)

1.1: Key features of spreadsheet software

Insert, Delete and Rearrange Worksheets (Google Sheets Version)

4.3.2: use pens, highlighters and arrows (Google Slides version)

INF2100 2.11: Pagination

2.2.8: add and modify bulleted lists (Google Slides version)

1.1.7: Printing a document (Google Docs version)

2.1.3: size and format text boxes (Google Slides version)

2.4.1: add animation and effects to a graphic, text box or photo (Google Slides version)

5.1.2: zoom (Google Docs version)

1.2.3: Inserting headers and footers (Google Docs version)