- Home
- Quiz
- _LIS Episode
- _MCQ Series
- _Practice Quiz
- _Online Quiz Test
- _Librarian
- LIS Questions
- __Objective
- __Subjective
- __LIS Quiz Set
- __Model Set
- __Practice Set
- __Online Test Set
- LIS Exams
- _NTA UGC NET
- __UGC NET
- __UGC NET paper-1
- __Online Quiz
- _KVS
- __KVS
- __KVS Paper-1
- __Online Quiz
- _NVS
- _RSMSSB
- _DSSSB
- _JKSSB
- _TSPSC
- Trend
- IT/CS
- Grammar
- GK
- _Comprehension
- _Methdology
- _Research
- _Teaching
- _Reasoing
- _Current Affairs
- Download
- _LIS MCQ Pdf
- _MLIS E-Book
- _BLIS E-Book
- _LIS E-Book
- _CS E-Book
- हिन्दी
- _अभ्यास प्रश्न
- _LIS वस्तुनिष्ठ प्रश्न
- _LIS वर्णनात्मक प्रश्न
- About
- _Index
- _Founder
- _Contact
- _Connect with LIS Cafe
LIS Cafe
Model Questions with Answer for Library Trainee Exam-Series-27
1
|
The programming language in which Excel keeps the macro code
record.
|
(A) Java
|
|
(B) Visual Basic
|
|
(C) Basic
|
|
(D) Video Basic
|
|
2
|
What is the shortcut key to replace in MS-Excel?
|
(A) Ctrl+R
|
|
(B) Ctrl+E
|
|
(C) Ctrl+H
|
|
(D) Ctrl+L
|
|
3
|
Which of the following menu is used for Cut, Copy, Paste, Delete
text in Excel?
|
(A) Edit menu
|
|
(B) File menu
|
|
(C) Tool menu
|
|
(D) Format menu
|
|
4
|
The default extension of the Excel file is______
|
(A) .XLS
|
|
(B) .XLW
|
|
(C) .WK1
|
|
(D) .123
|
|
5
|
A worksheet has a header by default-
|
(A) User Name
|
|
(B) Date and time
|
|
(C) Sheet tab name
|
|
(D) None
|
|
6
|
The maximum row in a work sheet is-
|
(A) 256
|
|
(B) 1024
|
|
(C) 65536
|
|
(D) 32000
|
|
7
|
Cell reference will be from range G2 to M12.
|
(A) G2=M12
|
|
(B) G2;M12
|
|
(C) G2:M12
|
|
(D) G2,M12
|
|
8
|
Which menu is used to show and hide the Status Bar in Excel
|
(A) Edit menu
|
|
(B) File menu
|
|
(C) View menu
|
|
(D) Format menu
|
|
9
|
The keyboard shortcut is used to create charts in the selected
range.
|
(A) F2
|
|
(B) F4
|
|
(C) F8
|
|
(D) F11
|
|
10
|
________ key is used to drag data of range from selected
worksheet to another worksheet.
|
(A) Tab
|
|
(B) Alt
|
|
(C) Shift
|
|
(D) Ctrl
|
|
11
|
Which column will you select to insert a new column between
Column D and E.
|
(A) select column E
|
|
(B) select column D
|
|
(C) select column E , F , G
|
|
(D) select column D, E , F
|
|
12
|
Which of the following is not the Zoom percentage in excel?
|
(A) 10
|
|
(B) 100
|
|
(C) 300
|
|
(D) 500
|
|
13
|
What is the feature of inserting by dragging number in cells in
MS Excel ?
|
(A) Auto Correct
|
|
(B) Auto Text
|
|
(C) Auto Fill
|
|
(D) Auto Cell
|
|
14
|
How many columns are there in Excel?
|
(A) 256
|
|
(B) 65536
|
|
(C) 216
|
|
(D) 220
|
|
15
|
In which menu have Freeze Pane option?
|
(A) Tools
|
|
(B) Data
|
|
(C) Window
|
|
(D) View
|
|
Visit Regular for New Updates.
Creator, Author, Editor and Compiler -Asheesh Kamal
Thanks for Visiting
Asheesh Kamal
  | ||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||
Mr. Asheesh Kamal
0 Comments