MS Excel 2003 Proficiency Quiz: Trivia!

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 Tjz0818
T
Tjz0818
Community Contributor
Quizzes Created: 1 | Total Attempts: 4,556
| Attempts: 4,558
SettingsSettings
Please wait...
  • 1/19 Questions

    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
    • 1:10:B:G
Please wait...
About This Quiz

Test your proficiency in MS Excel 2003 with this trivia quiz! It covers essential functions like deleting spreadsheets, identifying active cells, selecting columns, understanding cell references, and utilizing the autosum feature. Perfect for enhancing your Excel skills and preparing for certification exams.

MS Excel 2003 Proficiency Quiz: Trivia! - Quiz

Quiz Preview

  • 2. 

    Which of the following allows you to delete a spreadsheet from a workbook?

    • Left click on the spreadsheet tab and press delete

    • Right click on spreadsheet tab and select "delete"

    • Press control and click the spreadsheet tab

    • None of the above

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

  • 3. 

    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:

  • 4. 

    On an excel spreadsheet 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 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:

  • 5. 

    To Select a column the easiest method is to?

    • Double-click any cell in the column

    • Drag from the top of the cell i the colmn to the last cell in the column

    • Click the column heading

    • Click the column label

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

  • 6. 

    The default orientation for the printed page is?

    • Portrait

    • Landscape

    • Whatever was last used

    • Normal

    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, similar to a typical piece of paper.

    Rate this question:

  • 7. 

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

    • Tools/sort

    • Data/sort

    • Edit/data/sort

    • None of the above

    Correct Answer
    A. Data/sort
    Explanation
    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 you select a cell with a date in it and drag the fill handle down and 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 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:

  • 9. 

    How can you show data which was previously hidden?

    • Right click and select unhide

    • Go to options and click unhide

    • Hold down H and click the cell

    • None of the above

    Correct Answer
    A. Right click and select unhide
    Explanation
    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:

  • 10. 

    What best describes a pivot table?

    • A useful tool for giving extra details on tables

    • A useful tool for organizing data

    • A useful tool for quickly rearanging data to meet your needs

    • A annoying function which serves no purpose

    Correct Answer
    A. A useful tool for quickly rearanging data to meet your needs
    Explanation
    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:

  • 11. 

    What is the best describes the purpose of a macro?

    • Quickly sort data

    • Show data in easy to analyse ways

    • Make a chart quickly

    • Perform multiple functions quickly and easily

    • Both A and B

    Correct Answer
    A. Perform multiple functions quickly and easily
    Explanation
    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:

  • 12. 

    What is the difference between filter and sort?

    • Sorting arranges and hides data

    • Filtering just arranges data

    • Sorting can handle multiple criteria

    • Filtering hides data as well as can sort

    Correct Answer
    A. Filtering hides data as well as can sort
    Explanation
    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:

  • 13. 

    When can conditional formating be most useful.

    • To add values together

    • To change font sizes

    • To use unique formating options

    • To highlight cells if conditions are met

    Correct Answer
    A. To highlight cells if conditions are met
    Explanation
    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. 

    The "view" that puts a blue line around each page that would be printed is the

    • Print privew

    • Normal

    • Page break preview

    • None of the above

    Correct Answer
    A. Page break preview
    Explanation
    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:

  • 15. 

    The formula that will add D4 to the product of B1 plus B2 is

    • D4 + (B1+B2)

    • =D4+(B1*B2)

    • D4+B1*B2

    • =D4+(B1 + B2)

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

  • 16. 
    Why is this pivot chart showing only 1 for over 90 on all accounts? Why - ProProfs

    Why is this pivot chart showing only 1 for over 90 on all accounts? Why

    • The columns and rows are switched

    • There is no filter on

    • The sum of values over 90 shouldnt be selected

    • The Values box should be sum not count

    Correct Answer
    A. The Values box should be sum not count
    Explanation
    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:

  • 17. 

    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 colmn is too narrow to show all the digits of the number

    • Either B or C

    Correct Answer
    A. The colmn 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 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:

  • 18. 

    Using the autosum button will place in the selected cell.

    • The sum of the values in the cell column

    • Nothing untill you select a range

    • The sum of the cells 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
    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:

  • 19. 
    What is wrong with the following function arguments - ProProfs

    What is wrong with the following function arguments

    • The range lookup should never be 0

    • The column value should only be 1 since the lookup consist of only 1 column

    • The lookup value and table array should be switched

    • There is nothing wrong with the Function

    • Both B and C

    Correct Answer
    A. The lookup value and table array should be switched
    Explanation
    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:

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

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 11, 2009
    Quiz Created by
    Tjz0818
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.