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

Naldsauza

Community Contributor

Quizzes Created: 21 | Total Attempts: 15,505

Questions: 11 | Attempts: 352 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

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

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:

1
0
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

MS Office Excel 2007/2010 Intermediate - Pre Test

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

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

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

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

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

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

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

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