All questions of MS-Excel for Class 8 Exam

Explanation:
The correct function to find the highest number in a series is the MAX function. Here's why:
MAX(B1:B3)
- The MAX function is a built-in function in many spreadsheet programs, including Microsoft Excel and Google Sheets.
- It is used to find the maximum value from a range of cells or a series of numbers.
- In this case, the range B1:B3 represents a series of three cells (B1, B2, B3) from which we want to find the highest number.
- The MAX function will return the highest value among the numbers in the specified range.
MAXIMUM(B1:B3)
- This function is not a valid function in most spreadsheet programs.
- Using this function will result in an error or incorrect output.
HIGH(B1:B3)
- This function is not a valid function in most spreadsheet programs.
- Using this function will result in an error or incorrect output.
HIGHEST(B1:B3)
- This function is not a valid function in most spreadsheet programs.
- Using this function will result in an error or incorrect output.
Therefore, the correct function to find the highest number in a series is MAX(B1:B3).

"TRUE" or "FALSE" as the result.

Understanding Column Selection in Spreadsheets
When working with spreadsheets, selecting cells in a single column is a common task. The correct method to do so is highlighted in option 'C'.
Why Option C is Correct
- Direct Access: Left-clicking on the gray column title button (the letter at the top of the column, e.g., "A," "B," etc.) allows you to quickly select the entire column with just one click.
- Visual Cue: The gray column title is a clear indicator of which column you are selecting, making it user-friendly and efficient for navigation.
Why Other Options are Incorrect
- Option A: Right-clicking on a column may provide context menu options but does not specifically allow for selecting the entire column directly.
- Option B: The "Data – Text to Columns" menu item is used for splitting the contents of a cell into multiple columns, not for selecting an entire column.
- Option D: Pressing Ctrl + A selects all cells in the worksheet, not just a specific column, making it less precise for this task.
Conclusion
Selecting an entire column is a fundamental skill in spreadsheet management. Using option 'C' by left-clicking on the gray column title is the most efficient way to achieve this, ensuring you can easily manipulate or analyze the data contained within that column.

Explanation:

Printing a selected area of a worksheet:
- First, select the area of the worksheet that you want to print.
- Go to the File menu at the top of the Excel window.

Setting the print area:
- Click on the Print option in the File menu.
- A drop-down menu will appear, select "Selection" under the "Print what" section.
- This will set the selected area as the print area for the current print job.

Printing a different area next time:
- If you want to print a different area next time, you can repeat the process of selecting a new area and following the steps above to set it as the print area.
- This way, you can easily print different areas of your worksheet without affecting the overall layout or settings for future print jobs.

Conclusion:
By following these steps, you can easily print a selected area of a worksheet in Excel and set a different print area for future print jobs. This allows you to customize your printing preferences based on the specific data or information you want to include in each printout.

Cell Pointers that indicate you can move content to other cells:
- Mouse Pointer with anchor at the tip: This cell pointer indicates that you can move the content to other cells. When you see a mouse pointer with an anchor at the tip, it means you can click and drag the content to another cell.
Other options that are not correct:
- Doctor's symbol (Big Plus): This cell pointer is used to insert cells, not to move content to other cells.
- Small thin plus icon: This cell pointer is used to copy the content to other cells, not to move it.
- None of the above Tab scroll buttons are placed on Excel screen: This option is incorrect as it does not refer to any cell pointer.
In summary, the correct cell pointer that indicates you can move the content to other cells is the Mouse Pointer with anchor at the tip.

Why each excel file is called a workbook?
Explanation:
There are several reasons why each Excel file is called a workbook:
1. Multiple Sheets: A workbook can contain multiple sheets, including worksheets and chart sheets. This allows you to organize and manage different types of data within the same file.
2. Workspace: The term "workbook" implies that it provides a workspace for you to perform various tasks and calculations. It serves as a container for your data and allows you to manipulate and analyze it.
3. Data Storage: A workbook can store a vast amount of data, including text, numerical values, formulas, and charts. It provides a convenient way to store and organize information in a structured manner.
4. Modifiability: Workbooks are designed to be easily modifiable. You can add, delete, or modify sheets, cells, and data within the workbook as per your requirements. This flexibility allows you to customize the workbook to suit your specific needs.
5. Interactivity: Workbooks are interactive, meaning you can input data, perform calculations, create charts, and generate reports within the same file. This interactivity makes it a powerful tool for data analysis and decision-making.
In summary, the term "workbook" is used for Excel files because they provide a workspace for organizing and manipulating data. They can contain multiple sheets, support various data types, and offer flexibility and interactivity for performing calculations and analysis.

