Mixed spreadsheet reference 2026-10-14
A mixed spreadsheet reference fixes exactly one coordinate.
$A2 fixes column A and lets the row follow the copy; B$1 fixes row 1 and lets the column follow the copy. Put in A2:A4 and in B1:D1. Store =$A2*B$1 in B2, then fill the rectangle B2:D4. The colon denotes the inclusive rectangular range between the named corner spreadsheet cells. Each spreadsheet formula reads its row's factor from column A and its column's factor from row 1, producing a multiplication table.Original multiplication table showing how two mixed spreadsheet references anchor the column and row independently during two-dimensional copying
. Details. Copying from
B2 to D4 moves two columns right and two rows down. The mixed spreadsheet references become $A4 and D$1, so D4 contains =$A4*D$1 and has value . For comparison, under that same displacement A2 becomes C4, $A$2 remains $A$2, $A2 becomes $A4, and A$2 becomes C$2. These four cases express the independent choice for each coordinate. Microsoft's official table demonstrates the same four possibilities for a two-row, two-column copy. [ref]Switch between relative, absolute, and mixed references, Microsoft Support. Switch between relative, absolute, and mixed references: final four-row table, absolute column/row, relative column/absolute row, absolute column/relative row, and relative column/row
The filled rows have values , , and . The multiplication table works because the left factor moves only vertically and the top factor moves only horizontally. Without the anchors, copying
=A2*B1 from B2 to D4 would give =C4*D3, reading interior results rather than the intended boundary inputs.// Target: computer-science.bigb
Multiplication table Created 2026-10-14 Updated 2026-10-31
A multiplication table lists the products of the factors labeling its rows and columns. Each cell is determined by one multiplication; the same arrangement can serve as a spreadsheet tabular model.
Past exam of the mathematics course of the year 2 of the natural sciences course of the University of Cambridge 2001 Paper 2 10 Solution Created 2026-10-18 Updated 2026-10-20
Representations. A complex group representation is a group homomorphism to the invertible linear maps on a vector space. It is an irreducible representation when and the only invariant subspaces are and .
Group table. The supplied matrices satisfy , , and . Their multiplication table isThe table proves closure and gives identity and an inverse for every element; associativity is inherited from matrix multiplication. The table is symmetric, so the group is abelian. It is the Klein four-group .
Dimensions and conjugacy. The sum of squares of irreducible representation dimensions is . A two-dimensional irreducible would alone contribute four, leaving no room for the ever-present one-dimensional trivial representation. Hence the given two-dimensional representation is reducible. Since the group is abelian, every conjugacy class is a singleton. There are therefore four inequivalent complex irreducible representations, each of dimension one:Taking the trace of the given matrices gives their character of a representation:
Irreducible characters. In a one-dimensional representation, the values on and must each be , since both elements square to . Their values determine the value on . The four choices give the complete character table:Each row is a character because it respects the generating relations, and the rows have unit norm and pairwise zero character inner product. The multiplicities of these rows in are respectively , by character orthogonality. Thus
Past exam of the mathematics course of the year 2 of the natural sciences course of the University of Cambridge 2002 Paper 2 10 Solution Created 2026-10-18 Updated 2026-10-20
Definitions and labels. A complex group representation on a vector space is a group homomorphism , so and . It is an irreducible representation if and its only invariant subspaces are and .
Read permutation matrices by their action on column basis vectors. The labels in the original PDF areIn particular, the original PDF gives the last row of as ; the provided TeX transcription's is incorrect and would not give an invertible permutation matrix.
Multiplication and conjugacy. Matrix products act on columns with the right factor first. For example , , and . The complete multiplication table, with row factor multiplied by column factor, isConjugating a permutation relabels its cycles. Thus the conjugacy classes areof sizes one, two and three. These are respectively the identity, the three-cycles and the transpositions in the symmetric group on three letters.
Dimensions. The sum of squares of irreducible representation dimensions equals the group order, which here is six. A three-dimensional irreducible representation would already contribute nine, so the displayed representation is reducible. There are three inequivalent complex irreducible representations, one for each conjugacy class, including the trivial representation of dimension one. If their dimensions are , then , whose positive integer solution is . HenceOne can also see reducibility directly: every permutation matrix fixes .
Characters. The character of a representation is the trace of its representing matrix, constant on each conjugacy class. The given permutation representation has character equal to the number of fixed basis vectors:in class order . A trivial representation has character . For the second one-dimensional character, a transposition has value because its square is the identity. The two three-cycles are conjugate and inverse, so their common value obeys both and , forcing . Character orthogonality with the trivial character then requires , giving . This determines the sign representation without constructing its matrices.
Write the two-dimensional character as . Character orthogonality with the first two rows givesso , . Its squared norm is , as required. The complete character table is thereforeThe last row belongs to the standard representation of the symmetric group.
To decompose the given representation, use the character inner productIts multiplicities areThusConcretely the invariant line is spanned by and its invariant complement is . Their characters are exactly the first and third rows, agreeing with the decomposition obtained entirely from character orthogonality.
Write . The matrix is a reflection by part (a). Reflection reverses a rotation angle, giving . Faithfulness lifts this matrix identity back to the group:Moving each past a rotation reduces every word to or , . These elements are distinct: the rotations are distinct by the order of , and reflections have determinant , so cannot equal a rotation. ThereforeHere the subscript denotes group order. This is the reflection case of finite subgroups of the plane orthogonal group.
Every has square , so there are reflection subgroups of order two. Within the rotations, the even- assumption from part (b) supplies the additional half-turn . Distinct involutions generate distinct two-element subgroups. ThusFor comparison, without the evenness requirement the corresponding odd- count would be . The even case agrees with involutions in an even dihedral group.
For , takeDirect multiplication gives , so . The product rules arewith exponents modulo four. They yield the complete multiplication table, where the row element multiplies the column element on the left:This is the symmetry group of a square, the dihedral group of order eight, often written when its subscript counts vertices instead. Its five order-two subgroups are generated by .
Put . Direct matrix multiplication givesfor every real . Since commutes with all matrices and , the remaining relations also hold:All matrices are invertible, and the relations reproduce the multiplication table of the Klein four-group. ThereforeA representation need not be an orthogonal representation; imposing orthogonality on the displayed matrices would be an extra condition.
The characters are their traces, independent of :In terms of part (b), , so the representation is reducible. For an explicit change of basis, takeThen and , while remains . These are the equivalent sheared representations of the Klein four-group; the parameter changes the basis, not the two irreducible constituents.
Observe that , and . Thus , while , and . The multiplication table, with the left factor labeling the row, isIt proves closure of the set. Associativity is inherited from matrix multiplication, is the identity element, and every element is its own inverse element. Therefore this set is a group. The table is symmetric, so it is an Abelian group; its three nonidentity elements have order two, identifying it as the Klein four-group .
The cyclic subgroup has order four and index two. Every index-two subgroup is normal: its complement is both the only nontrivial left coset and the only nontrivial right coset. Thus conjugation by is an automorphism of . It must send its generator to another element of order four, namely or . Since ,equivalently or , as required. Also , since otherwise could generate at most four elements.
In the commuting case, every word reduces uniquely to with and . The eight expressions are distinct because and are disjoint. Multiplication is addition of the two exponents modulo four and two, respectively. ThereforeThis gives the multiplication table independently of any other properties of , proving uniqueness up to group isomorphism.
In the inversion case, the relation gives the same eight unique normal forms, now with multiplicationwith exponents reduced modulo four and two. Thus this case also has a uniquely determined group structure. A faithful geometric realization is the dihedral group of a square, with a quarter-turn and a reflection in a line through opposite edge midpoints. For example, on the plane,These preserve the square with vertices and satisfy , . They generate eight distinct transformations, so
The products in (a), together with and , give closure of the eight-element set. Associativity is inherited from matrix multiplication, is the identity element, and the inverses from (a), with , remain in the set. Thus the group axioms hold. This is the quaternion group .
In the element order specified in the question, the multiplication table isInterpreting “character of the group” as the character of a representation specified by these matrices, take the trace of each matrix:A character belongs to a representation; the underlying abstract group can have other characters.
Label the triangle's vertices counterclockwise as . Let rotate it by and let reflect it in the axis through vertex 1 and the midpoint of the opposite side. ThenThe six dihedral group elements areThe first three are the identity and the rotations by ; the last three are reflections fixing vertices , respectively. These are all possible symmetries: the image of one vertex has three choices, and the order of the other two has two choices.
Use rightmost-first composition. From the generator relation,with exponents reduced modulo three and two. The row-times-column multiplication table isThus every symmetry is expressed in the two group generators .
The relations in (a) reduce every word in the generators to , with and . These eight matrices are distinct: the elements have third diagonal entry and the elements have entry , while the four planar blocks are distinct in each family. Their multiplication iswith exponents reduced modulo four and two. This proves closure. The identity element is , the inverse of is , and each is its own inverse. Associativity is inherited from matrix multiplication, proving the group axioms. This is the eight-element dihedral group .
Set and for , consistently with the two labels specified in the question. The row-times-column multiplication table isThe rotation powers commute with one another, and commutes with exactly when is even. Two elements commute exactly when is even. These statements also check the symmetric portions of the table.
Here , and , so is a cyclic group of order four. Its multiplication table isWrite the specified image of as . Direct matrix multiplication givesA group representation is a group homomorphism to a general linear group, so the images of all powers of are forced:All four images are invertible. Defining is well-defined modulo four because , and verifies every product in the table. These observations prove both existence and uniqueness of this representation with the prescribed image.
By (d), every group of group order three is a cyclic group. Writing its elements as , every product is determined by ; the multiplication table isThe map is a bijective group homomorphism to addition modulo three. Thereforeso there is exactly one such group up to isomorphism.
