MS Excel 2007 And 2010 Quiz! Test

1. There are pivot graphs and pivot tables to present large data in real-time in excel 2007/2010.

True

False

Pivot graphs and pivot tables are indeed available in Excel 2007/2010 to present large data in real-time. These tools allow users to analyze and summarize data quickly and efficiently by providing interactive visual representations and dynamic tables that can be easily updated as the data changes. This feature is particularly useful when dealing with large datasets and enables users to gain insights and make informed decisions based on the data presented.

Explanation

Pivot graphs and pivot tables are indeed available in Excel 2007/2010 to present large data in real-time. These tools allow users to analyze and summarize data quickly and efficiently by providing interactive visual representations and dynamic tables that can be easily updated as the data changes. This feature is particularly useful when dealing with large datasets and enables users to gain insights and make informed decisions based on the data presented.

2. Default extension files for Excel 2007/2010 is:

Docx

Pptx

Exls

Xlsx

The default extension file for Excel 2007/2010 is "xlsx". This file format was introduced in the newer versions of Excel and is used to store spreadsheets and data. The "xlsx" extension indicates that the file is in the XML-based format, which allows for better compatibility and improved features compared to the older "xls" format.

Explanation

The default extension file for Excel 2007/2010 is "xlsx". This file format was introduced in the newer versions of Excel and is used to store spreadsheets and data. The "xlsx" extension indicates that the file is in the XML-based format, which allows for better compatibility and improved features compared to the older "xls" format.

3. What symbol represents the absolute reference in MS Excel?

$

&

%

#

The symbol "$" represents the absolute reference in MS Excel. An absolute reference is used to keep a specific cell reference constant when copying a formula to other cells. By using the "$" symbol before the column letter and row number, the cell reference will not change when the formula is copied. This is useful when referencing a fixed value or a constant in a formula that needs to remain the same across different cells.

Explanation

The symbol "$" represents the absolute reference in MS Excel. An absolute reference is used to keep a specific cell reference constant when copying a formula to other cells. By using the "$" symbol before the column letter and row number, the cell reference will not change when the formula is copied. This is useful when referencing a fixed value or a constant in a formula that needs to remain the same across different cells.

4. If the number is 364.66667, what is the final number if we use formula =ROUND(a cell that contains 364.66667,0)?

365

364.7

364

364.6

The formula =ROUND(a cell that contains 364.66667,0) rounds the number to the nearest whole number. In this case, the number 364.66667 is rounded up to the nearest whole number, which is 365.

Explanation

The formula =ROUND(a cell that contains 364.66667,0) rounds the number to the nearest whole number. In this case, the number 364.66667 is rounded up to the nearest whole number, which is 365.

5. Shortcut key for Print Preview in Excel 2010 is:

Ctrl + F2

Alt + F2

Shift + F2

Ctrl + Alt + F2

The correct shortcut key for Print Preview in Excel 2010 is Ctrl + F2. This key combination allows users to quickly preview how their spreadsheet will look when printed, helping them to make any necessary adjustments before printing.

Explanation

The correct shortcut key for Print Preview in Excel 2010 is Ctrl + F2. This key combination allows users to quickly preview how their spreadsheet will look when printed, helping them to make any necessary adjustments before printing.

6. Which formula is false in Excel 2007/2010?

=SUMIF(D4:D10,">600")

=ROUNDUP(C2/C3,1)

=IF(AVERAGE(B3:B6)>25,SUM(B3:B6),0)

=LEFTS(D4)

The formula =LEFTS(D4) is false in Excel 2007/2010. This is because there is no built-in function called "LEFTS" in Excel. The correct function to extract the leftmost characters from a cell is =LEFT(D4).

Explanation

The formula =LEFTS(D4) is false in Excel 2007/2010. This is because there is no built-in function called "LEFTS" in Excel. The correct function to extract the leftmost characters from a cell is =LEFT(D4).

7. What result for the following formula? =if(c2>500,"good","not good") where value in c2=500

Not good

Good

Not valid

No result appear

The formula checks if the value in cell C2 is greater than 500. Since the value in C2 is equal to 500, the condition is not met and the formula returns the value "not good".

Explanation

The formula checks if the value in cell C2 is greater than 500. Since the value in C2 is equal to 500, the condition is not met and the formula returns the value "not good".

