DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
F1
|
|
|
F3
|
|
|
F5
|
|
|
F7
|
Detailed explanation-1: -F5 Displays the Go To dialog box. Ctrl+F5 restores the window size of the selected workbook window.
Detailed explanation-2: -F5 Display-> Change. Switches from display to change mode. Shift F5 Filter; restrict values to search on Matchcode list.
Detailed explanation-3: -The F5 key is a function key found at the top of almost all computer keyboards. The key is often used to refresh a web page in an Internet browser. As mentioned below, F5 also has other uses depending on the computer and program.
Detailed explanation-4: -To move to the next cell to the right, press TAB. To move to the next cell to the left, press SHIFT + TAB. To move to the edge of a data region, press CONTROL + Arrow Keys. To move to the first cell in the row, press HOME.