MS Office Excel 2007/2010 Intermediate - Pre Test

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

True

False

I Dont Know

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.

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.

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

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.

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.

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

The Insert Function key is located within the Function Library Group in the Formula Tab.

Explanation

The Insert Function key is located within the Function Library Group in the Formula Tab.

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

True

False

I Dont Know

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.

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.

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

True (Valid)

False (Not Valid)

I Dont Know

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.

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.

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

True

False

I Dont Know

The default extension file for Excel 2007/2010 is .exls.

Explanation

The default extension file for Excel 2007/2010 is .exls.

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

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.

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.

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

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.

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.

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

True

False

I Dont Know

The given formula "=DATE(NOW)" is incorrect. The correct formula to create the current date and time is "=NOW()". Therefore, the answer is 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.

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

not-available-via-ai

Explanation

not-available-via-ai

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

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.

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.