To change the column width to fit the contents in Microsoft Excel, you can follow these steps:
Method: Double-clicking the boundary to the right of the column heading
1. Open the Excel spreadsheet that contains the column you want to adjust.
2. Locate the column heading, which is the lettered cell at the top of the column.
3. Move your cursor to the boundary line between the column heading and the next column.
4. Double-click the boundary line.
By double-clicking the boundary to the right of the column heading, Excel will automatically adjust the column width to fit the contents of the column. This will ensure that all the data in the column is visible without any truncation or hidden content.
Example:
Here is an example of how you can change the column width to fit the contents using this method:
1. Let's say you have a column with the heading "A" and it contains data.
2. Move your cursor to the boundary line between column A and column B.
3. Double-click the boundary line.
4. Excel will automatically adjust the width of column A to fit the contents, making all the data visible.
Note:
- This method works for individual columns, and you can repeat the process for other columns in your spreadsheet.
- You can also adjust the width manually by dragging the boundary line left or right, but double-clicking is a quick way to fit the width to the contents automatically.
By following these steps, you can easily change the column width to fit the contents in Microsoft Excel.

To insert three columns between columns D and E in a spreadsheet, follow these steps:
1. Select column E:
- Click on the header of column E to select the entire column.
- It should be highlighted or shaded to indicate that it is selected.
2. Insert three columns:
- Right-click on the selected column header (E).
- From the context menu, choose the option to insert three columns.
- The new columns will be inserted to the right of column E.
3. Verify the new columns:
- Columns F, G, and H should now appear between columns D and E.
- You can confirm this by looking at the column headers and checking the column letters.
Note: These instructions may vary slightly depending on the specific spreadsheet software or application you are using, but the general concept remains the same.

How are data organized in a spreadsheet?
In a spreadsheet, data is organized using rows and columns. Here is a detailed explanation of how data is organized in a spreadsheet:
Rows:
- Rows are horizontal lines in a spreadsheet.
- Each row is identified by a number, usually starting from 1 and increasing as you go down.
- Rows are used to organize data horizontally, with each cell in a row containing a specific piece of information.
Columns:
- Columns are vertical lines in a spreadsheet.
- Each column is identified by a letter, starting from A and increasing alphabetically as you move to the right.
- Columns are used to organize data vertically, with each cell in a column containing a specific type of information.
Cells:
- Cells are the individual units within a spreadsheet where data is entered.
- Each cell is identified by a combination of its column letter and row number.
- Cells can contain various types of data, such as text, numbers, formulas, or functions.
Data Organization:
- Data in a spreadsheet is organized by placing related information in the same row or column.
- Columns are typically used to represent different categories or attributes of the data, while rows represent individual records or entries.
- By organizing data in this way, it becomes easier to locate and manipulate specific information within a spreadsheet.
Benefits of Organizing Data in a Spreadsheet:
- Efficient data management: Organizing data in rows and columns allows for easy sorting, filtering, and searching.
- Data analysis: With organized data, you can perform calculations, create graphs, and generate reports to analyze trends and patterns.
- Data referencing: By using cell references, you can easily refer to specific data points in formulas or functions within the spreadsheet.
- Data sharing: Spreadsheets can be easily shared with others, allowing for collaborative data management and analysis.
In conclusion, data in a spreadsheet is organized using rows and columns, with each cell containing a specific piece of information. This organization allows for efficient data management, analysis, referencing, and sharing.

