Microsoft Excel 2007 Quiz: Practice Exam!

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 Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 15,686
| Attempts: 2,362
SettingsSettings
Please wait...
  • 1/122 Questions

    Ctrl+B key makes the shortcut for making font in selected cell bold.

    • True
    • False
Please wait...
About This Quiz

Are you familiar with Microsoft Excel 2007, and would you be interested in answering these questions? In the 2007 version, you can learn how to create a simple budget spreadsheet. You can also format and write formulas. Microsoft Excel includes applications such as Word, Excel, PowerPoint, and Outlook. The application download includes the popular components of each of these programs. If you want to learn more about Microsoft Excel 2007, put your knowledge to the test.

Microsoft Excel 2007 Quiz: Practice Exam! - Quiz

Quiz Preview

  • 2. 

    You can modify an exisiting chart?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Yes, you can modify an existing chart. Charts in various software applications like Microsoft Excel or Google Sheets can be edited and updated with new data or formatting options. This allows users to make changes to the chart's design, data range, labels, colors, and other elements to better represent and analyze the information they want to convey.

    Rate this question:

  • 3. 

    The divide symbol is

    • /

    • D

    • \

    • )

    Correct Answer
    A. /
    Explanation
    The divide symbol is represented by the forward slash symbol (/). It is commonly used in mathematical operations to indicate division.

    Rate this question:

  • 4. 

    An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the user to quickly arrange the data in ascending (A to Z) or descending (Z to A) order based on the selected field. This eliminates the need for manual sorting or using complex sorting algorithms, making it a convenient option for simple sorting tasks.

    Rate this question:

  • 5. 

    Which mathematical operation is performed by the * key in an Excel formula?

    • Multiplication

    • Factorial

    • Power

    • Logical

    Correct Answer
    A. Multiplication
    Explanation
    The * key in an Excel formula is used for multiplication. When you want to multiply two or more numbers together in Excel, you use the * symbol between them. For example, if you want to multiply the numbers in cell A1 and A2, the formula would be =A1*A2. This symbol is specifically used for performing multiplication operations in Excel.

    Rate this question:

  • 6. 

    Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?

    • =ADD(J1-J8)

    • =SUM(J1:J8)

    • =J:1+J:8

    • =SUM J:1-8

    Correct Answer
    A. =SUM(J1:J8)
    Explanation
    The correct answer is =SUM(J1:J8) because the SUM function in Excel is used to add up a range of cells. In this case, we want to find the sum of the cells in column J between rows 1 and 8, so we specify the range J1:J8 within the SUM function. This formula will correctly calculate the sum of the desired cells.

    Rate this question:

  • 7. 

    A worksheet is..

    • A symbol that represents a specific action

    • Refers to the change a formula makes when it is moved or copied to other cells with different data

    • A table of data that is organized into rows and columns

    Correct Answer
    A. A table of data that is organized into rows and columns
    Explanation
    The correct answer is "A table of data that is organized into rows and columns." This answer accurately describes what a worksheet is in the context of computer software, such as Microsoft Excel. A worksheet is a digital document that allows users to input, manipulate, and analyze data. It consists of a grid-like structure with rows and columns, where data can be organized and displayed. This answer distinguishes a worksheet from the other options, which do not accurately describe the purpose or functionality of a worksheet.

    Rate this question:

  • 8. 

    As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When typing a function name within a formula into a cell, a list of functions that begin with the letters you typed appears. This feature is called "AutoComplete" and it helps to suggest and complete the function name based on what you have typed so far. It saves time and helps to avoid spelling errors or forgetting the correct function name.

    Rate this question:

  • 9. 

    What is a workbook made up of?

    • Worksheet

    • Worksheets

    Correct Answer
    A. Worksheets
    Explanation
    A workbook is made up of multiple worksheets. Worksheets are individual tabs within a workbook where users can enter and manipulate data. Each worksheet can contain different sets of data and calculations, allowing users to organize and analyze information in a structured manner. By having multiple worksheets within a workbook, users can easily navigate between different sections or categories of data, making it a versatile tool for data management and analysis.

    Rate this question:

  • 10. 

    After writing the formula you have to press ---------------------------------  key from the keyboard to see the answer.  

    • Enter

    • Shift-Enter

    • Crt-Enter

    Correct Answer
    A. Enter
    Explanation
    After writing the formula, you have to press the "Enter" key from the keyboard to see the answer.

    Rate this question:

  • 11. 

    The function arguments dialog box tells you how to use functions.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The function arguments dialog box provides information on how to use functions. It helps users understand the parameters and inputs required for a function, guiding them on how to correctly use the function in their code. This dialog box typically displays the function name, the type and order of arguments, and any additional information or examples that may be helpful. Overall, the function arguments dialog box serves as a valuable tool for developers to ensure they are using functions correctly and efficiently.

    Rate this question:

  • 12. 

    The _________________ displays the name of the sheets in the workbook.

    • Sheet Tabs

    • Book Tabs

    • Menu Bar

    Correct Answer
    A. Sheet Tabs
    Explanation
    The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook. The sheet tabs are typically located at the bottom of the workbook window and can be clicked on to switch to a different sheet.

    Rate this question:

  • 13. 

    Which number formatting style adds the dollar signs and commas to values?

    • Comma

    • Currency

    • Percent

    • AdjustDecimal

    Correct Answer
    A. Currency
    Explanation
    The currency number formatting style adds dollar signs and commas to values. This formatting style is commonly used when dealing with monetary values to make them easier to read and understand. The dollar sign symbolizes the currency, while the commas are used to separate thousands, millions, etc. This formatting style helps to improve the clarity and presentation of financial data.

    Rate this question:

  • 14. 

    Formatting data only change the appearance of data, it does not affect the data itself.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Formatting data refers to changing the visual representation of data, such as changing font styles, colors, or adding borders. It does not alter the actual values or content of the data. Therefore, the statement that formatting data only changes the appearance of data and does not affect the data itself is true.

    Rate this question:

  • 15. 

    You cannot insert comments on each cell.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Based on the given information, the correct answer is "False". However, without any context or specific question, it is not possible to provide a detailed explanation for why the answer is false.

    Rate this question:

  • 16. 

    You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because Excel has a built-in feature called "External Data" that allows users to import data from a variety of sources, including database tables. Once the data is imported into an Excel worksheet, users can set it to refresh automatically with a single click, ensuring that the results are always up-to-date. This feature is particularly useful for users who need to regularly analyze and report on data from a database without having to manually update the information in Excel.

    Rate this question:

  • 17. 

    What is the function of the autofit ?

    • A symbol that represents a specific action

    • A way of arranging data in a particular order

    • Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

    Correct Answer
    A. Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
    Explanation
    The function of autofit is to automatically change the width of a column to fit the longest entry or change the height of a row to fit the font.

    Rate this question:

  • 18. 

    Microsoft Excel 2007 is a ___________________?

    • Word Processing Package.

    • Graphics Package

    • Spreadsheets Package

    • Multimedia Package

    • None of the above

    Correct Answer
    A. Spreadsheets Package
    Explanation
    Microsoft Excel 2007 is a spreadsheets package. It is a software program that allows users to create, edit, and analyze numerical data using spreadsheets. Excel provides various tools and functions to perform calculations, create charts and graphs, and organize data in a structured format. It is widely used for financial analysis, budgeting, data management, and other tasks that involve working with numbers and data.

    Rate this question:

  • 19. 

    One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file?

    • Template

    • Excel 97-2003 Workbook (*.xls)

    • CSV

    • HTML

    Correct Answer
    A. Excel 97-2003 Workbook (*.xls)
    Explanation
    To ensure that all users can open and edit the file, you should save it in the Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing all users to access and make changes to the file regardless of the version of Excel they are using. Other options like CSV and HTML may not preserve the formatting and functionality of the original Excel file, making the Excel 97-2003 Workbook format the best choice for compatibility.

    Rate this question:

  • 20. 

    You can use a spreadsheets package like the Microsoft Excel To _________________ 

    • Design speadsheets models.

    • Create charts.

    • Perform mathematical operations

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    A spreadsheets package like Microsoft Excel can be used to design spreadsheet models, create charts, and perform mathematical operations. It provides a range of tools and functions that allow users to organize and analyze data effectively. With its ability to handle complex calculations, visualize data through charts, and create models for various purposes, it can be used for all of the mentioned tasks.

    Rate this question:

  • 21. 

    To add two cells (A1 and A2) together you use the following formula

    • =A1+A2

    • =Add(A1+A2)

    • =together(A1:A2)

    • A1 plus A2

    Correct Answer
    A. =A1+A2
    Explanation
    The correct answer is "=A1+A2" because it is the correct formula to add the values of cells A1 and A2 together in Excel. The plus sign (+) is used to indicate addition in Excel formulas, and the equal sign (=) is used to start a formula. By typing "=A1+A2", Excel will calculate the sum of the values in cells A1 and A2 and display the result in the cell where the formula is entered.

    Rate this question:

  • 22. 

    All functions have arguments.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because arguments are the values that are passed into a function when it is called. Even if a function does not require any arguments, it still technically has an empty argument list. Therefore, all functions have arguments, even if they are not used or required.

    Rate this question:

  • 23. 

    A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?

    • Go to file - save as - save as type - excel 4.0 worksheet

    • Right click on the worksheet tab and select delete

    • Right click on the worksheet and select insert - entire column

    Correct Answer
    A. Right click on the worksheet tab and select delete
    Explanation
    To remove a worksheet from a workbook, the correct sequence of events is to right-click on the worksheet tab and select delete. This action will delete the selected worksheet from the workbook.

    Rate this question:

  • 24. 

    You can print

    • A range of cells by range name

    • An entire workbook

    • A single worksheet

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    The correct answer is "All of the above" because you can print a range of cells by using a range name, you can print an entire workbook, and you can also print a single worksheet. This option includes all the possible ways to print in Excel.

    Rate this question:

  • 25. 

    Once you hide a row, it remains hidden as long as the workbook is active.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When a row is hidden in a workbook, it will remain hidden until it is manually unhidden or until the workbook is closed. Even if the workbook is saved and reopened, the row will still remain hidden. Therefore, the statement "Once you hide a row, it remains hidden as long as the workbook is active" is true.

    Rate this question:

  • 26. 

    Which of the following keys/key can be used to check spelling and grammar?

    • F1

    • Ctrl-End

    • F7

    • Crt-Home

    Correct Answer
    A. F7
    Explanation
    Pressing the F7 key can be used to check spelling and grammar.

    Rate this question:

  • 27. 

    When using Excel 2007 which sign is used to create a formula or function in a cell?

    • Single Quotes

    • Double Quotes

    • Equal Sign

    • Parentheses

    Correct Answer
    A. Equal Sign
    Explanation
    In Excel 2007, the equal sign is used to create a formula or function in a cell. This is because the equal sign is the symbol that tells Excel that the content of the cell is a formula or function, rather than just text. By starting a cell with an equal sign, you can perform calculations or use built-in functions to manipulate data in Excel.

    Rate this question:

  • 28. 

    The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because when adding a record to a table, it is common practice to enter the data in the first available blank row. This ensures that the data is organized and easily accessible. By entering the data in the first blank row, it also avoids any potential conflicts or issues with existing data in the table. Therefore, it is the simplest and most convenient method for adding a record to a table.

    Rate this question:

  • 29. 

    Once data is entered into a cell, can it be edited after saving the file?

    • Yes, but it has to be saved as a different file name.

    • No, once it is saved it cannot be changed.

    • Yes, even after saving the file, double click on the cell where data is to be changed to edit

    Correct Answer
    A. Yes, even after saving the file, double click on the cell where data is to be changed to edit
    Explanation
    After saving the file, the data entered into a cell can still be edited by double-clicking on the cell. This allows the user to make changes to the data without having to save it as a different file name or starting a new file.

    Rate this question:

  • 30. 

    When a formula is written in a cell. It appears in the the active cell in which it is being written and in the ------------------------------ bar as well.  

    • Formula

    • Name Box

    • Title bar

    Correct Answer
    A. Formula
    Explanation
    When a formula is written in a cell, it appears in the active cell where it is being written and also in the formula bar. The formula bar is located above the spreadsheet and displays the contents of the active cell. Therefore, the correct answer is "Formula".

    Rate this question:

  • 31. 

    Which of the following would you use in an Excel formula to reference the cell located at column G row 17?

    • G(17)

    • G17

    • Cgr17

    • A cell is a dynamic value and cannot be referenced in a formula.

    Correct Answer
    A. G17
    Explanation
    To reference the cell located at column G row 17 in an Excel formula, you would use "G17". This is the correct answer because it follows the standard Excel convention of using the column letter followed by the row number to reference a specific cell.

    Rate this question:

  • 32. 

    Excel has a builtin format to display 4 digit year values, so you do not need to create on.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Excel does indeed have a built-in format to display 4 digit year values. This means that users do not need to manually create a format for displaying 4 digit year values in Excel. Therefore, the statement is true.

    Rate this question:

  • 33. 

    Pressing ENTER moves the selection one cell to the right.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Pressing ENTER does not move the selection one cell to the right. Instead, it moves the selection one cell down to the next row.

    Rate this question:

  • 34. 

    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. 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 colon (:) is used to indicate a range, and B1 represents the starting cell while G10 represents the ending cell.

    Rate this question:

  • 35. 

    An Excel spreadsheet is also called a _______________________ .

    • Document

    • Worksheet

    • Workbook

    Correct Answer
    A. Worksheet
    Explanation
    An Excel spreadsheet is also called a worksheet because it is a single page or tab within a larger workbook where data is organized and calculations are performed. A worksheet is a grid of cells that can contain text, numbers, formulas, and functions. It is used to store and manipulate data, create charts and graphs, and perform various calculations and analysis.

    Rate this question:

  • 36. 

    _____________ run horizontally in a spreadsheet.

    • Rows

    • Cell

    • Column

    Correct Answer
    A. Rows
    Explanation
    Rows run horizontally in a spreadsheet.

    Rate this question:

  • 37. 

    Columns are identified by a _______________ .  

    • Letter

    • Number

    • Word

    Correct Answer
    A. Letter
    Explanation
    Columns are identified by a letter because in most spreadsheet software, columns are labeled with letters from A to Z, and then continue with AA, AB, AC, and so on. This letter identification system allows users to easily reference and locate specific columns within a spreadsheet.

    Rate this question:

  • 38. 

    Which function converts miles to kilometers, kilograms to pounds, and so on?

    • Convert

    • Product

    • Change

    • All of above

    Correct Answer
    A. Convert
    Explanation
    The function "Convert" is the correct answer because it is a generic term that can be used to describe the process of converting one unit of measurement to another. In this case, it can be used to convert miles to kilometers, kilograms to pounds, and other similar conversions. The other options, "Product" and "Change," do not specifically refer to the act of converting units of measurement. The option "All of above" is incorrect because it includes all the given options, not just the function that converts units of measurement.

    Rate this question:

  • 39. 

    What is a Chart?  

    • It is a visual way to display and compare data

    • A way of arranging data in a particular order

    • A calculation that describes the relationship between cells

    Correct Answer
    A. It is a visual way to display and compare data
    Explanation
    A chart is a visual way to display and compare data. It allows for easy understanding and analysis of data by presenting it in a graphical format. Charts can be used to show trends, patterns, and relationships between different sets of data. They are commonly used in presentations, reports, and data analysis to make complex information more accessible and visually appealing.

    Rate this question:

  • 40. 

    After you merge a range into a single cell, you can't realign its content.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    After merging a range into a single cell, you can still realign its content. This means that even after combining multiple cells into one, you can adjust the positioning of the text or data within that merged cell.

    Rate this question:

  • 41. 

    You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis to view it from different angles and vertically along the y-axis to change the perspective. These two directions of rotation allow for a comprehensive understanding of the data presented in the chart.

    Rate this question:

  • 42. 

    Graphics objects on a chart are used to

    • Add emphasis to chart data

    • Add interest to a chart

    • Help explain the chart data

    • All of Above

    Correct Answer
    A. All of Above
    Explanation
    Graphics objects on a chart are used to add emphasis to chart data, add interest to a chart, and help explain the chart data. By using graphics objects such as colors, shapes, and images, the chart becomes visually appealing and draws attention to important data points. Additionally, these graphics can provide additional context or explanations for the data, making it easier for viewers to understand the information being presented. Therefore, all of the given options are correct explanations for the use of graphics objects on a chart.

    Rate this question:

  • 43. 

    The cell labeled F5 refers to

    • Row F column 5

    • Column F row 5

    • Functions available in cells

    • Function key F4

    Correct Answer
    A. Column F row 5
    Explanation
    The cell labeled F5 refers to the intersection of column F and row 5 in a spreadsheet. In other words, it is the cell located in the fifth row and the sixth column of the spreadsheet.

    Rate this question:

  • 44. 

    Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    3D charts can indeed be visually attractive but they can also make it difficult to accurately interpret the data. The use of depth and perspective in 3D charts can distort the sizes of the slices, making it harder to determine which slice is larger or smaller. This can lead to a misunderstanding of the relationships between the values in the chart. Therefore, the statement that 3D charts can obscure the relationship between the values in the chart is true.

    Rate this question:

  • 45. 

    What is a Workbook?

    • A table of data that is organized into rows and columns

    • The Excel file that holds your worksheets

    • A built-in formula in Excel

    Correct Answer
    A. The Excel file that holds your worksheets
    Explanation
    A workbook in Excel refers to the file that contains multiple worksheets. It is the main file where you can organize and store various sheets of data. Each sheet within the workbook can be used to input and manipulate data in rows and columns. Therefore, the correct answer is "The Excel file that holds your worksheets."

    Rate this question:

  • 46. 

    Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?  

    • Ribbon

    • Formula Bar

    • Tab

    Correct Answer
    A. Ribbon
    Explanation
    The Ribbon is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before. It is located at the top of the Excel window and consists of different tabs, such as Home, Insert, Page Layout, etc. Each tab contains specific commands and options related to that particular category, allowing users to easily access and utilize various functions and features in Excel.

    Rate this question:

  • 47. 

    What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?    

    • Matrix

    • Window

    • Sheet

    • Cell

    Correct Answer
    A. Cell
    Explanation
    The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell. A cell is the basic unit of a spreadsheet where data can be entered and manipulated. It can contain text, numbers, formulas, and other types of data. Cells are identified by their unique combination of a letter for the column and a number for the row, such as A1 or C3.

    Rate this question:

  • 48. 

    Which of Excel’s ribbon tabs is shown in the figure below?  

    • Review

    • Home

    • Data

    • View

    Correct Answer
    A. Data
    Explanation
    The correct answer is "Data" because in the figure provided, the ribbon tab highlighted is the "Data" tab. This tab contains various options and tools related to data manipulation and analysis in Excel.

    Rate this question:

  • 49. 

    Rows are identified by a _______________________ .

    • Cell

    • Column

    • Number

    Correct Answer
    A. Number
    Explanation
    Rows in a table or spreadsheet are typically identified by a number, such as a row number or index. This allows for easy reference and organization of data within the table. Each row is assigned a unique number, starting from 1, which helps to distinguish it from other rows and facilitates data manipulation and analysis.

    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
  • Apr 05, 2011
    Quiz Created by
    Nsurani
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.