14.7 Matrix Computation with Excel 443
- In the cells shown, type the appropriate characters and values. Use the Format Cellsand Font
option to create the boldface variables, as shown.
2. In cell A10, type [A][B], and using
the left mouse button, pick cells B9
through D11, as shown in the accompa-
nying figure.
3. Next, in the Formula bar, type B3:
D5G3:I5and, while holding down
the Ctrland the Shiftkeys, press the
Enterkey. Note that using the mouse,
you could also pick the ranges of B3:D5
or G3:I5 instead of typing them. This
sequence of operations will create the
result shown. You follow a procedure sim-
ilar to the one outlined in step 2 to per-
form [A][B], except in the Formula
bar type B3:D5G3:I5.
Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