DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
<Ctrl+X>
|
|
|
<Alt+V>
|
|
|
<Ctrl+B>
|
|
|
<Ctrl+A>
|
Detailed explanation-1: -By keyboard: First, press F6 to activate the sheet tabs. Next, use the left or right arrow keys to select the sheet you want, then you can use Ctrl+Space to select that sheet. Repeat the arrow and Ctrl+Space steps to select additional sheets. Right-click a sheet tab, and then click the Select All Sheets option.
Detailed explanation-2: -After entering the text you want to find, select Workbook in the “Within” drop-down list. Then, you can click Find Next to go through all matches, or click Find All to see all matches. You can use the keyboard shortcut Ctrl + F to open the Find and Replace box.
Detailed explanation-3: -You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note: Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column.