1) A _ is a group of worksheets. a) Work b) Workbook c) Spreadsheet d) Home Tab 2) In Ms Excel, a formula starts with _ sign. a) ( ) b) / c) = d) { } 3) The cell having bold boundary is the _ cell. a) Active b) Number c) Formula d) Address 4) Address of the cell at 20th column and 30th row is _. a) T20 b) T50 c) T10 d) T30 5) The shortcut key of copy is _. a) Ctrl + O b) Ctrl + C c) Ctrl + Y d) Ctrl + P 6) The shortcut key of paste is _ . a) Ctrl + P b) Ctrl + Z c) Ctrl + S d) Ctrl + V 7) Give address of the cell at 25th row and 10th column _ . a) J25 b) J10 c) J35 d) J5 8) A range can be filled either by the dragging the _ handle. a) Column b) Fill c) Row d) Cell 9) Cell is formed by intersection _ and _ . a) Formula, Number b) Address bar, Title bar c) Row, Column d) Column, Formula 10) The extension of a workbook in MS Excel is _ by default. a) .xlsv b) .xlvs c) .xlxs d) .xlsx 11) _ key can be used to remove the cell content. a) Hide b) Delete c) Remove d) Undo 12) The range of rows are _ to _ . a) 1, 1048576 b) 1, 1048567 c) 1, 1048756 d) 1, 1048765 13) Who is known as father of electronic spreadsheet? a) Daniel Haukin b) Daniel Brakin c) Daniel Hauklin d) Daniel Bricklin 14) A _ is a software that can store huge amount of data in a large table. a) Cell b) Home Tab c) Spreadsheet d) Address bar 15) Name the first electronic spreadsheet software? a) Visi Calc b) Visi Cacur c) Vis Calc d) Visi Ccr 16) 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 17) 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 18) The range of columns are _ to _. a) A, XYZ b) A, ZYX c) A, XFD d) A, ZXY 19) The shortcut key of cut is _ . a) Ctrl + V b) Ctrl + X c) Ctrl + C d) Ctrl + Z 20) The _ shows the name of the workbook, followed by the application name. ( MS Excel ) . a) Address Bar b) Name Box c) Column d) Title Bar 21) A thin bar at the bottom of the Excel Window. a) Status Bar b) Workbook c) Address bar d) Title Bar 22) A _ is a horizontal set of cells. a) Spreadsheet b) Column c) Row d) Workbook 23) A cell address contains its _ number and _ number. a) Column, Workbook b) Column, Row c) Formula, Row d) Formula, Text 24) _ is an input bar, below the ribbon. a) Formula Bar b) Address Bar c) Title Bar d) Status Bar 25) The _ is used to enlarge a window to cover entire desktop. a) Numbers b) Text c) Minimize button d) Maximize button

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

Pulihkan simpan otomatis: ?