Which of the following is not a worksheet design criterion?
✅ Correct Answer:Description
Explanation: Professional spreadsheet design focuses on Efficiency (speed/resources), Auditability (ability to trace errors), and Clarity (ease of understanding). 'Description' is an action you perform (documenting), but it is not considered a fundamental 'Design Criterion' or principle of model building itself.
122
Comments can be added to cells using
✅ Correct Answer:Insert > Comments
Explanation: In the classic Excel menu structure, the command to add a note was located at 'Insert > Comment'. In modern Excel (Ribbon interface), you can find this in the 'Review' tab (New Comment) or by right-clicking the cell and choosing 'Insert Comment'.
123
To delete an embedded object, first
✅ Correct Answer:Select it and then press the delete key
Explanation: Deleting an object (like a chart or image) is a two-step process. First, you must 'Select' it by clicking on it once (handles will appear around the edges). Once selected, you simply press the 'Delete' key on your keyboard. Double-clicking usually opens formatting options or the source application.
124
Files created with Lotus 1-2-3 have an extension
✅ Correct Answer:WK1
Explanation: Lotus 1-2-3 was the dominant spreadsheet software before Excel took over. Its files typically used extensions like '.WK1' (for Release 2) or '.123' (for later versions). In the context of older computer science exams, '.WK1' is the classic answer associated with Lotus 1-2-3 files that Excel can import.
125
Documentation should include
✅ Correct Answer:All the above
Explanation: Good spreadsheet practice involves 'Documentation' to help others (and yourself) understand the file later. This includes recording where the data came from (Source), who needs the reports (Destination/Users), and what the spreadsheet is actually trying to solve (Purpose). This metadata is crucial for auditability.
126
Right clicking something in Excel:
✅ Correct Answer:Opens a shortcut menu listing everything you can do to the object
Explanation: Right-clicking is a universal action in Windows and Excel known as invoking the 'Context Menu'. It displays a list of relevant commands (like Copy, Paste, Format, Delete) specific to the item you clicked on (whether it's a cell, a chart, or a picture), giving you quick access to common tasks.
127
How can you delete a record?
✅ Correct Answer:Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Explanation: In older versions of Excel (before 2007), the 'Data Form' was a popular feature to manage database-like lists. It opened a dialog box showing one row (record) at a time. From there, you could easily search for a specific record and click the 'Delete' button to remove that entire row from your table without manually selecting cells.
128
It is acceptable of let long text flow into adjacent cells on a worksheet when
✅ Correct Answer:No data will be entered in the adjacent cells
Explanation: If a cell contains text that is wider than the column, Excel allows it to spill over visually into the next cell ONLY IF the next cell is empty. If the adjacent cell has data, the long text will be cut off (truncated) at the border.
129
You can use the drag and drop method to
✅ Correct Answer:A and B
Explanation: Drag and Drop is versatile. By default, dragging a cell's border 'Moves' it to a new location. If you hold the 'Ctrl' key while dragging, it 'Copies' the cell. Therefore, it supports both moving and copying operations.
130
Which elements of worksheet can be protected from accidental modification
✅ Correct Answer:All of above
Explanation: Excel's protection features are granular. You can protect 'Contents' (formulas/data), 'Objects' (charts/shapes), and 'Scenarios' (saved 'what-if' values). When protecting a sheet (Tools > Protection), you can check or uncheck these specific elements to lock them.
131
You can select a single range of cells by
✅ Correct Answer:Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Explanation: This is known as the 'Shift-Click' method. It is very precise for selecting large ranges. You click the start point, hold Shift, and click the end point; Excel automatically selects everything in between. (Option D is also a valid method, but A describes the keyboard/mouse combo technique precisely).
132
You can edit a cell by
✅ Correct Answer:Double clicking the cell to edit it in-place
Explanation: The most direct way to edit a cell's content without overwriting it is to Double-Click the cell. This puts the cursor inside the cell (In-Cell Editing). Alternatively, you can select the cell and press F2 or click inside the Formula Bar.
133
To save a workbook, you:
✅ Correct Answer:Click the save button on the standard toolbar from the menu
Explanation: The standard ways to save are: Clicking the 'Floppy Disk' icon (Save button) on the toolbar, pressing 'Ctrl + S', or going to File > Save. Options B, C, and D are incorrect (Ctrl+F5 is not save, Windows Start button is for system, and Save is in the File menu, not Edit).
134
When you want to insert a blank imbedded excel object in a word document you can
✅ Correct Answer:Click the object command on the insert menu
Explanation: To put a new, empty Excel spreadsheet inside a Word document, you go to Insert > Object. From the list, you select 'Microsoft Excel Worksheet'. This embeds a fully functional mini-Excel window inside your Word page.
135
To view a cell comment
✅ Correct Answer:position the mouse pointer over the cell
Explanation: The quickest way to read a comment is to simply hover your mouse pointer over the cell that has a small red triangle in the corner. The comment box will pop up automatically. You do not need to click any menu buttons just to view it.
136
Excel uniquely identifies cells within a worksheet with a cell name
✅ Correct Answer:Column letters and row numbers
Explanation: Every cell in Excel has a unique address composed of its Column Letter followed by its Row Number. For example, the top-left cell is 'A1' (Column A, Row 1). This coordinate system allows Excel to reference any specific data point accurately in formulas.
137
You can use drag-and-drop to embed excel worksheet data in a word document
✅ Correct Answer:By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
Explanation: This is a Power User trick. To 'Embed' (copy) rather than 'Move' data via drag-and-drop between applications, you must hold the 'Ctrl' key. If you just drag without Ctrl, it might try to move the data. Holding Ctrl ensures a copy is created and embedded into the Word document.
138
Data can be arranged in a worksheet in a easy to understand manner using
✅ Correct Answer:all of above
Explanation: To make data readable and professional, you can use all these formatting tools. 'AutoFormat' applies pre-made designs, 'Styles' apply consistent formatting sets (like Good, Bad, Neutral), and changing 'Fonts' helps emphasize headings or specific data points.
139
Tab scrolling button
✅ Correct Answer:Allow you to view additional sheets tabs
Explanation: The Tab Scrolling Buttons are the small arrows located to the left of the sheet tabs (bottom left of the window). They do not switch the active sheet; instead, they scroll the list of sheet tabs (Sheet1, Sheet2...) left or right so you can see tabs that are hidden from view.
140
Getting data from a cell located in a different sheet is called
✅ Correct Answer:Referencing
Explanation: This is called 'Cell Referencing'. To get data from another sheet, you use a reference formula like '=Sheet2!A1'. This tells Excel to go to 'Sheet2' and pull the value from cell 'A1'. It creates a dynamic link between the two sheets.