Assessment For MS® Office Excel 2010

A paragraph is not a basic element of a spreadsheet. In a spreadsheet, data is organized into cells, which are arranged in rows and columns. Each cell can contain a single value or formula. Rows and columns are used to organize and manipulate data in the spreadsheet. However, a paragraph is a unit of text in a document or a piece of writing, and it is not a fundamental component of a spreadsheet.

To save an existing workbook with a new name, you need to choose the "File" tab and then select the "Save As" option. This allows you to create a copy of the workbook with a different name, while keeping the original file intact. The "Save As" option is commonly used when you want to create a duplicate of a workbook or save it with a different name for organizational purposes or to create different versions of the same file.

To freeze rows and columns in Excel, you need to go to the View tab. Then, in the Windows group, you will find the option to Freeze Panes. This feature allows you to lock specific rows and columns so that they remain visible while scrolling through a large spreadsheet. By selecting this option, you can easily keep important information in view even when navigating through different parts of the worksheet.

When a number is too large to fit within a cell, it is displayed as "#####". This is a formatting issue and occurs when the width of the cell is not wide enough to display the entire number. The "#####" symbol is used to indicate that the number is not visible in the cell. To resolve this, the cell width can be adjusted to accommodate the entire number.

The option "Undo" is used to restore something that was accidentally deleted. It allows the user to reverse the last action or series of actions, effectively bringing back the deleted item or returning to a previous state. This feature is commonly found in various software applications and provides a way to fix mistakes or recover lost data.

To perform any operation like cutting, copying, or moving data, the first step is to select the contents of the cell that contains the data. This is necessary because the selected data is what will be affected by the operation. Only after the data is selected can you proceed with the desired action such as cutting, copying, or moving it to another location.

The symbol "&" is used when concatenating data or joining two character strings together. This symbol is commonly used in programming languages and represents the logical operator for "AND". In the context of concatenation, it is used to combine two or more strings into a single string. For example, if we have two strings "Hello" and "World", using the "&" symbol we can concatenate them as "Hello" & "World" which would result in "HelloWorld".

PivotTable reports allow you to organize large amounts of data, create PivotCharts that show a graphical representation of large amounts of data, and easily change the layout of the report. By selecting "All of the above" as the correct answer, it implies that PivotTable reports offer all of these functionalities.

Applying an AutoFormat allows you to quickly format a range of cells with a predefined group of formats. This means that instead of manually applying individual formatting options to each cell, you can simply select the range and apply the AutoFormat to automatically apply a set of predefined formatting styles to the cells. This saves time and effort when formatting a large number of cells with consistent formatting.

An absolute reference is used when you want a cell reference to remain constant, regardless of where the formula is copied or moved. In this case, the correct absolute reference to cell A9 is $A$9. The dollar sign ($) before the column and row reference ensures that the reference does not change when the formula is copied or moved to another cell.

To select multiple cells that are not adjacent to each other, you can use the CTRL key. By holding down the CTRL key, you can individually select each cell that you want to include in the selection. This allows you to choose non-adjacent cells and create a multiple cell selection. The ALT key and selecting cells without any key modifier (option d) are not the correct methods for selecting non-adjacent cells.

To move one cell down from the active cell, you can press Enter. This is because pressing Enter moves the cursor to the cell directly below the active cell in most spreadsheet programs. Pressing Page Down, on the other hand, typically scrolls the screen down, rather than moving to the cell below. Clicking the upward scroll arrow would also not move the active cell down. Pressing Page Up would move the active cell up, not down.

The correct answer is c) Sort feature. The sort feature allows data to be arranged in ascending or descending order. This feature is commonly found in spreadsheet programs and databases, and it allows users to easily organize and analyze their data. By selecting the sort feature, users can choose which column or columns to sort by, as well as the order (ascending or descending). This feature is useful for tasks such as alphabetizing names, organizing numerical data, or sorting dates in chronological order.

A function in Excel refers to a built-in formula that performs a specific calculation or task. It is a predefined formula that can be used to manipulate data or perform calculations on a range of cells. Functions in Excel are designed to simplify complex calculations and can be accessed through the formula bar or by using the function wizard. They can be used to perform tasks such as summing numbers, finding averages, counting cells, and more.

The correct answer is c) File tab-->Help. This is the correct option because in Excel, the Help system can be accessed by clicking on the File tab, which is located in the top left corner of the Excel window. Once the File tab is clicked, a menu will appear on the left side of the screen, and the Help option can be found within this menu. By selecting the Help option, the Excel Help system will open, providing assistance and information on various topics related to Excel.

To rename a worksheet tab, the first step is to double-click on the worksheet tab. This action allows the user to directly edit the name of the tab and replace it with a new name. This is a simple and quick method to rename a worksheet tab without the need to navigate through different tabs or menus.

To split a worksheet, you would use the option from the View tab, specifically the Windows group, and select the Split option. This will allow you to divide the worksheet into multiple panes, allowing you to view different parts of the worksheet simultaneously.

To print a range of cells, you must first select the range of cells that you want to print. This can be done by clicking and dragging the mouse cursor over the desired cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell in the range. Once the range of cells is selected, you can proceed with the printing process.

To add a header or footer to a worksheet, you can choose any of the options mentioned. From the View tab, you can select Page Layout and then enter the headers in the worksheet. From the Insert tab, you can select Header & Footer in the Text group. Alternatively, from the Page Layout tab, you can select Print Titles and then go to the Header and Footer tab. All of these options allow you to add a header or footer to the worksheet.

The correct answer is d) From the Home tab in the Cells group -->Choose Insert-->Insert Sheet Rows. This option is the most appropriate for inserting a new row in a spreadsheet. The Home tab is where the basic formatting and editing options are located, and the Cells group specifically deals with operations related to cells. Choosing "Insert Sheet Rows" ensures that a new row is inserted into the spreadsheet, rather than just inserting a line or inserting cells.