excel lessons 4 & 6 100 200 400 300 400 definitions true or falseformulasformatting 300 200 400...
TRANSCRIPT
![Page 1: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/1.jpg)
Excel
Lessons 4 & 6
![Page 2: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/2.jpg)
100 100
200 200200
400 400
300300
400400
Definitions True or False Formulas Formatting
300 300 300300
200200
400400
200
100100
500 500 500500 500500
100
![Page 3: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/3.jpg)
Row 1, Col 1
What will be performed first in a formula that does not contain
parentheses: addition, exponentiation, multiplication
or subtraction?
Exponentiation (Excel 69)
![Page 4: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/4.jpg)
1,2
In a formula containing a relative cell reference, the
operators stay the same, but the cell references change when the
formula is copied.
True! (Excel 71)
![Page 5: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/5.jpg)
1,3
Adds the values in A25 and A26
=A25 + A26 (Excel 69)
![Page 6: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/6.jpg)
1,4
Change the contrast of the picture
Click the More Contrast or Less Contrast button on the Picture toolbar. (Excel 123)
![Page 7: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/7.jpg)
2,1
A(n) ___ cell reference does not change when it is moved or
copied to a new cell.
Absolute (Excel 71)
![Page 8: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/8.jpg)
2,2
The AutoCalculation feature of Excel may be used to
determine the sum of a group of numbers without inserting a formula into the worksheet.
True!! (Excel 76)
![Page 9: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/9.jpg)
2,3
Raises the value in A25 to the 27th power
= A25^27 (Excel 69)
![Page 10: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/10.jpg)
2,4
Change the brightness of the picture.
Click the More Brightness or Less Brightness button on the Picture toolbar. (Excel 123)
![Page 11: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/11.jpg)
3,1
A(n) ___ cell reference adjusts to its new location when copied
or moved.
Relative (Excel 71)
![Page 12: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/12.jpg)
3,2
The sorting buttons on the toolbar are identified by an icon of the letters “AZ” and an up or
down arrow.
TRUE (Excel 109 & 111)
![Page 13: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/13.jpg)
3,3
Divides the value in A25 by 27, then adds the value to A26
= A25/27+A26 (Excel 69)
![Page 14: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/14.jpg)
3,4
Restore the picture to the original font
Click the Reset Picture button on the Picture toolbar. (Excel 123)
![Page 15: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/15.jpg)
4,1
A ___ cell reference contains both relative and absolute
references.
MIXED (Excel 71)
![Page 16: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/16.jpg)
4,2
The plus sign (+) is an example of an operand in a worksheet
formula.
FALSE (an operator – Excel 68)
![Page 17: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/17.jpg)
4,3
Multiplies the value in A25 times 27
= A25*27 (Excel 69)
![Page 18: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/18.jpg)
4,4
Drag the sizing handles on the sides of the picture.
Resize the picture
![Page 19: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/19.jpg)
5,1
The ___ function is the most frequently used type of function
formula.
SUM (Excel 75)
![Page 20: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/20.jpg)
5,2
With the point-and-click method of cell referencing, you click the cell instead of keying a
cell reference.
TRUE (Excel 73)
![Page 21: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/21.jpg)
5,3
Divides the value in A25 by 27
= A25/27 (Excel 123)
![Page 22: Excel Lessons 4 & 6 100 200 400 300 400 Definitions True or FalseFormulasFormatting 300 200 400 200 100 500 100](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697bfa91a28abf838c9a17d/html5/thumbnails/22.jpg)
5,4
Crop the picture (trim the edges) handles
Click the Crop button on the toolbar and then drag the sizing handle. (Excel 123)