Coastal Construction Assessment - Microsoft Excel

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 Steph123
S
Steph123
Community Contributor
Quizzes Created: 5 | Total Attempts: 4,150
| Attempts: 136
SettingsSettings
Please wait...
  • 1/30 Questions

    Once data is entered into a cell, can it be edited?

    • Yes, but the file must be saved with a different file name
    • No, once a file is saved, cell data cannot be changed
    • Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
    • No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
Please wait...
About This Quiz

This quiz assesses knowledge of Microsoft Excel 2007, focusing on worksheet tabs, table creation, and pivot tables. It tests practical skills in navigating and utilizing Excel features for data management and analysis, essential for both academic and professional settings.

Coastal Construction Assessment - Microsoft Excel - Quiz

Quiz Preview

  • 2. 

    Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

    Correct Answer
    A.
    Explanation
    The correct answer is the "Number Format" button. This button allows users to format selected cells as currency values, displaying them with the appropriate currency symbol and decimal places. This formatting is useful when working with financial data or when presenting monetary values in a clear and consistent manner.

    Rate this question:

  • 3. 

    Which of the following will NOT set text in selected cells to ITALICS?

    • Pressing CTRL + I on the keyboard

    • Using the Tools - Wizard - Web Form menu item

    • Using the Format - Cells - Font menu item

    Correct Answer
    A. Using the Tools - Wizard - Web Form menu item
    Explanation
    Using the Tools - Wizard - Web Form menu item will not set text in selected cells to ITALICS. This menu item is typically used for creating web forms and does not have an option to change the font style to italics.

    Rate this question:

  • 4. 

    A user wishes to remove a spreadsheet 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 Work Sheet

    • Right click on the spreadsheet tab and select DELETE

    • Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

    Correct Answer
    A. Right click on the spreadsheet tab and select DELETE
  • 5. 

    When number signs (#####) are displayed in the cell, it means:

    • There are too many characters in the cell to be displayed with the current cell width

    • The formula in the cell is wrong

    • The decimal point placement in the cell is wrong

    • All of the above

    Correct Answer
    A. There are too many characters in the cell to be displayed with the current cell width
    Explanation
    When number signs (#####) are displayed in a cell, it indicates that there are too many characters in the cell to be displayed with the current cell width. This means that the content of the cell is too long and cannot fit within the given width, resulting in the number signs being displayed as a placeholder. This is a common occurrence when the cell contains a long string of text or a large number that exceeds the width of the cell.

    Rate this question:

  • 6. 

    Is it possible to insert an image from a file into an Excel spreadsheet?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    It is possible to insert an image from a file into an Excel spreadsheet. Excel provides the option to insert various types of objects, including images, into a worksheet. This allows users to enhance their spreadsheets by adding visual elements such as charts, logos, or pictures. By selecting the "Insert" tab and choosing the "Pictures" option, users can browse their computer files and select an image to insert into the spreadsheet.

    Rate this question:

  • 7. 

    What is a worksheet tab in Excel 2007?

    • A worksheet tab is used to access tools associated with the worksheet

    • A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet

    • A worksheet tab is used to get help when working with Microsoft Excel 2007

    • A worksheet tab is used to move from one cell to the next cell in a worksheet

    Correct Answer
    A. A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
    Explanation
    A worksheet tab in Excel 2007 is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet. This allows users to easily switch between different worksheets within the same Excel file. By clicking on a specific worksheet tab, that worksheet becomes active and visible, allowing users to view and edit its contents. This feature is particularly useful when working with large datasets or multiple worksheets within a workbook, as it provides a convenient way to navigate and access specific worksheets.

    Rate this question:

  • 8. 

    Once data in a table gets filtered, you can neither unfilter the table nor get the table back to the original settings.

    • False, you may change filters up to three times

    • True

    • False, you may change filters as many times as you please without limits

    • False, tables cannot be filtered

    Correct Answer
    A. False, you may change filters as many times as you please without limits
  • 9. 

    True or False: Tables created through Excel's table feature allow users to filter columns by different values.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Tables created through Excel's table feature allow users to filter columns by different values. This feature enables users to easily sort and filter data within a table based on specific criteria. By selecting the drop-down arrow next to a column header, users can choose to filter the data by specific values, such as text, numbers, dates, or even custom filters. This functionality provides a convenient way to analyze and manipulate data within Excel tables.

    Rate this question:

  • 10. 

    When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?

    • Seperate the page into two for easier printing

    • Use the Fit to Page option

    • Highlight all cells to print and print selection

    • None of the above

    Correct Answer
    A. Use the Fit to Page option
    Explanation
    If changing the margins on the spreadsheet does not solve the problem with the printout width, using the "Fit to Page" option would be the next step. This option automatically adjusts the size of the spreadsheet to fit within the printable area of the page, ensuring that all content is included in the printout. This can be helpful when the content is too wide to fit within the default page width.

    Rate this question:

  • 11. 

    What does the following error mean - #REF! ?

    • The #REF! error value occurs when a cell reference is not valid.

    • The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

    • The #REF! error value occurs when a cell has been formatted as a currency but contains text.

    Correct Answer
    A. The #REF! error value occurs when a cell reference is not valid.
    Explanation
    The #REF! error value occurs when a cell reference is not valid. This means that the formula in the cell is trying to reference a cell that does not exist or has been deleted. It could also occur if the formula is referencing a different sheet or workbook that is not open or accessible. This error indicates that there is an issue with the formula and it needs to be corrected in order for the cell to display the intended result.

    Rate this question:

  • 12. 

    Which of these will NOT select all the cells in a document?

    • Clicking three times with the right mouse button in the spreadsheet

    • Using the Edit - Select All menu item

    • Pressing CTRL + A on the keyboard

    Correct Answer
    A. Clicking three times with the right mouse button in the spreadsheet
    Explanation
    Clicking three times with the right mouse button in the spreadsheet does not select all the cells in a document. This action typically opens a context menu with options specific to the spreadsheet program, and does not have a built-in function to select all cells.

    Rate this question:

  • 13. 

    Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

    • Count

    • Average

    • Sum

    Correct Answer
    A. Sum
    Explanation
    The Sum formula is used to add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range. Therefore, Sum is the correct answer for this question.

    Rate this question:

  • 14. 
    When you see a cell with a red triangle in the top right corner, what does this signify? - ProProfs

    When you see a cell with a red triangle in the top right corner, what does this signify?

    • There is an error in the cell

    • There is a comment associated with the cell

    • The font color for text in the cell is red

    • A formula cannot be entered into the cell

    Correct Answer
    A. There is a comment associated with the cell
    Explanation
    When a cell has a red triangle in the top right corner, it signifies that there is a comment associated with the cell. This comment can be viewed by hovering over the cell or by clicking on the cell and viewing the comment in the toolbar. The red triangle serves as a visual indicator that additional information or notes are available for that specific cell.

    Rate this question:

  • 15. 

    What is the function of the Formulas tab in Microsoft Excel 2007?

    • The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically

    • The Formulas tab contain only the most common formulas supported by Excel

    • The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab

    • The Formulas tab is used for automatic creation of a complete formula without any user interaction at all

    Correct Answer
    A. The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab
    Explanation
    The Formulas tab in Microsoft Excel 2007 contains various formula-related functions such as a function library, formula auditing, defining names, and calculations. These functions can be easily inserted into a cell from the Formulas tab, allowing users to perform complex calculations and manipulate data efficiently.

    Rate this question:

  • 16. 

    What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?

    • F3

    • F5

    • F7

    • F9

    • F11

    • F13

    Correct Answer
    A. F11
    Explanation
    Pressing the F11 key on the keyboard creates a chart from the selected cells. This shortcut allows users to quickly generate a chart without having to navigate through menus or use the mouse. It is a convenient and efficient way to visualize data in a spreadsheet.

    Rate this question:

  • 17. 

    True or False:  Pivot tables that have been created can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.

    • True

    • False, pivot tables do not contain enough information for graphs or charts

    • False, only regular tables may be used to create graphs or charts

    Correct Answer
    A. True
    Explanation
    Pivot tables can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.

    Rate this question:

  • 18. 

    What does the Format Painter button do?

    • Only changes the color of each cell

    • Only changes the color of a group of cells that you choose

    • Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.

    • Only copies formulas from one cell or group of cells to another.

    Correct Answer
    A. Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.
    Explanation
    The Format Painter button allows you to quickly and easily copy the formatting of a cell, including formulas, from one cell or group of cells to another. This means that not only the color but also other formatting elements such as font style, border, and alignment will be copied. It saves time and effort by eliminating the need to manually apply the same formatting to multiple cells.

    Rate this question:

  • 19. 

    True or False:  Pivot tables allow filtering of table information by different values in column and row headers.

    • True

    • False

    • Only when using Excel 2003 or earlier versions

    Correct Answer
    A. True
    Explanation
    Pivot tables are a powerful feature in Excel that allow users to summarize and analyze large amounts of data. One of the key functionalities of pivot tables is the ability to filter table information by different values in column and row headers. This allows users to easily drill down into specific subsets of data and analyze it from different perspectives. Therefore, the statement "Pivot tables allow filtering of table information by different values in column and row headers" is true.

    Rate this question:

  • 20. 

    By default, each workbook automatically has 3 sheets labeled on the bottom tabs: Sheet 1, Sheet 2, Sheet 3. To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, what has to be done?

    • Right click on sheet 2 and select insert

    • Right click on sheet 1 and select insert

    • Right click on sheet 3 and select insert

    • None of the above

    Correct Answer
    A. Right click on sheet 2 and select insert
    Explanation
    To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, one needs to right click on sheet 2 and select insert. This action will create a new sheet between the existing Sheet 1 and Sheet 2, shifting the other sheets down accordingly.

    Rate this question:

  • 21. 

    What is the keyboard shortcut (button or buttons to be pressed) to Complete a cell entry and move up in the selection ?

    • CTRL+TAB

    • SHIFT+TAB

    • ALT+TAB

    • SHIFT+ENTER

    • CTRL+ENTER

    • ALT+ENTER

    Correct Answer
    A. SHIFT+ENTER
    Explanation
    The keyboard shortcut SHIFT+ENTER is used to complete a cell entry and move up in the selection. This means that after entering data into a cell, pressing SHIFT+ENTER will save the entry and move the cursor to the cell above.

    Rate this question:

  • 22. 

    Which of the following Excel features allows you to summarize the data in a large table?

    • Data Validation

    • Conditional Formatting

    • Pivot Table

    • Hyperlink

    Correct Answer
    A. Pivot Table
    Explanation
    A Pivot Table in Excel allows you to summarize and analyze large amounts of data in a table format. It enables you to quickly and easily create reports, perform calculations, and identify patterns or trends within the data. By selecting the relevant fields and applying functions such as sum, average, count, etc., you can summarize the data based on different criteria and generate meaningful insights. Thus, a Pivot Table is the correct feature that allows you to summarize data in a large table.

    Rate this question:

  • 23. 

    How do you turn off automatic calculation for a spreadsheet ?

    • You cannot turn off automatic calculation - its built into the spreadsheet / workbook.

    • Right click on the spreadsheet tab and select MANUAL CALCULATION.

    • Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.

    Correct Answer
    A. Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.
    Explanation
    To turn off automatic calculation for a spreadsheet in Excel, you can go to the Office Button, then select Excel Options. From there, navigate to the Formulas section and choose Manual in the Workbook Calculation section. This will disable the automatic calculation feature and allow you to manually calculate the spreadsheet when needed.

    Rate this question:

  • 24. 

    True or False:  For a table to work properly, the top row should have column headings.

    • True

    • False, only rows may have headings

    • False

    Correct Answer
    A. True
    Explanation
    In order for a table to work properly, it is essential for the top row to have column headings. Column headings provide a clear and organized structure to the table, allowing users to easily understand the data presented in each column. Without column headings, it would be difficult to identify and differentiate the information in each column, leading to confusion and potential misinterpretation of the data. Therefore, the statement "For a table to work properly, the top row should have column headings" is true.

    Rate this question:

  • 25. 

    Creating tables is as easy as highlighting cells that have already been filled in appropiately, followed by clicking on the insert tab and then clicking on the table button.

    • No, highlighting cells disables the ability to create tables

    • Yes, it is that simple, but the highlighted cells must have numerical data

    • No, you go to the home tab and then click on the table button

    • Yes, it is that simple, but the highlighted selection should not contain any blank cells

    Correct Answer
    A. Yes, it is that simple, but the highlighted selection should not contain any blank cells
    Explanation
    The correct answer is "Yes, it is that simple, but the highlighted selection should not contain any blank cells". This answer accurately reflects the statement given in the question, which states that creating tables is as easy as highlighting cells that have already been filled appropriately. However, it adds the condition that the highlighted selection should not contain any blank cells. This condition is important because creating tables typically requires complete data in each cell for accurate analysis and organization.

    Rate this question:

  • 26. 

    Which pivot table layout allows the dragging of fields to the grid in a spreadsheet?

    • Default Pivot Table Layout

    • Classic Pivot Table Layout

    • Master Pivot Table Layout

    • Operation Geronimo Layout

    Correct Answer
    A. Classic Pivot Table Layout
    Explanation
    The Classic Pivot Table Layout allows the dragging of fields to the grid in a spreadsheet. This layout is the traditional and most commonly used layout for creating pivot tables. It provides a user-friendly interface where users can easily drag and drop fields into rows, columns, and values sections of the pivot table grid. This layout offers flexibility and customization options to analyze data in a structured manner.

    Rate this question:

  • 27. 

    When working with a chart, which of the following will allow you to change the spacing of tick marks and labels on the category axis ? Click on the desired axis and go to:

    • FORMAT - SELECTED AXIS - SCALE - Select options required

    • FORMAT - CHART - AXIS - SCALE - Select options required

    • Format Tab - Format Selection - Axis Options - Select options required

    Correct Answer
    A. Format Tab - Format Selection - Axis Options - Select options required
    Explanation
    The correct answer is "Format Tab - Format Selection - Axis Options - Select options required". This option allows you to change the spacing of tick marks and labels on the category axis by accessing the Format tab, selecting the desired axis, and then going to Axis Options. From there, you can select the options required to adjust the spacing of tick marks and labels.

    Rate this question:

  • 28. 

    Which feature in Excel allows you to view two spreadsheets in one window?

    • Freeze panes

    • Split

    • View side by side

    Correct Answer
    A. Split
    Explanation
    The Split feature in Excel allows you to view two spreadsheets in one window. This feature is useful when you want to compare or analyze data from two different parts of a spreadsheet simultaneously. By splitting the window, you can scroll through one section while keeping the other section fixed, making it easier to navigate and work with large amounts of data.

    Rate this question:

  • 29. 

    What must first be created before copying the results of an advanced filter to another location?

    • Criteria range

    • Output range

    • Setup range

    • Filter range

    Correct Answer
    A. Criteria range
    Explanation
    Before copying the results of an advanced filter to another location, the criteria range must first be created. The criteria range specifies the conditions that the data must meet in order to be copied. By setting up the criteria range, the user can define the specific criteria for filtering the data. Once the criteria range is created, the advanced filter can be applied to the data, and the results can be copied to another location.

    Rate this question:

  • 30. 

    Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?

    • ROUND

    • ROUNDUP

    • ROUNDDOWN

    • RAND

    Correct Answer
    A. ROUND
    Explanation
    The ROUND formula will automatically change a decimal value of .5 or greater up to the next highest whole number value. This means that if the decimal value is .5 or greater, it will be rounded up to the next whole number. If the decimal value is less than .5, it will be rounded down to the previous whole number.

    Rate this question:

Quiz Review Timeline (Updated): Jul 31, 2024 +

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

  • Current Version
  • Jul 31, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 25, 2012
    Quiz Created by
    Steph123
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.