DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. Excel includes four types of sparkline charts: line, column, win/loss and stock. Rotated text allows you to fit more text into a smaller column width.
Detailed explanation-2: -Why would you not use a sparkline? You would not use a sparkline if you need to show specific details in your chart or need to augment the informative chart elements.
Detailed explanation-3: -To select the non-adjacent cells, press Shift+F8. This, in turn, enables the Add or Remove Selection mode. Now, use the arrow keys to move the selection and select the cells you want.
Detailed explanation-4: -Depending on the type of chart, a chart may have a chart title, a horizontal axis title, and a vertical axis title. However, a pie chart would not have axes titles because it has no axes.