# MS Excel 2007 And 2010 Quiz! Test

13 Questions | Total Attempts: 1381  Settings  Are you familiar with MS Excel 2007, and would you be interested in answering these questions? 2007 version is the legacy version of MS Office with Word, Excel, or PowerPoint. It includes applications such as Word, Excel, PowerPoint, and Outlook. Also included in Microsoft 2007 is the Outlook email client and access, a database management program. If you want to learn more about Microsoft Excel 2007, you have come to the right place.

• 1.
Default extension files for Excel 2007/2010 is:
• A.

Docx

• B.

Pptx

• C.

Exls

• D.

Xlsx

• 2.
Shortcut key for Print Preview in Excel 2010 is:
• A.

Ctrl + F2

• B.

Alt + F2

• C.

Shift + F2

• D.

Ctrl + Alt + F2

• 3.
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?
• A.

Formula Tab --> within Function Library group

• B.

Formula Tab --> within Defined Named group

• C.

Insert Tab --> within Function Library Group

• D.

Insert Tab --> within Defined Named group

• 4.
Formula to create current date and time is:
• A.

=DATE(NOW)

• B.

=DAY(NOW)

• C.

=NOW()

• D.

=(DATE)

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

365

• B.

364.7

• C.

364

• D.

364.6

• 6.
What formula to combine several texts at several cells into one cell?
• A.

=CONSOLIDATE()

• B.

=CONCATENATE()

• C.

=TRIM()

• D.

=MID()

• 7.
WHAT IS THE LAST COLUMN AND ROW FOR EXCEL 2007/2010?
• A.

IV, 65536

• B.

XFD, 1048576

• C.

Unlimited

• D.

ZZZ, 999999

• 8.
Which formula is false in Excel 2007/2010?
• A.

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

• B.

=ROUNDUP(C2/C3,1)

• C.

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

• D.

=LEFTS(D4)

• 9.
What symbol represents the absolute reference in MS Excel?
• A.

\$

• B.

&

• C.

%

• D.

#

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

True

• B.

False

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

Not good

• B.

Good

• C.

Not valid

• D.

No result appear

• 12.
Formula's that can find any value related with finance are:
• A.

SUM(), LEFT(), DSUM()

• B.

FV(), CONCATENATE(), NOW()

• C.

FV(), NPV(), PV()

• D.

DAY(), Now(), Today()

• 13.
What exactly the year 2001! means in excel 2007/2010?
• A.

Absolute reference

• B.

Name of worksheet

• C.

Name of cell reference

• D.

One of function in math and trig

Related Topics Back to top