Basic MS Excel 2010 Online Test

How many Rows are there in Excel 2010 worksheet?

How many Columns are there in Excel 2010 worksheet?

Maximum possible zoom in Excel is…....

Which of the following key/key combination will move your cursor one cell to the right ?

What is the address of last cell Excel 2010?

Which column follows immediately after column Z in Excel 2010?

What is default extension of file in Excel 2010?

Data can be sorted at multiple levels in Excel 2010?

Which statement regarding formatting is true?

Header & Footer can be displayed only in…....

Once you go to print preview mode, you either have to print or cancel because there is no way to go back and edit your spreadsheet.

You cannot print worksheet in parts.

$C$3 is example of which type of cell reference?

Which key is used to move between different types of cell references?

How will you enter Text in formulas?

'True' argument in VLOOKUP function denotes ________match.

With _________ Excel change the appearance of your data based on its value.

Conditional Formatting can be applied to text.

You can have more than one rule for a cell or range of cells in conditional formatting.

You can limit the data shown on a worksheet by creating ______

Filter can be applied to rows as well as to columns.

An Excel tool with which you can create worksheets that can be sorted, filtered, and rearranged dynamically to emphasize different aspects of your data.

Graphical filter objects in Pivot table is called as _____

What is not a type of chart in Excel 2010?

Which of the following is a description of the pie chart?


This test is aimed to test the basic knowledge of MS Excel 2010. Test may have multiple choice questions, True or False type questions or fill in the blanks type questions.
This test will have 25 questions. This is time bound test and the time will be 20 minutes.


Mizzi Smiff

test will not load says error getting test

1598 days 1 hours 45 minutes ago


asdsda asdad

2357 days 15 hours 18 minutes ago



2357 days 15 hours 18 minutes ago


I cant even get this test to load and have tried many times. any hints?

2440 days 4 hours 50 minutes ago

Larissa Brewington

This test is NOT practical. No one cares about how many cells there are. It's about how to apply the info. Questions like, "How do you change the sum of this cell?" are what people work with... Otherwise, you're wasting time.

2672 days 13 hours 14 minutes ago


This is a great test showing your knowledge of the use of Excel 2010.
Thank you.

2715 days 2 hours 13 minutes ago

Haribhau Raskar

all que of excell

3049 days 17 hours 49 minutes ago

Tests: 2

Your Facebook Friends on WizIQ

More Tests By Author

MS Excel
6 Questions | 19930 Attempts