MS Office Excel 2007/2010 Intermediate - Pre Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 20 | Total Attempts: 15,590
Questions: 11 | Attempts: 352

SettingsSettingsSettings
MS Excel 2007 Quizzes & Trivia

Enter either True, False or I Dont Know.


Questions and Answers
  • 1. 

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

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

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

    Rate this question:

  • 2. 

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

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    B. 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:

  • 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

    • A.

      True

    • B.

      False

    • C.

      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. 

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

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    B. 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:

  • 5. 

    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

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    B. False
  • 6. 

    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()

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    B. 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:

  • 7. 

    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

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    B. 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:

  • 8. 

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

    • A.

      True (Valid)

    • B.

      False (Not Valid)

    • C.

      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:

  • 9. 

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

    • A.

      True

    • B.

      False

    • C.

      I Dont Know

    Correct Answer
    A. True
    Explanation
    Excel 2007/2010 indeed includes financial formulas to calculate the future value (FV) of an investment. These formulas can be used to determine the value of an investment at a future date based on a specified interest rate and number of periods. By using the FV function in Excel, users can easily calculate the future value of their investments and make informed financial decisions.

    Rate this question:

  • 10. 

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

    • A.

      True

    • B.

      False

    • C.

      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:

  • 11. 

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

    • A.

      True

    • B.

      False

    • C.

      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:

Quiz Review Timeline +

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.