FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color button in the Font group on the ____ tab of the Ribbon.
A
Home
B
Page Layout
C
Data
D
Review
Explanation: 

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.

There is 1 question to complete.