FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
A
Font
B
Format Cell
C
Cell Styles
D
Find & Select
Explanation: 

Detailed explanation-1: -Press Ctrl+H or go to Home > Find & Select > Replace. In Find what, type the text or numbers you want to find. You can further define your search: Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Detailed explanation-2: -Find and Replace helps you to find words or formats in a document and can let you replace all instances of a word or format. This is particularly handy in long documents. To use Find and Replace, use the shortcut Ctrl+H or navigate to Editing in the Home tab of the ribbon, then choose Replace.

Detailed explanation-3: -The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review, View and Help. The Home tab contains the most frequently used commands in Excel.

Detailed explanation-4: -On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Cells.

There is 1 question to complete.