Cell c

As an index. See Comma-Separated List Assignment to an Undefined Variable for more information.c{1} = []; c{2} = [];c{:}Use deal to overwrite each element in the list. [c{:}] = deal([10 20],[14 12]);c{:}This example works in the same way, but with a comma-separated list of vectors in a structure field.s(1).field1 = [[]];s(2).field1 = [[]];s.field1Use deal to overwrite the structure fields.[s.field1] = deal([10 20],[14 12]);s.field1How to Use Comma-Separated ListsCommon uses for comma-separated lists are:Constructing ArraysDisplaying ArraysConcatenationFunction Call ArgumentsFunction Return ValuesThese sections provide examples of using comma-separated lists with cell arrays. Each of these examples applies to structures as well.Constructing ArraysYou can use a comma-separated list to enter a series of elements when constructing a matrix or array. When you specify a list of elements with C{:,5}, MATLAB inserts the four individual elements.C = cell(4,6);for k = 1:24 C{k} = k*2;endA = {'Hello',C{:,5},magic(4)}A = 1×6 cell array {'Hello'} {[34]} {[36]} {[38]} {[40]} {4×4 double}When you specify the C cell itself, MATLAB inserts the entire cell array.A = 1×3 cell array {'Hello'} {4×6 cell} {4×4 double}Displaying ArraysUse a list to display all or part of a structure or cell array.ans = 'Hello'ans = 4×6 cell array {[2]} {[10]} {[18]} {[26]} {[34]} {[42]} {[4]} {[12]} {[20]} {[28]} {[36]} {[44]} {[6]} {[14]} {[22]} {[30]} {[38]} {[46]} {[8]} {[16]} {[24]} {[32]} {[40]} {[48]}ans = 16 2 3 13 5 11 10 8 9 7 6 12 4 14 15 1ConcatenationPutting a comma-separated list inside square brackets extracts the specified elements from the list and concatenates them.A = 34 36 38 40 42 44 46 48Function Call ArgumentsWhen writing the code for a function call, you enter the input arguments as a list with each argument separated by a comma. If you have these arguments stored in a structure or cell array, then you can generate all or part of the argument list from the structure or cell array instead. This can be especially useful when passing in variable numbers of arguments.This example passes several name-value arguments to the plot function.X = -pi:pi/10:pi;Y = tan(sin(X)) - sin(tan(X));C = cell(2,3);C{1,1} = 'LineWidth';C{2,1} = 2;C{1,2} = 'MarkerEdgeColor';C{2,2} = 'k';C{1,3} = 'MarkerFaceColor';C{2,3} = 'g';figureplot(X,Y,'--rs',C{:})Function Return ValuesMATLAB functions can also return more than one value to the caller. These values are returned in a list with each value separated by a comma. Instead of listing each return value, you can use a comma-separated list with a structure or cell array. This becomes

