<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@e4c8c56611eb44918588830b83e76c84" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@1f97565aacbb40b7b2407e9a1b87b9fb">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@1f97565aacbb40b7b2407e9a1b87b9fb" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p>- <strong>Select</strong> a <strong>row</strong></p>
<ul>
<ul>
<li>Click the row heading</li>
</ul>
</ul>
<p>- <strong>Select</strong> a range of <strong>adjacent</strong> <strong>rows</strong></p>
<ul>
<ul>
<li>Click the first row heading</li>
<li>Drag to highlight through to the last row heading</li>
</ul>
</ul>
<p>- <strong>Select</strong> a <strong>range</strong> of <strong>non-adjacent rows</strong></p>
<ul>
<ul>
<li>Click the first row heading or range of rows</li>
<li>Hold the Ctrl key down and continue highlighting additional row headings</li>
</ul>
</ul>
<p>- <strong>Select</strong> a <strong>column</strong></p>
<ul>
<ul>
<li>Click the column heading</li>
</ul>
</ul>
<p>- <strong>Select</strong> a range of <strong>adjacent</strong> <strong>columns</strong></p>
<ul>
<ul>
<li>Click the first column heading</li>
<li>Drag to highlight through to the last column heading</li>
</ul>
</ul>
<p>- <strong>Select </strong>a<strong> range </strong>of<strong> non-adjacent columns</strong></p>
<ul>
<ul>
<li>Click the first column heading or range of columns</li>
<li>Hold the Ctrl key down and continue highlighting additional column headings</li>
</ul>
</ul>
<p></p>
<p></p>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@d1d2dc9808cf446686b0067d4c696c26" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@455e6dc8e20b45df90545b706546ed99">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@455e6dc8e20b45df90545b706546ed99" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p><strong>- </strong><b>Insert rows</b></p>
<ul>
<ul>
<li>Click the row heading(s) above which the new row will appear</li>
<li>On the Home tab, in the Cells group, click the Insert button</li>
</ul>
</ul>
<p><strong>- Insert columns</strong></p>
<ul>
<ul>
<li>Click the column heading(s) immediately to the right of where the new column will appear</li>
<li>On the Home tab, in the Cells group, click the Insert button</li>
</ul>
</ul>
<p><strong>- Delete rows and columns</strong></p>
<ul>
<ul>
<li>Select the row(s) or column(s) to be deleted</li>
<li>On the Home tab, in the Cells group, click the Delete button</li>
<li>Select the appropriate option</li>
</ul>
</ul>
<p></p>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@9aba3230b8b24209bc16147a78075f1c" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@7e878d5b3f7941c8b554cba4a8aef1de">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@7e878d5b3f7941c8b554cba4a8aef1de" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p style="text-align: justify;">- <strong>Modify</strong> <strong>column</strong> <strong>widths</strong> to a specified value, to optimal width</p>
<ul>
<ul>
<li>Click the column headings(s) of the columns to modify</li>
<li>On the Home tab, in the Cells group, click the Format button</li>
<li>To modify the column width to a specified value, click Column Width… and enter a width</li>
<li>Click OK</li>
<li>To modify the column with to optimal width, click AutoFit Column Width</li>
</ul>
</ul>
<p style="text-align: justify;">- <strong>Modify row heights</strong> to a specified value, to optimal height</p>
<ul>
<ul>
<li>Click the row headings(s) of the rows to modify</li>
<li>On the Home tab, in the Cells group, click the Format button</li>
<li>To modify row height to a specified value, click Row Height… and enter a row height</li>
<li>Click OK</li>
<li>To modify row height to optimal height, click AutoFit Row Height</li>
</ul>
</ul>
<p style="text-align: justify;"></p>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@b40bed517c084e21a29d3dcf6f2321e2" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@883192c839f54df8a7f1ec274cdbd48b">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@883192c839f54df8a7f1ec274cdbd48b" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p style="text-align: justify;"><strong>- Freeze row titles</strong></p>
<p style="text-align: justify;">Select the row immediately below the row to freeze</p>
<p style="text-align: justify;">On the View tab, in the Window group, click the Freeze Panes button</p>
<p style="text-align: justify;">Click Freeze Panes</p>
<p style="text-align: justify;"><strong>- Freeze column titles</strong></p>
<ul>
<ul>
<li>Select the column immediately to the right of the column to freeze</li>
<li>On the View tab, in the Window group, click the Freeze Panes button</li>
<li>Click Freeze Panes</li>
</ul>
</ul>
<p style="text-align: justify;"><strong>- Unfreeze rows and/or column titles</strong></p>
<ul>
<ul>
<li>On the View tab, in the Window group, click the Freeze Panes button</li>
<li>Click Unfreeze Panes</li>
</ul>
</ul>
<p style="text-align: justify;"></p>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@c5a97937510b4fc4ad84d87528a9a5c6" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@8e2d2647494e40dba8eddbbe97f9318a">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@8e2d2647494e40dba8eddbbe97f9318a" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p><b>- Switch between worksheets</b></p>
<ul>
<ul>
<li>Click the worksheet tab at the bottom of the workbook window</li>
</ul>
</ul>
<p><strong>- Insert a new worksheet</strong></p>
<ul>
<ul>
<li>Click the New sheet button on the Status bar</li>
</ul>
</ul>
<p><strong>- Delete a worksheet</strong></p>
<ul>
<ul>
<li>Select the worksheet to delete in the worksheet tab at the bottom of the workbook window</li>
<li>Right-click the tab and click Delete</li>
<li>Click Delete again if prompted</li>
</ul>
</ul>
<p><strong>- Recognise good practice in naming worksheets</strong></p>
<ul>
<ul>
<li>Use meaningful worksheet names rather than accept default names</li>
</ul>
</ul>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@0a1ed412c3294b6cab5b90ea84b7e0b8" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@f4d262364ce14c95b198b1e882c7addf">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="2914d67c15dc11ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@f4d262364ce14c95b198b1e882c7addf" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p>- <strong>Copy</strong>, <strong>move</strong> a <strong>worksheet</strong> within a spreadsheet, between spreadsheets</p>
<ul>
<ul>
<li>Right-click the worksheet tab at the bottom of the workbook window</li>
<li>Click Move or Copy</li>
<li>Select the location to copy the worksheet to</li>
<li>Check the Create a copy checkbox</li>
<li>Click OK</li>
<li>To copy a worksheet between spreadsheets, select the workbook to copy the worksheet to under the To book: drop-down menu, check the Create a copy checkbox, click OK</li>
<li>To move a worksheet within a spreadsheet, select the location to move the worksheet to, click OK</li>
<li>To move a worksheet between spreadsheets, select the workbook to copy the worksheet to under the To book: drop-down menu, click OK</li>
</ul>
</ul>
<p><strong>- Rename a worksheet</strong></p>
<ul>
<ul>
<li>Right-click the worksheet tab and click Rename</li>
<li>Enter the new name for the worksheet and hit Enter on the keyboard to save</li>
</ul>
</ul>
<p></p>
</div>
</div>
</div>
</div>