Ms-Excel Test MS-EXcel Test-01 MS Excel is a powerful spreadsheet application developed by Microsoft. It is used for data entry, calculations, data analysis, chart creation, and report preparation. Excel provides various formulas, functions, and tools that help users organize and manage information efficiently. It is widely used in offices, businesses, schools, and financial organizations. 1 / 30 Which Excel feature wraps text into multiple lines within a cell? Merge Cells Wrap Text AutoFit Freeze Panes 2 / 30 Which shortcut key is used to redo the last action? Ctrl+Z Ctrl+Y Ctrl+D Ctrl+X 3 / 30 Which shortcut key is used to rename a worksheet? F5 F4 F2 F1 4 / 30 Which option restricts the type of data entered into a cell? Data Validation Conditional Formatting Freeze Panes Advance Filter 5 / 30 Which Excel feature highlights data based on rules? Conditional Formatting Sort Filter Validation 6 / 30 Which function returns an integer by removing decimals? INT Round Round UP MOD 7 / 30 Which function returns the remainder after division? ROUND MOD ABS SQRT 8 / 30 MS Excel is a ______ software. Presentation Database Spreadsheet Graphics 9 / 30 Which shortcut opens Go To? Ctrl+G Ctrl+J Ctrl+H Ctrl+D 10 / 30 Which shortcut replaces data? Ctrl+R Ctrl+L Ctrl+H Ctrl+Shit+R 11 / 30 The default file extension of Excel is: .docx .pptx .xlxs .txt 12 / 30 Formula Bar displays: Sheet name Cell contents Row number Column name 13 / 30 Name Box displays: Cell address Formula Workbook name Chart title 14 / 30 Which feature arranges data in order? Sort Filter Freeze Split 15 / 30 Which feature displays selected records only? Sort Filter Freeze Merge 16 / 30 Merge Cells combines: Rows Columns Multiple cells into one Worksheets 17 / 30 Which function is used for logical testing? IF SUM Avarage Char 18 / 30 IF function returns: Average True/False based result Sum Count 19 / 30 Which tab contains Sort and Filter? Data Review View Page layout 20 / 30 Which function rounds a number? ROUND RAND NOW TODAY 21 / 30 Which function joins text strings? Concatenate SUM Count Code 22 / 30 First column name is: 1 A AA X 23 / 30 Which tab contains spelling check? View Review Home Insert 24 / 30 Which function returns the length of text? LEN Left Right MID 25 / 30 Which function capitalizes first letters? UPPER LOWER PROPER LEN 26 / 30 A1 refers to: Row 1 Column A Column 1 Row A Sheet 1 Workbook 1 27 / 30 Which function looks up values vertically? HLOOKUP VLOOKUP LOOKUP Find 28 / 30 HLOOKUP searches: Vertically Horizontally Diagonally Randomly 29 / 30 Which tab contains Page Setup? Layout/Page Layout Data Review View 30 / 30 Excel is mainly used for: Data calculation and analysis Video editing Web browsing Animation creation Your score isThe average score is 68% 0% Restart quiz