You cannot link excel worksheet data to a word document
✅ Correct Answer:With the copy and paste buttons on the standard toolbar
Explanation: Using the standard 'Copy' and 'Paste' buttons simply takes a snapshot of the data and pastes it as a static table in Word. It does NOT create a link. To create a link, you must use 'Paste Special > Paste Link' or the Right-drag method.
62
You can copy data or formulas
✅ Correct Answer:All of the above
Explanation: Excel provides multiple ways to Copy and Paste. You can use the Menu bar (Edit > Copy), Right-click for the Shortcut menu, or use the Toolbar icons (Copy/Paste buttons). All these methods perform the same action of duplicating content.
63
Rounding errors can occur
✅ Correct Answer:When you use multiplication, division, or exponentiation in a formula
Explanation: Rounding errors (floating-point errors) happen because computers store numbers in binary. Operations like division (e.g., 1/3) or exponentiation can produce infinite decimals that the computer must truncate, leading to tiny discrepancies in the final calculated value.
64
Which of the following is the oldest spreadsheet package?
✅ Correct Answer:VisiCalc
Explanation: VisiCalc (Visible Calculator), released in 1979 for the Apple II, is widely considered the world's first electronic spreadsheet software. It was the 'killer app' that turned microcomputers from hobbyist toys into serious business tools, predating Lotus 1-2-3 and Excel.
65
Status indicators are located on the
✅ Correct Answer:Formula bar
Explanation: Note: The correct technical answer is the 'Status Bar' (at the bottom of the window). However, this option is missing from the list. In some older exam contexts, 'Formula Bar' is sometimes chosen as a proxy because it indicates the 'Edit' or 'Enter' mode status, but strictly speaking, indicators like 'Ready', 'Num Lock', etc., are on the Status Bar.
66
To create a formula, you can use:
✅ Correct Answer:Value and cell references
Explanation: Formulas in Excel are versatile. You can mix and match both hard-coded 'Values' (like 100) and 'Cell References' (like A1). For example, a formula like '=A1*100' uses both a reference and a value successfully.
67
To edit in an embedded excel worksheet object in a word document
✅ Correct Answer:Use the excel menu bar and toolbars inside the word application
Explanation: When you double-click an embedded Excel object inside Word, it activates 'In-Place Editing'. The Word interface temporarily transforms: the ribbons and toolbars change to Excel's tools, allowing you to edit the spreadsheet without leaving the Word window.
68
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
✅ Correct Answer:Freeze panes command on the window menu
Explanation: The 'Freeze Panes' command locks specific rows or columns (usually headers) in place. This ensures that when you scroll down a long list, the titles remain visible at the top, making it easier to read the data.
69
Which area in an excel window allows entering values and formulas
✅ Correct Answer:Formula bar
Explanation: The Formula Bar is the long strip located above the worksheet grid. It is the primary place for entering and editing data, formulas, and functions. While you can type directly into a cell, the Formula Bar shows the underlying content (like the formula itself) rather than the calculated result.
70
When you link data maintained in an excel workbook to a word document
✅ Correct Answer:The word document contains a reference to the original source application
Explanation: Linking establishes a live connection. The Word document does not store the static data itself; instead, it stores a file path (reference) to the original Excel workbook. When the Excel file is updated, the Word document reflects those changes automatically.
71
In a worksheet you can select
✅ Correct Answer:All of the above
Explanation: Excel provides flexible selection tools. You can select the 'Entire Worksheet' (Ctrl+A or clicking the top-left triangle button), entire 'Rows' (Shift+Space), or entire 'Columns' (Ctrl+Space). All these options are valid ways to highlight data.
72
To copy formatting from one area in a worksheet and apply it to another area you would use:
✅ Correct Answer:The Format Painter button on the standard toolbar
Explanation: The 'Format Painter' (paintbrush icon) is the dedicated tool for this. You select the cell with the formatting you like, click the Format Painter button, and then paint (click) over the new cells. This copies fonts, colors, borders, and other styles instantly.
73
When the formula bar is active, you can see
✅ Correct Answer:All of the above
Explanation: When you start typing in a cell or the formula bar, three icons appear to the left of the bar: The 'Cancel' button (X), the 'Enter' button (Checkmark), and the 'Insert Function/Edit Formula' button (fx). All three become visible during active editing.
74
Which button do you click to add up a series of numbers?
✅ Correct Answer:The autosum button
Explanation: The 'AutoSum' button (represented by the Greek letter Sigma: Σ) is the quickest way to sum a column or row of numbers. Clicking it once inserts the SUM formula and guesses the range; clicking it twice calculates the total immediately.
75
To activate the previous cell in a pre-selected range, press
✅ Correct Answer:None of these
Explanation: To move forward in a range, you press 'Tab'. To move backward (to the previous cell), the shortcut is 'Shift + Tab'. Since 'Shift + Tab' is not listed in the options A, B, or C, the correct answer is 'None of these'.
76
Hyperlinks can be
✅ Correct Answer:All of above
Explanation: Excel allows you to turn almost any object into a clickable link. You can add a hyperlink to a specific text string inside a cell, or you can attach links to shapes (drawing objects), images, and buttons. Clicking any of these will take the user to the destination.
77
You can use the horizontal and vertical scroll bars to
✅ Correct Answer:View different rows and columns edit the contents of a cell
Explanation: Scroll bars allow you to navigate the viewable area of the spreadsheet. The Vertical bar lets you see different Rows (up/down), and the Horizontal bar lets you see different Columns (left/right). (Note: The option B text in the book seems to contain a typo merging two phrases, but it is the intended correct answer for navigation).
78
Which is used to perform what if analysis?
✅ Correct Answer:All of above
Explanation: Excel provides a suite of 'What-If Analysis' tools. 'Goal Seek' finds the input for a specific output. 'Scenario Manager' allows comparing different sets of inputs. 'Solver' is an advanced add-in for optimization problems. All three are used to analyze how changes in data affect outcomes.
79
Comments put in cells are called
✅ Correct Answer:Celltip
Explanation: In some older computer terminology and specific exam banks, Excel comments were referred to as 'Celltips' (similar to Tooltips), because they pop up when you hover over the cell. In modern Excel, they are simply called 'Comments' or 'Notes'.
80
The name box
✅ Correct Answer:Appears to the left of the formula bar
Explanation: The Name Box is a key interface element located directly to the left of the Formula Bar. It displays the address of the currently selected cell (e.g., 'A1') or the name of a named range. You can also type an address into it to jump to that cell.