ICDS Supervisor - Computer Applications (MS Excel) Practice Test 50 MCS's

ICDS Supervisor - Computer Applications (MS Excel) Practice Test

ICDS Supervisor - Computer Applications (MS Excel) Practice Test

Targeted 50 MCQ Practice Module focusing on: Excel Fundamentals & Interface, Formulas & Functions, Formatting & Data Management, Charts/Sorting/Filtering, and PivotTables/Macros/Printing/Shortcuts.

Select your answers and click Submit Assessment Answers at the bottom to calculate your total score and review explanations.

📢 Stay Updated on ICDS Exam Materials! Follow the Official WhatsApp Channel: Join Channel Here  |  💬 Contact Admin Direct
SECTION I: Excel Fundamentals & Interface [Questions 1 to 10]
1. MS Excel belongs to which category of application software?
Explanation: MS Excel is a spreadsheet application used for storing, organizing, and analyzing data in a grid of rows and columns.
2. What is the default file extension for a workbook saved in Excel 2007 and later versions?
Explanation: Since Excel 2007, workbooks are saved with the XML-based .xlsx extension by default. .xls was used in earlier versions (97-2003).
3. The intersection point of a row and a column in an Excel worksheet is called a:
Explanation: A cell is the basic unit of a worksheet, formed at the intersection of a row and a column, and is identified by a cell reference like A1.
4. What is the maximum number of rows available in a worksheet in Excel 2016/2019/365?
Explanation: Modern Excel worksheets (2007 onwards) support up to 1,048,576 rows and 16,384 columns.
5. What is the maximum number of columns available in a worksheet, and what is the last column labeled?
Explanation: Excel 2007 onward supports 16,384 columns, with the last column labeled XFD.
6. Which element of the Excel window displays the reference (address) of the currently active cell?
Explanation: The Name Box, located to the left of the Formula Bar, shows the cell reference (e.g., B5) of the active cell and can also be used to name ranges.
7. The bar located just below the Ribbon that displays the actual content, formula, or function of the active cell is called the:
Explanation: The Formula Bar displays and allows editing of the content or formula contained in the currently selected cell.
8. Which of the following is NOT a default tab found on the Excel Ribbon?
Explanation: "Slide Show" is a tab found in MS PowerPoint, not Excel. Excel's default tabs include Home, Insert, Page Layout, Formulas, Data, Review, and View.
9. A collection of one or more worksheets contained within a single Excel file is called a:
Explanation: A workbook is the entire Excel file, which can contain multiple individual worksheets (tabs).
10. In Excel 2016 and later, how many worksheets does a new blank workbook contain by default?
Explanation: Since Excel 2013/2016, a new workbook opens with just 1 worksheet by default (earlier versions like Excel 2003 defaulted to 3).
SECTION II: Formulas & Functions [Questions 11 to 20]
11. Every formula entered into an Excel cell must begin with which symbol?
Explanation: Excel identifies cell content as a formula only when it begins with an equals sign (=).
12. Which function is used to add up a range of numeric values in Excel, e.g., =FUNCTION(A1:A10)?
Explanation: The SUM function, e.g., =SUM(A1:A10), returns the total of all numeric values in the specified range.
13. The AVERAGE function calculates:
Explanation: =AVERAGE(range) sums the numeric values and divides by the count of numeric values to return the arithmetic mean.
14. Which function counts only the cells in a range that contain numeric values, ignoring text and blank cells?
Explanation: COUNT tallies only cells containing numbers within a range, while COUNTA counts all non-empty cells (numbers and text both).
15. Which function is used to count all non-empty cells in a range, regardless of whether they contain text or numbers?
Explanation: COUNTA counts every non-blank cell in a selected range irrespective of the data type it holds.
16. Which function returns the largest (maximum) value from a given range of cells?
Explanation: =MAX(range) returns the highest numeric value present within the specified range of cells.
17. The IF function in Excel is primarily used to:
Explanation: =IF(logical_test, value_if_true, value_if_false) evaluates a condition and returns different results based on whether it is true or false.
18. The VLOOKUP function searches for a value in the leftmost column of a table and returns a value from:
Explanation: VLOOKUP looks up a value in the first column of a table array and returns a value from the same row, in the column number specified.
19. In cell referencing, which symbol is used to lock a row or column so that it does not change when a formula is copied (e.g., $A$1)?
Explanation: The dollar sign ($) creates an absolute reference; placing it before the column letter and/or row number prevents that part from changing when the formula is copied.
20. What does the error value #DIV/0! indicate in a cell?
Explanation: #DIV/0! appears when a formula tries to divide a value by zero or by an empty cell.
SECTION III: Formatting & Data Management [Questions 21 to 30]
21. The "Merge & Center" command on the Home tab does what to selected cells?
Explanation: Merge & Center joins multiple selected cells into a single larger cell and horizontally centers its content, commonly used for titles.
22. Which formatting option automatically adjusts row height so that long text displays on multiple lines within a single cell instead of overflowing?
Explanation: Wrap Text forces long cell content to display on multiple lines within the same cell, expanding the row height as needed.
23. Which feature automatically applies special formatting (like color scales or icon sets) to cells that meet a defined rule or condition?
Explanation: Conditional Formatting changes the appearance of cells automatically based on their values meeting specified rules, useful for visual data analysis.
24. Which feature allows certain rows or columns (such as headers) to remain visible on screen while scrolling through a large worksheet?
Explanation: Freeze Panes (found under the View tab) locks specified rows and/or columns in place so they stay visible while the rest of the sheet scrolls.
25. Dragging the small square at the bottom-right corner of a selected cell to automatically extend a series (e.g., 1, 2, 3...) is called using the:
Explanation: The Fill Handle is the small square at the bottom-right corner of a cell/selection used to drag and auto-fill data series or copy formulas.
26. Which tool allows a user to copy formatting (font, color, borders) from one cell and apply it to another without copying the cell content?
Explanation: Format Painter copies only the formatting attributes of a selected cell and applies them to another cell or range, leaving content untouched.
27. By default, how does Excel align numeric values and text values within a cell?
Explanation: By default, Excel right-aligns numeric/date values and left-aligns text values within cells.
28. Which feature restricts the type of data (e.g., only whole numbers between 1-100) that can be entered into a specific cell?
Explanation: Data Validation (found on the Data tab) restricts the type or range of data users can enter into a cell and can trigger error alerts for invalid entries.
29. Which keyboard shortcut opens the "Find and Replace" dialog box in Excel?
Explanation: Ctrl+H opens the Find and Replace dialog directly on the Replace tab, allowing users to search and substitute data across the worksheet.
30. Which keyboard shortcut is used to reverse (undo) the last action performed in Excel?
Explanation: Ctrl+Z undoes the last action. Ctrl+Y is used to redo an action that was undone.
SECTION IV: Charts, Sorting & Filtering [Questions 31 to 40]
31. Which chart type is most appropriate for showing individual data values as proportions/percentages of a single total (a whole)?
Explanation: A Pie Chart is best suited for displaying how individual parts contribute to a whole, typically expressed as percentages of 100%.
32. Which chart type is most suitable for displaying trends in data over a continuous period of time, such as monthly sales?
Explanation: Line charts connect data points across a continuous axis (usually time), making them ideal for visualizing trends.
33. Arranging data in a worksheet in ascending or descending order based on values in one or more columns is called:
Explanation: Sorting rearranges rows of data based on the values in selected column(s), either in ascending (A-Z, smallest-largest) or descending order.
34. Which feature temporarily hides rows that do not meet specified criteria, displaying only the rows that match, without deleting any data?
Explanation: The Filter (AutoFilter) feature displays only rows meeting chosen criteria while temporarily hiding the rest; the underlying data is not deleted.
35. A tiny chart embedded within a single cell that shows a visual trend alongside the corresponding data is called a:
Explanation: Sparklines are miniature charts placed inside a single cell to give a quick visual summary of data trends, found under the Insert tab.
36. Which tool under the Data tab is used to automatically identify and remove identical repeated rows from a dataset?
Explanation: "Remove Duplicates," located on the Data tab, scans selected columns and deletes rows containing duplicate values.
37. Which feature splits the content of a single column (e.g., a full name) into multiple separate columns based on a delimiter such as a comma or space?
Explanation: Text to Columns (Data tab) breaks a single column's content into multiple columns using a delimiter (comma, space, tab) or fixed width.
38. Which symbol/function is commonly used to join (combine) text from two or more cells into a single cell, e.g., =A1&" "&B1?
Explanation: The ampersand (&) operator, or the CONCATENATE/CONCAT/TEXTJOIN functions, joins text from multiple cells into one string.
39. The "Sort & Filter" command group is located under which Ribbon tab (though it is also accessible via the Home tab)?
Explanation: The Data tab houses the primary "Sort & Filter" group, though quick Sort & Filter options are also duplicated on the Home tab.
40. When more than one criterion (across multiple columns) needs to be applied while sorting data, which Excel feature should be used?
Explanation: The Custom Sort dialog box allows adding multiple sort levels (e.g., sort by Department, then by Name) using the "Add Level" button.
SECTION V: PivotTables, Macros, Printing & Shortcuts [Questions 41 to 50]
41. A PivotTable is primarily used to:
Explanation: A PivotTable lets users summarize, group, filter, and rearrange large datasets quickly to extract meaningful insights without altering the source data.
42. A Macro in Excel is best described as:
Explanation: A Macro records a sequence of commands/keystrokes (often written in VBA) that can be executed repeatedly to automate routine tasks.
43. The "Record Macro" option, used to begin recording a new macro, is primarily found under which Ribbon tab?
Explanation: The Macros group, including "Record Macro," is located on the View tab (and also on the Developer tab, if enabled).
44. Which keyboard shortcut is used to save the current Excel workbook?
Explanation: Ctrl+S is the universal shortcut for saving a file, including an Excel workbook.
45. Which Ribbon tab contains the "Print Area" option, used to define exactly which cells will be printed?
Explanation: The "Print Area" command is located in the Page Setup group of the Page Layout tab, allowing users to restrict printing to a specific range.
46. Which keyboard shortcut is used to open a new blank Excel workbook?
Explanation: Ctrl+N instantly opens a new blank workbook in Excel.
47. Which Ribbon tab contains the "Protect Sheet" and "Protect Workbook" options used to restrict editing?
Explanation: The Review tab contains the "Protect Sheet" and "Protect Workbook" commands in the Protect group, used to prevent unauthorized changes.
48. What is the file extension used for a macro-enabled Excel workbook?
Explanation: A workbook containing macros must be saved with the .xlsm extension, since the standard .xlsx format does not support macro storage.
49. Which keyboard shortcut instantly moves the active cell selection to cell A1 of the current worksheet?
Explanation: Ctrl+Home moves the cursor directly to cell A1. Ctrl+End instead moves to the last used cell in the worksheet.
50. Which key or key-combination is used to edit the content of the currently selected/active cell directly?
Explanation: Pressing F2 places the active cell into Edit mode, positioning the cursor within the cell content for direct editing.

Comments

Post a Comment