FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ is directly above worksheet and below the ribbon on the top left corner of screen.
A
Worksheet tabs
B
Name box
C
Active cell
D
Title bar
Explanation: 

Detailed explanation-1: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.

Detailed explanation-2: -The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box.

Detailed explanation-3: -Quick Access Toolbar In addition to the ribbon that accommodates most commands available to you in Excel, a small set of frequently used commands is located on a special toolbar at the top of the Excel window for quick access, hence the toolbar name.

Detailed explanation-4: -The correct answer is the Formula bar. Among the options, the formula bar appears at the top of a worksheet in MS Excel. It is located directly above the spreadsheet.

Detailed explanation-5: -Name Box: The name box appears to the left of the formula bar and displays the name of the current cell. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.

There is 1 question to complete.