Excel Practical Exam

Results

next

#1 Which of the following is not an option in the spelling dialog box?

next

#2 We can quickly change the appearance of your work by choosing Auto Format from the _________ Menu.

next

#3 To protect a worksheet, we can choose protection and the protect sheet from the __________ menu.

next

#4 We can open the highlight changes dialog box by choosing track changes from the ____________ menu.

next

#5 To copy cell contents using drag and drop, press the _________

next

#6 In excel the column width changes from _________ to ____________

next

#7 It is possible to _________ the name of the cell.

next

#8 Char(65) will return ___________

next

#9 Form option is present in _________ menu.

next

#10 Set of Work sheet is called as __________

next

#11 The extension of the workspace file is _________

next

#12 We can use maximum 3 fields at the same time during ________

next

#13 _________ is the shortcut key for spell check.

next

#14 Protect sheet and protect worksheet are ___________

next

#15 _____________ is the shortcut key to hide the selected column.

next

#16 Which of the following is not a valid zoom percentage in Excel?

next

#17 The Spelling tool is placed on ______ toolbar.

next

#18 “Qtr 1, Qtr 2, Qtr 3” is an example of a ___________

next

#19 We can edit existing excel data by pressing the ____________

next

#20 What term describes a background that appears as a grainy, non smooth surface?

next

#21 _____________ is the shortcut key to edit a cell.

next

#22 Each Scenario can change a maximum of _________ cells.

next

#23 _____________ and ____________ are the two type of chart type.

next

#24 ___________ is the shortcut for Redo.

next

#25 The Shortcut key for Font dialog box is ____________

next

#26 The Default row height is ____________

next

#27 The default Zoom size is ________

next

#28 Abs(-125) will return __________

next

#29 Len(“computer”) will return ___________

next

#30 __________ is the shortcut key for paste command.

next

#31 The Shortcut key for Undo is ____________

next

#32 The left end of the formula bar is called as _________

next

#33 Text to columns present in __________ menu.

next

#34 ___________ Number of sheets are opened when excel opens the workbook.

next

#35 __________ and _____________ are the two types of filter.

next

#36 ODBC is the acronym for ________________

next

#37 __________ toolbar is used to run a macro.

next

#38 ________ generates the serial number automatically.

next

#39 The function power(10,2) Will return ___________

next

#40 Merge cells option can be applied from ____________

next

#41 We can remove borders applied in cells by ____________

next

#42 If we press _________ the cell accepts your typing as its contents.

next

#43 We can set page border in excel from ___________

next

#44 We can check the conditions against __________ when applying conditional formatting.

next

#45 Formatting a cell in number format we can’t set as _____________

next

#46 By applying today() function, the result is __________

next

#47 _____________ is not an option in the spelling dialog box.

next

#48 The Default Column width is __________

next

#49 We can apply condition to the table using ___________ formatting.

next

#50 We can group all the details in __________ menu.

finish