Copying Data or Formulas
There are several ways to copy data or formulas in a spreadsheet program like Microsoft Excel. These methods include:
1. Copy, Paste, and Cut Commands on the Edit Menu:
- Select the cells that you want to copy.
- Go to the Edit menu at the top of the program.
- Click on the "Copy" command to copy the selected cells.
- Place the cursor in the desired location where you want to paste the copied cells.
- Again, go to the Edit menu and click on the "Paste" command to paste the copied cells.
- Alternatively, you can use the "Cut" command to remove the selected cells from their original location and place them in the clipboard. Then, use the "Paste" command to paste them elsewhere.
2. Commands on a Shortcut Menu:
- Right-click on the selected cells.
- A shortcut menu will appear.
- Choose the "Copy" option to copy the cells or the "Cut" option to cut them.
- Right-click on the destination where you want to paste the copied or cut cells.
- Select the "Paste" option from the shortcut menu.
3. Buttons on the Standard Toolbar:
- Select the cells that you want to copy.
- Look for the copy button on the standard toolbar, which typically looks like two overlapping sheets of paper.
- Click on the copy button to copy the cells.
- Place the cursor in the desired location where you want to paste the copied cells.
- Locate the paste button on the standard toolbar, which usually looks like a clipboard.
- Click on the paste button to paste the copied cells.
4. All of the Above:
- You can use any of the above methods to copy data or formulas in a spreadsheet program.
- These methods provide flexibility and convenience, allowing you to choose the one that suits your preference or the situation.
In conclusion, copying data or formulas in a spreadsheet program can be done using the copy, paste, and cut commands on the edit menu, commands on a shortcut menu, or buttons on the standard toolbar. These methods provide various options for copying and pasting cells, giving you the flexibility to choose the most suitable approach.

The answer to the question is: A. Nested
Explanation:
- A function inside another function is called a nested function.
- The concept of nesting functions allows for more complex and modular programming.
- By nesting functions, you can encapsulate logic and reuse code.
- The nested function is defined within the body of the outer function.
- The nested function can access and use variables from the outer function, creating a closure.
- The outer function acts as a scope for the nested function.
- The nested function can only be accessed and called from within the outer function.
- Nesting functions can help improve code organization and readability.
- It allows for the creation of private functions that are only accessible within the scope of the outer function.
- Nested functions are commonly used in programming languages like JavaScript and Python.
- They can be used to implement design patterns and solve specific programming problems.

To identify the incorrect method of editing the cell content, let's analyze each option:
A: Press the Alt key
This is not the correct method of editing the cell content. The Alt key is primarily used for accessing the Excel menu and shortcut keys.
B: Press the F2 key
This is a correct method of editing the cell content. Pressing the F2 key allows you to enter the edit mode for the selected cell.
C: Click the formula bar
This is a correct method of editing the cell content. Clicking the formula bar allows you to directly edit the content of the selected cell.
D: Double click the cell
This is a correct method of editing the cell content. Double-clicking the cell activates the edit mode, allowing you to modify the content.
Therefore, the correct answer is A: Press the Alt key as it is not the correct method of editing the cell content in Excel.
Remember, when editing cell content in Excel, you can use the F2 key, click the formula bar, or double-click the cell to enter the edit mode and make changes.

To answer the question, we need to identify the method that cannot be used to enter data in a cell. Let's analyze each option:
A: Pressing an arrow key
- Pressing an arrow key can be used to move the cursor to a different cell, but it does not directly enter data in a cell.
B: Pressing the tab key
- Pressing the tab key is commonly used to move the cursor to the next cell, allowing data to be entered.
C: Pressing the Esc key
- Pressing the Esc key is used to cancel or exit the current editing mode in a cell. It does not enter data in a cell.
D: Clicking the enter button to the formula bar
- Clicking the enter button in the formula bar is a common method to confirm and enter data in a cell.
Based on the above analysis, we can conclude that the method that cannot be used to enter data in a cell is C: Pressing the Esc key.

To determine which of the following options is correct, we need to understand the purpose and syntax of the AVERAGE function in Excel.
AVERAGE function:
The AVERAGE function in Excel calculates the average (arithmetic mean) of a set of numbers. It adds up all the numbers in the specified range and then divides the sum by the count of numbers in that range.
Now, let's analyze each option to determine its correctness:
A: =AVERAGE(4,5,6,7)
In this option, the AVERAGE function is used to calculate the average of the numbers 4, 5, 6, and 7. This syntax is correct, and it will return the average value of those numbers.
B: =AVERAGE(A1,B1,C1)
In this option, the AVERAGE function is used to calculate the average of the values in cells A1, B1, and C1. This syntax is correct, and it will return the average value of those cells.
C: =AVERAGE(A1:A9,B1:B9)
In this option, the AVERAGE function is used to calculate the average of the values in two ranges: A1:A9 and B1:B9. This syntax is correct, and it will return the average value of all the cells in those ranges.
D: =ALL OF ABOVE
This option suggests that all of the above options are correct. Since options A, B, and C are all valid uses of the AVERAGE function, option D is the correct answer.
In conclusion, the correct option is D: =ALL OF ABOVE, as all the provided options use the AVERAGE function correctly.

