Total Possible

Points
Max Scores 100 100 100 100 30 30 30 30 520

Names Test 1 Test 2 Test 3 Test 4 Quiz 1 Quiz 2 Quiz 3 Quiz 4 Total
Sioux 80 87 62 80 25 28 21 23 416
Gigi 75 82 55 87 24 22 22 19 396
Chantel 95 100 82 99 25 30 23 22 486
Dean 94 99 81 98 23 30 21 28 484
Miki 92 95 87 91 25 30 25 28 483
Mo 89 89 79 100 24 30 26 30 477
Average 87.50 92.00 74.33 92.50 24.33 28.33 23 25 457

07/25/2025 - 09:06:51 Page 1 of 20 EB01(C)

 Extra Points

% Grade
Decimal
80.00% Grade
76.15% #NAME?
93.46% #NAME?
93.08% #NAME?
92.88% #NAME?
91.73% #NAME?
87.88% #NAME?
#NAME?

07/25/2025 - 09:06:51 Page 2 of 20 EB01(C)

 Excel Basis #1: Formulas, Functions, Formatting, Cell References & Page Setup
#NAME? What is Excel?
#NAME? Default Alignment
#NAME? Enter Data
#NAME? Fill Handle & Angry Rabbit
#NAME? Old School Formulas
#NAME? Dynamic Spilled Array Formulas
#NAME? SUM, AVERAGE & XLOOKUP Built-in Functions
#NAME? Number Formatting
#NAME? Excel’s Golden Rule
#NAME? Page Setup

07/25/2025 Page 3 of 20 Topics

Page Setup

07/25/2025 Page 4 of 20 Topics

 H I J K L M N O P Q R S T U V W
1 What is Excel? Keyboard to move (activate) the next sheet:
2 1 Two-way grid Ctrl + PgDn = move to right and activate next sheet
3 2 Column = Letter Ctrl + PgUp = move to left and activate next sheet
4 3 Row = Number Open Activate dialog box: Right-click Scroll Arrows
5 4 Cell = Intersection of Column and Row
6 5 Worksheet = All Cells
7 6 Sheet Tab = Name of Worksheet. You can select (or activate) a worksheet with your mouse cursor.
8 7 Workbook = File = All Worksheets (and other behind the scenes things such as: (Queries, Data Model and VBA)
9 8 Excel does two things: 1) Calculations, like Worksheet Formula, and 2) Data Analysis, like PivotTable
10
11 1) 2) Product Sales Product Sum of Sales
12 3 Quad 23 Carlota 137
13 4 Carlota 67 Quad 75
14 5 Carlota 46 Total Result 212
15 Total: 12 =SUM(J12:J14) Worksheet Formula that result in text answer Quad 9
16 Quad 43
17 Worksheet Formula that results in number answer Carlota 24
18
19 9 Ribbon has tabs, tabs have groups and groups have buttons and dropdowns to enact commands
20 10 QAT (Quick Access Toolbar) has buttons to enact commands
21 11 Default Alignment indicates Data Type:
22 Text is aligned to left
23 Numbers are aligned to right
24 Logical Values (Boolean) are aligned center and Capitalized
25 Error Message is centered Database Export
26 35
27 Text: Word Excel Word 36
28 Number: 43 8:00 AM 2/3/2025 43.12 8:00AM 12/31/2024 37
29 Logical: 1 0 Total?
30 Error #DIV/0! #N/A
31
32 12 Number Formatting is a façade. Number Formatting displays a number in a certain way on the surface of the cell, without changing the underlying number.
33 Formulas do not see Number Formatting. Formulas act on the underlying number.
34
35 Sales Sales Tax Rate Sales Tax $
36 3 3.4 0.04 100.00 4
37 4 4.4 =P36*O36
38 5 5.4
39 Total: 12 <= Which one is right? => 13.2 #1 most ask question in online Excel formulas for decades is about Number Formatting.
40
41 * Use the General Number Formatting to wipe away all Number Formatting and see what number is actually in the cell.

