Excel Quiz for Beginners with Answers Welcome to your Excel Quiz for Beginners with Answers 1. What is the shortcut to copy in Excel? Ctrl+C Ctrl+X Ctrl+V Ctrl+P 2. What is the shortcut to paste as values in Excel? Ctrl+Shift+V Ctrl+Alt+V, then V Ctrl+Alt+V Ctrl+Shift+V, then V 3. LibreOffice's alternative for Microsoft Excel is called Calc Docs Slides Sheets 4. Which of the following is an example of absolute cell referencing? B3 B!3! $B$3 5. To select the current row, you can press Ctrl+Shift+Space Shift+Space Ctrl+Space Alt+Space 6. The number of rows in Excel for Microsoft 365 is - 16,48,576 1,48,576 16,384 10,48,576 7. You can remove Gridlines from Home tab Page Layout tab Insert tab View tab 8. The default alignment for texts Right Left 9. A group of cells is known as - Cell Group Range Range Group Cluster 10. Which of the following is NOT a lookup function in Excel? HLOOKUP XLOOKUP VLOOKUP PLOOKUP 11. For Less Than MATCH, data needs to be sorted in - Descending order Ascending order 12. Filter in Excel Views data according to condition Sorts data according to criteria Deletes data according to condition Arranges data according to criteria 13. To count empty cells, you can use - COUNTEMPTY Function ISBLANK Function COUNTBLANK Function COUNTA Function 14. Which of the following are available under What-If analysis? Goal Seek Scenario Manager All of above Data Table 15. Freeze Pane feature is available in which tab? Page Layout Data View Home 16. Relative cell reference - $B$3 B3 B$3 B!3! 17. What is the shortcut to paste in Excel? Ctrl+P Ctrl+C Ctrl+V Ctrl+X 18. Which is NOT an Excel function? AVERAGEA MEAN AVERAGE COUNTBLANK 19. Cell means in Excel - Intersection of a row and a column Entire Sheet Area of a chart A group of selected items 20. Which of the following function is used to count ONLY numerical values in a range? COUNT NUM COUNTA COUNTIF 21. You can lock cells by pressing F4 F2 F3 F5 22. The default alignment for numbers Left Right 23. The function you can use to count characters of a cell is CHAR COUNT LENGTH LEN 24. To select the current column, you can press Alt+Space Ctrl+Shift+Space Shift+Space Ctrl+Space 25. The number of columns in Excel for Microsoft 365 is - 1,48,576 16,384 10,48,576 16,48,576 26. Rows are labelled by 1,2,3 A,B,C 27. Fill in the blanks. You should have _________ volatile functions. fewer more 28. Which of the following statement is TRUE? Rows are horizontal, Columns are vertical Rows are vertical, Columns are horizontal Rows are denoted by alphabets, columns are denoted by numbers 29. Which of the following is a hybrid cell reference? B$4 B4 B!4! $B$4 30. To add values from cell B3 and B4, you can use =B3+B4 option 2 and 3 =SUM(B3:B4) B3+B4 31. You can sum the range B3 to B5 using the following formula- All of above =SUM(B3,B5) =B3+B4+BS =SUM(B3:B5) 32. The first version of MS Excel was released on MS DOS Windows Linux Macintosh 33. Which one is the latest version of Excel version? Excel 2024 Excel 2021 Excel 2023 Excel for Microsoft 365 34. You can change the font styles in - Home Tab Insert Tab Font Tab Format Tab 35. The last column in Excel for Microsoft 365 - XFF XFG XFE XFD 36. The function of the Freeze Pane is - To hide some rows To keep the row visible To keep the row and column visible while scrolling To hide some rows and columns while scrolling 37. You can check spell errors by pressing F11 F5 F7 F2 38. Google's alternative for Microsoft Excel is called Docs Slides Calc Sheets 39. Shortcut for AutoSum - Ctrl+= Shift+= Alt+= Ctrl+Shift+= 40. For Greater Than MATCH, data needs to be sorted in - Ascending order Descending order 41. To find the arithmetic average of a range of cells, you need to use the - MEAN Function AVG Function AVERAGE Function MOD Function 42. Lowest Zoom Level in Excel - 20% 15% 10% 5% 43. For absolute cell referencing, you need to use # $ @ ! 44. You can fill in formulas using the - Fill Handle tool AutoFill tool AutoFilter tool Formula Fill tool 45. For multiplication you need to use the following symbol * ^ x / 46. Maximum Zoom Level in Excel - 300% 200% 500% 400% 47. Which of the following statement is TRUE? =COUNT(B3:B7) returns 4 =COUNTA(B3:B7) returns 1 =COUNT(B3:B7) returns 5 =COUNTA(B3:B7) returns 4 48. Which feature allows you to create visual representation of the data? Data Validation Conditional Formatting Graphs Charts 49. To show trends over time, the best chart is - Pie Line Bar Histogram 50. You can switch between worksheets by pressing - Ctrl+Page Down None of the above Both Ctrl+Page Up 51. Which is NOT an alignment type in Excel? Top Justify Center Middle 52. Columns are labelled by A,B,C 1,2,3 53. You can Redo by pressing Ctrl+Z Ctrl+Esc Ctrl+Shift+Z Ctrl+Y 54. Which function can be used to find the highest value of a range? BIG LARGEST HIGHEST MAX 55. You can Undo by pressing Ctrl+Esc Ctrl+Z Ctrl+Y Ctrl+X 56. The image below is related to PivotTable Power Query Data Validation Conditional Formatting 57. You can add charts by pressing F2 F5 F11 F7 58. Print dialog window will be opened if you press Ctrl+Alt+P Ctrl+Shift+P Ctrl+P Ctrl+PrintScreen 59. Which of the following formula can be used to sum cell B3 to B5? =SUM(B3:B5) =SUM(B3,B4,B5) All of above =B3+B4+B5 60. The Goal Seek option is available in - Home Tab Formulas Tab Data Tab Insert Tab 61. Any formula will always starts with a - () = + 62. You can create dropdown lists using Insert List Conditional Formatting Dropdown List Data Validation 63. =SUM(B3:B7) will return 146 #REF! 1 out of 13 Time's up