MS Excel MCQs with Answers

When formatting a cell in Currency, which of the following can you specify?

• A.Decimal Places only
• B.Currency Symbol only
• C.Both Decimal Places and Currency Symbol
• D.Font Style only

What is the file you create and edit in Microsoft Excel called?

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

In Microsoft Excel, where can a trendline be added to visualize data trends?

• A.Worksheet
• B.Chart
• C.PivotTable
• D.Formula Bar

Which type of chart is most effective for illustrating trends over a period of time in data visualization?

• A.Scatter chart
• B.Pie chart
• C.Bar chart
• D.Line chart

In MS Excel, what are the comments added to a cell called?

• A.Cell tips
• B.Cell notes
• C.Data labels
• D.Smart tags

In Microsoft Excel, what is the function of the 'Filter' feature?

• A.To merge multiple worksheets into one
• B.To permanently delete rows that do not meet a condition
• C.To sort data in ascending order only
• D.To temporarily hide certain data based on specific criteria

In MS Excel, which function does not return a logical value of 'True' or 'False'?

• A.AND
• B.OR
• C.IF
• D.NOT

What is the process called when rows are converted into columns in a spreadsheet application?

• A.Sorting
• B.Pivoting
• C.Transposing
• D.Filtering

In MS Excel, what is used to keep a cell reference constant while copying a formula?

• A.Absolute reference
• B.Relative reference
• C.Mixed reference
• D.Circular reference

Past Paper MCQ

In Microsoft Excel, how are function arguments always enclosed?

• A.Square brackets [ ]
• B.Curly braces { }
• C.Parentheses ( )
• D.Angle brackets < >