Microsoft Excel 2003 Test: Quiz!

1. To print just part of a sheet, you would select what you want to print and select Print selection in the Print dialog and then print.

True

False

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.

Explanation

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.

2. Which option allows you to delete a spreadsheet from a workbook?

Left click on spreadsheet tab and press delete

Right click on spreadsheet tab and select "delete"

Press "Ctrl" and the spreadsheet tab

None of the above

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.

Explanation

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.

3. Which option will NOT allow you to copy a cell?

Right click and select "copy"

Right click and select "insert"

Go to "Edit" and select "copy"

None of the above

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.

Explanation

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.

4. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is:

B1-G10

B1.G10

B1;G10

B1:G10

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.

Explanation

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.

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

Number

Alignment

Font

Border

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

Explanation

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

6. On an Excel sheet, the active cell is indicated by:

A dark wide border

A dotted border

A blinking border

None of the above

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.

Explanation

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.

7. The default orientation for the printed page is:

Portrait

Landscape

Whatever was last used

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.

Explanation

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.

8. The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is:

(D4+C2)*B2

D4+C2*B2

=(D4+C2)*B2

=(B2*(D4+C2)

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.

Explanation

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.

9. To select a column the easiest method is to:

Double-click any cell in the column

Drag from the top cell in the column to the last cell in the column

Click the column heading

Click the column label

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.

Explanation

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.

10. To arrange rows in alphabetical order based on column A, you need to use the command.

Tools | Sort

Data | Sort

Edit | Data | Sort

None of the above

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.

Explanation

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.

11. If you select a cell with a date in it and drag the fill handle down across several cells, what happens is:

The date is copied to each cell

The date is increased by 1 day into each cell

The date is increased by 1 week into each cell

Nothing as AutoFill applies only to numbers

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.

Explanation

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.

12. The "view" that puts a blue line around each page that would be printed in the:

Print Preview

Normal

Page Break Preview

None of the above

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.

Explanation

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.

13. A spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have a white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button,

Nothing will print because some cells with data have been omitted

Only the cells with gray background will print

The whole sheet will print

Only the cells with white background will print.

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.

Explanation

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.

14. If a cell shows ####### , it means that:

Your formula has a syntax error

The row is too short to show the number at the current font size

The column is too narrow to show all the digits of the number

Either b or c

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.

Explanation

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.

15. Using the AutoSum button will place in the selected cell.

The sum of values in the cell's column

Nothing until you select a range of cells

The sum of the cell's row unless you change the range

A formula which will add values in the range Excel guesses you want to add

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.

Explanation

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.