Excel Practical Exam

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

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

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

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

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

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

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

Question #8: Char(65) will return ___________

Question #9: Form option is present in _________ menu.

Question #10: Set of Work sheet is called as __________

Question #11: The extension of the workspace file is _________

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

Question #13: _________ is the shortcut key for spell check.

Question #14: Protect sheet and protect worksheet are ___________

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

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

Question #17: The Spelling tool is placed on ______ toolbar.

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

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

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

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

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

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

Question #24: ___________ is the shortcut for Redo.

Question #25: The Shortcut key for Font dialog box is ____________

Question #26: The Default row height is ____________

Question #27: The default Zoom size is ________

Question #28: Abs(-125) will return __________

Question #29: Len(“computer”) will return ___________

Question #30: __________ is the shortcut key for paste command.

Question #31: The Shortcut key for Undo is ____________

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

Question #33: Text to columns present in __________ menu.

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

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

Question #36: ODBC is the acronym for ________________

Question #37: __________ toolbar is used to run a macro.

Question #38: ________ generates the serial number automatically.

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

Question #40: Merge cells option can be applied from ____________

Question #41: We can remove borders applied in cells by ____________

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

Question #43: We can set page border in excel from ___________

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

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

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

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

Question #48: The Default Column width is __________

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

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