MS Office Excel 2007/2010 Intermediate - 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 Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 16,239
| Attempts: 352
SettingsSettings
Please wait...
  • 1/11 Questions

    In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)

    • True
    • False
    • I Dont Know
Please wait...
About This Quiz

This pre-test assesses intermediate skills in MS Office Excel 2007\/2010, focusing on file extensions, shortcuts, functions, and formulas. It evaluates the user's ability to navigate Excel efficiently and accurately apply functions for data management and analysis.

Microsoft Office Quizzes & Trivia

Quiz Preview

  • 2. 

    Symbol $ will be used to create Absolute Reference in Ms Excel / Simbol $ digunakan untuk mencipta Absolute Reference di dalam Ms Excel

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The statement is true. In Microsoft Excel, the symbol $ is used to create an absolute reference. Absolute references do not change when copied or filled, meaning that the cell reference remains the same regardless of where it is copied to. This is useful when you want to refer to a specific cell or range of cells in a formula and want to ensure that the reference does not change.

    Rate this question:

  • 3. 

    One of features that help user make using spreadsheet with quicker and faster is Insert Function utility. Where is the location for Insert Function key? / Dimana letaknya butang  Insert Function ? Formula Tab --> within Function Library Group

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The Insert Function key is located within the Function Library Group in the Formula Tab.

    Rate this question:

  • 4. 

    Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The statement is true because Excel 2010 does indeed have three lookup functions: HLOOKUP, VLOOKUP, and VECTOR LOOKUP. These functions allow users to search for specific values in a table and retrieve corresponding data from the same row or column. HLOOKUP is used for horizontal lookup, VLOOKUP for vertical lookup, and VECTOR LOOKUP for searching in both rows and columns. These functions are commonly used in data analysis and manipulation tasks in Excel.

    Rate this question:

  • 5. 

    =SUMIF(D4:D10,”>600”) is a formula in Excel 2010. Is it valid or not?

    • True (Valid)

    • False (Not Valid)

    • I Dont Know

    Correct Answer
    A. True (Valid)
    Explanation
    The formula =SUMIF(D4:D10,">600") is valid in Excel 2010. This formula calculates the sum of the values in the range D4 to D10 that are greater than 600. The ">" symbol is used to specify the condition for the sum.

    Rate this question:

  • 6. 

    Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The default extension file for Excel 2007/2010 is .exls.

    Rate this question:

  • 7. 

    Shortcut key for Print Preview in Excel 2007/2010 is / Kekunci pendek bagi fungsi Print Preview di Excel2007/ 2010 adalah: Control + F3

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    The given answer "False" is correct because the shortcut key for Print Preview in Excel 2007/2010 is not Control + F3. The correct shortcut key for Print Preview in Excel 2007/2010 is Control + F2.

    Rate this question:

  • 8. 

    What is the last column and row for Excel 2007/ 2010? Lajur dan Kolum terakhir di dalam Excel 2007/2010 adalah Ans: Unlimited/ Jawapan : Tiada had

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    The given answer is false because the last column and row in Excel 2007/2010 is not unlimited or without limit. In Excel 2007, the last column is column XFD and the last row is 1,048,576. In Excel 2010, the last column is also column XFD but the last row is increased to 1,048,576.

    Rate this question:

  • 9. 

    Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    The given formula "=DATE(NOW)" is incorrect. The correct formula to create the current date and time is "=NOW()". Therefore, the answer is False.

    Rate this question:

  • 10. 

    If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667)? / Apakah yang terhasil sekiranya kita menggunakan formula =ROUND(sel yang mengandungi nombor 364.666667)? 364.7

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
  • 11. 

    What formula to combine several text at several cell into one cell? / Formula apakah yang kita gunakan untuk menyambungkan beberapa perkataan menjadi satu ayat dalam satu sel? =CONSOLIDATE()

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    The correct answer is False. The CONSOLIDATE() formula is not used to combine several texts into one cell. It is used to combine data from multiple ranges into one range or to consolidate data from multiple worksheets into one worksheet.

    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
  • Jul 07, 2011
    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.