here are some multiple-choice questions (MCQs) on Microsoft Excel along with their answers:1. What function would you use to find the highest value in a range of cells?a) MAX()b) MIN()c) AVG()d) SUM()Answer: a) MAX()2. Which keyboard shortcut is used to paste values only (without formatting) in Excel?a) Ctrl + Cb) Ctrl + Vc) Ctrl + Alt + Vd) Ctrl + Shift + VAnswer: c) Ctrl + Alt + V3. What is the default file extension of an Excel workbook?a) .xlsb) .xlsxc) .xlsmd) .xlsbAnswer: b) .xlsx4. Which function is used to join the contents of two or more cells in Excel?a) CONCATENATE()b) JOIN()c) MERGE()d) COMBINE()Answer: a) CONCATENATE()5. Which chart type is suitable for comparing values across categories in Excel?a) Pie Chartb) Line Chartc) Bar Chartd) Scatter PlotAnswer: c) Bar Chart6. What does the function =AVERAGE(A1:A10) do in Excel?a) Returns the sum of values in cells A1 to A10.b) Returns the highest value in cells A1 to A10.c) Returns the average value of cells A1 to A10.d) Returns the count of cells with numerical values in cells A1 to A10.Answer: c) Returns the average value of cells A1 to A10.7. Which Excel feature allows you to automatically fill cells with data based on a pattern?a) Autofillb) Autoformatc) AutoSumd) AutoCorrectAnswer: a) Autofill8. Which Excel function is used to count the number of cells that contain numbers within a range?a) COUNT()b) SUM()c) AVERAGE()d) MAX()Answer: a) COUNT()