Students MCQ

What is the default file extension for an Excel workbook?

• .docx

• .xlsx

• .pptx

• .pdf

Which function is used to find the average of a range of cells?

• a) SUM()

• b) AVERAGE()

• c) COUNT()

• d) MAX()

What does the CONCATENATE() function do in Excel?

• a) Adds numbers

• b) Joins text from different cells

• c) Calculates percentages

• d) Sorts data

Which tab would you use to insert a chart in Excel?

• a) Home

• b) Insert

• c) Data

• d) View

How do you apply bold formatting to a cell?

• a) Right-click the cell and select "Bold"

• b) Go to the "Home" tab and click the "Bold" button

• c) Press Ctrl+B

• d) All of the above

Which of the following is used to insert a page break in a Word document?

• a) Ctrl+Enter

• b) Ctrl+P

• c) Ctrl+N

• d) Ctrl+S

Where can you find the option to change the document's orientation?

• a) "File" tab

• b) "Home" tab

• c) "Page Layout" or "Layout" tab

• d) "Review" tab

How can you insert a table into a Word document?

• a) Go to the "Home" tab and select "Table"

• b) Go to the "Insert" tab and click "Table"

• c) Go to the "Design" tab and choose "Table"

• d) Go to the "Review" tab and click "Table"

What is the purpose of the "Find and Replace" feature?

• a) To find specific text and replace it with different text

• b) To locate a document by its name

• c) To find and insert page numbers

• d) To locate formatting changes

How do you set up columns in a Word document?

• a) Go to the "Home" tab and select "Columns"

• b) Go to the "Insert" tab and click "Columns"

• c) Go to the "Page Layout" or "Layout" tab and click "Columns"

• d) Go to the "Review" tab and choose "Columns"