Microsoft Excel 2003 Test: Quiz!

To print just part of a sheet, you can select the specific content that you want to print and then choose the "Print selection" option in the Print dialog. This allows you to print only the selected portion of the sheet instead of the entire sheet. Therefore, the statement "True" is correct.

The correct answer is "Right click on spreadsheet tab and select 'delete'". This option allows you to delete a spreadsheet from a workbook by right-clicking on the spreadsheet tab and selecting the "delete" option. This action will remove the selected spreadsheet from the workbook. The other options mentioned do not provide the specific method to delete a spreadsheet.

The option "Right click and select 'insert'" will not allow you to copy a cell. Inserting a cell refers to adding a new cell into a spreadsheet, not copying an existing cell. Therefore, this option is not related to the action of copying a cell.

The correct answer is B1:G10 because the colon (:) is used to indicate a range of cells. In this case, the range starts from cell B1 and goes over to column G, and down to row 10. The colon separates the starting cell (B1) from the ending cell (G10), indicating that all cells within that range are included.

The settings to wrap text in a cell and to merge cells are found in the Format Cells dialog on the Alignment tab.

The active cell on an Excel sheet is indicated by a dark wide border. This border helps to visually distinguish the active cell from the rest of the cells on the sheet. It allows the user to easily identify which cell they are currently working on or editing. The dark wide border is a common feature in spreadsheet software and is widely used to indicate the active cell.

The default orientation for a printed page is portrait. This means that the page is taller than it is wide. Portrait orientation is commonly used for documents such as letters, reports, and essays. It is the standard orientation for most printers and word processing software. Landscape orientation, on the other hand, is wider than it is tall and is often used for documents such as spreadsheets, presentations, and graphics. "Whatever was last used" is not the default orientation, but rather a setting that remembers the last orientation used for convenience.

The correct formula to add the value of cell D4 to the value of C2 and then multiply by the value in B2 is =(D4+C2)*B2. This formula first adds the values of D4 and C2 together, and then multiplies the result by the value in B2.

To select a column, the easiest method is to click the column heading. This is because the column heading represents the entire column and clicking on it automatically selects the entire column. This method is simple and efficient as it allows the user to quickly select the desired column without having to manually drag or double-click on individual cells.

To arrange rows in alphabetical order based on column A, you need to use the command "Data | Sort". This command allows you to sort the data in a spreadsheet based on a specific column, in this case, column A. It provides the functionality to organize the rows in alphabetical order, making it easier to analyze and find specific information within the data.

When you select a cell with a date in it and drag the fill handle down across several cells, the date is increased by 1 day into each cell. This is because Excel automatically increments the date by one day for each cell as you drag the fill handle.

The "Page Break Preview" view in a print preview puts a blue line around each page that would be printed. This view allows the user to see how the content is divided into pages and where the page breaks occur. It is useful for adjusting the layout and formatting of the document to ensure that the content is appropriately distributed across the pages when printed.

When you click the Print button, only the cells with a white background will print. This is because the Page Break Preview shows that cells in Rows 1-25 have a white background, indicating that they are set to print. On the other hand, the cells in Row 26 that contain data have a dark gray background, suggesting that they are not set to print. Therefore, only the cells with a white background will be included in the printout.

If a cell shows "#######", it means that the column is too narrow to show all the digits of the number. This is because when a number is too wide to fit within the width of the column, Excel displays a series of pound signs (######) to indicate that the cell is not wide enough to display the full number.

When you use the AutoSum button, it will automatically insert a formula in the selected cell that adds up the values in the range of cells that Excel predicts you want to add. This feature is helpful for quickly calculating the sum of a column or row without manually typing the formula.