Answer:
The maximum number of rows in an Excel sheet is 65,536.
Explanation:
Here is a detailed explanation of the maximum number of rows in an Excel sheet:
- Excel is a spreadsheet program developed by Microsoft that is widely used for data analysis and manipulation.
- In Excel, a sheet is organized into a grid of cells, with columns labeled by letters (A, B, C, etc.) and rows labeled by numbers (1, 2, 3, etc.).
- Each cell can contain data such as numbers, text, formulas, or functions.
- The maximum number of rows in an Excel sheet is determined by the file format used.
- In Excel 2003 and earlier versions, the file format (.xls) has a maximum limit of 65,536 rows.
- In Excel 2007 and later versions, the file format (.xlsx) increased the maximum limit to 1,048,576 rows.
- However, for compatibility reasons, Excel still limits the number of rows that can be displayed on a single sheet to 65,536.
- To view or work with more than 65,536 rows in Excel, you can use multiple sheets or create a PivotTable to summarize the data.
Conclusion:
In conclusion, the maximum number of rows in an Excel sheet is 65,536 for the .xls file format.

Answer:

To activate a cell in a spreadsheet, such as in Microsoft Excel or Google Sheets, you have multiple options. These options are pressing the Tab key, clicking the cell, or pressing an arrow key.

Pressing the Tab key:
- Pressing the Tab key is a quick and efficient way to move from one cell to another in a spreadsheet.
- When you press the Tab key, it moves the cursor to the next cell in the same row.
- This action activates the new cell by selecting it and allowing you to enter or edit data.

Clicking the cell:
- You can activate a cell by simply clicking on it with your mouse pointer.
- When you click on a cell, it becomes the active cell, and its contents are displayed in the formula bar or input box.
- Clicking on a cell also allows you to enter or edit data directly in that cell.

Pressing an arrow key:
- Another way to activate a cell is by using the arrow keys on your keyboard.
- When you press an arrow key (up, down, left, or right), it moves the cursor to the adjacent cell in that direction.
- This action activates the new cell, and you can start entering or editing data in that cell.

All of the above:
- The correct answer to this question is option 'D' - all of the above.
- This means that you can use any of the mentioned methods (pressing the Tab key, clicking the cell, or pressing an arrow key) to activate a cell in a spreadsheet.
- Each method serves the same purpose of selecting and making a cell active, allowing you to perform various operations on it.

In conclusion, activating a cell in a spreadsheet can be done by pressing the Tab key, clicking the cell, or pressing an arrow key. These options provide flexibility and ease of use when navigating and inputting data in a spreadsheet program.

To activate the previous cell in a pre-selected range, you need to follow these steps:
1. Open the spreadsheet or document where the pre-selected range is located.
2. Select the desired range of cells.
3. Press the corresponding key to activate the previous cell within the selected range.
The correct answer is "D: None of the above." None of the keys mentioned (Alt, Tab, Enter) will activate the previous cell within the pre-selected range.
Here's a breakdown of the given options and why they are incorrect:
A: The Alt key
- The Alt key is commonly used for accessing the menu bar or activating keyboard shortcuts, but it does not specifically activate the previous cell in a pre-selected range.
B: The Tab key
- The Tab key is typically used to move between cells horizontally, advancing to the next cell in the selected range, rather than activating the previous cell.
C: The Enter key
- The Enter key is used to confirm an input or move to the cell below. It does not activate the previous cell within a pre-selected range.
Therefore, the correct answer is "D: None of the above." There is no specific key that activates the previous cell within a pre-selected range. The user would need to manually select the desired cell within the range to activate it.