07/25/2025 Page 5 of 20 WIE

Cursors:
Selection Cursor
Move Cursor
Fill Handle
Cross Hair = Angry Rabbit Cursor
Use Angry Rabbit to increment Text and Numbers, Dates, Numbers, Months and more. Use it to copy numbers and formulas.
Put data or formula in cell:
Enter = Put thing in cell and move selected cell down
Ctrl + Enter = Put thing in cell and keep cell selected
Tab = Put thing in cell and move selected cell to right
Shift + Enter = Put thing in cell and move selected cell up
Enter data into selected range: Enter moves down until last cell and then jumps to top of next column.
Excel's Golden Rule:

If a formula input can change, put it in a cell, label it, and refer to it in the formula with a cell reference. If the input will never change, like
24 hours in a day, then you can hard code it into formula.
Examples of formula inputs that can change: SalesRep name like: Luong, Sales amount like: 100, Tax Rates like: 0.0375 or 3.75%,
Sales Hurdles like: >500.
Examples of formula inputs that will not change: Months in a year: 12, Hours in a day: 24, Days in a week: 7.
Formatting:
Number Formatting is a façade. Number Formatting displays a number in a certain way on the surface of the cell, without changing the
underlying number. Formulas do not see Number Formatting. Formulas act on the underlying number.
Style Formatting = Fill Color, Font Color, Borders and more (Not Number Formatting)
Creating formulas:
All formulas start with an = sign as the first character in the cell
Cell References are used in formulas to refer to cells with numbers and other content, like K2 or C7:J7
Relative Cell References = When you copy formula, the cell reference moves relative the cell with the formula
Absolute Cell Reference is created with F4 key. A $ sign is put in front of Column Reference and Row Reference, so cell reference will not
move throughout copy action.
Enter cell references into formula with Mouse or Arrow Keys. Use Arrows when cell is close, use Mouse when cell is not close.
Alt + = = SUM Function
F2 = put cell in Edit Mode and place cursor at end of formula
F4 = When cursor touching cell reference in Edit Mode, F4 adds dollar signs to lock the row and column references
Arrow Key = when creating a formula in Edit Mode, Arrow Keys will hunt for cell references
Tab = When function name is highlighted in blue, Tab, enters the function into the formula
Calculation / Formula Types:
Aggregate calculation = From many numbers (range or array) to calculate one answer, like SUM to get a total or AVERAGE to calculate the
average (mean: add up and divide by the count)
Single-Input Single-Output formulas (Old School Formulas) = have to lock cell references, manually copy formula, and editing must be
done in top cell and then you must re-copy formula through range. Because a single input is placed on either side of an operator, or in a
function argument, the formula can only deliver a single answer.
Dynamic Spilled Array Formulas (DSAF):

An array formula is a formula where there is two or more items (in a range or an array) on either side of the operator (like math * or /, or
in a function argument) are then causes the formula to deliver more than one answer that spills to the cells below the cell with the
formula. A Dynamic Spilled Array Formula is "dynamic" because if the results expand or contact, the spilled range expands or contracts.

Benefits: Usually do not have to lock cell references, do not have to manually copy formula, and editing is only done in top cell
Formula only lives in top cell
Cells below top cell show ghost formulas, but do not actually have a formula in the cell
When making a formula you can refer to any cell in the dynamic spilled range with a cell reference
If you type data in the path of the spilled array, you get a #SPILL! Error

07/25/2025 Page 6 of 20 Notes - Excel Basics 01

Functions shown in video:
ROUND(number,num_digits) = Round a number.
number = Number that you want to round.

