More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
Online Microsoft Excel Quiz MCQs With Answers
Question # 1
In MS Excel, the shortcut key F4 is used to ---------------?
Choose an answer
Create a Chart
Paste Named range in formula
Repeat the last action
Help
Previous
Skip
Next
Question # 2
In MS Excel, the shortcut key "Ctrl + Shift +_" is used to --------------?
Choose an answer
Delete the selected cells
Remove the outline border
Enter a link break within a cell
Delete the selected cells
Previous
Skip
Next
Question # 3
The shortcut key to Edit cells is ___________?
Choose an answer
Ctrl + E
F5
Ctrl + Shift + E
F2
Previous
Skip
Next
Question # 4
In MS Excel, the shortcut key "Ctrl + ;" is used to ________?
Choose an answer
Copy the value form the cell above
Insert the current date
Insert the current time
Define a range name
Previous
Skip
Next
Question # 5
The Shortcut key to Insert blank cells is _______?
Choose an answer
Ctrl + +
Ctrl + Shift + C
Shift + +
Ctrl + Shift + +
Previous
Skip
Next
Question # 6
In MS Excel, the shortcut key "Ctrl + Shift" is used to -----------?
Choose an answer
Define a range name
Insert the current time
Open the Visual Basic editor
Format Cells dialog
Previous
Skip
Next
Question # 7
The shortcut key to select the entire column is -------------?
Choose an answer
Shift + Spacebar
Ctrl + Spacebar
Alt + Spacebar
Alt + Ctrl+ Spacebar
Previous
Skip
Next
Question # 8
The shortcut key to insert a new worksheet is ------------?
Choose an answer
Ctrl + Shift + F11
Ctrl + W
Ctrl + F5
Ctrl + F11
Previous
Skip
Next
Question # 9
The shortcut key to select the entire row is ----------?
Choose an answer
Ctrl + Spacebar
Alt+ Spacebar
Shift + Spacebar
Alt + Shift + Spacebar
Previous
Skip
Next
Question # 10
The shortcut key to delete the selected cells is ________?
Choose an answer
Ctrl + Shift +_
Ctrl + _
Shift + _
Alt + Ctrl + -
Previous
Skip
Next
Question # 11
In the MS Excel, the shortcut key Ctrl + 9 is used to ________?
Choose an answer
Display the format cells dialog box
Hide the selected rows
Remove the outline border
Hide the selected columns
Previous
Skip
Next
Question # 12
The shortcut key to move to next sheet is __________?
Choose an answer
Alt + PgDn
PgDn
Ctrl + Shift + N
Ctrl +PgDn
Previous
Skip
Next
Question # 13
In MS Excel, the shortcut key Ctrl + F2 is used to _________?
Choose an answer
Display the style dialog box
Create a new, blank workbook
Display the insert function dialog box
Open print preview
Previous
Skip
Next
Question # 14
In MS Excel, the shortcut key F11 is used to ...................?
Choose an answer
Create a chart
Open the Visual Basic editor
Define a range name
Create a nae, blank workbook
Previous
Skip
Next
Question # 15
In MS Excel, the shortcut key Alt + 0165 is used to _______?
Choose an answer
Enter the cent character
Enter the euro symbol
Enter the yen symbol
Enter the pound sterling character
Previous
Skip
Next
Back