DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Caps Lock
|
|
|
Tabs
|
|
|
Worksheet tabs
|
|
|
Scroll bars
|
Detailed explanation-1: -The status bar is used to move the screen up, down, left and right. For this purpose, it has vertical and horizontal scroll bars. To move the screen up and down, vertical scroll bar is used. While to move the screen left and right, horizontal scroll bar is used.
Detailed explanation-2: -However, you can turn scroll bars on or off as needed. Click the File tab. Click Options, and then click the Advanced category. Under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars.
Detailed explanation-3: -A vertical or horizontal bar commonly on the far right or bottom of a window that lets you move the window viewing area up, down, left, or right.
Detailed explanation-4: -There are two scroll bars in Excel: a vertical scroll bar is used to view the data in Excel from up and down, and another scroll bar is a horizontal scroll bar used to view the data from left to the right.