Question 1

You can add an image to a template by clicking the Insert Picture From File button on the ______ Toolbar.

Accepted Answer

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.

Question 2

What do we call a computer program that organizes data in rows and columns of cells?

Accepted Answer

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.

Question 3

You can use the horizontal and vertical scroll bars to

Accepted Answer

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).

Question 4

Hyperlinks cannot be

Accepted Answer

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.

Question 5

When you work with large worksheets, you may need to

Accepted Answer

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.

Question 6

How do you change column width to fit the contents?

Accepted Answer

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.

Question 7

The Name box

Accepted Answer

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.

Question 8

Charts tips can

Accepted Answer

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.

Question 9

When integrating MS-Word and Excel, Word is usually the

Accepted Answer

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).

Question 10

To center worksheet titles across a range of cell, you must

Accepted Answer

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).

Question 11

To insert three columns between columns D and E you would

Accepted Answer

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.

Question 12

What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

Accepted Answer

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.

Question 13

Which of the following is not a basic step in creating a worksheet?

Accepted Answer

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.

Question 14

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

Accepted Answer

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.

Question 15

When you use the fill effects in the format data series dialog box, you can not

Accepted Answer

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.

Question 16

Which of the following describes how to select all the cells in a single column?

Accepted Answer

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.

Question 17

Got functions? No? You need the insert function dialog box. How do you get it?

Accepted Answer

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.

Question 18

What term refers to a specific set of values saved with the workbook?

Accepted Answer

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.

Question 19

Which of the following setup options cannot be set in the page setup dialog box?

Accepted Answer

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.

Question 20

You can activate a cell by

Accepted Answer

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.

MS Excel MCQs