1) A _ is a group of worksheets. a) Work b) Workbook c) Spreadsheet d) Home Tab 2) The cell having bold boundary is the _ cell. a) Active b) Number c) Formula d) Address 3) Address of the cell at 20th column and 30th row is _. a) T20 b) T50 c) T10 d) T30 4) The shortcut key of copy is _. a) Ctrl + O b) Ctrl + C c) Ctrl + Y d) Ctrl + P 5) Give address of the cell at 25th row and 10th column _ . a) J25 b) J10 c) J35 d) J5 6) A range can be filled either by the dragging the _ handle. a) Column b) Fill c) Row d) Cell 7) The extension of a workbook in MS Excel is _ by default. a) .xlsv b) .xlvs c) .xlxs d) .xlsx 8) How would you refer to the range starting from 1st column, 1st row and spread till 5th column and 3rd row. a) T20 b) A1 : F3 c) Cell d) Spreadsheet 9) Three types of data can be entered in a worksheet. a) 1. Numbers, 2. Text, 3. Row b) 1. Formula, 2. Cell, 3. Row c) 1. Row, 2.Column, 3.Text d) 1. Numbers, 2. Text, 3. Formula 10) _ is an input bar, below the ribbon. a) Formula Bar b) Address Bar c) Title Bar d) Status Bar

Functions and Calculation in Spreadsheet p1

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?