num_digits = Position that you want to round to. 4 = 4th position to the right of the decimal. 2 = to the penny. 0 = to the dollar.
XLOOKUP(lookup_value,lookup_array,return_array,[if_not_found],[match_mode],[search_mode]) = Lookup a value.
lookup_value = item used to find match in lookup_array
lookup_array = yields relative position to be used to retrieve item in return_array
return_array = contains items that you want to lookup or retrieve
* lookup_array and return_array must be the same size.
[if_not_found] = what to put in cell if lookup_value is not found in lookup_array
[match_mode] =

0 - Exact Match = Default. "Quad" matches "Quad". "Quad " does NOT match "Quad". If no match and nothing in 4th argument, #N/A.
-1 - Exact Match or Next Smaller = Use for items like tax rates and commission rates. Values do not have to be sorted.
1 - Exact Match or Next Bigger = Use for items like square footage. Values do not have to be sorted.
2 - Wildcards => * = zero or more characters, ? = single character. "Quad*" finds anything that begins with "Quad". "*?" finds any
text.
3 - Regex = coding language to extract text
[search_mode] =
1 - Search First to Last = Default. When there are duplicates, it gets FIRST ONE!
-1 - Search Last To First = When there are Duplicates, it gets LAST ONE!

2 - Binary search for Smallest To Biggest Sort = Column must be sorted. Like old VLOOKUP and MATCH Approximate Match Lookup.
2 - Binary search for Biggest To Smallest Sort = Column must be sorted. Like old MATCH -1 Approximate Match Lookup.
IFERROR(value, value_if_error) = replace error with value.
value = the value that is checked for an error.
value_if_error = The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!,
#DIV/0!, #NUM!, #NAME?, or #NULL!.
SUM(number1, [number2], ...) = adds numbers to get a total.
Number1 Required. The first number, cell reference, or range for which you want the average.

Number2, ... Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.

AVERAGE(number1, [number2], ...) = Returns the average (arithmetic mean) of the arguments (add numbers then divide by the count)
Number1 Required. The first number, cell reference, or range for which you want the average.

Number2, ... Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.
Page Setup:
Page Setup dialog box = Page Layout Ribbon tab, Page Setup group, Dialog Launch arrow in lower right corner (keyboard = Alt, P, S, P)
Tabs: Page, Margins, Header/Footer, Sheet
Useful keyboards:
Ctrl + B = Bold and Ctrl + U = Underline
Ctrl + ; = Todays Date
Ctrl + * (Ctrl + Shift + 8) = select current range (everything until it bumps into all empty cells)
Ctrl + Arrow will jump selected cell down to last cell with data
Ctrl + Shift + Arrow will select range down to last cell with data
Ctrl + 1 = open Format Cells dialog box
Shift Selection Trick: Click cell, hold Shift, Click last cell to highlight everything in between
Ctrl Selection Trick: Click cell, hold Ctrl, Click other cell to highlight cells that are not next to each other (noncontiguous cells)

07/25/2025 Page 7 of 20 Notes - Excel Basics 01

07/25/2025 Page 8 of 20 Notes - Excel Basics 01
 A B C D E F G H I J K L M N O P Q
1 Extra Credit
2 5
3
4 Total
5 Max Points 100 100 100 100 30 30 30 30 520
6
7 Name Test 1 Test 2 Test 3 Test 4 Quiz 1 Quiz 2 Quiz 3 Quiz 4 Total % Grade % Grade Decimal Grade % Grade Decimal Grade
8 Sioux 88 87 92 100 25 21 29 29 476 0.9154 0.9154 #NAME? 0 0
9 Gigi 78 78 87 91 24 22 30 14 429 0.825 0.825 #NAME? 0.61 0.7
10 Chantel 99 92 100 99 25 25 30 28 503 0.9673 0.9673 #NAME? 0.62 0.8
11 Dean 100 91 100 98 26 24 30 27 501 0.9635 0.9635 #NAME? 0.63 0.9
12 Miki 92 98 99 90 21 19 30 29 483 0.9288 0.9288 #NAME? 0.64 1
13 Mo 95 87 97 84 25 18 30 30 471 0.9058 0.9058 #NAME? 0.65 1.1
14 Average 92 89 96 94 24 22 30 26 477 0.9176 0.9176 #NAME? 0.66 1.2
15 0.67 1.3
16 Formula in cell K5: =SUM(C5:J5) 0.68 1.4
17 #NAME? OR: ### 0.69 1.5
18 0.7 1.6
19 0.71 1.7
20 0.72 1.8
21 Formula in cell C14: =AVERAGE(C8:C13) OR: Formula in cell C14: {=_xlfn.bycol(C8:N13,_xleta.average)} 0.73 1.9
22 0.74 2
Rows 23 to 38
39
are hidden so 0.91 3.7
40 image fits on 0.92 3.8
41 one page 0.93 3.9
42 0.94 4

