Informatika | Alapismeretek, ECDL » Kuncicky and Larsen - Introduction to Excel

Source: http://www.doksinet Introduction to Excel, 3rd ed. Kuncicky and Larsen Solutions to Practice! Problems Practice! Problem, Section 1.81 Step 2. Step 4. Maximum Size of a Worksheet: 256 columns, 65536 rows. Source: http://www.doksinet Practice! Problem, Section 1.93 Practice! Problem, Section 2.21 Source: http://www.doksinet Practice! Problem, Section 2.21b Practice! Problem, Section 2.23 Practice! Problem, Section 2.34 Source: http://www.doksinet Practice! Problem, Section 2.52 Before After Sort Source: http://www.doksinet Practice! Problem, Section 3.32 Practice! Problem, Section 3.4 Practice! Problem, Section 3.42 • • • • • • • Trigonometric Sine: SIN() Inverse Hyperbolic Tangent: ATANH() Natural Logarithm: LN() Base 10 Logarithm: LOG10(), or LOG() with omitted base argument Raise e to a power: EXP() Convert Radians to Degrees: DEGREES() Convert Degrees to Radians: RADIANS() Source: http://www.doksinet Practice! Problem, Section 3.43

Practice! Problem, Section 3.5 There is an error in Figure 3.38 “Circumference” should be “Area” in cell B3 Source: http://www.doksinet Practice! Problem, Section 3.5b Practice! Problem, Section 4.22 Practice! Problem, Section 4.3 1. Enter the data Source: http://www.doksinet 2. Select a data set (eg, A4:B8) 3. Press F11 The resulting chart is shown below 4. The chart created after selecting the thermocouple data (D4:E16) looks like this: Source: http://www.doksinet Practice! Problem, Section 4.46 Formatted for Black and White Printer Formatted for Color Display Source: http://www.doksinet Practice! Problem, Section 5.72 Source: http://www.doksinet Practice! Problem, Section 5.73 Part 1. Linear Trendline, Equation and R2 displayed, Intercept set to zero, Forecast backwards 1.7 units Part 2. 6th Order Polynomial (other options turned off) Part 3. Moving Average with Period = 2 (other options turned off) Source: http://www.doksinet A moving average

trendline with unsorted data is a mess! Practice! Problem, Section 6.3 Data entry using a Data Entry Form is useful for helping get the right information into the correct column. Source: http://www.doksinet Practice! Problem, Section 6.4 Practice! Problem, Section 6.52 Source: http://www.doksinet Practice! Problem, Section 6.53 Practice! Problem, Section 6.54 Part 1, Method 1: Part 2, Method 2: Source: http://www.doksinet End