IT DAY QUIZ

What is the default file extension of a Microsoft Word document in recent versions?

• a) .txt
  

• b) .doc
  

• c) .docx
  

• d) .pdf
  

Which of the following is used to create a link to another document or webpage in Microsoft Word?

• a) Bookmark
  

• b) Hyperlink
  

• c) Table of Contents
  

• d) Footer
  

What is the maximum zoom percentage available in Microsoft Word?

• a) 200%
  

• b) 400%
  

• c) 500%
  

• d) 1000%
  

Which feature in Microsoft Word is used to combine data from a list with a document to create personalized letters or labels?

• a) Merge Cells
  

• b) Mail Merge
  

• c) SmartArt
  

• d) Format Painter
  

What is the function of the “Header and Footer” option in Microsoft Word?

• a) To insert text or graphics that appear at the top and bottom of every page
  

• b) To adjust the page layout
  

• c) To create a table of contents
  

• d) To highlight important text in a document
  

Which of the following is NOT a valid Excel error code?

• a) #DIV/0!
  

• b) #VALUE!
  

• c) #NUM!
  

• d) #MISMATCH!
  

How do you apply a filter to a data set in Excel?

• a) Go to the Insert tab and click Filter
  

• b) Go to the Data tab and click Filter
  

• c) Use the shortcut Ctrl + F
  

• d) Right-click the data and select Filter
  

What does the formula =IF(A1>10, "Yes", "No") do in Excel?

• a) Checks if A1 equals 10 and returns "Yes" if true, "No" if false
  

• b) Checks if A1 is greater than 10 and returns "Yes" if true, "No" if false
  

• c) Adds 10 to A1 if true and subtracts if false
  

• d) Compares A1 with 10 and returns the difference
  

What is the purpose of the CONCAT function in Excel?

• a) To add numbers in a range
  

• b) To combine text from multiple cells into one
  

• c) To calculate the difference between two values
  

• d) To find duplicate entries in a range
  

Which of the following is a valid formula for calculating the sum of cells A1 to A5 in Excel?

• a) =SUM(A1:A5)

• b) =SUM(A1;A5)

• c) =TOTAL(A1:A5)
  

• d) =ADD(A1:A5)