FinishedProject 9 of 20 07/25/2025 - 09:06:51

Max Point: 100 100 100 100 30

Name Test 1 Test 2 Test 3 Test 4 Test 5

mick 88 56 78 66 5
Hari 75 34 86 88 34
Pawan 67 42 45 65 55
Nishan 90 98 80 33 57
Mo 34 50 66 56 88
Ram 56 88 45 22 20
Average

11/14/2024 11/15/2024 11/16/2024 11/17/2024 11/18/2024 11/19/2024

Jan Feb Mar Apr May Jun

1/1/2024 1/2/2024 1/3/2024 1/4/2024 1/5/2024 1/6/2024

Wed Thu Fri Sun Mon Tue

11/14/2024 11/15/2024 11/16/2024 11/18/2024 11/19/2024
 30 30 30 30 550

Quiz1 Quiz2 Quiz3 Quiz4 Total %Grade %Grade Decimal Grade

18 88 76 45 530 0.9636 0.9636
33 44 79 98 581 1.0564 1.0564
56 43 33 93 509 0.9255 0.9255
78 42 55 94 637 1.1582 1.1582
33 66 96 55 554 1.0073 1.0073
98 69 97 52 557 1.0127 1.0127

11/20/2024 11/21/2024 11/22/2024

Jul Aug Sep Oct Nov Dec

1/7/2024 1/8/2024 1/9/2024

Tue Wed Thu

%Grade Decimal Grade
0 0 sun mon tue
0.61 0.99
0.61
0.61
0.61
0.61
0.61
0.61
0.61
0.61

0
0
0
0
0
0
 Extra Credit
5

Total
Max Points 100 100 100 100 30 30 30 30 520

Name Test 1 Test 2 Test 3 Test 4 Quiz 1 Quiz 2 Quiz 3 Quiz 4 Total % Grade % Grade Decimal Grade
Sioux 88 87 92 100 25 21 29 29 476 0.9154 0.9154 #NAME?
Gigi 78 78 87 91 24 22 30 14 429 0.825 0.825 #NAME?
Chantel 99 92 100 99 25 25 30 28 503 0.9673 0.9673 #NAME?
Dean 100 91 100 98 26 24 30 27 501 0.9635 0.9635 #NAME?
Miki 92 98 99 90 21 19 30 29 483 0.9288 0.9288 #NAME?
Mo 95 87 97 84 25 18 30 30 471 0.9058 0.9058 #NAME?
Average 92 89 96 94 24 22 30 26 477 0.9176 0.9176 #NAME?

GradebookW(1)(an) 13 of 20 07/25/2025 - 09:06:51

 Extra Credit

Total
Max Points 100 100

Name Test 1 Test 2 Test 3 Test 4 Quiz 1 Quiz 2 Quiz 3 Quiz 4 Total % Grade % Grade Decimal Grade
Sioux 88 88 0.88 0.88 #NAME?
Gigi 87 87 0.87 0.87 #NAME?
Chantel 92 92 0.92 0.92 #NAME?
Dean 98 98 0.98 0.98 #NAME?
Miki 99 99 0.99 0.99 #NAME?
Mo 52 52 0.52 0.52 #NAME?
Average 86 0 0 0 0 0 0 0 86 0.8600 0.8600 0

