Home
MCQs / Quiz
MCQs all subjects
Quiz all subjects
Allama Iqbal Open University
Old Papers AIOU
Solved Papers AIOU 
Assignments AIOU
Internship Reports
All Other Material
Contact us
About us
Feedback
FB
MCQs on Microsoft Excel
MCQs on Microsoft Excel
MCQ and Quiz online related to Microsoft Excel are available here.
MCQ and Quiz online related to Microsoft Excel are available here.
Q No.1 of 5
To select an entire column in MS-EXCEL, press?
|
Option 1
|
CTRL + S
|
|
Option 2
|
CTRL + C
|
|
Option 3
|
CTRL + Arrow key
|
|
Option 4
|
None of the above
|
Q No.2 of 5
In EXCEL, you can sum a large range of data by simply selecting a tool button called
|
Option 1
|
Auto correct
|
|
Option 2
|
Auto sum
|
|
Option 3
|
AutoFill
|
|
Option 4
|
Auto format
|
Q No.3 of 5
Which function is not available in the Consolidate dialog box?
|
Option 1
|
Average
|
|
Option 2
|
Max
|
|
Option 3
|
Pmt
|
|
Option 4
|
Sum
|
Q No.4 of 5
Which is not the function of “Edit, Clear” command
|
Option 1
|
Delete contents
|
|
Option 2
|
Delete cells
|
|
Option 3
|
Delete formats
|
|
Option 4
|
Delete notes
|
Q No.5 of 5
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
|
Option 1
|
DIV ( )
|
|
Option 2
|
ROUND ( )
|
|
Option 3
|
FACT ( )
|
|
Option 4
|
MOD ( )
|
