ECAT Computer Science Chapter 8 Word Processing Online Test With Answers

image
image
image

ECAT Computer Science Chapter 8 Word Processing Online Test

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
Download This Set