GradebookS(2)(an) 14 of 20 07/25/2025 - 09:06:51

 Extra Credit
5

Total
Max Points 100 100 100 100 30 30 30 30 520

Name Test 1 Test 2 Test 3 Test 4 Quiz 1 Quiz 2 Quiz 3 Quiz 4 Total % Grade % Grade Decimal Grade
Sioux 88 87 92 100 25 21 29 29 #NAME? #NAME? #NAME? #NAME?
Gigi 78 78 87 91 24 22 30 14 #NAME? #NAME?
Chantel 99 92 100 99 25 25 30 28 #NAME? #NAME?
Dean 100 91 100 98 26 24 30 27 #NAME? #NAME?
Miki 92 98 99 90 21 19 30 29 #NAME? #NAME? 0.123
Mo 95 87 97 84 25 18 30 30 #NAME? #NAME?
Average #NAME? 0.1200

GradebookBRBC(an) 15 of 20 07/25/2025 - 09:06:51

Using the picture below, create the gradebook as shown in the picture below. A solution is also shown on the worksheet "HW
Average #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

Total
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
shown on the worksheet "HW(1an)".
#NAME? #NAME? #NAME?
 A B C D E F G H I J K L M N O P Q R
1
2 Total Extra Credit
3 Max Points 50 50 50 50 50 50 100 75 75 200 750 5
4
5 Student Name Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 MidTerm Test 6 Test 7 Final Total % Grade Decimal Grade % Grade Decimal Grade
6 Mohamed Aziz 50 49 48 49 50 33 82 50 73 175 664 0.8853333333 #NAME? 0 0
7 Timmy Cartman 22 36 41 33 20 48 43 40 31 142 461 0.6146666667 #NAME? 0.450 0.5
8 Gigi Gabar 26 30 10 37 29 14 99 62 0 184 496 0.6613333333 #NAME? 0.465 0.6
9 Miki Ito 41 39 38 31 37 48 77 74 70 192 652 0.8693333333 #NAME? 0.480 0.7
10 Shinnay Mims 46 45 41 45 49 50 85 75 75 182 698 0.9306666667 #NAME? 0.495 0.8
11 Kenny Noline 46 48 46 50 48 44 99 70 68 191 715 0.9533333333 #NAME? 0.510 0.9
12 Lin Pham 15 29 22 31 37 11 55 42 36 87 370 0.4933333333 #NAME? 0.525 1
13 Dean Washington 48 49 48 45 43 45 98 71 69 195 716 0.9546666667 #NAME? 0.540 1.1
14 Average 37 41 37 40 39 37 80 61 53 169 597 0.7953333333 #NAME? 0.555 1.2
15 0.570 1.3
16 Formula in cell M3: =SUM(C3:L3) 0.585 1.4
17 #NAME? OR: Formula in cell M6: {=_xlfn.byrow(C6:L13,_xleta.sum)+N3} 0.600 1.5
18 0.615 1.6
19 0.630 1.7
20 Formula in cell C14: =AVERAGE(C6:C13) OR: Formula in cell C14: {=_xlfn.bycol(C6:L13,_xleta.average)} 0.645 1.8
21 Bottom of lookup table: 0.660 1.9
22 0.675 2
23 0.840 3.1 0.690 2.1
24 0.855 3.2 0.705 2.2
25 0.870 3.3 0.720 2.3
26 0.885 3.4 0.735 2.4
27 0.900 3.5 0.750 2.5
28 0.915 3.6 0.765 2.6
29 0.930 3.7 0.780 2.7
30 0.945 3.8 0.795 2.8
31 0.960 3.9 0.810 2.9
32 0.975 4 0.825 3