Microsoft Excel 2003 Test: Quiz!
(142).jpg "Microsoft Excel 2003 Test: Quiz! - 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.
- 1.
Which option allows you to delete a spreadsheet from a workbook?
- A.
Left click on spreadsheet tab and press delete
- B.
Right click on spreadsheet tab and select "delete"
- C.
Press "Ctrl" and the spreadsheet tab
- D.
None of the above
Correct Answer
B. 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:
-
- 2.
Which option will NOT allow you to copy a cell?
- A.
Right click and select "copy"
- B.
Right click and select "insert"
- C.
Go to "Edit" and select "copy"
- D.
None of the above
Correct Answer
B. 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:
-
- 3.
On an Excel sheet, the active cell is indicated by:
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A dark wide borderExplanation
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:
-
- 4.
To select a column the easiest method is to:
- A.
Double-click any cell in the column
- B.
Drag from the top cell in the column to the last cell in the column
- C.
Click the column heading
- D.
Click the column label
Correct Answer
C. Click the column headingExplanation
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:
-
- 5.
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:
- A.
B1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
Correct Answer
D. B1:G10Explanation
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:
-
- 6.
The "view" that puts a blue line around each page that would be printed in the:
- A.
Print Preview
- B.
Normal
- C.
Page Break Preview
- D.
None of the above
Correct Answer
C. Page Break PreviewExplanation
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:
-
- 7.
Using the AutoSum button will place in the selected cell.
- A.
The sum of values in the cell's column
- B.
Nothing until you select a range of cells
- C.
The sum of the cell's row unless you change the range
- D.
A formula which will add values in the range Excel guesses you want to add
Correct Answer
D. A formula which will add values in the range Excel guesses you want to addExplanation
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:
-
- 8.
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,
- A.
Nothing will print because some cells with data have been omitted
- B.
Only the cells with gray background will print
- C.
The whole sheet will print
- D.
Only the cells with white background will print.
Correct Answer
D. 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:
-
- 9.
To arrange rows in alphabetical order based on column A, you need to use the command.
- A.
Tools | Sort
- B.
Data | Sort
- C.
Edit | Data | Sort
- D.
None of the above
Correct Answer
B. Data | SortExplanation
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:
-
- 10.
If a cell shows ####### , it means that:
- A.
Your formula has a syntax error
- B.
The row is too short to show the number at the current font size
- C.
The column is too narrow to show all the digits of the number
- D.
Either b or c
Correct Answer
C. The column is too narrow to show all the digits of the numberExplanation
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:
-
- 11.
The default orientation for the printed page is:
- A.
Portrait
- B.
Landscape
- C.
Whatever was last used
Correct Answer
A. PortraitExplanation
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:
-
- 12.
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 13.
The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is:
- A.
(D4+C2)*B2
- B.
D4+C2*B2
- C.
=(D4+C2)*B2
- D.
=(B2*(D4+C2)
Correct Answer
C. =(D4+C2)*B2Explanation
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:
-
- 14.
If you select a cell with a date in it and drag the fill handle down across several cells, what happens is:
- A.
The date is copied to each cell
- B.
The date is increased by 1 day into each cell
- C.
The date is increased by 1 week into each cell
- D.
Nothing as AutoFill applies only to numbers
Correct Answer
B. The date is increased by 1 day into each cellExplanation
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:
-
- 15.
The settings to wrap text in a cell and to merge cells are found in the Format Cells dialog on the _____ tab.
- A.
Number
- B.
Alignment
- C.
Font
- D.
Border
Correct Answer
B. AlignmentExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 01, 2012Quiz Created by
Zerina
Back to top