Excel - 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 Bhavanabhagat
B
Bhavanabhagat
Community Contributor
Quizzes Created: 1 | Total Attempts: 409
| Attempts: 411
SettingsSettings
Please wait...
  • 1/13 Questions

    Which function results can be displayed in AutoCalculate?

    • SUM and AVERAGE
    • MAX and AVERAGE
    • LABEL and AVERAGE
    • MIN and BLANK
Please wait...
About This Quiz

The 'Excel - Pre Test' assesses knowledge of Excel's views, functions, cell referencing, and formatting capabilities. It is designed for learners to evaluate their understanding of Excel's operational features and prepare for advanced usage or certification.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    Which of the following is the correct order for an A to Z sort?

    • 1, 3, 5, 7

    • 7, 5, 3, 1

    • Tom, John, Adam

    • May 1, 2007; April 1, 2007; March 1, 2007

    Correct Answer
    A. 1, 3, 5, 7
  • 3. 

    Which view shows margins and the rulers?

    • Normal

    • Page Layout

    • Page Setup

    • Review

    Correct Answer
    A. Page Layout
    Explanation
    The Page Layout view shows margins and rulers. This view allows users to see how the document will look when printed and adjust margins accordingly. The rulers help in aligning and positioning text, images, and other elements on the page.

    Rate this question:

  • 4. 

    What statement describes this function: =SUMIF(D7:D14, ">1")?

    • It adds the values in cells D7:D14 if the value is greater than 1.

    • It adds all the negative values in cells D7:D14.

    • If the value in a cell is greater than 1, it is added to the other values in column D.

    • If the value in a cell is greater than 1, the range D7:D14 is placed on a summary sheet.

    Correct Answer
    A. It adds the values in cells D7:D14 if the value is greater than 1.
    Explanation
    The function =SUMIF(D7:D14, ">1") calculates the sum of values in cells D7:D14 only if the value is greater than 1.

    Rate this question:

  • 5. 

    If a cell contains =ROUND(3.4567,2), what value would be used in a formula that refers to that cell?

    • 3.45

    • 3.46

    • 3.457

    • 3.4567

    Correct Answer
    A. 3.46
    Explanation
    The ROUND function is used to round a number to a specified number of decimal places. In this case, the number 3.4567 is being rounded to 2 decimal places. The ROUND function rounds up if the next digit is 5 or greater, and rounds down if the next digit is 4 or less. Therefore, the value that would be used in a formula that refers to the cell containing =ROUND(3.4567,2) is 3.46.

    Rate this question:

  • 6. 

    Which of the following arguments in a financial function indicates the interest for a period?

    • FV

    • PV

    • Nper

    • Rate

    Correct Answer
    A. Rate
    Explanation
    The argument "Rate" in a financial function indicates the interest for a period. This parameter is used to specify the interest rate per period in financial calculations. It is an essential component in calculations such as determining the future value or present value of an investment, calculating loan payments, or evaluating the profitability of an investment. The "Rate" argument allows for accurate and precise financial analysis by considering the interest rate associated with a specific period.

    Rate this question:

  • 7. 
    Which category of functions obtains data or displays information from the current or other workbooks? - ProProfs

    Which category of functions obtains data or displays information from the current or other workbooks?

    • Financial

    • Database

    • Lookup and Reference

    • Logical

    Correct Answer
    A. Lookup and Reference
    Explanation
    Lookup and Reference functions are used to obtain data or display information from the current or other workbooks. These functions allow users to search for specific values in a table or range and retrieve corresponding data or information. They are commonly used in Excel to perform tasks such as searching for a specific value in a large dataset, retrieving values from different worksheets or workbooks, and creating dynamic formulas that automatically update when the referenced data changes. Therefore, the correct answer is Lookup and Reference.

    Rate this question:

  • 8. 

    Why are PivotTables considered interactive?

    • They allow you to add dynamic data.

    • They allow you to rearrange row and column data.

    • They allow you to generate e-mail enabled reports.

    • They allow you to print the reports with various settings.

    Correct Answer
    A. They allow you to rearrange row and column data.
    Explanation
    PivotTables are considered interactive because they allow users to rearrange row and column data. This means that users can easily change the layout of the data to analyze it from different perspectives. By rearranging the rows and columns, users can quickly summarize and compare different aspects of the data, making the analysis process more dynamic and flexible. This interactivity enables users to explore and understand the data more effectively.

    Rate this question:

  • 9. 

    How is a relative reference different from an absolute reference?

    • It includes column and row references.

    • It adjusts to its location on the worksheet.

    • It refers to an existing cell on the worksheet.

    • It resets to its original value.

    Correct Answer
    A. It adjusts to its location on the worksheet.
    Explanation
    A relative reference is different from an absolute reference because it adjusts to its location on the worksheet. Unlike an absolute reference, which always refers to a specific cell, a relative reference is flexible and changes its reference based on its position relative to other cells. This means that if the relative reference is copied or moved to a different cell, it will automatically adjust its reference accordingly. This allows for more dynamic and flexible formulas in Excel.

    Rate this question:

  • 10. 

    What category in the Format Cells dialog box is used to define a unique format for a date?

    • Custom

    • Date

    • Special

    • Text

    Correct Answer
    A. Custom
    Explanation
    The category in the Format Cells dialog box that is used to define a unique format for a date is "Custom". This category allows users to create their own customized formats for dates, such as displaying the date in a specific order or including additional text or symbols. By selecting the "Custom" category, users have the flexibility to design a format that meets their specific needs and preferences for displaying dates.

    Rate this question:

  • 11. 

    Which of these references is an example of a mixed reference?

    • B1

    • $B$1

    • $B1

    • AB1

    Correct Answer
    A. $B1
    Explanation
    A mixed reference is a reference that contains both absolute and relative references. In this case, the correct answer is $B1 because the column reference ($B) is absolute, while the row reference (1) is relative. This means that when the formula is copied or filled down to other cells, the column reference will stay the same ($B), but the row reference will change based on the relative position of the new cell.

    Rate this question:

  • 12. 

    What is a macro?

    • Solver scenario

    • Visual Basic scenario

    • Visual Basic routine

    • Solver routine

    Correct Answer
    A. Visual Basic routine
    Explanation
    A macro is a set of instructions or commands that are recorded and can be executed to automate tasks in a software program. In this context, a Visual Basic routine refers to a macro that is written using the Visual Basic programming language. Therefore, the correct answer is Visual Basic routine.

    Rate this question:

  • 13. 

    Which of the following statements about range names is false?

    • They are easier to remember than cell addresses.

    • They can be used for navigation.

    • They automatically substitute the relevant cell addresses.

    • They make formulas easier to understand.

    Correct Answer
    A. They can be used for navigation.
    Explanation
    Range names can be used for navigation within a worksheet, allowing users to quickly jump to specific areas. This feature enhances the ease of use and navigation within a large worksheet. Therefore, the statement "They can be used for navigation" is true, not false.

    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
  • Oct 31, 2010
    Quiz Created by
    Bhavanabhagat
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.