Advantages of paper spreadsheets:
- Rows and columns: Paper spreadsheets can have rows and columns just like electronic spreadsheets. This allows for organized and structured data presentation.
- Headings: Paper spreadsheets can also have headings to label different sections or categories of data. Headings help in providing clarity and making the spreadsheet easier to understand.
- None: This option is incorrect as paper spreadsheets can have all the same advantages as electronic spreadsheets except for the speed of calculations. Paper spreadsheets require manual calculations and are generally slower compared to electronic spreadsheets that can perform calculations instantly.
- Speed: The speed of calculations is the advantage that electronic spreadsheets have over paper spreadsheets. Electronic spreadsheets can perform complex calculations quickly and efficiently, saving time and effort.
In summary, paper spreadsheets can have all the same advantages as electronic spreadsheets except for the speed of calculations.

To determine which function will return a value of 8, we need to evaluate each function:
A: ROUNDUP(8.49999,0):
- The ROUNDUP function rounds a number up to a specified number of decimal places or digits.
- In this case, we are rounding 8.49999 to 0 decimal places.
- Since 8.49999 is already greater than 8, rounding it up to 0 decimal places will yield 9.
- Therefore, this function does not return a value of 8.
B: ROUNDDOWN(8.49999,0):
- The ROUNDDOWN function rounds a number down to a specified number of decimal places or digits.
- In this case, we are rounding 8.49999 to 0 decimal places.
- Since 8.49999 is already less than 9, rounding it down to 0 decimal places will yield 8.
- Therefore, this function returns a value of 8.
C: ROUND(8.49999,0):
- The ROUND function rounds a number to a specified number of decimal places or digits.
- In this case, we are rounding 8.49999 to 0 decimal places.
- Since 8.49999 is closer to 8 than to 9, rounding it to 0 decimal places will yield 8.
- Therefore, this function returns a value of 8.
D: ONLY B AND C:
- This option is incorrect because option A, ROUNDUP(8.49999,0), does not return a value of 8.
Therefore, the correct answer is A: ROUNDUP(8.49999,0).

The Formula Bar in Excel:
The formula bar in Excel is a useful feature that allows users to view and edit formulas in cells. When activated, the formula bar appears at the top of the Excel window, just below the ribbon. The formula bar displays the contents of the selected cell, including formulas, text, or numerical values.
When the formula bar is activated, you can see:
- The Edit Formula button: This button appears as a small icon in the formula bar and allows you to enter edit mode for the selected cell's formula. Clicking on this button activates the formula editing mode, where you can modify the formula as needed.
- The Cancel button: This button appears as a small "X" icon in the formula bar and allows you to cancel any changes made to the formula. Clicking on this button will revert the formula back to its original state before editing.
- The Enter button: This button appears as a checkmark icon in the formula bar and allows you to confirm the changes made to the formula. Clicking on this button will save the edited formula and apply it to the selected cell.
Therefore, the correct answer is:
- D: All of the above
When the formula bar is activated, you can see the Edit Formula button, the Cancel button, and the Enter button. These buttons provide convenient options for editing and finalizing formulas in Excel.

Explanation:
The provided options are A, B, C, and D. The correct answer is D, which means both B and C are correct.
To further explain, let's break down each option:
A: Show the formatting of a data label
- Charts can display the formatting of a data label, such as the font, color, size, and style used for the label text.
B: Show the name of a data series
- Charts can also show the name of a data series, which helps identify the specific dataset being represented.
C: Show the value of a data point
- In addition, charts can display the value of each data point, providing numerical information about the data being presented.
D: (b) and (c) both
- The correct answer, D, states that both options B and C are correct. Therefore, charts can show both the name of a data series and the value of each data point.
In summary, charts can display various elements, including the formatting of data labels, the names of data series, and the values of data points.

To drag a selected range of data to another worksheet in the same workbook, you can use the Ctrl key. Here's a step-by-step guide on how to do it:
1. Select the range of data that you want to move to another worksheet. You can do this by clicking and dragging over the cells or by using the Shift key and the arrow keys to extend the selection.
2. With the range of data selected, press and hold the Ctrl key on your keyboard.
3. While holding the Ctrl key, click and drag the selected range to the desired worksheet tab at the bottom of the screen. This will open the target worksheet.
4. Release the Ctrl key and the mouse button to drop the data in the new worksheet.
5. The selected range of data will now be copied to the new worksheet, while still remaining in the original location.
Using the Ctrl key in combination with dragging allows you to quickly and easily move or copy data between worksheets within the same workbook. This can be useful when organizing and arranging data in different sections or categories.

A: The entire worksheet
- Selecting the entire worksheet means you are selecting all the cells, rows, and columns within the worksheet.
- This allows you to perform operations or formatting changes on the entire worksheet at once.

