DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Home
|
|
Page Layout
|
|
Data
|
|
Review
|
Detailed explanation-1: -Click the View tab on the Ribbon, then select the Split command. The workbook will be split into different panes. You can scroll through each pane separately using the scroll bars, allowing you to compare different sections of the workbook.
Detailed explanation-2: -Answer: Conditional formatting is automatically updated if you change data in the worksheet.
Detailed explanation-3: -Tip: To make page setup changes, on the Print Preview tab, in the Print group, click Page Setup, and then select the options that you want on the Page, Margins, Header/Footer, or Sheet tabs of the Page Setup dialog box.
Detailed explanation-4: -On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.