Show:
Misc. 1
Misc. 2
Misc. 3
Misc. 4
Mis. 5
100
How do you delete an image that is in the spreadsheet?
By clicking the image, then pressing the delete key.
100
How can you place a ClipArt image in your spreadsheet?
Click the insert tab, click clipart, search for picture you want, and click on it.
100
How can you rotate an image that is placed in a spreadsheet?
Position the mouse pounter over the green rotation handle and drag it to the desired location.
100
How can you save a workbook as a web page file?
Click Save As, create file name, and in the Save as Type, click Single File Web Page.
100
How can you insert a symbol in an Excel spreadsheet?
Click the Insert tab, click the symbol button, find symbol, and click insert.
200
How can you add a hyperlink to text in a spreadsheet?
Right click on the text you want to be a link, select hyperlink, type address in the address bar, click ok.
200
How can you edit a hyperlink?
Right click on link, click edit hyperlink,make your changes, click ok.
200
How can you insert the Registered symbol in a spreadsheet without using the Insert symbol feature?
Typing (r) and pressing space bar
200
How can you resize an image? There are two ways.
1.) Use the measurement boxes, change height and width 2.) Drage one of the sizing handles.
200
Can you change the color of a ClipArt picture once it is inserted in to an spreadsheet? If so, how?
Yes. Click the recolor option.
300
How can you copy a shape without using the toolbars or menus?
Click on existing shape, hold the control key down, and drag the shape.
300
How can you change an image to be mirrored? (i.e. recall the bird flying to the right, we now want it to fly to the left)
Click the rotate button, and select Flip Horizontal.
300
How do you insert a text box?
Click Insert Tab, click insert shape, click text box; or just click text box button.
300
How can you insert a picture as a watermark?
Click the Insert tab, click header/footer, click the picture button, select the correct file, click ok.
300
Where can you find a cycle graphic? (i.e. graphics showing flows of things, gears, etc.
Click the Insert tab, click SmartArt Graphic.
400
Give an example of when would be a good time to use an IF statement.
Instructor will determine if answer is correct.
400
What formula tells you how much money you have to send in a month on a loan?
What is PMT (the payment function).
400
What three pieces of information do you need to determine how much your monthly payment would be on a loan?
Principal (amount borrowed), Interest rate (rate the lending company charges you to borrow the money, and Term (the length of time you take out the loan).
400
Which formula function returns the highest number from a group of numbers?
What is MAX.
400
Which formula function returns the lowest number from a group of numbers?
What is MIN.
500
When writing a formula that requires one cell to be used in every calcuation, what must you do to that cell in the formula to keep it from changing?
What is make it absolute, press F4, or type a $ in front of the column letter and a dollar sign in front of the $ row number.
500
What is the feature called that allows you to quickly copy formulas by dragging it down through other cells?
What is the Autofill handle.
500
Approximately, how many rows are there in a spreadsheet?
Over 1 million.
500
What is the toolbar called that contains the save, undo, and redo buttons?
What is Quick Access Toolbar.
500
What is the button called that selects every cell in a spreadsheet?
What is the Select All Button.