Basics of Spreadsheet

________ helps to view the worksheet before the final printout is taken.

• Print

• Print Preview

• Save

• Edit

We can have _________ worksheets in a single workbook.

• Single

• Double

• Triple

• Multiple

F2 key is used to _______ the cell.

• Resize

• Delete

• Edit

• Autofill

Excel is used to prepare _______ data.

• Statistical

• Numerical

• Graphical

• Analytical

Cell range is a group of cells in a worksheet that have been ______.

• Edited

• Selected

• Deleted

• Resized

Autosum helps to add contents of a group of ________ cells.

• Selected

• Horizontal

• Vertical

• Adjacent

Complete the steps :

Home Tab→______→Replace

• Save

• Edit

• Find

• Delete

Pivot table flips and ______ data in less time.

• Sums

• Selects

• Edits

• Deletes

Use of _______ enables us to treat the number as text.

• Comma (,)

• Full stop (.)

• Astrick (*)

• Apostrophe (')

Cell address A5 refers to _____ A and ______ 5.

• Row, Column

• Column, Row

• Header, Footer

• Cell, Range