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

Naldsauza

Community Contributor

Quizzes Created: 21 | Total Attempts: 16,239

| Attempts: 352

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/11 Questions

In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)
- True
- False
- I Dont Know

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.

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:

1
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

MS Office Excel 2007/2010 Intermediate - Pre Test

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

Quiz Preview

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

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

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

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

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

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

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

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

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

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