Microsoft Excel 2003 Test: Quiz!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Zerina
Z
Zerina
Community Contributor
Quizzes Created: 1 | Total Attempts: 938
| Attempts: 938
SettingsSettings
Please wait...
  • 1/15 Questions

    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
Please wait...
About This Quiz


What do you know about Microsoft Excel 2003? As it concerns this quiz, you should be aware of which option allows you to delete a spreadsheet from a workbook, which option will not allow you to copy a cell on an Excel sheet, what is the active cell indicated by, and what is the easiest way to select a column. This quiz will reveal your knowledge of Microsoft Excel 2003. Good luck.

Microsoft Excel 2003 Test: Quiz! - Quiz

Quiz Preview

  • 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

    Correct Answer
    A. Right click on spreadsheet tab and select "delete"
    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.

    Rate this question:

  • 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

    Correct Answer
    A. Right click and select "insert"
    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.

    Rate this question:

  • 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

    Correct Answer
    A. B1:G10
    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.

    Rate this question:

  • 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

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

    Rate this question:

  • 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

    Correct Answer
    A. A dark wide border
    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.

    Rate this question:

  • 7. 

    The default orientation for the printed page is:

    • Portrait

    • Landscape

    • Whatever was last used

    Correct Answer
    A. Portrait
    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.

    Rate this question:

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

    Correct Answer
    A. =(D4+C2)*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.

    Rate this question:

  • 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

    Correct Answer
    A. Click the column heading
    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.

    Rate this question:

  • 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

    Correct Answer
    A. Data | Sort
    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.

    Rate this question:

  • 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

    Correct Answer
    A. The date is increased by 1 day into each cell
    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.

    Rate this question:

  • 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

    Correct Answer
    A. Page Break Preview
    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.

    Rate this question:

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

    Correct Answer
    A. Only the cells with white background will print.
    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.

    Rate this question:

  • 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

    Correct Answer
    A. The column is too narrow to show all the digits of the 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.

    Rate this question:

  • 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

    Correct Answer
    A. A formula which will add values in the range Excel guesses you want to add
    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.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 01, 2012
    Quiz Created by
    Zerina
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.