MS Excel – Online Education & Certification

Results

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

Edit

Ignore

Ignore all

Change

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

Edit

Format

View

Tools

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

Format

Edit

Tools

Review

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

Edit

Format

Insert

Review

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

End key

Shift key

Esc key

None of these

#6. In excel the column width changes from _ to ____

8 to 15

15 to 25

25 to 50

None of these

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

Change

Not Change

Rename

None

#8. Char(65) will return ___________

#9. Form option is present in _________ menu.

Format

Edit

Data

Review

#10. Set of Work sheet is called as __________

Work Book

Sheet

Book

None

#11. The extension of the workspace file is _________

.xls

.doc

.xml

.html

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

Sorting

Filter

Format

Formula

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

#14. Protect sheet and protect worksheet are ___________

Different

Same

Unique

None

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

Ctrl+9

Ctrl+0

Ctrl+1

Ctrl+8

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

100

300

500

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

Standard

Formatting

Drawing

Reviewing

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

Formula

Function

Series

Syntax

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

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

Gradient

Pattern

Solid

Texture

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

Shift+F2

Shift+F3

Shift+F4

Shift+F5

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

#23. _ and are the two type of chart type.

Pie and bar

Group and Shapes

Line and Rectangle

None

#24. ___________ is the shortcut for Redo.

Ctrl+Y

Ctrl+Z

Ctrl+N

Ctrl+A

#25. The Shortcut key for Font dialog box is ____________

Ctrl+F

Ctrl+Shift+F

Alt+F

Ctrl+E

#26. The Default row height is ____________

#27. The default Zoom size is ________

100%

90%

200%

300%

#28. Abs(-125) will return __________

125

-125

1250

None

#29. Len(“computer”) will return ___________

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

Ctrl+V

Ctrl+C

Ctrl+X

Ctrl+E

#31. The Shortcut key for Undo is ____________

Ctrl+Z

Ctrl+Y

Ctrl+V

Ctrl+X

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

Formula

Name Box

Cell Box

None

#33. Text to columns present in __________ menu.

Home

Formulas

Insert

Data

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

#35. and ___ are the two types of filter.

Clear and Reapply

Clear and Filter

Advanced and Reapply

None

#36. ODBC is the acronym for ________________

Open Database Connectivity

Open Data Connectivity

Open Date Connectivity

Open Data Character

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

View

Zoom

Macros

Save Workspace

#38. ________ generates the serial number automatically.

Fill

Sum

Auto

Hide

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

100

10000

1000

#40. Merge cells option can be applied from ____________

Home

Formulas

Data

Review

#41. We can remove borders applied in cells by ____________

No border

Left Border

All border

Right border

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

Space Bar

Enter

Esc

Ctrl

#43. We can set page border in excel from ___________

Insert

Home

Data

Review

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

Table

Data

Content

Formula

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

Percentage

Date

Time

Currency

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

Return Today Date

Return Today Date and Time

Return Yesterday Date

Return Yesterday Date and Time

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

Autocorrect

Edit

Change

Ignore

#48. The Default Column width is __________

8.9

8.43

8.3

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

Cell

Conditional

Format

Font

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

Data

Formula

Home

Insert

#51. On an excel sheet the active cell in indicated by ?

A dotted border

A dark wide border

A blinking border

By italic text

#52. You can use the horizontal and vertical scroll bars to

Split a worksheet into two panes

View different rows and columns

Edit the contents of a cell

View different worksheets

#53. What term describes explanatory text attached to a cell ?

Context

Callout

Comment

Dialog

#54. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

Unfreeze panes command on the window menu

Freeze panes command on the window menu

Hold titles command on the edit menu

Split command on the window menu

#55. A function inside another function is known as ?

Round function

Sandwich function

Switch function

Nested function

#56. Which function calculates your monthly mortage payment ?

NPER

PMT

All of above

#57. Got functions? No? You need the insert function dialog box. How do you get it?

Right click a cell and then click insert

Click the insert menu and then click function

Type = in a cell

All of the above

#58. Which of the following is not true regarding Conditional Formatting?

You can add more than one condition to check

You can set condition to look for Bold and apply Italics on them.

You can apply Font, border and pattern formats that meets the specified conditions

You can delete any condition from Conditional Formatting dialog box if it is not required

#59. ?In a worksheet you can select

The entire worksheet

Rows

Columns

All of the above

#60. Which of the following is not an underline option in the format cells dialog box?

Double

Single Accounting

Double Accounting

Single Engineering

Finish

Results

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

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

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

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

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

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

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

#8. Char(65) will return ___________

#9. Form option is present in _________ menu.

#10. Set of Work sheet is called as __________

#11. The extension of the workspace file is _________

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

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

#14. Protect sheet and protect worksheet are ___________

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

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

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

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

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

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

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

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

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

#24. ___________ is the shortcut for Redo.

#25. The Shortcut key for Font dialog box is ____________

#26. The Default row height is ____________

#27. The default Zoom size is ________

#28. Abs(-125) will return __________

#29. Len(“computer”) will return ___________

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

#31. The Shortcut key for Undo is ____________

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

#33. Text to columns present in __________ menu.

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

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

#36. ODBC is the acronym for ________________

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

#38. ________ generates the serial number automatically.

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

#40. Merge cells option can be applied from ____________

#41. We can remove borders applied in cells by ____________

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

#43. We can set page border in excel from ___________

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

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

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

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

#48. The Default Column width is __________

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

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

#51. On an excel sheet the active cell in indicated by ?

#52. You can use the horizontal and vertical scroll bars to

#53. What term describes explanatory text attached to a cell ?

#54. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

#55. A function inside another function is known as ?

#56. Which function calculates your monthly mortage payment ?

#57. Got functions? No? You need the insert function dialog box. How do you get it?

#58. Which of the following is not true regarding Conditional Formatting?

#59. ?In a worksheet you can select

#60. Which of the following is not an underline option in the format cells dialog box?

#6. In excel the column width changes from _ to ____

#23. _ and are the two type of chart type.

#35. and ___ are the two types of filter.