MS Excel 2003 Proficiency Quiz: Trivia!
(181).jpg "MS Excel 2003 Proficiency Quiz: Trivia! - Quiz")
.
- 1.
Which of the following allows you to delete a spreadsheet from a workbook?
- A.
Left click on the spreadsheet tab and press delete
- B.
Right click on spreadsheet tab and select "delete"
- C.
Press control and click the spreadsheet tab
- D.
None of the above
Correct Answer
B. Right click on spreadsheet tab and select "delete"Explanation
To delete a spreadsheet from a workbook, you can right-click on the spreadsheet tab and select "delete". This option allows you to easily remove a specific spreadsheet from the workbook without affecting the others. Left-clicking on the tab and pressing delete may not have the same effect, as it could simply select the tab without providing an option to delete it. Pressing control and clicking the spreadsheet tab is not a valid method to delete a spreadsheet. Therefore, the correct answer is to right-click on the spreadsheet tab and select "delete".Rate this question:
-
- 2.
On an excel spreadsheet 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 spreadsheet is indicated by a dark wide border. This border helps to identify which cell is currently selected and allows the user to perform actions such as entering data or applying formatting specifically to that cell. The dark wide border stands out from the other cells, making it easy to locate and work with the active cell.Rate this question:
-
- 3.
To Select a column the easiest method is to?
- A.
Double-click any cell in the column
- B.
Drag from the top of the cell i the colmn to the last cell in the column
- C.
Click the column heading
- D.
Click the column label
Correct Answer
C. Click the column headingExplanation
The easiest method to select a column is by clicking the column heading. This is because the column heading represents the entire column and clicking on it automatically selects the entire column. It is a straightforward and efficient way to select a column in a spreadsheet or any other tabular data format.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
- A.
B1.G10
- B.
B1-G10
- C.
B1:G10
- D.
1:10:B:G
Correct Answer
C. B1:G10Explanation
The correct answer is B1:G10. This is the correct cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10. The ":" symbol is used to indicate a range, and the starting cell is specified before the ":" symbol, while the ending cell is specified after the ":" symbol.Rate this question:
-
- 5.
The "view" that puts a blue line around each page that would be printed is the
- A.
Print privew
- B.
Normal
- C.
Page break preview
- D.
None of the above
Correct Answer
C. Page break previewExplanation
Page break preview is the correct answer because it is a view in which you can see how the pages of your document will be divided when printed. It shows a blue line around each page that would be printed, indicating where the page breaks will occur. This view is useful for adjusting page breaks and formatting to ensure that the document prints correctly. The other options, Print preview and Normal view, do not specifically show the page breaks in this manner.Rate this question:
-
- 6.
Using the autosum button will place in the selected cell.
- A.
The sum of the values in the cell column
- B.
Nothing untill you select a range
- C.
The sum of the cells 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
The correct answer is "a formula which will add values in the range excel guesses you want to add". This is because when you use the autosum button in Excel, it automatically creates a formula that adds up the values in the selected range of cells. Excel guesses the range based on the surrounding data and selects it for you.Rate this question:
-
- 7.
To arrange rows in alphabetical order based on column A you need to use command.
- A.
Tools/sort
- B.
Data/sort
- C.
Edit/data/sort
- D.
None of the above
Correct Answer
B. Data/sortExplanation
The correct answer is "data/sort" because the command to arrange rows in alphabetical order based on column A is typically found in the "data" menu. Using the "sort" command under the "data" menu allows you to sort the rows in a dataset based on a specific column, in this case, column A.Rate this question:
-
- 8.
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 colmn is too narrow to show all the digits of the number
- D.
Either B or C
Correct Answer
C. The colmn 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 occurs when the number in the cell is too wide to fit within the column width. Increasing the column width will allow the full number to be displayed in the cell.Rate this question:
-
- 9.
The default orientation for the printed page is?
- A.
Portrait
- B.
Landscape
- C.
Whatever was last used
- D.
Normal
Correct Answer
A. PortraitExplanation
The default orientation for a printed page is portrait. This means that the page is taller than it is wide, similar to a typical piece of paper.Rate this question:
-
- 10.
The formula that will add D4 to the product of B1 plus B2 is
- A.
D4 + (B1+B2)
- B.
=D4+(B1*B2)
- C.
D4+B1*B2
- D.
=D4+(B1 + B2)
Correct Answer
D. =D4+(B1 + B2)Explanation
The correct answer is =D4+(B1 + B2). This is the correct formula because it adds the value in cell D4 to the sum of the values in cells B1 and B2. The parentheses ensure that the addition of B1 and B2 is done before adding it to D4.Rate this question:
-
- 11.
If you select a cell with a date in it and drag the fill handle down and 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 and drag the fill handle down and across several cells, the date is increased by 1 day into each cell. This is because Excel recognizes the pattern of dates and automatically increments the date by 1 day in each subsequent cell.Rate this question:
-
- 12.
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:
-
- 13.
When can conditional formating be most useful.
- A.
To add values together
- B.
To change font sizes
- C.
To use unique formating options
- D.
To highlight cells if conditions are met
Correct Answer
D. To highlight cells if conditions are metExplanation
Conditional formatting is most useful when we want to highlight cells if certain conditions are met. This feature allows us to apply formatting rules to cells based on their values or the values of other cells. By using conditional formatting, we can easily identify and emphasize specific data that meets certain criteria, making it easier to analyze and interpret the information in a spreadsheet.Rate this question:
-
- 14.
What best describes a pivot table?
- A.
A useful tool for giving extra details on tables
- B.
A useful tool for organizing data
- C.
A useful tool for quickly rearanging data to meet your needs
- D.
A annoying function which serves no purpose
Correct Answer
C. A useful tool for quickly rearanging data to meet your needsExplanation
A pivot table is a useful tool for quickly rearranging data to meet your needs. It allows you to summarize and analyze large amounts of data by organizing it into a more manageable and meaningful format. With a pivot table, you can easily change the layout and structure of the data, making it easier to identify patterns, trends, and relationships. This flexibility and ability to customize the data view make pivot tables a valuable tool for data analysis and decision-making.Rate this question:
-
- 15.
What is wrong with the following function arguments
- A.
The range lookup should never be 0
- B.
The column value should only be 1 since the lookup consist of only 1 column
- C.
The lookup value and table array should be switched
- D.
There is nothing wrong with the Function
- E.
Both B and C
Correct Answer
C. The lookup value and table array should be switchedExplanation
The lookup value and table array should be switched. This means that the function arguments are not in the correct order. The lookup value should be the first argument, followed by the table array. Switching the order of these arguments will ensure that the function works correctly.Rate this question:
-
- 16.
What is the best describes the purpose of a macro?
- A.
Quickly sort data
- B.
Show data in easy to analyse ways
- C.
Make a chart quickly
- D.
Perform multiple functions quickly and easily
- E.
Both A and B
Correct Answer
D. Perform multiple functions quickly and easilyExplanation
The purpose of a macro is to perform multiple functions quickly and easily. Macros are sets of instructions that can be recorded and executed to automate repetitive tasks in software applications. They allow users to save time and effort by automating complex or repetitive actions, making it easier to perform multiple functions with just a few clicks.Rate this question:
-
- 17.
What is the difference between filter and sort?
- A.
Sorting arranges and hides data
- B.
Filtering just arranges data
- C.
Sorting can handle multiple criteria
- D.
Filtering hides data as well as can sort
Correct Answer
D. Filtering hides data as well as can sortExplanation
Filtering is a process that allows the user to selectively display or hide certain data based on specific criteria. It helps in narrowing down the data set to only show the relevant information. On the other hand, sorting arranges the data in a specific order, such as ascending or descending, based on one or more criteria. While both filtering and sorting can arrange data, filtering has the additional capability of hiding certain data that does not meet the specified criteria. Therefore, the answer correctly states that filtering can hide data as well as sort it.Rate this question:
-
- 18.
How can you show data which was previously hidden?
- A.
Right click and select unhide
- B.
Go to options and click unhide
- C.
Hold down H and click the cell
- D.
None of the above
Correct Answer
A. Right click and select unhideExplanation
Right-clicking on a cell and selecting the "unhide" option allows you to display data that was previously hidden. This action brings back any hidden columns, rows, or worksheets that were hidden using the "hide" function.Rate this question:
-
- 19.
Why is this pivot chart showing only 1 for over 90 on all accounts? Why
- A.
The columns and rows are switched
- B.
There is no filter on
- C.
The sum of values over 90 shouldnt be selected
- D.
The Values box should be sum not count
Correct Answer
D. The Values box should be sum not countExplanation
The pivot chart is showing only 1 for over 90 on all accounts because the Values box in the chart is set to count instead of sum. This means that instead of summing up the values over 90 for each account, it is counting the number of occurrences of the value over 90, which is always 1.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 11, 2009Quiz Created by
Tjz0818
Back to top