Soalan Microsoft Excel

What is the main function of Microsoft Excel?

• Image editor

• Spreadsheet and data analysis

• Word processor

• Video editor

What symbol is used to start a formula in Excel?

• #

• @

• =

• &

Which of the following is a calculation function in Excel?

• SUM

• AVERAGE

• COUNT

• All of the above

What is the use of the IF function in Excel?

• Make decisions based on certain conditions

• Sum values in a range

• Convert text to numbers

• Sort data in a table

What is the use of Pivot Table in Excel?

• To create animations

• To organize table of contents

• To analyze and summarize data

• To convert files to PDF format

What is the VLOOKUP function used for?

• To find values in a table vertically

• To calculate the total of a data range

• To convert text to numbers

• To compare two worksheets

What is the use of Conditional Formatting in Excel?

• Convert text format to numbers

• Highlight cells based on certain conditions

• Create 3D graphics

• Merge cells with specific colors

How to lock cells so they cannot be edited in Excel?

• Use the IF function

• Use Protect Sheet and lock certain cells

• Use the LOCKED function

• Change the cell to text format

What function is used to count the number of characters in a cell?

• LEN

• COUNT

• MID

• CHAR

What is the advantage of using Macros in Excel?

• Allows animations in tables

• Automate repetitive tasks

• Sort files by date

• Automatically change text color