{"id":17884,"date":"2025-11-10T11:21:29","date_gmt":"2025-11-10T11:21:29","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=17884"},"modified":"2025-12-20T09:11:07","modified_gmt":"2025-12-20T09:11:07","slug":"microsoft-excel100-mcqs-with-answer-and-explanation","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2025\/11\/10\/microsoft-excel100-mcqs-with-answer-and-explanation\/","title":{"rendered":"Microsoft Excel100 MCQs With Answer and Explanation"},"content":{"rendered":"\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">1. What is the default file extension of an Excel workbook in Excel 2016 and later?<\/mark><\/strong><br>A) .xls<br>B) .xlsx<br>C) .csv<br>D) .docx<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B  <\/b><BR>\n<b>Explanation:<\/b>  Excel 2007 onward uses the XML-based .xlsx format as the default workbook extension.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">2. Which of the following is the default font in Excel 2016?<\/mark><\/strong><br>A) Times New Roman<br>B) Arial<br>C) Calibri<br>D) Verdana<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  Calibri, size 11, is the default font in Excel 2016.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">3. Which key combination is used to create a new workbook in Excel?<\/mark><\/strong><br>A) Ctrl + N<br>B) Ctrl + O<br>C) Ctrl + S<br>D) Ctrl + P<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>   Ctrl + N opens a new blank workbook in Excel.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">4. What is the intersection of a row and a column in Excel called?<br><\/mark><\/strong>A) Range<br>B) Cell<br>C) Column<br>D) Worksheet<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B  <\/b><BR>\n<b>Explanation:<\/b>  Each cell is uniquely identified by its column letter and row number (e.g., A1).\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">5. Which function is used to calculate the sum of numbers in Excel?<br><\/mark><\/strong>A) SUM<br>B) ADD<br>C) TOTAL<br>D) COUNT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  SUM adds all numbers in the specified range of cells.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">6. Which key is used to edit the contents of a selected cell in Excel?<br><\/mark><\/strong>A) F2<br>B) F4<br>C) F7<br>D) F12<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  F2 allows you to edit the active cell directly.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">7. Which function is used to calculate the average of a range of numbers in Excel?<br><\/mark><\/strong>A) AVG<br>B) MEAN<br>C) AVERAGE<br>D) SUM<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  AVERAGE calculates the mean of the numbers in the specified range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">8. Which of the following is used to copy the format of a cell to another cell?<br><\/mark><\/strong>A) Format Painter<br>B) Copy<br>C) Paste<br>D) Fill Handle<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Format Painter copies formatting such as font, color, and borders from one cell to another.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\"><strong>9. Which of the following is the shortcut key to save a workbook in Excel?<br><\/strong><\/mark>A) Ctrl + S<br>B) Ctrl + C<br>C) Ctrl + P<br>D) Ctrl + V<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Ctrl + S saves the current workbook.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">10. Which of the following allows you to fill cells with a series of numbers, dates, or text in Excel?<br><\/mark><\/strong>A) Fill Handle<br>B) AutoSum<br>C) Paste<br>D) Format Painter<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  The Fill Handle (small square at the bottom-right corner) can be dragged to fill series automatically.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">11. Which tab in Excel contains options for inserting charts, tables, and pictures?<br><\/mark><\/strong>A) Home<br>B) Insert<br>C) Data<br>D) Review<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  The Insert tab provides tools for charts, tables, shapes, images, and other objects.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">12. Which function in Excel counts the number of numeric entries in a range?<br><\/mark><\/strong>A) COUNTA<br>B) COUNT<br>C) COUNTIF<br>D) COUNTBLANK<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>   COUNT counts only numeric entries, while COUNTA counts all non-empty cells.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">13. Which key combination is used to select the entire worksheet in Excel?<br><\/mark><\/strong>A) Ctrl + A<br>B) Ctrl + S<br>C) Ctrl + C<br>D) Ctrl + V<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  Ctrl + A selects all cells in the worksheet.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">14. Which function returns the largest value in a range in Excel?<br><\/mark><\/strong>A) MIN<br>B) MAX<br>C) LARGE<br>D) SUM<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  MAX returns the highest numeric value in the specified range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">15. Which function returns the smallest value in a range?<br><\/mark><\/strong>A) MAX<br>B) MIN<br>C) SMALL<br>D) AVERAGE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  MIN returns the smallest number in the specified range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">16. Which of the following is used to combine text from two or more cells into one in Excel?<br><\/mark><\/strong>A) CONCATENATE \/ CONCAT<br>B) MERGE<br>C) JOIN<br>D) COMBINE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  CONCATENATE (or CONCAT in newer versions) combines text from multiple cells.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">17. Which of the following is the shortcut to insert a new worksheet in Excel?<br><\/mark><\/strong>A) Shift + F11<br>B) Ctrl + N<br>C) Alt + F1<br>D) Ctrl + F4<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Shift + F11 inserts a new worksheet into the current workbook.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">18. Which of the following is used to remove duplicate entries in Excel?<br><\/mark><\/strong>A) Remove Duplicates<br>B) Data Validation<br>C) Conditional Formatting<br>D) Text to Columns<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Remove Duplicates (under the Data tab) removes repeated values from selected data.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">19. Which feature in Excel allows sorting data in ascending or descending order?<br><\/mark><\/strong>A) Sort &amp; Filter<br>B) Data Validation<br>C) Conditional Formatting<br>D) AutoFill<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Sort &#038; Filter in the Data tab is used to organize data alphabetically or numerically.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">20. Which function is used to look up a value in a vertical table in Excel?<br><\/mark><\/strong>A) HLOOKUP<br>B) VLOOKUP<br>C) LOOKUP<br>D) INDEX<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  VLOOKUP searches for a value in the first column of a vertical table and returns a corresponding value.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">21. Which function is used to return the current date in Excel?<br><\/mark><\/strong>A) TODAY()<br>B) NOW()<br>C) DATE()<br>D) CURRENT()<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer:  A <\/b><BR>\n<b>Explanation:<\/b>  TODAY() returns the current system date without time.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">22. Which function is used to return the current date and time?<br><\/mark><\/strong>A) TODAY()<br>B) NOW()<br>C) TIME()<br>D) DATE()<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B  <\/b><BR>\n<b>Explanation:<\/b>  NOW() returns both the current date and system time.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">23. Which of the following is used to protect an Excel workbook with a password?<br><\/mark><\/strong>A) File \u2192 Info \u2192 Protect Workbook<br>B) Review \u2192 Protect Sheet<br>C) Data \u2192 Protect<br>D) Home \u2192 Format<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Protect Workbook allows setting a password to restrict opening or editing.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">24. Which feature allows entering the same data into multiple cells simultaneously?<br><\/mark><\/strong>A) Ctrl + Enter<br>B) Shift + Enter<br>C) Alt + Enter<br>D) Enter<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Ctrl + Enter fills the selected range with the same data or formula.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">25. Which of the following is used to create a chart based on selected data?<br><\/mark><\/strong>A) Insert \u2192 Chart<br>B) Layout \u2192 Chart<br>C) Data \u2192 Chart<br>D) Review \u2192 Chart<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer:  A  <\/b><BR>\n<b>Explanation:<\/b>  The Insert tab provides multiple chart types like Column, Line, Pie, and Bar charts.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">26. Which function returns the number of non-empty cells in a range?<br><\/mark><\/strong>A) COUNT<br>B) COUNTA<br>C) COUNTBLANK<br>D) COUNTIF<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  COUNTA counts all non-empty cells, including text, numbers, and errors.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">27. Which function counts only blank cells in a range?<br><\/mark><\/strong>A) COUNT<br>B) COUNTA<br>C) COUNTBLANK<br>D) COUNTIF<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  COUNTBLANK counts only the empty cells in the specified range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">28. Which function is used to count cells that meet a specific condition?<br><\/mark><\/strong>A) COUNTIF<br>B) COUNTA<br>C) COUNTBLANK<br>D) COUNT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  COUNTIF(range, criteria) counts cells in a range that meet the given condition.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">29. Which of the following is used to create a drop-down list in Excel?<br><\/mark><\/strong>A) Data Validation<br>B) Conditional Formatting<br>C) Filter<br>D) Sort<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Data Validation allows creating lists, setting rules, and restricting input in cells.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">30. Which shortcut key is used to open the Format Cells dialog box in Excel?<br><\/mark><\/strong>A) Ctrl + F<br>B) Ctrl + 1<br>C) Ctrl + 2<br>D) Ctrl + 3<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  Ctrl + 1 opens the Format Cells dialog for font, alignment, border, number, and fill options.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">31. Which function is used to return a value from a specific row and column in Excel?<br><\/mark><\/strong>A) VLOOKUP<br>B) HLOOKUP<br>C) INDEX<br>D) MATCH<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  INDEX(array, row_num, [col_num]) returns the value at a specified row and column in a range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">32. Which function returns the relative position of a value in a range?<br><\/mark><\/strong>A) INDEX<br>B) MATCH<br>C) VLOOKUP<br>D) HLOOKUP<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  MATCH(value, range, 0) returns the position of a value in a range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">33. Which function combines INDEX and MATCH to perform flexible lookups?<br><\/mark><\/strong>A) VLOOKUP<br>B) HLOOKUP<br>C) INDEX + MATCH<br>D) LOOKUP<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  Using INDEX + MATCH allows dynamic lookups both vertically and horizontally.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">34. Which function in Excel returns the number of characters in a cell?<br><\/mark><\/strong>A) LEN<br>B) LEFT<br>C) RIGHT<br>D) MID<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  LEN(text) counts all characters, including spaces, in a cell.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">35. Which function extracts a specific number of characters from the beginning of a text string?<br><\/mark><\/strong>A) LEFT<br>B) RIGHT<br>C) MID<br>D) LEN<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  LEFT(text, num_chars) returns the first specified number of characters.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">36. Which function extracts characters from the end of a text string?<br><\/mark><\/strong>A) LEFT<br>B) RIGHT<br>C) MID<br>D) LEN<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  RIGHT(text, num_chars) returns characters from the end of a text string.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">37. Which function extracts characters from the middle of a text string?<br><\/mark><\/strong>A) LEFT<br>B) RIGHT<br>C) MID<br>D) LEN<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>   MID(text, start_num, num_chars) returns characters starting from a specified position.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">38. Which function converts text to uppercase in Excel?<br><\/mark><\/strong>A) LOWER<br>B) UPPER<br>C) PROPER<br>D) CAPITAL<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>   UPPER(text) converts all letters to uppercase.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">39. Which function converts text to lowercase?<br><\/mark><\/strong>A) LOWER<br>B) UPPER<br>C) PROPER<br>D) CAPITAL<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  LOWER(text) converts all letters to lowercase.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">40. Which function capitalizes the first letter of each word in a text string?<br><\/mark><\/strong>A) UPPER<br>B) LOWER<br>C) PROPER<br>D) CAPITAL<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  PROPER(text) converts the first letter of each word to uppercase.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">41. Which Excel function removes extra spaces from text?<br><\/mark><\/strong>A) TRIM<br>B) CLEAN<br>C) SUBSTITUTE<br>D) REPLACE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  TRIM removes leading, trailing, and multiple spaces between words.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">42. Which function removes non-printable characters from text?<br><\/mark><\/strong>A) TRIM<br>B) CLEAN<br>C) SUBSTITUTE<br>D) REPLACE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  CLEAN removes all non-printable characters from text.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">43. Which function is used to replace part of a text string with another text?<br><\/mark><\/strong>A) SUBSTITUTE<br>B) REPLACE<br>C) REPLACEB<br>D) MID<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  REPLACE(old_text, start_num, num_chars, new_text) replaces a part of a string with new text.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">44. Which function replaces all occurrences of a specific text in a string?<br><\/mark><\/strong>A) SUBSTITUTE<br>B) REPLACE<br>C) REPLACEB<br>D) MID<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  SUBSTITUTE(text, old_text, new_text) replaces all or specific occurrences of a substring.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">45. Which of the following is used to sort data alphabetically or numerically?<br><\/mark><\/strong>A) Sort &amp; Filter<br>B) Conditional Formatting<br>C) Data Validation<br>D) Fill Handle<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Sort &#038; Filter allows arranging data in ascending or descending order.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">46. Which function returns the current system time in Excel?<br><\/mark><\/strong>A) TIME()<br>B) NOW()<br>C) TODAY()<br>D) CURRENT()<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  NOW() returns both current date and time; TIME() is used to create a time value.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">47. Which Excel feature allows filtering data based on specific conditions?<br><\/mark><\/strong>A) AutoFilter<br>B) Conditional Formatting<br>C) Data Validation<br>D) Freeze Panes<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  AutoFilter enables filtering rows that meet criteria in selected columns.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">48. Which of the following is used to freeze rows or columns in Excel?<br><\/mark><\/strong>A) Freeze Panes<br>B) Split<br>C) Lock Cells<br>D) Protect Sheet<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Freeze Panes keeps specific rows\/columns visible while scrolling through the worksheet.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">49. Which of the following is used to remove duplicates in Excel?<br><\/mark><\/strong>A) Data \u2192 Remove Duplicates<br>B) Home \u2192 Clear<br>C) Insert \u2192 Remove<br>D) Review \u2192 Delete<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Removes repeated values from selected data ranges.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">50. Which function in Excel calculates the standard deviation of a set of values?<br><\/mark><\/strong>A) STDEV<br>B) VAR<br>C) STDEVP<br>D) STDDEV<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  STDEV estimates standard deviation based on a sample; STDEVP is for the entire population.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">51. Which Excel function returns the present value of an investment?<br><\/mark><\/strong>A) PV<br>B) FV<br>C) PMT<br>D) RATE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  PV(rate, nper, pmt, [fv], [type]) calculates the present value of an investment.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">52. Which function calculates the future value of an investment?<br><\/mark><\/strong>A) PV<br>B) FV<br>C) PMT<br>D) RATE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  FV(rate, nper, pmt, [pv], [type]) returns the future value of an investment.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">53. Which function calculates the payment for a loan based on constant interest rate and periods?<br><\/mark><\/strong>A) PV<br>B) FV<br>C) PMT<br>D) RATE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  PMT(rate, nper, pv, [fv], [type]) calculates periodic loan payments.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">54. Which function is used to calculate the interest rate per period of a loan?<br><\/mark><\/strong>A) PV<br>B) FV<br>C) PMT<br>D) RATE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: D <\/b><BR>\n<b>Explanation:<\/b>  RATE(nper, pmt, pv, [fv], [type], [guess]) returns the interest rate per period.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">55. Which function rounds a number to a specified number of digits?<br><\/mark><\/strong>A) ROUND<br>B) ROUNDUP<br>C) ROUNDDOWN<br>D) MROUND<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  ROUND(number, num_digits) rounds a number to the desired precision.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">56. Which function always rounds a number up?<br><\/mark><\/strong>A) ROUND<br>B) ROUNDUP<br>C) ROUNDDOWN<br>D) CEILING<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  ROUNDUP(number, num_digits) rounds numbers away from zero.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">57. Which function always rounds a number down?<br><\/mark><\/strong>A) ROUND<br>B) ROUNDUP<br>C) ROUNDDOWN<br>D) FLOOR<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  ROUNDDOWN(number, num_digits) rounds numbers toward zero.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">58. Which function rounds a number to the nearest multiple?<br><\/mark><\/strong>A) ROUND<br>B) MROUND<br>C) CEILING<br>D) FLOOR<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  MROUND(number, multiple) rounds a number to the nearest specified multiple.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">59. Which function returns the current week number of a date?<br><\/mark><\/strong>A) WEEKDAY<br>B) WEEKNUM<br>C) NOW<br>D) TODAY<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  WEEKNUM(serial_number, [return_type]) returns the week number in the year.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">60. Which function returns the day of the week as a number?<br><\/mark><\/strong>A) WEEKDAY<br>B) WEEKNUM<br>C) DAY<br>D) DAYOFWEEK<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  WEEKDAY(serial_number, [return_type]) returns a number (1\u20137) representing the day.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">61. Which function returns the current year from a date?<br><\/mark><\/strong>A) YEAR<br>B) MONTH<br>C) DAY<br>D) TODAY<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  YEAR(serial_number) extracts the year from a date.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">62. Which function returns the month from a date?<br><\/mark><\/strong>A) YEAR<br>B) MONTH<br>C) DAY<br>D) TODAY<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>   MONTH(serial_number) extracts the month number (1\u201312).\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">63. Which function returns the day from a date?<br><\/mark><\/strong>A) YEAR<br>B) MONTH<br>C) DAY<br>D) TODAY<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>   DAY(serial_number) extracts the day from a date.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">64. Which Excel function rounds a number up to the nearest integer?<br><\/mark><\/strong>A) ROUND<br>B) CEILING<br>C) FLOOR<br>D) INT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  CEILING(number, significance) rounds a number up to the nearest multiple of significance.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">65. Which function rounds a number down to the nearest integer?<br><\/mark><\/strong>A) ROUND<br>B) CEILING<br>C) FLOOR<br>D) INT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  FLOOR(number, significance) rounds a number down to the nearest multiple of significance.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">66. Which function removes the fractional part of a number, returning an integer?<br><\/mark><\/strong>A) ROUND<br>B) CEILING<br>C) FLOOR<br>D) INT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: D <\/b><BR>\n<b>Explanation:<\/b>   INT(number) returns the largest integer less than or equal to the number.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">67. Which function returns a random number between 0 and 1?<br><\/mark><\/strong>A) RAND<br>B) RANDBETWEEN<br>C) RANDOM<br>D) RANDOMIZE<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  RAND() generates a decimal number between 0 and 1.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">68. Which function returns a random integer between two specified numbers?<br><\/mark><\/strong>A) RAND<br>B) RANDBETWEEN<br>C) RANDOM<br>D) RANDINT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>   RANDBETWEEN(bottom, top) generates a random integer within the specified range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">69. Which function returns the largest value in a range?<br><\/mark><\/strong>A) MAX<br>B) MIN<br>C) LARGE<br>D) COUNT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  MAX(range) returns the maximum value in the range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">70. Which function returns the smallest value in a range?<br><\/mark><\/strong>A) MAX<br>B) MIN<br>C) SMALL<br>D) COUNT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  MIN(range) returns the minimum value in the range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">71. Which function returns the nth largest value in a range?<br><\/mark><\/strong>A) MAX<br>B) MIN<br>C) LARGE<br>D) COUNT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  LARGE(array, n) returns the nth largest value in a range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">72. Which function returns the nth smallest value in a range?<br><\/mark><\/strong>A) MAX<br>B) MIN<br>C) SMALL<br>D) COUNT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  SMALL(array, n) returns the nth smallest value in a range.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">73. Which Excel feature highlights cells based on specific conditions?<br><\/mark><\/strong>A) Conditional Formatting<br>B) Data Validation<br>C) AutoFilter<br>D) Format Painter<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>   Conditional Formatting allows formatting cells based on criteria, e.g., values above\/below a threshold.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">74. Which Excel feature allows analyzing data by summarizing it in a pivot table?<br><\/mark><\/strong>A) Pivot Table<br>B) Sort &amp; Filter<br>C) Goal Seek<br>D) Scenario Manager<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Pivot Tables summarize large datasets for quick insights.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">75. Which feature is used to perform \u201cwhat-if\u201d analysis for a single variable?<br><\/mark><\/strong>A) Goal Seek<br>B) Scenario Manager<br>C) Data Table<br>D) Solver<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  Goal Seek adjusts an input value to achieve a desired output for a formula.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">76. Which feature allows you to perform \u201cwhat-if\u201d analysis for multiple variables?<br><\/mark><\/strong>A) Goal Seek<br>B) Scenario Manager<br>C) Data Table<br>D) Solver<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer:  B <\/b><BR>\n<b>Explanation:<\/b>  Scenario Manager lets you define and compare multiple input scenarios to see their impact on results.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">77. Which Excel feature allows creating tables that automatically expand when new data is added?<br><\/mark><\/strong>A) Pivot Table<br>B) Data Table<br>C) Excel Table<br>D) Named Range<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: C <\/b><BR>\n<b>Explanation:<\/b>  Excel Tables (Insert \u2192 Table) automatically adjust formulas, formatting, and references when data grows.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">78. Which function returns the absolute value of a number?<br><\/mark><\/strong>A) SIGN<br>B) ABS<br>C) MOD<br>D) ROUND<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  ABS(number) returns the non-negative value of a number.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">79. Which function returns the remainder after division of two numbers?<br><\/mark><\/strong>A) MOD<br>B) QUOTIENT<br>C) INT<br>D) DIV<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  MOD(number, divisor) returns the remainder of number divided by divisor.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">80. Which function returns only the integer portion of a division?<br><\/mark><\/strong>A) MOD<br>B) QUOTIENT<br>C) INT<br>D) FLOOR<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  QUOTIENT(numerator, denominator) returns the integer part of a division, ignoring remainder.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">81. Which function returns the square root of a number in Excel?A) POWER<br><\/mark><\/strong>B) SQRT<br>C) EXP<br>D) ROOT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  SQRT(number) returns the square root of a number.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">82. Which function raises a number to a specified power?<\/mark><\/strong><br>A) POWER<br>B) SQRT<br>C) EXP<br>D) LOG<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>   POWER(number, power) returns the number raised to the specified exponent.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">83. Which Excel function returns the logarithm of a number?<\/mark><\/strong><br>A) LOG<br>B) LOG10<br>C) LN<br>D) All of the above<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: D <\/b><BR>\n<b>Explanation:<\/b>  LOG(number, base) returns logarithm with any base, LOG10 returns base 10 log, LN returns natural log.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">84. Which function returns the integer part of a number toward zero?<\/mark><\/strong><br>A) INT<br>B) TRUNC<br>C) FLOOR<br>D) ROUND<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>   TRUNC(number, [num_digits]) truncates the decimal portion without rounding.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">85. Which function is used to look up a value in a horizontal table?<br><\/mark><\/strong>A) VLOOKUP<br>B) HLOOKUP<br>C) INDEX<br>D) MATCH<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  HLOOKUP searches in the first row of a horizontal range and returns value from specified row.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">86. Which Excel feature is used to split text into multiple columns?<br><\/mark><\/strong>A) Text to Columns<br>B) Flash Fill<br>C) CONCAT<br>D) Split Cells<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Text to Columns (Data tab) splits data based on delimiter or fixed width.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">87. Which function combines multiple text strings into one?<br><\/mark><\/strong>A) CONCATENATE \/ CONCAT<br>B) TEXTJOIN<br>C) &amp; operator<br>D) All of the above<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: D <\/b><BR>\n<b>Explanation:<\/b>  CONCATENATE \/ CONCAT, TEXTJOIN, or &#038; operator can combine text strings in Excel.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">88. Which function inserts the current date in a cell that updates automatically?<br><\/mark><\/strong>A) TODAY<br>B) NOW<br>C) DATE<br>D) CURRENT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  TODAY() returns the current system date and updates daily.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">89. Which function inserts the current date and time in a cell?<br><\/mark><\/strong>A) TODAY<br>B) NOW<br>C) DATE<br>D) CURRENT<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  NOW() returns both current date and time, updating whenever the worksheet recalculates.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">90. Which function rounds a number to the nearest even integer?<br><\/mark><\/strong>A) EVEN<br>B) ODD<br>C) MROUND<br>D) ROUND<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  EVEN(number) rounds a number up to the nearest even integer.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">91. Which function rounds a number up to the nearest odd integer?<br><\/mark><\/strong>A) EVEN<br>B) ODD<br>C) MROUND<br>D) ROUND<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B  <\/b><BR>\n<b>Explanation:<\/b>  ODD(number) rounds a number up to the nearest odd integer.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">92. Which Excel feature allows automatic data entry based on patterns?<br><\/mark><\/strong>A) AutoFill<br>B) Flash Fill<br>C) Data Validation<br>D) Fill Handle<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  Flash Fill recognizes patterns in data entry and automatically fills remaining cells.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">93. Which Excel feature displays the frequency distribution of data?<br><\/mark><\/strong>A) Pivot Table<br>B) Histogram<br>C) Data Table<br>D) Goal Seek<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  Histogram summarizes data by showing frequency distribution in bins.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">94. Which option allows grouping and outlining rows or columns in Excel?<br><\/mark><\/strong>A) Group &amp; Outline<br>B) Freeze Panes<br>C) Split<br>D) Filter<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Group &#038; Outline (Data tab) allows collapsing\/expanding sections of rows or columns.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">95. Which function converts a text string into a numeric value?<br><\/mark><\/strong>A) VALUE<br>B) NUMBERVALUE<br>C) TEXT<br>D) Both A &amp; B<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: D <\/b><BR>\n<b>Explanation:<\/b>  VALUE(text) and NUMBERVALUE(text) convert text to numbers, depending on format.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">96. Which Excel feature allows tracking changes made by multiple users?<br><\/mark><\/strong>A) Track Changes<br>B) Comments<br>C) Protect Sheet<br>D) Review<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>   Track Changes highlights edits made by users, useful for collaborative work.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">97. Which Excel feature allows creating macros?<br><\/mark><\/strong>A) Developer \u2192 Record Macro<br>B) Insert \u2192 Macro<br>C) Home \u2192 Macro<br>D) Data \u2192 Macro<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A  <\/b><BR>\n<b>Explanation:<\/b>  Developer tab allows recording and managing macros to automate tasks.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">98. Which feature in Excel allows scenario-based analysis using multiple input variables?<br><\/mark><\/strong>A) Scenario Manager<br>B) Goal Seek<br>C) Solver<br>D) Data Table<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: D <\/b><BR>\n<b>Explanation:<\/b>  Data Tables allow analyzing the effect of one or two variables on formulas.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">99. Which Excel tool finds solutions for optimizing a target cell?<br><\/mark><\/strong>A) Goal Seek<br>B) Solver<br>C) Scenario Manager<br>D) Data Table<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: B <\/b><BR>\n<b>Explanation:<\/b>  Solver adjusts multiple input values to optimize (maximize, minimize, or reach a target) output.\n <\/p>\n<\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">100. Which Excel feature protects a sheet from editing while allowing some cells to remain editable?<br><\/mark><\/strong>A) Protect Sheet<br>B) Protect Workbook<br>C) Lock Cells<br>D) Data Validation<\/p>\n\n\n\n<button class=\"acc\">Show Answer<\/button>\n<div class=\"pnl\">\n  <p style=\"font-size: 22px;\"><b> Answer: A <\/b><BR>\n<b>Explanation:<\/b>  Protect Sheet restricts editing, and unlocked cells remain editable.\n <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>1. What is the default file extension of an Excel workbook in Excel 2016 and later?A) .xlsB) .xlsxC) .csvD) .docx Show Answer Answer: B Explanation: Excel 2007 onward uses the XML-based .xlsx format as the default workbook extension. 2. Which of the following is the default font in Excel 2016?A) Times New RomanB) ArialC) CalibriD)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"[]"},"categories":[2],"tags":[4029,5649],"class_list":{"0":"post-17884","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-mcqs-adda","8":"tag-mcqs-for-pc-psi-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/17884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/comments?post=17884"}],"version-history":[{"count":100,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/17884\/revisions"}],"predecessor-version":[{"id":37502,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/17884\/revisions\/37502"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=17884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=17884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=17884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}