102Ntest

102Ntest - Instructions 1. 0.14 For Excel 2007 users,...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Instructions 1. 0.14 For Excel 2007 users, follow the directions below 1. Click on the Office Button (far left looks like a lot of windows). 2. Scroll down to the bottom of the list and look to the right for Excel Options 3. Click Trust Center. Click on the Trust Center Settings. 4. Click on the Macro Settings, then click on Enable all Macros. Close and re-2. Videos showing how to use these Excel sheets are on the CD that com 3. You can scroll up and down on a sheet by using the scroll bars to the 4. You can go to different sheets by clicking on any of the sheet names 5. An Excel sheet is made up of "cells". A cell can be located by the co 6. These sheets are set up so that you can only type in the white cells. A 7. To use a sheet as a calculator, click in a white cell and type "=", then Example Click in any white cell below and type, =(2+3)/(7-10) and pres Solution Solution-1.67 The cell to the left is C23 because it is in c 8. To change a decimal to a fraction, right mouse click on the cell and c Example Change the numbers in cells C26and D26 to fractions. -1.67 0.06 Solution- 5/ 3 31/512 9. Example Change the number is cells C30 and D30 so that they show 7 120.02 100234.12 If there is not enough for 10. Example Change the number is cells C33 and D33 so that they are in s 12342000 Solution 1.234E+07 1.230E-04 11. Using cells for calculations - To evaluate the expression 2x - 5 when You need to enable the macros for the buttons on the Exce Click on the button below. If you get a random decimal below the button, then you do not, then follow the directions to the right. Click in cell C23 to see the correct way of typing in the expres To change the number of digits to the right of the decimal point, righ change the number of "Decimal Places". To change a number so that it is in scientific notation, right mouse cl the number of "Decimal Places" if needed.-3-11 Note: We could type any number in ce 12. To unprotect a sheet on Office 2007, click on Review, then click on U 13. To evaluate roots of numbers, use fractional exponents. To evaluate t s on how to use these Excel sheets 1. Click on Tools and choose Macro, then 2. Click Low. Click OK and click OK a 3. Close the file (the file must be closed and re 4. Open the file again and you will get one of w. s button.-open the file. omes with your textbook and also on your Blackboard site. You will need to e right. You can scroll left and right by using the scroll bars at the bottom r s at the bottom left. olumn and row it is in. All the other cells are "protected". n type in the expression. ss enter. You should get -1.66667 column C and in row 23. choose "Format Cell". Choose the "Number" tab and choose "Fraction" and 7 decimal places....
View Full Document

Page1 / 823

102Ntest - Instructions 1. 0.14 For Excel 2007 users,...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online