Bengkel Microsoft Excel 2025

Formula for returns the largest value

• =MAX(range)
• =SUM(range)
• =AVERAGE(range)
• =MIN(range)

Formula in excel to capitalize the first word in a string

• =UPPER(A1)
• =UPPER(LEFT(A1,1))&MID(A1,2,LEN(A1)-1)
• =PROPER(A1)
• =LOWER(LEFT(A1,1))&MID(A1,2,LEN(A1)-1)

What is the formula to display current date in excel?

• =NOW()
• =DATE()
• =CURRENT_DATE()
• =TODAY()

Menu to add drop down list in excel

• Use the 'Data Validation' feature to create a list or type items directly into cells.
• Click on 'Format' to change cell colors.
• Select 'File' and then 'New' to create a list.
• Use the 'Insert' menu to add a chart.

Below is the basic formula in excel , EXCEPT

• SUM()

• VLOOKUP

• MIN()

• MAX()

Location ribbon for create border in excel

• Use the 'Fill Color' button in the 'Home' tab.
• Select 'Page Layout' for border options.
• Access 'Data' tab to create borders.
• Use the 'Borders' button in the 'Home' tab on the Ribbon.

What is the formula to check for TWO Condition in excel?

• =OR(condition1, condition2)
• =AND(condition1, condition2)
• =IF(condition1, condition2)
• =NOT(condition1, condition2)

Shorcut keys for copy in excel

• Ctrl + X
• Ctrl + V
• Alt + C
• Ctrl + C

what paste option that we use to display WITHOUT formula

• Paste Link
• Paste Formatting
• Paste Values
• Paste All

Shortcut for absolute the cell in excel

• Ctrl + L (to lock the cell)
• F4

• Alt + F4

• F12