ECAT Computer Science MCQ's Test For Full Book With Answers

ECAT Computer Science MCQ's Test For Full Book

Sr. # Questions Answers Choice
1 Range of cells from C2 to C100 is referenced as: C2-100 C2:C100 C2 to C100 C2:100
2 Symbol is used before formula: & = # $
3 ____ menu contains the 'Name' command: File View Insert Format
4 The absolute reference of cell address A15 is written as: $A15 $A15$ A$15 $A$15
5 _____ is an absolute address: A1 A1$ A$1$ None
6 A mathematical expression that is used to perform calculation on worksheet is called: Cell Format Formula Address
7 Which of the following is an absolute address? A1 A1$ $A$1 None of these
8 To add the value of cell 'C9' of worksheet "Sheet3" with the cell 'B2' of current worksheet, the formula is written as: =C9+B2 =Sheet3!C9+B2 =Sheet3!B2+C9 =Sheet3!B2+sheet3!C9
9 Formula can only be applied on: Values Labels Unmerged cells None
10 For a currency format cell, the number 461.593 will be displayed as: 461.593 $4615.19 $46159.3 $461.59
11 If the custom format is ###.000 then the number 16.3 will be displayed as: 016.3 16.30 16.300 16.3
12 If the custom format is ##.### then the number 23349 will be displayed as: 167.00 23.349 16.300 16.3
13 If the custom format is 00000 then the number 420 will be displayed as: 420 0420 00420 420.00
14 The default number format assigned to a cell is: Currency Number Text General
15 Each number of format consist of _______ part: 2 3 4 5
16 ___ menu contains the 'Cell' command: File View Format Edit
17 The 0.0000000001 us displayed in default column width as: IE - 10 E-10 1E-9 01E-9
18 _____ represents a label: Mubeen Ahmad 736 = A1+B2 None
19 ____ cell addresses is correct: Z2 AZ3 2Z Both a and b
20 A set of worksheet which is not active is called: Active cell Idle cell Passive cell Present cell
21 The actual working area in Microsoft excel is: Workbook Worksheet Spreadsheet Note sheet
22 _______Is not a feature of spreadsheet program: Rows and columns Formula Print WordArt
23 In a worksheet a bold rectangle border indicates (n): Present cell Active sell Passive cell Idle cell
24 The currently selected cell where data can be entered or edited is called: Idle cell Active cell Passive cell Present cell
25 A collection of related worksheets is called: Spreadsheet Cells File Workbook
26 A cell at third column and 15 rows has a cell address: A15 B15 C15 D15
27 The actual working area in Microsoft excel is: A15 B15 C15 D15
28 The intersection of row and column form a: Cell Address Reference Field
29 ______ is a spreadsheet: MS word MS excel Ms power point Both a and b
30 Which of the following is a spreadsheet? MS word MS excel Ms power point Both a and b
Download This Set

Is this page helpful?