Microsoft Excel - Quiz

The name box appears at the?
  • A left of the formula bar
  • B right of the formula bar
  • C below the status bar
  • D below the menu bar

Shortcut to edit the selected cell?
  • A F3
  • B F8
  • C F4
  • D F2

Which dialogue box we can use to name a constant?
  • A Create Name
  • B Define Name
  • C Get Name
  • D Create Constant

The accounting style shows negative numbers in?
  • A Bold
  • B Italics
  • C Parentheses
  • D Quotes

What term describes a background that appears as a grainy, non-smooth surface?
  • A Pattern
  • B Gradient
  • C Texture
  • D Velvet

Each excel can contain many sheets including worksheets and chart sheets.
  • A True
  • B False

Which shortcut can be used to Switch between open workbooks?
  • A Ctrl + F2
  • B Ctrl + F6
  • C Ctrl + F8
  • D Ctrl + F10

You can check the conditions against ____ when applying conditional formatting?
  • A Cell Value
  • B Formula
  • C Both of above
  • D None of above

In Excel Worksheet how can you show or hide the gridlines?
  • A Click Gridline tool on Forms toolbar
  • B Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • C Both of above
  • D None of above

You can convert existing Excel worksheet data and charts to HTML document by using the?
  • A Internet Assistant Wizard
  • B Intranet Wizard
  • C Import Wizard
  • D Export Wizard