B: Rows
- Selecting rows allows you to choose specific rows within the worksheet.
- You can select multiple rows by clicking and dragging over the row numbers or by using the Shift key along with the arrow keys.

C: Columns
- Selecting columns allows you to choose specific columns within the worksheet.
- You can select multiple columns by clicking and dragging over the column letters or by using the Shift key along with the arrow keys.

D: a, b, and c
- Option D is the correct answer as it includes all the options mentioned above.
- You can select the entire worksheet, specific rows, and specific columns by using the various selection methods available in the spreadsheet software.

Explanation:
The correct answer is D: Copy the worksheet.
Here is a detailed explanation of each option:
A: Save the workbook
- Saving the workbook is a crucial step in creating a worksheet as it ensures that all the changes made are stored and can be accessed later.
B: Modify the worksheet
- Modifying the worksheet is an essential step in creating a worksheet as it allows you to customize the layout, formatting, formulas, and other elements to suit your needs.
C: Enter text and data
- Entering text and data is a fundamental step in creating a worksheet as it forms the basis of the information you want to organize and analyze.
D: Copy the worksheet
- Copying the worksheet is not a basic step in creating a worksheet. While copying a worksheet can be useful in certain situations, it is not an essential step in the initial creation process.
In summary, copying the worksheet is not a basic step in creating a worksheet. The other options, such as saving the workbook, modifying the worksheet, and entering text and data, are all essential steps in creating a worksheet.

When you print preview a worksheet:
- The entire worksheet is displayed: This means that the print preview will show the entire content of the worksheet, including all the rows, columns, and cells.
- The selected range is displayed: If you have selected a specific range of cells before going into print preview, only that selected range will be displayed in the print preview.
- The active portion of the worksheet is displayed: If you have not selected a specific range before going into print preview, only the active portion of the worksheet, which includes the cells that contain data or formatting, will be displayed.
- a, b and c: All of the above options are possible when you print preview a worksheet. It depends on whether you have selected a range or not, and whether you want to see the entire worksheet or just the active portion.
In summary, when you print preview a worksheet, you may see the entire worksheet, a selected range, or the active portion of the worksheet, depending on your selection and preferences.

**Explanation:**

In mathematics, there is a specific order in which mathematical operations should be performed in a formula or calculation. This order is known as the order of precedence, and it ensures that calculations are done correctly and consistently.

The correct order of precedence in a formula calculation is as follows:

**1) Parentheses:** Operations within parentheses should always be done first. This allows for grouping and ensures that calculations inside parentheses are performed before any other operations.

**2) Exponentiation:** Exponentiation refers to raising a number to a power. This operation should be done next after any operations within parentheses.

**3) Multiplication and Division:** After parentheses and exponentiation, multiplication and division should be done next. These operations should be performed from left to right.

**4) Addition and Subtraction:** Finally, after parentheses, exponentiation, and multiplication/division, addition and subtraction should be done. Like multiplication and division, these operations should also be performed from left to right.

Therefore, none of the given options (a, b, or c) provide the correct order of precedence in a formula calculation. The correct order is: parentheses, exponentiation, multiplication/division, and addition/subtraction.

It is important to follow the order of precedence in mathematical calculations to ensure accurate results. If the order is not followed, the calculation may yield incorrect results.

Function to display row data in a column or column data in a row:
The function that allows you to display row data in a column or column data in a row is the Transpose function.
Explanation:
The Transpose function is a powerful tool that can be used to convert the orientation of data in a spreadsheet. It allows you to switch the rows and columns of a range or array, effectively transposing the data.
Here is how the Transpose function works:
1. Select the range of cells or array that you want to transpose.
2. In Excel, you can use the Paste Special feature to transpose the range. Right-click on the destination cell where you want to paste the transposed data, and select "Paste Special."
3. In the Paste Special dialog box, check the "Transpose" option under the "Paste" section.
4. Click on the "OK" button to apply the transposition.
The result is that the rows become columns and the columns become rows, effectively displaying row data in a column or column data in a row.
By using the Transpose function, you can easily reorganize and manipulate your data to suit your needs. It is particularly useful when you want to switch the orientation of data in a table or create summary reports.
In conclusion, the Transpose function is the correct answer for displaying row data in a column or column data in a row.