Prelim Exam: Computer Quiz MCQ!

When creating formulas, it should always start with an equal sign. This is because the equal sign is used to indicate that a formula is being entered in a cell. Without the equal sign, the content entered in the cell will be treated as text or a value, rather than a formula. Therefore, to perform calculations or use functions in Excel or other spreadsheet programs, it is important to begin the formula with an equal sign.

The Insert Tab allows users to insert various items into a document, such as pictures, clipart, headers, and footers. It provides a range of options for adding visual elements and formatting to enhance the document's appearance and functionality. This tab is commonly used when customizing the layout and design of a document.

The Page Layout Tab is the correct answer because it contains commands that allow users to adjust various aspects of a document's pages, such as margins, orientation, and themes. This tab is specifically designed for formatting and organizing the layout of the document, making it the most appropriate choice for this question. The other tabs listed do not typically include these specific page adjustment commands.

The Formulas Tab is the correct answer because it contains a function library that can assist in creating formulas and functions in a spreadsheet. This tab provides access to various mathematical, logical, text, date, and other types of functions that can be used to perform calculations and manipulate data within the spreadsheet. It also includes tools for auditing and debugging formulas, as well as managing named ranges and formula calculations.

To set the column and row width and height, you need to navigate to the Home tab. From there, you should go to the cells group and click on the format option. This will allow you to adjust the width and height of the columns and rows in your spreadsheet.

The title bar is the topmost horizontal bar in a window that displays the name of the workbook or document being worked on, as well as the name of the program or application being used. It provides a quick and easy way for users to identify the current file and program they are working with.

The Home Tab is the correct answer because it incorporates all text and cell formatting features such as font and paragraph changes. This tab is commonly used for basic formatting tasks in Microsoft Excel, such as changing the font style, size, and color, as well as aligning text and applying borders. It also includes options for formatting numbers, applying conditional formatting, and managing styles.

To select all cells in a worksheet, you can either press CTRL A or click the select all button. This will highlight all the cells in the worksheet, allowing you to perform actions on the entire range of cells at once.

When a cell displays an animated moving border around itself, it means that the cell was copied or cut. This animation is a visual indication that the cell has been selected and is being moved or copied to another location. It helps the user to track the movement of the cell and ensures that they are aware of the action being performed on the cell.

The Office Button is the correct answer because it is the button that replaces the file menu in previous versions of Excel. The Office Button provides access to common file-related tasks such as opening, saving, and printing files. It is located in the top left corner of the Excel window and has the Microsoft Office logo on it. By clicking on the Office Button, users can access various options and commands related to managing files in Excel.

When dealing with data that involves money, it is best to use the currency number format. This format ensures that the numbers are displayed with the appropriate currency symbol and decimal places, making it easier to read and understand the monetary values. It also helps in performing calculations and maintaining accuracy when working with financial data.

When a cell displays "#######", it means that the number or date entered in the cell is too wide to fit within the column width. This usually happens when the number or date has more digits or characters than the column can accommodate. To fix this, the column width needs to be adjusted to make it wider or the number/date needs to be shortened or formatted differently to fit within the cell.

To select a single cell, you can either click on the cell directly or use the arrow keys to navigate to the desired cell. This allows you to highlight and work with only one cell at a time.

The Quick Access Toolbar is the correct answer because it contains common commands such as Save and Undo, and allows users to add more commands as well. This toolbar is located at the top of the application window, providing easy access to frequently used commands, regardless of which tab is currently selected in the Ribbon. It offers a convenient way for users to quickly perform actions without navigating through various menus and options.

The formula a2+b2+c2 is incorrect because it does not represent a valid mathematical operation. In order to perform a mathematical operation, there needs to be an operator between the variables or constants. The given formula only consists of variables and constants without any operators, making it invalid.

The maximum row height size that can be set is 409.

To enter data in a worksheet, you need to click on the cell where you want to enter the data. This is the correct answer because clicking on the cell allows you to select it and activate it for data entry. Pointing to the cell is not sufficient for entering data as it only highlights the cell without actually inputting any data. Typing the data in the cell is also necessary, but it is the action you perform after clicking on the cell. Therefore, the correct sequence is to click the cell you want to enter data, and then type the data in the selected cell.

The answer is Ribbon because the Ribbon is a feature in Excel that replaces the traditional menus and toolbars. It is a tabbed interface that organizes commands and functions into different groups, making it easier for users to access and use various features in Excel. The Ribbon provides a more intuitive and streamlined way of navigating and using Excel compared to the previous versions.

The maximum column width size that can be set is 255.

To select a range of cells, you can click on the first cell in the range and then drag the cursor to the last cell. This action will highlight all the cells in between.

When dealing with data that involves employee salary, it is best to use the currency number format. This format ensures that the numbers are displayed with the appropriate currency symbol, decimal places, and formatting conventions. It helps to maintain consistency and clarity in representing salary figures, making it easier for users to understand and interpret the data accurately.

To cancel any selection in the worksheet, you can simply click on any cell in the worksheet. This action deselects any selected cells or ranges, allowing you to start a new selection or perform other actions on the worksheet. The other options, such as clicking the cancel button or closing and reopening MS Excel, are not necessary or efficient methods to cancel a selection.

To move a cell using the mouse, you first need to select the cells or range of cells that you want to move. Then, you click on the move button. After that, you need to point to the border of the selection and drag the cell or range of cells to another location.

To merge and center cells in Microsoft Excel, you need to first click on the Home Tab, which is where the formatting options are located. Then, go to the Alignment Group, which contains the options for aligning and merging cells. Finally, click on the Merge and Center button to merge and center the selected cells.

The given answer is correct. The types of number formats listed in the choices are General, Text, Currency, Accounting, Date. General format is used for displaying numbers as they are entered, Text format treats numbers as text and displays them as such, Currency format is used for displaying currency values, Accounting format is similar to currency format but it aligns the currency symbols and decimal points in a column, and Date format is used for displaying dates.