You can add an image to a template by clicking the Insert Picture From File button on the ______ Toolbar.
✅ Correct Answer:Picture
Explanation: In older versions of Excel (like 2003), there was a specific toolbar called the 'Picture' toolbar that appeared when dealing with images. It contained buttons for inserting pictures from files, adjusting brightness, and cropping. In modern Excel, this is done via the Insert Tab > Pictures.
182
What do we call a computer program that organizes data in rows and columns of cells?
✅ Correct Answer:Spreadsheet program
Explanation: A 'Spreadsheet program' (like Microsoft Excel, Google Sheets) is specifically defined by its grid layout of Rows and Columns forming Cells. While databases also store data, the visual grid interface for calculation and analysis is the hallmark of a spreadsheet.
183
You can use the horizontal and vertical scroll bars to
✅ Correct Answer:View different rows and columns
Explanation: Scroll bars are strictly navigation tools. The Vertical scroll bar allows you to move up and down to see different Rows, while the Horizontal scroll bar moves left and right to see different Columns. They do not edit data or switch between worksheet tabs (which is done via the Sheet Tabs at the bottom).
184
Hyperlinks cannot be
✅ Correct Answer:All can be hyperlinks
Explanation: Excel is very flexible with hyperlinks. You can attach a clickable link to almost any object, including Text, Cells, Pictures, Shapes (rectangles, stars), and SmartArt. Therefore, the statement 'All can be hyperlinks' is the correct description of Excel's capabilities.
185
When you work with large worksheets, you may need to
✅ Correct Answer:all of above
Explanation: Handling large Excel datasets for printing requires specific formatting tools. You might need to 'Scale to Fit' (e.g., fit all columns on one page), manually insert 'Page Breaks' to split data logically, or set a 'Print Area' to print only the relevant table and ignore the rest of the sheet.
186
How do you change column width to fit the contents?
✅ Correct Answer:Double click the boundary to the right of the column heading
Explanation: The fastest way to 'AutoFit' a column so that it is wide enough to show all its content is to Double-Click the boundary line on the right side of the column header (e.g., the line between A and B). This automatically adjusts the width to fit the longest entry in that column.
187
The Name box
✅ Correct Answer:Appears to the left of the formula bar
Explanation: The Name Box is the small input field located at the top-left of the Excel sheet, directly to the left of the Formula Bar. It displays the address of the currently active cell (e.g., A1) or the name of the selected range if it has a defined name.
188
Charts tips can
✅ Correct Answer:B and C
Explanation: When you hover your mouse pointer over any part of a chart in Excel, a small tooltip (Chart Tip) appears. It displays specific details like the 'Name of the Data Series' (e.g., Sales 2023) and the exact 'Value of the Data Point' (e.g., 5000), helping you read the chart accurately.
189
When integrating MS-Word and Excel, Word is usually the
✅ Correct Answer:Client
Explanation: This refers to OLE (Object Linking and Embedding). When you put Excel data into a Word document, Excel holds the original data (making it the Source or Server), and Word displays/consumes the data (making it the Destination or Client).
190
To center worksheet titles across a range of cell, you must
✅ Correct Answer:Select the cells containing the title text and click Merge and Center
Explanation: The correct way to center a title (e.g., in cell A1) across a range (e.g., A1 to E1) is to select the cells (A1:E1) and click the 'Merge and Center' button on the toolbar. (Note: The book option mentions 'fill handle' which is incorrect; we have corrected the answer here for your website to be accurate).
191
To insert three columns between columns D and E you would
✅ Correct Answer:Select columns E, F and G
Explanation: In Excel, columns are always inserted to the 'Left' of the selection. To insert 3 columns between D and E (meaning, before E), you must start selecting from E. Since you want 3 new columns, you must select 3 existing columns (E, F, and G). Then right-click and choose Insert.
192
What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
✅ Correct Answer:Select both cells, and then drag the fill handle over the range you want
Explanation: To create a sequence (like 1, 2, 3...), you must type the first two numbers (1 and 2) to establish the pattern. Then, select BOTH cells and drag the Fill Handle (small square at the bottom right) down. Excel will recognize the step value (1) and extend the series to 20 automatically.
193
Which of the following is not a basic step in creating a worksheet?
✅ Correct Answer:Copy the worksheet
Explanation: The fundamental lifecycle of creating a worksheet involves: 1. Entering data/text, 2. Modifying/Formatting it, and 3. Saving the work. 'Copying the worksheet' is a file management or duplication task, not a core step in the creation process itself.
194
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
✅ Correct Answer:Speed
Explanation: Paper spreadsheets (ledgers) have rows, columns, and headings just like Excel. However, the biggest advantage of an electronic spreadsheet (Excel) is 'Speed'. If you change one number in Excel, all formulas update instantly. On paper, you would have to manually erase and recalculate everything, which is very slow.
195
When you use the fill effects in the format data series dialog box, you can not
✅ Correct Answer:rotate text on the chart
Explanation: Fill Effects are used to change the visual look of chart elements, such as adding Gradients, Textures, Patterns, or Colors (foreground/background). However, 'Rotating Text' is an Alignment setting, not a Fill effect. To rotate text, you would go to the Alignment tab, not the Fill tab.
196
Which of the following describes how to select all the cells in a single column?
✅ Correct Answer:Left click on the gray column title button
Explanation: To select an entire column (from row 1 to 1,048,576), you simply click on the Column Header (the gray box with the letter, e.g., 'A', 'B'). Ctrl + A selects the whole sheet, not just one column. 'Pick from list' is for auto-complete, not selection.
197
Got functions? No? You need the insert function dialog box. How do you get it?
✅ Correct Answer:Click the insert menu and then click function
Explanation: To open the Insert Function dialog box (which helps you find and use functions like SUM, AVERAGE), you can go to the Insert menu and select Function (in older Excel) or click the 'fx' button next to the formula bar. You can also press 'Shift + F3'. Simply typing '=' starts a formula but doesn't open the helper dialog.
198
What term refers to a specific set of values saved with the workbook?
✅ Correct Answer:Scenario
Explanation: A 'Scenario' in Excel is a set of saved input values that you can substitute in calculations. For example, you can create a 'Best Case' scenario and a 'Worst Case' scenario. By switching between them, Excel updates the results without you having to re-type the numbers every time.
199
Which of the following setup options cannot be set in the page setup dialog box?
✅ Correct Answer:Printer selection
Explanation: The Page Setup dialog box handles layout settings like Margins, Orientation (Portrait/Landscape), Paper Size, and Sheet options (like print titles). However, selecting a specific 'Printer' is done in the 'Print' dialog box (Ctrl + P), not inside Page Setup.
200
You can activate a cell by
✅ Correct Answer:All of above
Explanation: Activating a cell means making it the 'Active Cell' (where data will be entered). You can do this by clicking it with the mouse, moving to it with Arrow keys, or using the Tab key (which moves selection to the right). Therefore, all the listed methods effectively activate a cell.