Excel 2007 (Pre Test)

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 PradipMCT
P
PradipMCT
Community Contributor
Quizzes Created: 1 | Total Attempts: 118
| Attempts: 118
SettingsSettings
Please wait...
  • 1/15 Questions

    A column chart is made out of data present in A1:B5. For a new data added in A6 and B6, the chart has to be redesigned to include the new record

    • There is no feature in excel to solve this problem
    • This problem can be easily solved by converting your data into a list/ table range
    • The chart will get auto updated with the new records, if the data is refreshed
    • Column chart does not support new records to be added however, other chart types do
Please wait...
About This Quiz

The 'Excel 2007 (Pre Test)' assesses user proficiency in using Excel 2007, covering topics like addition of rows and columns, Goal Seek, function syntax, chart updating, cell protection, and array formulas. This quiz is essential for learners looking to verify their Excel skills.

Excel 2007 (Pre Test) - Quiz

Quiz Preview

  • 2. 

    When you first create a comment, what appears in the comment text box?

    • Nothing

    • User name

    • IP address

    • Worksheet name

    Correct Answer
    A. User name
    Explanation
    When you first create a comment, the comment text box is initially empty. It does not contain any pre-filled information such as the user name, IP address, or worksheet name. The user needs to manually input their comment into the empty text box.

    Rate this question:

  • 3. 

    What is the keyboard short cut for ‘Save-As’?

    • F8

    • F12

    • F11

    • Ctrl + Shift + A

    Correct Answer
    A. F12
    Explanation
    The keyboard shortcut for "Save-As" is F12.

    Rate this question:

  • 4. 

    The formula present in cell D7 of book1, sheet2, is =sum(A2:A5). The same formula is copied to another workbook, book2 and pasted in sheet2, cell C7. Select the most appropriate outcome?

    • Data cannot be copied across workbooks, if it contains a formula

    • Will give the sum of data present in cells A2:A5 of book book2, sheet2

    • Will give the sum of data present in cells A2:A5 of book book1, sheet2

    • Will result in an error

    Correct Answer
    A. Will result in an error
    Explanation
    When the formula =sum(A2:A5) is copied from cell D7 in book1, sheet2 to cell C7 in book2, sheet2, it will result in an error. This is because the formula is referencing cells in book1, sheet2, which are not available in book2. The formula needs to be adjusted to reference the correct cells in book2, sheet2 in order to calculate the sum correctly.

    Rate this question:

  • 5. 

    Is addition of rows and columns is possible beyond defined limit

    • Yes

    • No

    • None of the above

    Correct Answer
    A. No
    Explanation
    The given answer "No" suggests that the addition of rows and columns is not possible beyond the defined limit. This implies that there is a limit set for the number of rows and columns that can be added, and exceeding this limit is not allowed. Therefore, the correct answer indicates that there is a restriction on the number of rows and columns that can be added beyond the defined limit.

    Rate this question:

  • 6. 

    Which of the following functions are correct syntactically?

    • =Small(A5:A1:C1:C5,3)

    • =Small(A1:A5,C1)

    • =Small((A1:A5,C1:C5),3)

    • All of the above

    Correct Answer
    A. =Small(A1:A5,C1)
    Explanation
    The correct answer is "=Small(A1:A5,C1)". This function is correct syntactically because it follows the proper syntax for the SMALL function, which is "SMALL(array, k)". In this case, the "array" is A1:A5, which represents a range of cells, and "k" is C1, which represents the k-th smallest value to return from the array.

    Rate this question:

  • 7. 

    The Name box

    • Shows the address of the active cell

    • Can be used to navigate to any cell and convert it to an active cell

    • Can be used to give names to cells and corresponding ranges as applicable

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    The Name box in Excel serves multiple purposes. It displays the address of the active cell, allowing users to easily identify where they are in the spreadsheet. Additionally, it can be used for navigation, allowing users to enter a cell reference and go directly to that cell. Furthermore, the Name box can be used to give names to cells and ranges, making it easier to refer to them in formulas and calculations. Therefore, the correct answer is "All of the above."

    Rate this question:

  • 8. 

    Control + Enter shortcut is used ....

    • As a shortcut to run Macro

    • Copy the formula from a cell in editing mode to the range of cells selected

    • To go back to the last edited cell

    • Select the current region

    Correct Answer
    A. Copy the formula from a cell in editing mode to the range of cells selected
    Explanation
    The Control + Enter shortcut is used to copy the formula from a cell in editing mode to the range of cells selected. This shortcut is useful when you want to quickly apply the same formula to multiple cells without manually typing or dragging the formula. By selecting the range of cells and using Control + Enter, the formula will be copied to all the selected cells simultaneously.

    Rate this question:

  • 9. 

    The number 32002 formatted as a date would be:

    • March 2, 2002

    • February 3, 2002

    • August 13, 1987

    • June 30, 1990

    Correct Answer
    A. August 13, 1987
    Explanation
    The number 32002 can be formatted as a date by interpreting the first two digits as the month, the middle two digits as the day, and the last two digits as the year. Therefore, the correct answer is August 13, 1987.

    Rate this question:

  • 10. 

    You open a worksheet, you received in an email with cells D6:D9 containing the formula {=a6:A9*C6:C9}. Which feature of excel can help us design formulae like this

    • List

    • Array

    • Range Product

    • Matrix

    Correct Answer
    A. Array
    Explanation
    The feature of Excel that can help us design formulae like this is Array. Array formulas allow us to perform calculations on multiple cells or ranges of cells at once, rather than having to apply the formula to each individual cell. In this case, the formula {=a6:A9*C6:C9} is using an array formula to multiply corresponding values in the ranges A6:A9 and C6:C9.

    Rate this question:

  • 11. 

    Which of the following function syntax is correct?

    • =Vlookup(A1,$A$1:$B$12,"First Name",0)

    • =Vlookup(A1:A101, $A$1:$B$12,2,0)

    • =Vlookup(A1, $A$1:$B$12,1,0)

    • None of the above

    Correct Answer
    A. None of the above
  • 12. 

    Select the most appropriate amongst the following

    • Goal Seek can be used conditionally to solve scenarios based on multiple constraints

    • Goal Seek can be used conditionally to solve scenarios based on single constraints

    • Goal Seek is not an excel command

    • Iterations must be enabled in order to use Goal Seek

    Correct Answer
    A. Goal Seek can be used conditionally to solve scenarios based on single constraints
    Explanation
    Goal Seek is a feature in Excel that allows users to find the input value needed to achieve a specific goal or desired result. It can be used conditionally to solve scenarios based on single constraints, meaning that it can find a specific input value that meets a single condition. For example, it can be used to determine the required sales volume to achieve a target profit. However, it cannot be used to solve scenarios based on multiple constraints simultaneously.

    Rate this question:

  • 13. 

    Which amongst the following is ideal methods is ideal to work with a workbook which has the huge data and takes lot of time to do the calculations

    • You will copy the entire data, go to ‘paste special’ and paste as value. Workbook will now not calculate anything since there are no formulae in the workbook

    • Tools à Options à Calculation à Manual

    • You will go to Formulas à Evaluate formula in the formula auditing Group. This will help you to evaluate the formula step by step

    • Excel does not have the option to work with huge workbooks.

    Correct Answer
    A. You will go to Formulas à Evaluate formula in the formula auditing Group. This will help you to evaluate the formula step by step
  • 14. 

    Excel allows users to be able to protect each cell with a different password

    • This statement is true, but the protection only works if the workbook is protected too

    • This statement is true, but the protection only works if the sheet is protected too

    • This statement is true however, read only mode must be activated for those cells undergoing protection

    • The above statement is false and this is not possible in excel

    Correct Answer
    A. This statement is true, but the protection only works if the sheet is protected too
    Explanation
    The given answer is correct because Excel does allow users to protect each cell with a different password. However, this protection only works if the sheet is protected too.

    Rate this question:

  • 15. 

    Cell formatted as ";;;" will result in

    • The cell will appear like ";;;".

    • The cell's contents will appear in bold.

    • The cell's contents will appear in italics.

    • The cell's contents will be hidden.

    Correct Answer
    A. The cell's contents will be hidden.
    Explanation
    When a cell is formatted as ";;;;", it means that the cell's contents will be hidden. This formatting will make the text in the cell completely invisible, giving the appearance that the cell is empty.

    Rate this question:

Quiz Review Timeline (Updated): Mar 11, 2024 +

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

  • Current Version
  • Mar 11, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 06, 2013
    Quiz Created by
    PradipMCT
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.