MS Excel MCQs with Answers

What type of chart in MS Excel is best suited for comparing the performance of two employees over a specific year?

• A.Scatter Chart
• B.Pie Chart
• C.Line Chart
• D.Column Chart

What is the main window called in a computer spreadsheet application like MS Excel?

• A.Worksheet
• B.Workbook
• C.Document
• D.Presentation

How is absolute cell reference indicated in MS Excel formulas?

• A.Using dollar signs ($)
• B.Using hash signs (#)
• C.Using percentage signs (%)
• D.Using ampersand signs (&)

What is the main feature of a spreadsheet application?

• A.Creating slide presentations
• B.Managing relational databases
• C.Arranging data in grids for calculations
• D.Editing and formatting text documents

Which command is used to add data in Microsoft Excel?

• A.PLUS
• B.ADD
• C.TOTAL
• D.SUM

Which function in MS Excel is used to count the number of entries in a column?

• A.MAX
• B.SUM
• C.AVERAGE
• D.COUNT

How can you edit a chart in MS Excel?

• A.Right-click the chart and select "Edit Chart"
• B.Double click the chart object
• C.Click the chart and press F2
• D.Go to File menu and select "Edit Chart"

What type of function is VLOOKUP in MS Excel?

• A.Logical function
• B.Text function
• C.Lookup and reference function
• D.Statistical function

Which tab in MS Excel is used to organize and sort data effectively?

• A.Home
• B.Data
• C.Insert
• D.Formulas

In the Fill Series dialog box in MS Excel, which series type is not available?

• A.Linear
• B.Growth
• C.Date
• D.Time