DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Meeting between rows and columns
|
|
|
Meeting between cells and ranges
|
|
|
Worksheet in excel
|
|
|
Groups from worksheets
|
Detailed explanation-1: -A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook. A workbook can contain many worksheeks.
Detailed explanation-2: -Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs. The worksheet itself is hidden. To unhide a worksheet, right-click on any visible tab and then click Unhide.
Detailed explanation-3: -A worksheet has a single spreadsheet containing data. A set of worksheets can be added in a workbook.
Detailed explanation-4: -A spreadsheet is a configuration of rows and columns. Rows are horizontal vectors while columns are vertical vectors. A spreadsheet is also known as a worksheet.