When a label is too long to fit within a worksheet cell, you typically must
✅ Correct Answer:Increase the column width
Explanation: If text (a label) is too long and the next cell is not empty, the text gets cut off. The standard solution is to 'Increase the column width' so the full text is visible. You can do this by double-clicking the column boundary (AutoFit) or dragging it manually.
82
When integrating word and excel, word is usually the
✅ Correct Answer:Both B and C
Explanation: In OLE (Object Linking and Embedding) terms, the application that holds the original data (Excel) is the 'Server' or Source. The application that receives and displays the data (Word) is called the 'Client' or 'Destination'. Therefore, Word acts as both the Client and the Destination for the data.
83
How can you find specific information in a list?
✅ Correct Answer:Select Data> Form from the menu to open the Data Form dialog box and click the Criteria button
Explanation: This refers to the classic 'Data Form' feature for managing lists. By opening the Data Form and clicking the 'Criteria' button, you can type specific search terms (like 'Sales > 5000') to filter and find records within your list without using complex filters.
84
How do you delete a column?
✅ Correct Answer:Right click the column heading you want to delete and select delete from the shortcut menu
Explanation: The fastest way to delete a column is to Right-Click its letter heading (e.g., Column 'D'). This opens the context menu where you can simply click 'Delete'. This action removes the entire column and shifts the remaining columns to the left to fill the gap.
85
To center worksheet titles across a range of cells, you must
✅ Correct Answer:Select the cells containing the title text plus the range over which the title text is to be centered
Explanation: This describes the 'Merge and Center' operation. First, you write the title in the first cell (e.g., A1). Then, you select that cell AND the empty cells next to it (e.g., A1 to E1). Finally, you click the 'Merge and Center' button, which centers the text across the entire selected block.
86
To create a formula, you first:
✅ Correct Answer:Select the cell you want to place the formula into
Explanation: The very first logical step to creating a formula is to 'Select the cell' where you want the result to appear. You cannot type the equals sign (=) or start the formula until you have clicked on or navigated to the target cell.
87
How can you print three copies of a workbook?
✅ Correct Answer:Select File >Print from the menu and type 3 in the Number of copies text box.
Explanation: To print multiple copies, you use the standard Print dialog box (File > Print or Ctrl+P). Inside this dialog, there is a clearly labeled 'Number of copies' field where you can type '3'. The standard toolbar Print button usually sends just one copy immediately to the default printer without asking.
88
How do you select an entire column?
✅ Correct Answer:Click the column heading letter
Explanation: To select an entire column (from row 1 to the very last row) instantly, you simply click on the 'Column Heading' (the box with the letter, like 'A', 'B', 'C' at the top). This highlights the whole vertical strip. Holding Ctrl or Shift is used for selecting multiple specific cells, not a whole column with one click.
89
Which of the following is not a basic step in creating a worksheet?
✅ Correct Answer:Copy the worksheet
Explanation: The core lifecycle of creating a spreadsheet involves: 1. Entering Data, 2. Modifying/Formatting that data to make it useful, and 3. Saving the workbook to preserve it. 'Copying the worksheet' is a file management or duplication task, not a fundamental step in the creation process itself.
90
How do you insert a row?
✅ Correct Answer:All of the above
Explanation: Excel provides multiple ways to perform common tasks. To insert a row, you can use the Context Menu (Right-click row header > Insert), the Main Menu (Insert > Rows in older Excel), or Toolbar buttons. All listed options describe valid methods to add a new row.
91
Text formulas:
✅ Correct Answer:Concatenate and manipulate text
Explanation: Text formulas in Excel are used to handle strings of characters. The most common operation is 'Concatenation' (joining text using & or the CONCAT function), but they can also manipulate text (like LEFT, RIGHT, MID, UPPER) to clean up or reformat data.
92
You can activate a cell by
✅ Correct Answer:All of the above
Explanation: Activating a cell means moving the selection focus to it so you can type. You can do this by navigating with the keyboard (Tab moves right, Arrow keys move in respective directions) or by directly clicking the desired cell with the mouse. All methods are valid.
93
Which of the following is not a way to complete a cell entry?
✅ Correct Answer:Pressing spacebar
Explanation: Pressing the Spacebar does not complete or save the cell entry; it simply adds a space character into the text you are typing. To finish/commit the entry, you must press Enter, Tab, an Arrow key, or click the checkmark icon (Enter button) on the Formula bar.
94
Which of the following will not cut information?
✅ Correct Answer:Pressing Ctrl + C
Explanation: The shortcut 'Ctrl + C' is for 'Copy', which duplicates the information to the clipboard while leaving the original intact. 'Cut' (which removes the original) is performed by 'Ctrl + X', the Cut button (scissors), or the Edit > Cut menu.
95
Which of the following methods cannot be used to enter data in a cell
✅ Correct Answer:Pressing the Esc key
Explanation: Pressing Arrow keys, Tab, or Enter will 'commit' (save) what you typed into the cell. Clicking the formula bar allows you to type. However, pressing 'Esc' cancels the action. Therefore, Esc cannot be used to 'enter' data; it is used to 'avoid' entering data.
96
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you
✅ Correct Answer:Press Esc
Explanation: The 'Esc' (Escape) key is the 'Cancel' button for Excel data entry. If you are halfway through typing a formula or data and change your mind, pressing Esc aborts the entry completely and reverts the cell to its previous state (or leaves it empty if it was new).
97
Which of the following methods cannot be used to edit the contents of a cell?
✅ Correct Answer:Press the Alt key
Explanation: You can edit a cell by Double-clicking it, pressing F2, or clicking inside the Formula Bar. However, pressing the 'Alt' key on its own activates the Menu Bar or Ribbon Key Tips (shortcuts for menu items) and does not put the cell into 'Edit Mode'.
98
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
✅ Correct Answer:Press Ctrl +Home
Explanation: The 'Ctrl + Home' shortcut is the universal navigation command in Excel to instantly jump to the very beginning of the worksheet (Cell A1), regardless of how far down or right you have scrolled. Pressing just 'Home' usually takes you to the start of the current row, not A1.
99
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
✅ Correct Answer:Line chart
Explanation: Line charts are specifically designed to show trends over time. When tracking stock market prices (continuous data) day by day, a Line chart connects the data points, making it easy to visualize the ups and downs (trends) of the market. Pie charts are for parts of a whole, not trends.
100
Which of the following options is not located in the Page Setup dialog box?
✅ Correct Answer:Page Break Preview
Explanation: The Page Setup dialog box contains tabs for Page (Orientation), Margins, Header/Footer, and Sheet settings. 'Page Break Preview', however, is a 'View Mode'. You access it via the View menu or View tab to see how pages will split; it is not a setting inside the Page Setup dialog itself.