Question

How will you select the long range of cells A1: H50?​plz ans

Answer 1

Answer:

Medieval archaeology is the study of humankind through its material culture, specialising in the period of the European Middle Ages. At its broadest, the period stretches from the 5th to the 16th century and refers to post-Roman but pre-modern remains. The period covers the upheaval caused by the Fall of the Western Roman Empire and cultures such as the Vikings, the Saxons, and the Franks. Archaeologists often specialise in studying either the Early Middle Ages (Migration Period) or the High Middle Ages and Late Middle Ages, although many projects and professionals move across these chronological boundaries. The rich nature of the medieval written record has meant that archaeology has often been seen as the "handmaiden to history",[1] especially in the Late Middle Ages. Analysis of material culture may enrich or call into question written evidence from the medieval period and the two sources of evidence need to be used together. Medieval archaeology has examined the development of medieval settlements, particularly the development of medieval towns and castles. It has also contributed to understanding of the spread and development of Christian monasticism during the medieval period.

Answer 2

Answer:

when the range of cells to be selected is very large dragging the mouse through the range can be cumbersome in such case you can do the following:

click a corner cell at the starting cell of the range

press f8 key the status bar shows that the extend selection mode is turned on

click the diagonal opposite cell or the last cell of the range the range of cells will be selected

press f8 again to turn off extend selection off or press the esc key.

OR

CLICK THE CELL AT ONE CORNER OF THE RANGE. CLICK THE HOME TAB. UNDER THE EDITING GROUP CLICK THE FIND AND SELECT BUTTON. CLICK GO TO A PRESS THE F5 KEY OF PRESS CONTROL + G THE GO TO DIALOGUE BOX APPEARS. TYPE THE CELL ADDRESS OF THE OPPOSITE CORNER OF THE RANGE IN THE REFERENCE TEXTBOX SIMPLY IT OR ENTER THE RANGE A1:E8. in the first case hold down the shift key when clicking ok or pressing the enter key in the second case click ok or press the enter key