8. Formula's that can find any value related with finance are:

SUM(), LEFT(), DSUM()

FV(), CONCATENATE(), NOW()

FV(), NPV(), PV()

DAY(), Now(), Today()

The formulas FV(), NPV(), and PV() are used in finance to calculate different values. FV() is used to calculate the future value of an investment, NPV() is used to calculate the net present value of cash flows, and PV() is used to calculate the present value of an investment. These formulas are commonly used in financial analysis and planning to evaluate investments and determine their profitability.

Explanation

The formulas FV(), NPV(), and PV() are used in finance to calculate different values. FV() is used to calculate the future value of an investment, NPV() is used to calculate the net present value of cash flows, and PV() is used to calculate the present value of an investment. These formulas are commonly used in financial analysis and planning to evaluate investments and determine their profitability.

9. What formula to combine several texts at several cells into one cell?

=CONSOLIDATE()

=CONCATENATE()

=TRIM()

=MID()

The correct answer is =CONCATENATE(). This formula is used to combine several texts at several cells into one cell. It allows you to merge multiple cell values or text strings together into a single cell. By using this formula, you can easily concatenate or join text from different cells or ranges, and customize the result by adding separators or additional text.

Explanation

The correct answer is =CONCATENATE(). This formula is used to combine several texts at several cells into one cell. It allows you to merge multiple cell values or text strings together into a single cell. By using this formula, you can easily concatenate or join text from different cells or ranges, and customize the result by adding separators or additional text.

10. Formula to create current date and time is:

=DATE(NOW)

=DAY(NOW)

=NOW()

=(DATE)

The correct answer is =NOW(). The NOW() function is used to retrieve the current date and time in Excel. It returns the current date and time as a serial number, which can be formatted in different ways. So, using =NOW() in a cell will display the current date and time when the worksheet was last recalculated.

Explanation

The correct answer is =NOW(). The NOW() function is used to retrieve the current date and time in Excel. It returns the current date and time as a serial number, which can be formatted in different ways. So, using =NOW() in a cell will display the current date and time when the worksheet was last recalculated.

11. What exactly the year 2001! means in excel 2007/2010?

Absolute reference

Name of worksheet

Name of cell reference

One of function in math and trig

The year 2001! in Excel 2007/2010 does not have any specific meaning. It is not an absolute reference, name of a worksheet, name of a cell reference, or a function in math and trig. Therefore, it can be concluded that the given answer "name of worksheet" is incorrect.

Explanation

The year 2001! in Excel 2007/2010 does not have any specific meaning. It is not an absolute reference, name of a worksheet, name of a cell reference, or a function in math and trig. Therefore, it can be concluded that the given answer "name of worksheet" is incorrect.

12. WHAT IS THE LAST COLUMN AND ROW FOR EXCEL 2007/2010?

IV, 65536

XFD, 1048576

Unlimited

ZZZ, 999999

The last column and row for Excel 2007/2010 is XFD and 1048576 respectively. In Excel, columns are labeled with letters starting from A and going up to XFD, which is the 16384th column. Rows are numbered starting from 1 and go up to 1048576. Therefore, XFD represents the last column and 1048576 represents the last row in Excel 2007/2010.

Explanation

The last column and row for Excel 2007/2010 is XFD and 1048576 respectively. In Excel, columns are labeled with letters starting from A and going up to XFD, which is the 16384th column. Rows are numbered starting from 1 and go up to 1048576. Therefore, XFD represents the last column and 1048576 represents the last row in Excel 2007/2010.

13. One of the features that help users make using spreadsheets quicker and faster is Insert Function Utility. Where is the location for the Insert Function Utility key?

Formula Tab --> within Function Library group

Formula Tab --> within Defined Named group

Insert Tab --> within Function Library Group

Insert Tab --> within Defined Named group

The Insert Function Utility key is located in the Formula Tab within the Function Library group. This feature allows users to easily insert functions into their spreadsheets, making it quicker and faster to perform calculations and data analysis.

Explanation

The Insert Function Utility key is located in the Formula Tab within the Function Library group. This feature allows users to easily insert functions into their spreadsheets, making it quicker and faster to perform calculations and data analysis.