Apply Custom Formats and Layouts

Question 1

Special/Custom Format

Answer 1

Ctrl + 1 = Format cells

Pick format that’s close + then modify in custom

Question 2

Custom date format

Answer 2

1. Select range –> if it is not already in some sort of date format, grab a format
2. Format cells Ctrl + 1
3. Select Custom category
4. Select format – if selecting date, remove what’s in front to remove regional setting

• Can copy the format and paste in a cell to visualize it
• If you create a custom format, it will show on format cells.
• You’re able to delete a custom format that you have created, not the ones that are built in

Question 3

Accounting

Answer 3

Moves a little away from the right alignment

Question 4

Currency

Answer 4

Moves closer to the right alignment for the decimal points

Question 5

Customizing Fill Series:

Answer 5

1. Home
2. Editing Group
3. Fill
4. Series

Question 6

Autofill days of week

Answer 6

1. Type day of the week
2. Select range
3. Autofill

Question 7

Autofill date

Answer 7

1. Type date
2. Select range
3. Autofill

Question 8

Fill series with names

Answer 8

1. Write several names
2. Select range
3. Autofills with three names repeatedly

Question 9

How to autofill from 1-5000

Answer 9

1. Home
2. Fill
3. Series
4. Type in range 1 to 5000

Question 10

Growth value fill

Answer 10

1. Home
2. Fill
3. Series
4. Type
5. Growth
6. Fill in range

Question 11

Fill series: Row

Answer 11

Filling series across

Question 12

Fill series: Column

Answer 12

Filling series down

Question 13

Fill series: Growth

Answer 13

Multiple each value created by step value

Question 14

Data validation

Answer 14

1. Select range
2. Data tab
3. Data validation
4. Settings
5. Select conditionals

Question 15

Data validation has two additional features/tabs:

Answer 15

1. Input message

2. Error

Question 16

Data validation with lists

Answer 16

1. Select range
2. Data validation
3. Settings
4. Source
5. Select Range

• Or select named range to use as a list
• Or type in values

Question 17

What is conditional formatting

Answer 17

Additional customization that can be applied to highlight or find values can be performed through advanced conditional formatting

Question 18

Where to find conditional formatting?

Answer 18

Home –> under styles tab –> conditional formatting

Question 19

Conditional formatting on the worksheet:

Answer 19

Select conditional formatting –> manage rules –> show formatting rules for:

• Conditional formatting is dynamic

Question 20

Conditional formatting and If statements

Answer 20

If you’re creating a formula, the assumption is that it is an IF statement already, and you’re telling what the CONDITION is that needs to be met in order to apply the formatting. You don’t need to use an IF.

Question 21

Customization can also be applied to:

Answer 21

Templates, styles, colors, fonts and themes

Question 22

Changing default font

Answer 22

File –> Options –> General

Question 23

Color schemes and fonts sets can be customized under

Answer 23

Page Layout –> Theme Group –> color or Fonts –> Customize

After you modify colors/fonts/effects, you can save as a new theme

Question 24

Save current theme

Answer 24

Page layout –> select theme –> save theme

Question 25

Customize cell

Answer 25

Select cells you want to customize –> Home –> Cell styles (or the style box with options, click the arrow down)

new cell style –> Format – Change the cell style –> Click the style

Question 26

See identified range/tables

Answer 26

Control + F3