>> format short g is used to show a number. How is it shown? Shows the exponenti

Question

>> format short g is used to show a number. How is it shown? Shows the exponential floating point format with 15 digits Shortest possible format with g in front of it. Shows the best of fixed or floating point format with 4 digits Shows the fixed format which is also suitable for dollars and cents. While reading from the Excel file Pressure, the following statement produces a ...... >> X = xlsread('Pressure.xlsx') a vector containing only the numbers. a matrix containing the matrix of raw data (combination of texts and numbers). a vector containing only the texts. three matrices of numbers, texts and raw data (combined). xlswrite is capable of writing the combination of texts and numbers into a file, considering any sheet number and any cell number. True False Which one of the following statements stores the matrix B in second sheet of Excel file My_flie.xls in cell D4. M = 6.1 B = m'ones (10, 4) xlswrite('My_file.xls' .B. 'Sheet2', '04'); m = 6.1 B = m'ones (10, 4) xlswrite('My_flle.xls', B, 2, 'D4'); Both two answers above m = 6.1 B = m'ones(10, 4) xlswrite('My_file.xls', B, 2, D4);

Explanation / Answer

>> format short g
is used to show a number and how is it shown?

Answer. Shows the best of fixed or floating point format with 4 digits.

Explanation. Format commans is basically used to display format for output.
   Syntax for Format command is
     

Short g format can use only when some of the values of the array are short numbers and have large exponents The short g format picks whichever short fixed-decimal format or short scientific notation has the most compact display.

Create a variable and display output in the short format, which is the default.

Set the format to short g and redisplay the values.

2.while reading from the excel file pressure the following statement produces on x= xlsread("Pressure.xlsx")

Answer. A matrix containing the matrix of row data(Combination of texts and numbers)

Explanation. x = xlsread("Pressure.xlsx") reads the first worksheet in the Microsoft Excel spreadsheet workbook named filename and returns the numeric data in a matrix.

Create an Excel file named Pressure.xlsx.

Sheet1 of myPressure.xlsx contains:

Read numeric data from the first worksheet.

The xlsread ignores leading rows or columns of text. However, if a cell not in a leading row or column is empty or contains text, xlsread puts a NaN in its place in the return array, num.

3.xlswrite is capable of writing the combination of texts and numbers into a file,considering any sheet number and any cell number.
Answer . True

Explanation.

Write mixed text and numeric data to an Excel file starting at cell E1 of Sheet2.

4. Which one of the following statements stores the matrix B in second sheet of Excel file My_file.xls in cell D4

Answer : Both two answers above

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.