WorksheetsMs Excel 30 Mcq Chapter-19:23
Total questions: 30
Worksheet time: 15mins
HOW MANY MAXIMUM SHEET INSERT IN EXCEL?
258
255
259
365
MS Excel stands for ___________
MICROMAX EXCEL
MANAGEMENT EXCEL
MICROSOFT EXCESS
MICROSOFT EXCEL
MS Excel is a ________.
(Page no-201)
DATABASE MANAGEMENT SOFTWARE
PRESENTATION SOFTWARE
WORKBOOK SOFTWARE
SPREADSHEET SOFTWARE
Microsoft Excel 2010 has column limit of __________
(Page no-204)
13684
16384
.18634
84163
MS Excel 2010 has row limit of __________
(Page no-204)
1048,576
4,81,0576
16384
1,57,648
MS Excel 2010 has maximum column width limit is of __________characters
(Page no-222)
256
512
255
128
Microsoft Excel was first time launched in ______ by the Microsoft Corporation
1985
1991
1995
1998
Formulas in Excel start with ________
/
f
-
=
In Microsoft Excel Spreadsheets, rows are labelled as _______
(Page no-216)
1,2,3,…..
A,B,C,….
A1,B1,C1….
I,II,III,…..
In Microsoft Excel spreadsheets, COLUMNS are labelled as _______ (Page no- 216)
1,2,3,…..
A,B,C,….
A1,B1,C1….
I,II,III,….
In MS Excel, keyboard shortcut keys to create a new workbook is _____(Page no- 328)
TAB+N
FN+N
ALT+N
CTRL+N
In MS Excel, the keyboard shortcut key to Open the Save As dialog box is ________(Page no-331)
CTRL+S
F2
CTRL+N
F12
In MS Excel, Workbook can be closed using keyboard shortcut ______ (Page no-329)
CTRL+C
CTRL+W
ESC
CTRL+E
_______ can be used as a keyboard shortcut key to check spelling in MS Excel.
(Page no-331)
F1
F7
F2
F12
FORMULA OF SUM….?
=SUM(A1:G1)
=SUM(A1.G1)
=SUM(A1=G1)
=SUM(A1::G1)
WHICH FUNCTION CATEGORY INCLUDE INT AND ROUND?
LOGICAL
MATH AND TRIG
STATISTICAL
CURRENCY
FIRST CELL IS…….MS EXCEL.
(Page no-204)
C1
XI
A1
A3
EXTANTION OF MS-EXCEL…. (Page no-202)
.DOCX
.PPTX
.XLSX
.DOTX
WHAT IS THE RESULT OF THIS FORMULA=1+5*3-1?
4
15
8
10
WHAT IS THE RESULT OF THIS FORMULA=1+2*3-1?
4
6
8
10
WHAT SYMBOL IS USED TO ENTER NUMBER AS TEXT?
'
"
+
-
WHICH OF THE FOLLOWING IS CONCATENATING OPERATOR?
APOSTROPHE(')
EXCLAMATION (!)
AMPERSAND(&)
HASH(#)
HOW MANY SHEETS ARE THERE IN EXCEL WORKBOOK BY DEFAULT?
2
3
4
5
WHICH FUNCTION CONVERTS A VALUE TO A SPECIFIED DIGIT TO THE LEFT OF RIGHT OF THE DECIMAL POINT?
IF
INT
ROUND
SUM
IF A CELL CONTAINS =ROUND(3.4567,2)
3.45
3.46
3.457
3.4567
WHICH OF THE FOLLOWING ARGUMENTS IN A FINACIAL FUNCTION REPRESENTS THE TOTAL NUMBER OF PAYMENT?
FV
PV
NPER
RATE
LAST CELL IS…….MS EXCEL.
(Page no-204)
XFD2
XFD1
XFB1
XFC1
How do you display current date only in MS Excel?
(Page no-268)
Date ()
Today ()
Now ()
Time ()
How do you display current date and time in MS Excel? (Page no-268)
Date ()
Today ()
Now ()
Time ()
In MS Excel, what is the function of the shortcut key Ctrl + T?
PAGE NO-329
Opens the "Insert Function" dialog box
Creates a Table from the selected data range
Opens the "Format Cells" dialog box
Inserts a new worksheet
