SP | MCQs

Explanation

In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box

In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

Explanation

In Excel we can Find and Replace within the sheet or workbook.

Explanation

Excel sheet:

Cells: The basic unit of an Excel sheet, where data is entered. 

Rows: Horizontal lines that run across the sheet, numbered sequentially. 

Columns: Vertical lines that run down the sheet, identified by alphabetical letters. 

Workbook: A collection of one or more worksheets within a single Excel file. 

Explanation

Excel 2003 and earlier 65,536 Rows.

Excel 2007 and higher 1,048,576 Rows.

and 16,384 columns

ND5-2-2023

Explanation

• in a computer spreadsheet block of numbers is called a range
• In a computer, spreadsheet rows are labeled: By numbers
• 
  
• In a spreadsheet, letters are used to represent Columns

Explanation

The option that corrects the spelling of words automatically in Microsoft Word is "Auto Correct."

Explanation

The MS Office feature to automatically correct spelling mistakes during typing in a document is called "AutoCorrect."

Explanation

Spell checker programs use a dictionary.

They compare the words in your text against a list of correctly spelled words stored in the dictionary to identify and correct spelling errors.

Explanation

Describing the color used to indicate a spelling error in Microsoft Office:

Red: Indicates a spelling error.

Blue: Highlights grammar errors.

Green: Suggests a possible correction or contextual error.

Yellow: Highlights repeated words or other inconsistencies.

Explanation

• the shortcut key used to insert the trademark (TM) symbol is Ctrl+Alt+T
• **
  
• To insert the copyright symbol, press Ctrl+Alt+C.
  
• To insert the trademark symbol, press Ctrl+Alt+T.
• **
• Keyboard Shortcuts - Windows ALT-Codes and Unicode Symbols

  To type this symbol	Press this on your keyboard	Description
  ™	Alt+0153	Trademark
  ©	Alt+0169	Copyright
  ®	Alt+0174	Registered
  ‰	Alt+0137	Per mille (per thousand)