Post Test Excel 2007 And 2010 Intermediate

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 Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 16,311
| Attempts: 175
SettingsSettings
Please wait...
  • 1/13 Questions

    There are pivot graph and pivot table to present large data in real time in excel 2007/2010.

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

This post-test assesses intermediate skills in Excel 2007 and 2010, focusing on core functions like file handling, shortcuts, formula usage, and text manipulation. It is designed to enhance proficiency in using Excel effectively in various professional settings.

Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    Default extension files for Excel 2007/2010 is

    • Docx

    • Pptx

    • Exls

    • Xlsx

    Correct Answer
    A. Xlsx
    Explanation
    The default extension file for Excel 2007/2010 is "xlsx". This file extension is used for Excel workbook files in the XML-based file format introduced in Excel 2007. The "xlsx" format allows for better data storage and manipulation, improved file size, and compatibility with other Microsoft Office applications. Therefore, when saving a file in Excel 2007/2010, the default option is to save it with the "xlsx" extension.

    Rate this question:

  • 3. 

    Shortcut key for Print Preview in Excel 2010 is

    • Ctrl + F2

    • Alt + F2

    • Shift + F2

    • Ctrl + Alt + F2

    Correct Answer
    A. Ctrl + F2
    Explanation
    The correct answer is Ctrl + F2. This shortcut key is used to open the Print Preview window in Excel 2010. By pressing Ctrl + F2, users can quickly preview how their spreadsheet will look when printed, allowing them to make any necessary adjustments before printing.

    Rate this question:

  • 4. 

    What symbol represent absolute reference in Ms Excel?

    • $

    • &

    • %

    • #

    Correct Answer
    A. $
    Explanation
    The symbol "$" represents absolute reference in Ms Excel. Absolute reference is used to lock a specific cell or range of cells in a formula so that when the formula is copied to other cells, the locked cell(s) remain the same. The "$" symbol is placed before the column letter and/or row number to indicate that they should not change when the formula is copied.

    Rate this question:

  • 5. 

    What formula to combine several text at several cell into one cell?

    • =CONSOLIDATE()

    • =CONCATENATE()

    • =TRIM()

    • =MID()

    Correct Answer
    A. =CONCATENATE()
    Explanation
    The correct answer is =CONCATENATE(). This formula is used to combine several text values from different cells into one cell. It allows you to join multiple strings together by specifying the cells or text values to be combined. This can be useful for creating full names, addresses, or any other text that needs to be merged into a single cell.

    Rate this question:

  • 6. 

    If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667,0)?

    • 365

    • 364.7

    • 364

    • 364.6

    Correct Answer
    A. 365
    Explanation
    The formula =ROUND(cell that contains 364.66667,0) rounds the number to the nearest whole number. In this case, since 364.66667 is closer to 365 than to 364, the final number after rounding would be 365.

    Rate this question:

  • 7. 

    Formula's that can find any value related with finance are

    • SUM(), LEFT(), DSUM()

    • FV(), CONCATENATE(), NOW()

    • FV(), NPV(), PV()

    • DAY(), Now(), Today()

    Correct Answer
    A. FV(), NPV(), PV()
    Explanation
    The correct answer is FV(), NPV(), PV(). These formulas are commonly used in finance to calculate different values. FV() is used to calculate the future value of an investment, NPV() is used to calculate the net present value of cash flows, and PV() is used to calculate the present value of future cash flows. These formulas are essential in financial analysis and decision-making processes.

    Rate this question:

  • 8. 

    Formula to create current date and time is

    • =DATE(NOW)

    • =DAY(NOW)

    • =NOW()

    • =(DATE)

    Correct Answer
    A. =NOW()
    Explanation
    The correct answer is =NOW(). This formula is used to create the current date and time in a cell. It will display the current date and time as a serial number, which can be formatted to show the desired date and time format. This formula is commonly used when you need to have the current date and time automatically updated in a spreadsheet.

    Rate this question:

  • 9. 

    What exactly year 2001! means in excel 2007/2010?

    • Name of cell reference

    • Name of worksheet

    • Absolute reference

    • One of function in math and trig

    Correct Answer
    A. Name of worksheet
    Explanation
    In Excel 2007/2010, the term "year 2001!" refers to the name of a worksheet. In Excel, worksheets can be given specific names to make it easier to organize and navigate through multiple sheets within a workbook. By naming a worksheet as "year 2001!", it helps to identify and differentiate it from other worksheets.

    Rate this question:

  • 10. 

    WHAT IS THE LAST COLUMN AND ROW FOR EXCEL 2007/2010?

    • IV, 65536

    • XFD, 1048576

    • Unlimited

    • ZZZ, 999999

    Correct Answer
    A. XFD, 1048576
    Explanation
    The last column and row for Excel 2007/2010 is XFD and 1048576 respectively. In Excel, columns are labeled alphabetically starting from A to XFD, and rows are numbered from 1 to 1048576. Therefore, XFD represents the last column and 1048576 represents the last row in Excel 2007/2010.

    Rate this question:

  • 11. 

    What result for the following formula? =if(c2>500,"good","not good") where value in c2=500

    • Not good

    • Good

    • Not valid

    • No result appear

    Correct Answer
    A. Not good
    Explanation
    The formula in the question uses the IF function to check if the value in cell C2 is greater than 500. Since the value in C2 is 500, which is not greater than 500, the formula returns "not good" as the result.

    Rate this question:

  • 12. 

    One of features that help user make using spreadsheet with quicker and faster is Insert Function Utility. Where i sthe location for Insert Function Utility key?

    • Formula Tab --> within Function Library group

    • Formula Tab --> within Defined Named group

    • Insert Tab --> within Function Library Group

    • Insert Tab --> within Defined Named group

    Correct Answer
    A. Formula Tab --> within Function Library group
    Explanation
    The correct answer is "Formula Tab --> within Function Library group". The Insert Function Utility key is located on the Formula Tab, specifically within the Function Library group. This feature allows users to easily insert and use functions in their spreadsheets, making the process quicker and faster.

    Rate this question:

  • 13. 

    Which formula is false in Excel 2007/2010?

    • =SUMIF(D4:D10,">600")

    • =ROUNDUP(C2/C3,1)

    • =IF(AVERAGE(B3:B6)>25,SUM(B3:B6),0)

    • =LEFTS(D4)

    Correct Answer
    A. =LEFTS(D4)
    Explanation
    The formula =LEFTS(D4) is false in Excel 2007/2010 because there is no function called LEFTS in Excel. The correct function to extract the leftmost characters from a cell is LEFT.

    Rate this question:

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

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

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 13, 2012
    Quiz Created by
    Naldsauza
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.