DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Columns, rows, and charts
|
|
|
Columns, rows, and cells
|
|
|
Columns, rows, and formulas
|
|
|
None of the above
|
Detailed explanation-1: -Columns, rows and cells are what you see when you open Excel. They are typically used for holding various variables that are to be processed into useful informations. Columns are the vertical sections of a workbook while the horizontal sections are referred to as rows.
Detailed explanation-2: -The Excel Starter startup screen appears, and a blank spreadsheet is displayed. In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them.
Detailed explanation-3: -Rows are the horizontal lines in the worksheet, and columns are the vertical lines in the worksheet. In the worksheet, the total rows are 10, 48, 576, while the total columns are 16, 384. In the worksheet, rows range from 1 to 1, 048, 576, while columns range from A to XFD.
Detailed explanation-4: -The cell. An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they form little boxes called cells.
Detailed explanation-5: -Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.