+91 98988 32395
info@webtech365.com
Home
Products
Blog
MCQ Exams
Pricing
Other Links
Property
Jobs
Free Download
Tech News
Gayatri Computer Classes - Dwarka
BMZ Jewellers - Dwarka
Hotel Bansi Palace - Dwarka
Gitech Education Pvt. Ltd.
Shree Ram Parotha House - Dwarka
Vivekanand Coaching - Budaun
Karani enterprises
Narayan Travels - Dwarka
Anand Novelty Store - Dwarka
Umiya traders - Goa
Randal krupa sales agencies - Dwarka
SPTECNO - Anand (Gujarat)
Crystal Beauty Studio
Web World
Riddhi mobile - Dwarka
GIFTCORNER - Dwarka
Gayatri Computer Classes - Dwarka
Contact
Login
MS Excel
Time Remaining:
10:00
Question
1
of 30
Your Information
Your Name
Your Email
Question 1: Which key is used to recalculate formulas?
F5
F9
F7
F8
Question 2: The cell reference A$1 is?
Relative
Absolute
Mixed
Fixed
Question 3: The function to find the current date is?
TODAY()
DATE()
NOW()
TIME()
Question 4: The default alignment for numbers is?
Left
Right
Center
Justify
Question 5: Which function replaces text?
CHANGE()
REPLACE()
SUBSTITUTE()
MODIFY()
Question 6: Which function calculates net present value?
NPV()
IRR()
PV()
PMT()
Question 7: The default alignment for text is?
Left
Right
Center
Justify
Question 8: Which key combination repeats the last action?
F4
Ctrl + Y
Ctrl + Z
Alt + R
Question 9: Which operator is used for concatenation?
&
+
#
Question 10: The active cell is identified by?
Blue border
Bold border
Green border
Black border
Question 11: Which feature is used to lock specific cells?
Data Validation
Freeze Panes
Protect Sheet
Lock Sheet
Question 12: The function to find current time is?
TODAY()
TIME()
NOW()
HOUR()
Question 13: Which function converts numbers to text?
TEXT()
VALUE()
STRING()
CONVERT()
Question 14: Which function returns true if all conditions are true?
IF()
AND()
OR()
NOT()
Question 15: Which key combination is used to paste?
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + P
Question 16: Which key combination opens the Format Cells dialog?
Ctrl + 1
Ctrl + 2
Ctrl + F
Alt + Enter
Question 17: Which feature prevents invalid data entry?
Data Validation
Data Filter
Protection
Freeze Pane
Question 18: Which option is used to freeze rows/columns?
View ? Freeze Panes
Home ? Freeze
Data ? Freeze
Insert ? Freeze
Question 19: Which function searches horizontally?
VLOOKUP()
HLOOKUP()
MATCH()
INDEX()
Question 20: Which function converts text to numbers?
TEXT()
VALUE()
NUM()
CONVERT()
Question 21: Which function converts text to uppercase?
UPPER()
LOWER()
PROPER()
CAPS()
Question 22: Which feature changes cell contents automatically?
AutoFormat
AutoFill
AutoCorrect
AutoAdjust
Question 23: Which function returns true if any condition is true?
IF()
AND()
OR()
NOT()
Question 24: Which function converts text to lowercase?
UPPER()
LOWER()
PROPER()
SMALL()
Question 25: Which tab contains sorting and filtering options?
Data
Insert
Review
Home
Question 26: Which key combination inserts a new worksheet?
Shift + F11
Ctrl + N
Ctrl + W
Alt + F1
Question 27: Which function returns the weekday number?
WEEKDAY()
DAY()
DATE()
NOW()
Question 28: Which function returns the number of characters in a string?
CHAR()
LEN()
TEXT()
COUNT()
Question 29: Which function returns a value from a specified position?
INDEX()
MATCH()
SEARCH()
FIND()
Question 30: Which chart is best for showing proportions?
Line Chart
Pie Chart
Bar Chart
Column Chart
Previous
Next
Submit Exam