Study Guide Flashcards
What are the two types of formating?
Number formating and Colours & fonts.
How to select non continuous ranges?
Press and hold the ctrl key while selecting the other ranges
How do you change the number format (decimals, dollar sign, comma, etc.)?
Home tab, Number Section
How to force recalculation?
F9
What are the three different page veiws?
Normal, Page Layout, Page Break Preveiw
Where are Borders found?
Home tab, Font section
How to edit row or column Height?
Three ways…
- Click on rows/columns and then drag or double click
- Go to the selected rows/columns, right-click, then put in a number that matches row height.
- Click on rows/columns, under Home tab go to the cells section and under format click the desired height/with function
How to add a text wraP?
Two ways…
- Hold alt + press enter
2. Cell dialogue box go-to alignment and check text wrap.
Where to find conditional Formatting?
Home tab, Section styles
What are the five different sets of pictures you can put on excel
Pictures, Clip Art, Shapes, Smart Art, and Screenshots
How to insert a picture?
Insert tab, Under the illustration section pick picture, double click picture, then insert.
How to remove the background of a Picture?
Two ways with different results…
- Click on Picture, go to the Picture tools format tab, Press remove the background
- Click on Picture, go to the Picture tools format tab, press colour under the adjustment tab and select a transparent colour.
how to make a shape snap to grid lines?
Alt, Click and drag!
How to insert a smart art?
Press the insert tab and under illustrations
How to create a sub bullet under smart art?
Press the tab key on a new bullet
How to open the text pane box
Under smart art design tools and create graphics section
Or double headed arrow
How to change text effect
Go to the format tab then word art styles then text effect
How to find the themes section?
Page layout tab, then under themes.
How to create a theme?
Under page layout and theme section, go to colour and then create theme.
How to create a font theme?
Page layout, then theme section, then font.
How to create a cell style?
Home tab then under styles.
Where can you edit a style?
Home tab, under style, click on style or select create new.
Then select what you want to be part of your style.
What can a style change?
Font, alignment, number format, fill, broader, protection
