(C)
4
(B)
8
12
A) FILL IN THE BLANKS WITH PROPER WORDS:
(100)
1 In MS-Excel
displays the address of active cell.
(A) Cell
(B) Name Box (C)
2. Each Excel file is a
Formula Bar
that can hold many worksheets.
(A) Presentation (B) V Document
3
First Cell in Range is separated from Last Cell with a
Workbook
(A) V (Equal)=
symbol.
(B) (Colon) (C)
A Built-in-Tool that performs Calculation automatically is a/an
$ (Dollar)
(A) Function (B) Values
(C)
Formulas
5
Function add the cells only if they meet the specified criteria.
(A) Sum If
(B) Count If (C) Sum
6
Type of file created by Electronic Worksheets like Excel is
(A) Database
Workbook (C) Document
7.
Function calculates the future value of an Investment based o periodic payments.
(A) PV
(B) FV
(C) PMT
8
Cell Address of Selected Cell is displayed on
(A) Formula Bar (B) Title Bar (C) Name Box
9
is the process of extracting records meeting a Certain Criteria.
(A) Filtering (B) Sorting
(C) Custom List
10 Text stored in a cell is called a
(A) Value
(B) Label
(C) Intersection
11 All Formulas must start with a
sign.
(A) $
(B) =
(C)
A Built-in-Tool that performs Calculation automatically is a/an
(A) Function (B) Values
(C) Formulas
13 In MS-Excel
key is used for Editing Data written in the cell.
(A) F2
(B) F3
(C) F4
14 Type of file created By Electronic Spreadsheet like Excel
(A) Database (B) Worksheet (C) Document
15 Worksheet is Grid of Column designated by
& Rows by
(A)Letters & Numbers (B)Arabic & Roman Numbers (C)Numbers & Letters
16 Spreadsheets should be best used for
(A) Calculation (B) Writing Letters
Presentation
17 In Excel Sum is a
type of Function.
(A) Financial (B) Statistical
Mathematical
18 Spreadsheets should be best used for
(A) Calculation (B) Writing Letters (C) Presentation
in format.
19 The cells in the sheet can be shown
(A) Flat
(B) Sunken
Raised
(C)
20 With the help of toolbar, the table can be sorted quickly by using,
Sort Ascending (B) Sort Descending (C)
(A)
both a & b
21
Spread sheet displays data in the form of
(B) Row & Cell (C) both a & b
(A) Rows & columns
22
By default the file name in Excel is
Book1
(B)
(C) Worksheet1
Workbook1
(A)
are used to perform complex scientific and statistical operations.
23
Referencing (C) Functions
(A) V Formula's
24
By default work book contains
(B)
3 worksheets
18 worksheets (C)
16 Worksheets
(A)
25
Text direction option is available under
Insert Tab
(B)
(C) Mailing Tab
(A) Home Tab
function key is used.
26 To Modify data in a cell
F9
(C) F8
(B)
(A) F2
(C)
(C)
(B)
Answers
Answered by
5
Answer:
what is this!
Explanation:
thanks for the points..
Similar questions