Question

Aadya is working on a spreadsheet. Help her with the solutions for the following : (a) Identify the following symbol/toolbar :  (b) Renaming a worksheet from sheet1 to Cost Sheet. (c) To keep the headings constant/visible even if she scrolls down.

Answer 1

a) Go to Insert option – Symbols – Symbols – select ‘:’ or select Normal Text – Lisu – Character code A4FD from Unicode (Hex) – Description ‘Lisu Letter Tone Mya Jeu’

Go to Insert option – Symbols – Symbols – select ‘□’ or select Normal Text – Geometric Shapes – Character code 25A1 from Unicode (Hex) – Description ‘White square’

b) Double-click on Sheet1. When it is hi-lighted, type Cost Sheet. Press ‘Enter’.

c) Hi-light entire row below headings to stay constant (by clicking on number cell to left of spreadsheet). Select view, select Freeze pane.

Answer 2

Explanation:

To keep the column headers viewing means to freeze the top row of the worksheet.