DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Tab scrolling buttons
|
|
|
Order of precedence
|
|
|
Active cells
|
|
|
Currency format
|
Detailed explanation-1: -First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced-in under Display options for this workbook-and then ensure that there is a check in the Show sheet tabs box.
Detailed explanation-2: -Down in the bottom left corner of the screen to the left of the worksheet tabs, you’ll find the worksheet navigation buttons. These nav buttons come into play when you create so many worksheet tabs that they disappear behind the scroll bar divider.
Detailed explanation-3: -If you have a lot of tabs open, you can use the “Ctrl+Tab” shortcut to cycle through them quickly. This shortcut will move you forward through the tabs one at a time. You can also use the “Ctrl+Shift+Tab” shortcut to move backwards through the tabs one at a time.
Detailed explanation-4: -Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key. Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.