Study Guide

Question 1

What are the two types of formating?

Answer 1

Number formating and Colours & fonts.

Question 2

How to select non continuous ranges?

Answer 2

Press and hold the ctrl key while selecting the other ranges

Question 3

How do you change the number format (decimals, dollar sign, comma, etc.)?

Answer 3

Home tab, Number Section

Question 4

How to force recalculation?

Answer 4

F9

Question 5

What are the three different page veiws?

Answer 5

Normal, Page Layout, Page Break Preveiw

Question 6

Where are Borders found?

Answer 6

Home tab, Font section

Question 7

How to edit row or column Height?

Three ways…

Answer 7

1. Click on rows/columns and then drag or double click
2. Go to the selected rows/columns, right-click, then put in a number that matches row height.
3. Click on rows/columns, under Home tab go to the cells section and under format click the desired height/with function

Question 8

How to add a text wraP?

Two ways…

Answer 8

1. Hold alt + press enter

2. Cell dialogue box go-to alignment and check text wrap.

Question 9

Where to find conditional Formatting?

Answer 9

Home tab, Section styles

Question 10

What are the five different sets of pictures you can put on excel

Answer 10

Pictures, Clip Art, Shapes, Smart Art, and Screenshots

Question 11

How to insert a picture?

Answer 11

Insert tab, Under the illustration section pick picture, double click picture, then insert.

Question 12

How to remove the background of a Picture?

Two ways with different results…

Answer 12

1. Click on Picture, go to the Picture tools format tab, Press remove the background
2. Click on Picture, go to the Picture tools format tab, press colour under the adjustment tab and select a transparent colour.

Question 13

how to make a shape snap to grid lines?

Answer 13

Alt, Click and drag!

Question 14

How to insert a smart art?

Answer 14

Press the insert tab and under illustrations

Question 15

How to create a sub bullet under smart art?

Answer 15

Press the tab key on a new bullet

Question 16

How to open the text pane box

Answer 16

Under smart art design tools and create graphics section

Or double headed arrow

Question 17

How to change text effect

Answer 17

Go to the format tab then word art styles then text effect

Question 18

How to find the themes section?

Answer 18

Page layout tab, then under themes.

Question 19

How to create a theme?

Answer 19

Under page layout and theme section, go to colour and then create theme.

Question 20

How to create a font theme?

Answer 20

Page layout, then theme section, then font.

Question 21

How to create a cell style?

Answer 21

Home tab then under styles.

Question 22

Where can you edit a style?

Answer 22

Home tab, under style, click on style or select create new.

Then select what you want to be part of your style.

Question 23

What can a style change?

Answer 23

Font, alignment, number format, fill, broader, protection