Formula, you need to use the following shortcut:(a) Ctrl + D(b) Alt + D(c) Shift + D(d) Ctrl + Alt + DQ38. Which of the following shortcuts can be used to use the Flash Fill feature?(a) Ctrl + F(b) Ctrl + E(c) Alt + E(d) Alt + FQ39. If you want to display the remainder after you divide 100 by 3, you should use:(a) =MOD(100,3)(b) =DIV(3,100)(c) =MODE(100,3)(d) =REMAINDER(100,3)Q40. To concatenate values in the formula, you need to use:(a) Semicolon (;)(b) Comma (,)(c) Ampersand (&)(d) Pipe (|)Q41. Which is the newest lookup function?(a) KLOOKUP(b) XLOOKUP(c) VLOOKUP(d) LOOKUPQ42. A formula must begin with:(a) =(b) +(c) –(d) (Q43. Which of the following formulas contains an error?(a) =F7+F8(b) =F9+F11(c) (F9+F11)(d) No errorQ44. To find the output of the formula, you need to select the full formula or a portion of it and press X to show the output. Here X is: (a) F7(b) F8(c) F9(d) F10Q45. To refer to a cell reference from another worksheet, you can:(a) navigate to the sheet and click on that cell(b) type the sheet name, add !, and include the cell address(c) both a & c(d) This is not possible in ExcelQ46. Which of the following functions was introduced in Excel 2019?(a) UNIQUE(b) IFS(c) FLOOR.MATH(d) XLOOKUPQ47. Which of the following functions can handle all kinds of errors?(a) IFNA(b) IFERROR(c) ISERROR(d) ALLERRORQ48. In the VBA Cells function, the argument is Cells (x, y), which means:(a) x = row number, y = column number(b) x = column number, y = row number(c) x = row index, y = column index(d) x = column index, y = row indexQ49. To remove extra spaces, you can use the function:(a) TRIM(b) TRUNC(c) CODE(d) DELETEQ50. If there is a VBA code in your Excel file, then you should save the file as ____ format:(a) .xlsx(b) .xls(c) .xlsm(d) .csvQ51. To insert a chart from a data selection, you will need to press: (a) F5(b) F7(c) F11(d) F2Q52. If there is a Green triangle in the top left corner of the cell, then it signifies:(a) There is a note in that cell(b) The cell is formatted as a number(c) There is no error on that cell(d) There is a circular referenceQ53. If there is a Red triangle in the top right corner of the cell, then it signifies:(a) There is a note in that cell(b) The cell is formatted as text(c) There is an error on that cell(d) There is a circular referenceQ54. The maximum height of a row is: (a) 409.5 units(b) 403.5 units(c) 410 units(d) 412 unitsQ55. To show data distribution, you should use:(a) Pie chart(b) Line chart(c) Bar chart(d) HistogramQ56. To open the Spelling dialog box, you need to press: (a) F5(b) F7(c) F11(d) F2Q57. The first cell of an Excel Workbook is:(a) AA(b) A1(c) a1(d) AQ58. The executable file to open the Windows version of MS Excel is:(a) EXCEL.exe(b) MSEXCEL.exe(c) WINEXCEL.exe(d) EXCEL.exeQ59. To repeat the previous action, you will need to press:(a) F4(b) F5(c) F6(d) F8Q60. The first version of Excel released on

Transformations using a MatrixWhat is a transformation matrix?A transformation matrix is used to determine the coordinates of an image from the transformation of an objectreflections, rotations, enlargements and stretchesCommonly used transformation matrices include(In 2D) a multiplication by any 2x2 matrix could be considered a transformation (in the 2D plane)This can be done similarly in higher dimensionsAn individual point in the plane can be represented as a position vector, xy{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="33" alt="open parentheses table row x row y end table close parentheses">Several points, that create a shape say, can be written as a position matrix x1x2x3...y1y2y3...{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="66" width="117" alt="space open parentheses table row cell x subscript 1 end cell cell x subscript 2 end cell cell x subscript 3 end cell cell... end cell row cell y subscript 1 end cell cell y subscript 2 end cell cell y subscript 3 end cell cell... end cell end table close parentheses">A matrix transformation will be of the form abcdxy{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="82" alt="open parentheses table row a b row c d end table close parentheses open parentheses table row x row y end table close parentheses">where xy{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="33" alt="open parentheses table row x row y end table close parentheses"> represents any point in the 2D plane abcd{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="50" alt="open parentheses table row a b row c d end table close parentheses"> is a given matrixHow do I find the coordinates of an image under a transformation?The coordinates (x’, y’) - the image of the point (x, y) under the transformation with matrix abcd{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="50" alt="open parentheses table row a b row c d end table close parentheses"> are given byx'y'=abcdxy{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="58" width="136" alt="open parentheses table row cell x apostrophe end cell row cell y apostrophe end cell end table close parentheses equals open parentheses table row a b row c d end table close parentheses open parentheses table row x row y end table close parentheses">Similarly, for a position matrixx'1x'2x'3...y'1y'2y'3...=abcdx1x2x3...y1y2y3...{"language":"en","fontFamily":"Times New Roman","fontSize":"18","autoformat":true}" role="math" height="68" width="306" alt="open parentheses table row cell x apostrophe subscript 1 end cell cell x apostrophe subscript 2 end cell cell x apostrophe subscript 3 end cell cell... end cell row cell y apostrophe subscript 1 end cell cell y apostrophe subscript 2 end cell cell y apostrophe subscript 3 end cell cell... end cell end table close parentheses equals open parentheses table row a b row c d end table close parentheses open parentheses table row cell x subscript 1 end cell cell x subscript 2 end cell cell x subscript 3 end cell cell... end cell row cell y subscript 1 end cell

Cell arrays follow the same basic rules for expansion, concatenation, and deletion as other types of MATLAB® arrays. However, you can index into a cell array in two ways: with curly braces {} to access cell contents or with parentheses () to refer to the cells themselves. Keep this distinction in mind when you add, delete, or combine cells in a cell array.Add CellsA common way to expand a cell array is to concatenate cell arrays vertically or horizontally. Use the standard square bracket concatenation operator []. Separate elements with semicolons for vertical concatenation or commas for horizontal concatenation.C1 = {'one',2};C2 = {ones(3,3),'four'};C = [C1; C2]C=2×2 cell array {'one' } {[ 2]} {3x3 double} {'four'}C_horz=1×4 cell array {'one'} {[2]} {3x3 double} {'four'}Concatenating a cell array and a non-cell array encloses the non-cell array in a single cell. Therefore, the cell array must be a vector.A = [1 2 3; 4 5 6];C3 = [C1,A]C3=1×3 cell array {'one'} {[2]} {2x3 double}To create separate cells from the non-cell array, you can use num2cell.C4=2×5 cell array {'one' } {[ 2]} {[1]} {[2]} {[3]} {3x3 double} {'four'} {[4]} {[5]} {[6]}Cell arrays also support scalar expansion. That is, if you assign values to the contents of cells outside the existing array, the array expands to include them. The expanded array is rectangular, and any intervening cells contain empty numeric arrays. When assigning the contents of a cell, use curly braces.C=3×3 cell array {'one' } {[ 2]} {0x0 double} {3x3 double} {'four' } {0x0 double} {0x0 double} {0x0 double} {[ 9]}C=3×4 cell array {'one' } {[ 2]} {0x0 double} {0x0 double} {3x3 double} {'four' } {0x0 double} {0x0 double} {0x0 double} {0x0 double} {[ 9]} {0x0 double}To replace the contents of cells, define a cell array using curly braces, and then assign it to an equivalently sized set of cells using parentheses.C(3,:) = {'replacement', rand(2,2), 42, 'row'}C=3×4 cell array {'one' } {[ 2]} {0x0 double} {0x0 double} {3x3 double } {'four' } {0x0 double} {0x0 double} {'replacement'} {2x2 double} {[ 42]} {'row' }Delete CellsThe syntax for removing rows or columns of a cell array is consistent

Cell y subscript 2 end cell cell y subscript 3 end cell cell... end cell end table close parentheses"> A calculator can be used for matrix multiplicationIf matrices involved are small, it may be as quick to do this manually STEP 1 Determine the transformation matrix (T) and the position matrix (P) The transformation matrix, if uncommon, will be given in the question The position matrix is determined from the coordinates involved, it is best to have the coordinates in order, to avoid confusion STEP 2 Set up and perform the matrix multiplication required to determine the image position matrix, P’ P’ = TP STEP 3 Determine the coordinates of the image from the image position matrix, P’How do I find the coordinates of the original point given the image under a transformation? To ‘reverse’ a transformation we would need the inverse transformation matrixi.e. T-1For a 2x2 matrix abcd{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="50" alt="open parentheses table row a b row c d end table close parentheses"> the inverse is given by 1detTd-b-ca{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="119" alt="fraction numerator 1 over denominator det bold italic T end fraction open parentheses table row d cell negative b end cell row cell negative c end cell a end table close parentheses">where detT=ad-bc{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="22" width="106" alt="det bold italic T equals a d minus b c">A calculator can be used to work out inverse matricesYou would rearrange x'y'=abcdxy{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="58" width="136" alt="open parentheses table row cell x apostrophe end cell row cell y apostrophe end cell end table close parentheses equals open parentheses table row a b row c d end table close parentheses open parentheses table row x row y end table close parentheses">1det T(d-b-ca)(x'y')=(xy){"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="48" width="198" alt="fraction numerator 1 over denominator det space bold italic T end fraction stretchy left parenthesis table row d cell negative b end cell row cell negative c end cell a end table stretchy right parenthesis stretchy left parenthesis table row cell x apostrophe end cell row cell y apostrophe end cell end table stretchy right parenthesis equals stretchy left parenthesis table row x row y end table stretchy right parenthesis">Examiner Tips and TricksRead the question carefully to determine if you have the points before or after a transformationWorked ExampleA quadrilateral, Q, has the four vertices A(2, 5), B(5, 9), C(11, 9) and D(8, 5).Find the coordinates of the image of Q under the transformation T=3-1-12{"language":"en","fontFamily":"Times New Roman","fontSize":"18"}" role="math" height="54" width="105" alt="bold italic T equals open parentheses table row 3 cell negative 1 end cell row cell negative 1 end cell 2 end table close parentheses">.Determinant of a Transformation MatrixWhat does the determinant of a transformation matrix (A)

What Is a Comma-Separated List?When you type in a series of numbers separated by commas, MATLAB® creates a comma-separated list and returns each value individually.When used with large and more complex data structures like MATLAB structures and cell arrays, comma-separated lists can help simplify your code.Generating a Comma-Separated ListYou can generate a comma-separated list from either a cell array or a MATLAB structure.Generating a List from a Cell ArrayWhen you extract multiple elements from a cell array, the result is a comma-separated list. Define a 4-by-6 cell array.C = cell(4,6);for k = 1:24 C{k} = k*2;endCC = 4×6 cell array {[2]} {[10]} {[18]} {[26]} {[34]} {[42]} {[4]} {[12]} {[20]} {[28]} {[36]} {[44]} {[6]} {[14]} {[22]} {[30]} {[38]} {[46]} {[8]} {[16]} {[24]} {[32]} {[40]} {[48]}Extract the fifth column to generate a comma-separated list.ans = 34ans = 36ans = 38ans = 40This is the same as explicitly typing the list.C{1,5},C{2,5},C{3,5},C{4,5}Generating a List from a StructureWhen you extract a field of a structure array across one of its dimensions, the result is a comma-separated list.Start by converting the cell array used above into a 4-by-1 MATLAB structure with six fields: f1 through f6. Read field f5 for all rows, and MATLAB returns a comma-separated list.S = cell2struct(C,{'f1','f2','f3','f4','f5','f6'},2);S.f5ans = 34ans = 36ans = 38ans = 40This is the same as explicitly typing the list.S(1).f5,S(2).f5,S(3).f5,S(4).f5Assigning Output from a Comma-Separated ListYou can assign any or all consecutive elements of a comma-separated list to variables with a simple assignment statement. Define the cell array Cand assign the first row to variables c1 through c6.C = cell(4,6);for k = 1:24 C{k} = k*2;end[c1,c2,c3,c4,c5,c6] = C{1,1:6};c5When you specify fewer output variables than the number of outputs returned by the expression, MATLAB assigns the first N outputs to those N variables and ignores any remaining outputs. In this example, MATLAB assigns C{1,1:3} to the variables c1, c2, and c3 and ignores C{1,4:6}.You can assign structure outputs in the same manner.S = cell2struct(C,{'f1','f2','f3','f4','f5','f6'},2);[sf1,sf2,sf3] = S.f5;sf3You also can use the deal function for this purpose.Assigning to a Comma-Separated ListThe simplest way to assign multiple values to a comma-separated list is to use the deal function. This function distributes its input arguments to the elements of a comma-separated list.This example uses deal to overwrite each element in a comma-separated list. First initialize a two-element list. This step is necessary because you cannot use comma-separated list assignment with an undefined variable when using :