Microsoft Excel Mock Test Computer Quiz 112 views 0 comments Microsoft Excel Mock Test Microsoft Excel quiz with questions and answers. Start: Excel Quiz Full Name Email (Receive Result) Phone 1. When a workbook is marked as final it becomes read-only. This means that Both A&B Typing, editing commands and proofing marks are disabled and turned off. Workbook is encrypted None 2. What type of chart is useful for comparing values over categories ? Pie Chart Line Chart Column Chart 3. =NOW () Returns the current time Current time Current date and time Wrong Formula Current date 4. An Excel file is generally called a / an : Woorksheet Sheet Workbook Spreadsheet 5. Which area in an excel window allows entering values and formulas? Standard toolbar Menu bar Formula bar Title bar 6. Which of the following is used to freeze rows and columns in Excel? Scroll Panes Split Panes Freeze Panes Lock Panes 7. In MS-Excel what does SUMIF function do? Adds up cell values based on a condition All answers are wrong Returns a subtotal in a list or database Adds all the numbers in a range of cells 8. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ______ menu Format Edit Protection Tools 9. The Greater Than sign (>) is an example of _____ operator. Arithmetic Greater Conditional Logical 10. By default, MS Excel shows ______ characters in a column 13 54 43 73 11. Merge and center option merge all selected cells into a single cell retaining only the contents of the: left-most cells Bottom-eft cells Bottom-most cells upper-left most cell 12. = TODAY () Returns the None Current time Current date Current date and time 13. Which of the following will not cut information? Pressing Ctrl + C Pressing Ctrl+X Selecting Edit>Cut from the menu Clicking the Cut button on the standard 14. A features that displays only the data in column's according to specified criteria Sorting Pivot Formula Filtering 15. How do you select an entire column? Click on Column letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu 16. Which of the following options is not located in the Page Setup dialog box? Page Break Preview. Margins Page Orientation Headers and Footers 17. In Excel, which one denoted a range from A1 through D15 A1$D15 A1-D15 A1,D15 A1:D15 18. Where you can find the name box in excel? Appears to the left of the formula bar Appears below the status bar Shows the location of the previously active cell Appears below the menu bar 19. How many sheets are there, by default, when we create a new Excel file ? 3 1 2 4 20. Which of the following is not a valid data type in Excel? Currency Date/Time Picture Text Time is Up! Share this post Related Posts Internet and E-mail Quiz August 6, 2021 164 views Microsoft PowerPoint Mock Test August 6, 2021 89 views Microsoft Word MCQ Test August 6, 2021 230 views Computer Fundamental MCQ Test August 6, 2021 376 views Leave your thought here Cancel replyYou must be logged in to post a comment.