{"id":12442,"date":"2025-08-01T11:03:36","date_gmt":"2025-08-01T11:03:36","guid":{"rendered":"https:\/\/guidance24.in\/?p=12442"},"modified":"2025-08-01T11:03:38","modified_gmt":"2025-08-01T11:03:38","slug":"ms-excel-top-100-one-liner-questions","status":"publish","type":"post","link":"https:\/\/guidance24.in\/?p=12442","title":{"rendered":"MS Excel top 100 one liner questions"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>General Excel Basics<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Q: What is the default file extension of Excel 2016?<br>A: <code>.xlsx<\/code><\/li>\n\n\n\n<li>Q: Which company developed MS Excel?<br>A: Microsoft<\/li>\n\n\n\n<li>Q: Which key is used to start a new line in a cell?<br>A: <code>Alt + Enter<\/code><\/li>\n\n\n\n<li>Q: What is the default row height in Excel?<br>A: 15<\/li>\n\n\n\n<li>Q: What is the maximum number of rows in Excel 2016?<br>A: 10,48,576<\/li>\n\n\n\n<li>Q: What is the maximum number of columns in Excel 2016?<br>A: 16,384 (Column XFD)<\/li>\n\n\n\n<li>Q: What is a cell in Excel?<br>A: Intersection of a row and column<\/li>\n\n\n\n<li>Q: How many sheets are there by default in Excel 2016?<br>A: One<\/li>\n\n\n\n<li>Q: What is the name of the horizontal lines in Excel?<br>A: Rows<\/li>\n\n\n\n<li>Q: What is the name of vertical lines in Excel?<br>A: Columns<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Excel Formulas &amp; Functions<\/strong><\/h3>\n\n\n\n<ol start=\"11\" class=\"wp-block-list\">\n<li>Q: Which symbol is used to start a formula in Excel?<br>A: <code>=<\/code><\/li>\n\n\n\n<li>Q: Which function is used to calculate sum?<br>A: <code>=SUM()<\/code><\/li>\n\n\n\n<li>Q: Which function finds the average value?<br>A: <code>=AVERAGE()<\/code><\/li>\n\n\n\n<li>Q: Which function returns the largest value?<br>A: <code>=MAX()<\/code><\/li>\n\n\n\n<li>Q: Which function returns the smallest value?<br>A: <code>=MIN()<\/code><\/li>\n\n\n\n<li>Q: Which function counts numeric values?<br>A: <code>=COUNT()<\/code><\/li>\n\n\n\n<li>Q: Which function counts all non-empty cells?<br>A: <code>=COUNTA()<\/code><\/li>\n\n\n\n<li>Q: What is the function for today\u2019s date?<br>A: <code>=TODAY()<\/code><\/li>\n\n\n\n<li>Q: Which function returns current time?<br>A: <code>=NOW()<\/code><\/li>\n\n\n\n<li>Q: Which function is used to remove extra spaces?<br>A: <code>=TRIM()<\/code><\/li>\n\n\n\n<li>Q: Which function joins text?<br>A: <code>=CONCATENATE()<\/code> or <code>=TEXTJOIN()<\/code><\/li>\n\n\n\n<li>Q: What is the use of <code>IF<\/code> function?<br>A: To test a condition and return value<\/li>\n\n\n\n<li>Q: What is the syntax of IF function?<br>A: <code>=IF(condition, value_if_true, value_if_false)<\/code><\/li>\n\n\n\n<li>Q: Which function finds specific value in range?<br>A: <code>=VLOOKUP()<\/code><\/li>\n\n\n\n<li>Q: What does <code>ISBLANK()<\/code> do?<br>A: Checks if a cell is empty<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Excel Shortcuts<\/strong><\/h3>\n\n\n\n<ol start=\"26\" class=\"wp-block-list\">\n<li>Q: Shortcut to copy a cell?<br>A: <code>Ctrl + C<\/code><\/li>\n\n\n\n<li>Q: Shortcut to paste?<br>A: <code>Ctrl + V<\/code><\/li>\n\n\n\n<li>Q: Shortcut to cut?<br>A: <code>Ctrl + X<\/code><\/li>\n\n\n\n<li>Q: Shortcut to save workbook?<br>A: <code>Ctrl + S<\/code><\/li>\n\n\n\n<li>Q: Shortcut to open new workbook?<br>A: <code>Ctrl + N<\/code><\/li>\n\n\n\n<li>Q: Shortcut to print workbook?<br>A: <code>Ctrl + P<\/code><\/li>\n\n\n\n<li>Q: Shortcut to undo action?<br>A: <code>Ctrl + Z<\/code><\/li>\n\n\n\n<li>Q: Shortcut to redo action?<br>A: <code>Ctrl + Y<\/code><\/li>\n\n\n\n<li>Q: Shortcut to bold text?<br>A: <code>Ctrl + B<\/code><\/li>\n\n\n\n<li>Q: Shortcut to italicize text?<br>A: <code>Ctrl + I<\/code><\/li>\n\n\n\n<li>Q: Shortcut to underline text?<br>A: <code>Ctrl + U<\/code><\/li>\n\n\n\n<li>Q: Shortcut to insert hyperlink?<br>A: <code>Ctrl + K<\/code><\/li>\n\n\n\n<li>Q: Shortcut to move to next worksheet?<br>A: <code>Ctrl + Page Down<\/code><\/li>\n\n\n\n<li>Q: Shortcut to move to previous worksheet?<br>A: <code>Ctrl + Page Up<\/code><\/li>\n\n\n\n<li>Q: Shortcut to find text in worksheet?<br>A: <code>Ctrl + F<\/code><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Formatting &amp; Editing<\/strong><\/h3>\n\n\n\n<ol start=\"41\" class=\"wp-block-list\">\n<li>Q: Shortcut to format cells?<br>A: <code>Ctrl + 1<\/code><\/li>\n\n\n\n<li>Q: Shortcut to insert new row?<br>A: <code>Ctrl + Shift + +<\/code><\/li>\n\n\n\n<li>Q: Shortcut to delete row?<br>A: <code>Ctrl + -<\/code><\/li>\n\n\n\n<li>Q: How to merge cells?<br>A: Home > Merge &amp; Center<\/li>\n\n\n\n<li>Q: How to wrap text in a cell?<br>A: Home > Wrap Text<\/li>\n\n\n\n<li>Q: Shortcut to AutoFit column width?<br>A: <code>Alt + H + O + I<\/code><\/li>\n\n\n\n<li>Q: Shortcut to AutoFit row height?<br>A: <code>Alt + H + O + A<\/code><\/li>\n\n\n\n<li>Q: What is conditional formatting?<br>A: Format cells based on condition<\/li>\n\n\n\n<li>Q: Where is Format Painter found?<br>A: Home tab<\/li>\n\n\n\n<li>Q: What is used to protect worksheet?<br>A: Review > Protect Sheet<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Charts &amp; Data Tools<\/strong><\/h3>\n\n\n\n<ol start=\"51\" class=\"wp-block-list\">\n<li>Q: Which chart is used for trends over time?<br>A: Line Chart<\/li>\n\n\n\n<li>Q: Which chart is used to compare parts of whole?<br>A: Pie Chart<\/li>\n\n\n\n<li>Q: Shortcut to insert chart?<br>A: <code>Alt + F1<\/code><\/li>\n\n\n\n<li>Q: What is a Pivot Table?<br>A: Tool to summarize large data<\/li>\n\n\n\n<li>Q: Where is Data Validation found?<br>A: Data tab<\/li>\n\n\n\n<li>Q: What is used to sort data?<br>A: Sort button under Data tab<\/li>\n\n\n\n<li>Q: What is the use of Filter?<br>A: Show only specific data<\/li>\n\n\n\n<li>Q: What is Flash Fill?<br>A: Automatically fills pattern data<\/li>\n\n\n\n<li>Q: Which feature removes duplicates?<br>A: Data > Remove Duplicates<\/li>\n\n\n\n<li>Q: What is Goal Seek?<br>A: To find input for desired output<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>File &amp; Workbook Management<\/strong><\/h3>\n\n\n\n<ol start=\"61\" class=\"wp-block-list\">\n<li>Q: What is a workbook?<br>A: A file that contains worksheets<\/li>\n\n\n\n<li>Q: What is a worksheet?<br>A: A single sheet in Excel file<\/li>\n\n\n\n<li>Q: Shortcut to switch between open Excel files?<br>A: <code>Ctrl + Tab<\/code><\/li>\n\n\n\n<li>Q: Shortcut to rename worksheet?<br>A: <code>Alt + H + O + R<\/code><\/li>\n\n\n\n<li>Q: How to insert comment in a cell?<br>A: <code>Shift + F2<\/code><\/li>\n\n\n\n<li>Q: What is cell reference?<br>A: Address of a cell (e.g., A1)<\/li>\n\n\n\n<li>Q: What is an absolute reference?<br>A: A reference that doesn&#8217;t change (<code>$A$1<\/code>)<\/li>\n\n\n\n<li>Q: What is relative reference?<br>A: A reference that changes when copied<\/li>\n\n\n\n<li>Q: What is mixed reference?<br>A: Combination of absolute and relative<\/li>\n\n\n\n<li>Q: What does <code>.xls<\/code> stand for?<br>A: Excel Spreadsheet (older version)<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Advanced Excel<\/strong><\/h3>\n\n\n\n<ol start=\"71\" class=\"wp-block-list\">\n<li>Q: What is the function of <code>=IFERROR()<\/code>?<br>A: Returns value if error occurs<\/li>\n\n\n\n<li>Q: What is <code>=LEN()<\/code> used for?<br>A: Counts characters in a cell<\/li>\n\n\n\n<li>Q: What is <code>=LEFT(text,n)<\/code>?<br>A: Returns first n characters from text<\/li>\n\n\n\n<li>Q: What is <code>=RIGHT(text,n)<\/code>?<br>A: Returns last n characters from text<\/li>\n\n\n\n<li>Q: What does <code>=MID(text, start, num)<\/code> do?<br>A: Extracts text from middle<\/li>\n\n\n\n<li>Q: What is <code>=ROUND()<\/code> used for?<br>A: Rounds a number to desired digits<\/li>\n\n\n\n<li>Q: What is the use of <code>=TEXT()<\/code>?<br>A: Formats numbers\/dates as text<\/li>\n\n\n\n<li>Q: What is the use of <code>=PROPER()<\/code>?<br>A: Capitalizes first letter of each word<\/li>\n\n\n\n<li>Q: What is <code>=LOWER()<\/code>?<br>A: Converts text to lowercase<\/li>\n\n\n\n<li>Q: What is <code>=UPPER()<\/code>?<br>A: Converts text to uppercase<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Data Security &amp; Review<\/strong><\/h3>\n\n\n\n<ol start=\"81\" class=\"wp-block-list\">\n<li>Q: How to protect a workbook with password?<br>A: File > Info > Protect Workbook<\/li>\n\n\n\n<li>Q: Can you lock specific cells in Excel?<br>A: Yes, using Format Cells > Protection<\/li>\n\n\n\n<li>Q: How to enable AutoSave in Excel?<br>A: File > Options > Save > AutoSave<\/li>\n\n\n\n<li>Q: What is Track Changes?<br>A: Shows edits made by users<\/li>\n\n\n\n<li>Q: Shortcut to check spelling?<br>A: <code>F7<\/code><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 <strong>Miscellaneous<\/strong><\/h3>\n\n\n\n<ol start=\"86\" class=\"wp-block-list\">\n<li>Q: What is the default alignment for text in Excel?<br>A: Left<\/li>\n\n\n\n<li>Q: What is the default alignment for numbers?<br>A: Right<\/li>\n\n\n\n<li>Q: What is the intersection of row 5 and column C?<br>A: Cell C5<\/li>\n\n\n\n<li>Q: What are gridlines?<br>A: Light lines dividing cells<\/li>\n\n\n\n<li>Q: Can you insert image in Excel?<br>A: Yes, via Insert > Pictures<\/li>\n\n\n\n<li>Q: What is the use of Name Box?<br>A: Shows active cell name<\/li>\n\n\n\n<li>Q: What does Formula Bar show?<br>A: Formula or content of active cell<\/li>\n\n\n\n<li>Q: What is zoom control used for?<br>A: Enlarge or reduce worksheet view<\/li>\n\n\n\n<li>Q: How to freeze top row?<br>A: View > Freeze Panes > Freeze Top Row<\/li>\n\n\n\n<li>Q: How to insert drop-down list?<br>A: Data > Data Validation<\/li>\n\n\n\n<li>Q: What is the use of Comments in Excel?<br>A: To add notes to cells<\/li>\n\n\n\n<li>Q: Can Excel be used for budgeting?<br>A: Yes<\/li>\n\n\n\n<li>Q: Can Excel connect to databases?<br>A: Yes, via Data > Get External Data<\/li>\n\n\n\n<li>Q: What is cell range?<br>A: Group of selected cells (e.g., A1:B5)<\/li>\n\n\n\n<li>Q: What is AutoSum?<br>A: Adds numbers quickly using <code>\u03a3<\/code> button<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udd39 General Excel Basics \ud83d\udd39 Excel Formulas &amp; Functions \ud83d\udd39 Excel Shortcuts \ud83d\udd39 Formatting &amp; Editing \ud83d\udd39 Charts &amp; Data Tools \ud83d\udd39 File &amp; Workbook Management \ud83d\udd39 Advanced Excel \ud83d\udd39 Data Security &amp; Review \ud83d\udd39 Miscellaneous<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,8,30],"tags":[],"class_list":["post-12442","post","type-post","status-publish","format-standard","hentry","category-blog","category-excel-mcq","category-ms-excel"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"admin","author_link":"https:\/\/guidance24.in\/?author=1"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/guidance24.in\/?cat=15\" rel=\"category\">Blog<\/a> <a href=\"https:\/\/guidance24.in\/?cat=8\" rel=\"category\">Excel MCQ<\/a> <a href=\"https:\/\/guidance24.in\/?cat=30\" rel=\"category\">MS Excel<\/a>","rttpg_excerpt":"\ud83d\udd39 General Excel Basics \ud83d\udd39 Excel Formulas &amp; Functions \ud83d\udd39 Excel Shortcuts \ud83d\udd39 Formatting &amp; Editing \ud83d\udd39 Charts &amp; Data Tools \ud83d\udd39 File &amp; Workbook Management \ud83d\udd39 Advanced Excel \ud83d\udd39 Data Security &amp; Review \ud83d\udd39 Miscellaneous","_links":{"self":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12442"}],"version-history":[{"count":1,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12442\/revisions"}],"predecessor-version":[{"id":12691,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12442\/revisions\/12691"}],"wp:attachment":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}