USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Spreadsheet specialists usually format a worksheet before they enter any data. Spreadsheet specialists often assign names to a cell or range of cells so that they can select them quickly. An alternative to a one-input data table is a three-input data table.
Detailed explanation-2: -The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you. This topic does not explain how to use a data form to enter data in worksheet.
Detailed explanation-3: -A workbook contains one or more worksheets. 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.
Detailed explanation-4: -The Rows command on the Insert menu or the Insert command on the shortcut menu allow rows to be inserted between rows that already contain data. 36. When rows are inserted into a worksheet, if rows that are shifted down include any formulas, Excel adjusts the cell references to the new locations.