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?



























Description:

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.

Discussion

Mizzi Smiff

test will not load says error getting test

188 days 3 hours 17 minutes ago

Asd

asdsda asdad

947 days 16 hours 50 minutes ago

Asd

asdasda

947 days 16 hours 50 minutes ago

Terry

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

1030 days 6 hours 22 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.

1262 days 14 hours 47 minutes ago

Evelyn

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

1305 days 3 hours 45 minutes ago

Haribhau Raskar

all que of excell

1639 days 19 hours 22 minutes ago

2 Followers
Tests: 2

Your Facebook Friends on WizIQ

More Tests By Author

MS Excel
6 Questions | 19489 Attempts