WorksheetsBengkel Microsoft Excel 2025
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Formula for returns the largest value
a)
=MAX(range)
b)
=SUM(range)
c)
=AVERAGE(range)
d)
=MIN(range)
2.
Formula in excel to capitalize the first word in a string
a)
=UPPER(A1)
b)
=UPPER(LEFT(A1,1))&MID(A1,2,LEN(A1)-1)
c)
=PROPER(A1)
d)
=LOWER(LEFT(A1,1))&MID(A1,2,LEN(A1)-1)
3.
What is the formula to display current date in excel?
a)
=NOW()
b)
=DATE()
c)
=CURRENT_DATE()
d)
=TODAY()
4.
Menu to add drop down list in excel
a)
Use the 'Data Validation' feature to create a list or type items directly into cells.
b)
Click on 'Format' to change cell colors.
c)
Select 'File' and then 'New' to create a list.
d)
Use the 'Insert' menu to add a chart.
5.
Below is the basic formula in excel , EXCEPT
a)
SUM()
b)
VLOOKUP
c)
MIN()
d)
MAX()
6.
Location ribbon for create border in excel
a)
Use the 'Fill Color' button in the 'Home' tab.
b)
Select 'Page Layout' for border options.
c)
Access 'Data' tab to create borders.
d)
Use the 'Borders' button in the 'Home' tab on the Ribbon.
7.
What is the formula to check for TWO Condition in excel?
a)
=OR(condition1, condition2)
b)
=AND(condition1, condition2)
c)
=IF(condition1, condition2)
d)
=NOT(condition1, condition2)
8.
Shorcut keys for copy in excel
a)
Ctrl + X
b)
Ctrl + V
c)
Alt + C
d)
Ctrl + C
9.
what paste option that we use to display WITHOUT formula
a)
Paste Link
b)
Paste Formatting
c)
Paste Values
d)
Paste All
10.
Shortcut for absolute the cell in excel
a)
Ctrl + L (to lock the cell)
b)
F4
c)
Alt + F4
d)
F12
100 %
