DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Ribbon
|
|
Tools tab
|
|
Live Preview
|
|
Status bar
|
Detailed explanation-1: -The status bar at the bottom of Office programs displays status on options that are selected to appear on the status bar. Many options are selected by default. If you want to customize the status bar, right-click it, and then click the options that you want.
Detailed explanation-2: -Gridlines in Excel[1] are the horizontal and vertical gray lines that differentiate between cells in a worksheet. The gridlines guide users to differentiate between the specific cells and read the data in an organized manner. They also help users navigate through the worksheet columns and rows with ease.
Detailed explanation-3: -Excel also grays out many menus while you are completing a formula. Check the formula bar first to make sure that your cursor is not in a cell with a formula in progress. Cancel or accept the formula to unlock inactive menus.
Detailed explanation-4: -Zoom control is a slider that lies next to view buttons at the right end of the status bar. It helps zoom in and zoom out the document. Move the slider to right or click on the plus sign to zoom in and move it to left or click on the minus sign to zoom out.
Detailed explanation-5: -You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.