1. On an excel sheet the active cell in indicated by ......... ?

A dark wide boarder

A dotted border

A blinking border

None of above

Answer: A dark wide boarder

Explanation:

On an Excel sheet, the active cell is indicated by option (1) A dark wide border. When you select a cell or navigate through the cells using the arrow keys or other navigation methods, the active cell is highlighted with a dark wide border. This border helps you identify which cell is currently selected and where any input or changes will be applied.


2. Which of the following special function keys allow the content in cell ?

esc

shift

return

Tab

Answer: return

Explanation:

The special function key that allows the content in a cell to be edited is option (3) Return. Pressing the Return key (also known as Enter) after typing in a cell is what confirms the input and accepts the content as the cell's contents. The content will be displayed in the cell, and the active cell selection will move to the next cell according to the direction of the spreadsheet.


3. A constant is another name for this type of data ?

number

equation

formula

description

Answer: number

Explanation:

A constant is another name for option (1) number. In Excel, a constant refers to a fixed value or number that is entered directly into a cell or used in calculations and formulas. It does not change unless manually modified. Constants can include whole numbers, decimals, percentages, dates, and other numeric values.


4. Which of the following is the oldest spreadsheet package ?

VisiCalc

Lotus 1-2-3

Excel

StarCalc

Answer: VisiCalc

Explanation:

The oldest spreadsheet package among the options provided is (1) VisiCalc. VisiCalc, developed by Dan Bricklin and Bob Frankston, is widely considered the first electronic spreadsheet program for personal computers. It was initially released for the Apple II computer in 1979. VisiCalc revolutionized the business world by enabling users to perform calculations, create tables, and analyze data in a digital format. Its introduction was a significant milestone in the history of spreadsheet software.


5. You can open the consolidate dialog box by choosing Consolidate from the ...... menu ?

Insert

Format

Tools

Data

Answer: Data

Explanation:

You can open the consolidate dialog box by choosing Consolidate from the (4) Data menu. In Microsoft Excel, the Consolidate feature allows you to combine data from multiple ranges or worksheets into a single summary. To access the Consolidate feature and open the consolidate dialog box, you need to follow these steps: Open Excel and open the workbook that contains the data you want to consolidate. Go to the Data menu at the top of the Excel window. Click on "Consolidate" in the Data menu. The Consolidate dialog box will appear, allowing you to specify the ranges or worksheets you want to consolidate and select the consolidation function. By using the Consolidate feature, you can summarize data from different sources or worksheets into a single location, making it easier to analyze and work with. So, the correct answer is (4) Data.


6. Graphics objects on a chart are used to ?

Add emphasis to chart data

Add interest to a chart

Help explain the chart data

(1), (2) and (3)

Answer: (1), (2) and (3)

Explanation:

The correct answer is option (4) (1), (2), and (3). Graphics objects on a chart in Excel are used for multiple purposes: (1) Add emphasis to chart data: Graphics objects such as data labels, data markers, and data points can be used to highlight specific data points or values in the chart, making it easier for viewers to understand and interpret the data. (2) Add interest to a chart: Graphics objects like shapes, pictures, and backgrounds can be added to a chart to make it visually appealing and engaging. These elements can enhance the overall design and aesthetics of the chart. (3) Help explain the chart data: Graphics objects, such as titles, legends, and annotations, can be used to provide additional information or context about the chart data. These elements help viewers understand the chart's purpose, data sources, units of measurement, or any other relevant details. Therefore, the correct answer is option (4) (1), (2), and (3).


7. Which is not an advantage of using computerized spread-sheets ?

flexibility of moving entries

speed of calculation

ability of generate tables

cost of initial setup

Answer: cost of initial setup

Explanation:

The option that is not an advantage of using computerized spreadsheets is option (4) cost of initial setup. Advantages of using computerized spreadsheets include: Flexibility of moving entries: Computerized spreadsheets allow you to easily move, insert, or delete entries within the spreadsheet without needing to manually rewrite or recalculate the data. Speed of calculation: Spreadsheets are designed to perform calculations quickly and accurately. They can handle complex formulas and perform calculations on large amounts of data efficiently. Ability to generate tables: Spreadsheets enable you to generate tables and reports based on the data entered. You can use functions, sorting, filtering, and formatting features to organize and analyze data effectively. However, the cost of initial setup is not typically considered an advantage of using computerized spreadsheets. While there may be costs associated with obtaining spreadsheet software or licenses, the initial setup cost is not one of the inherent advantages of using spreadsheets. Therefore, the correct answer is option (4) cost of initial setup.


8. You can print ?

A range of cells by range name

An entire worksheet

A single worksheet

All of the above

Answer: All of the above

Explanation:

You can print all of the options mentioned. The correct answer is option (4) All of the above. In Excel, you have the flexibility to print various elements of your workbook: You can print a range of cells by using a defined range name or by selecting the desired range manually. You can print an entire worksheet, which includes all the data and formatting within that sheet. You can print a single worksheet, which means only the active sheet will be printed while excluding other sheets in the workbook. So, all of the options mentioned in the question are valid printing options in Excel.


9. All macro keyboard shortcuts include the ________ key ?

Alt

Ctrl

F11

Shift

Answer: Alt

Explanation:

Alt


10. Rounding errors can occur ?

When you use multiplication, division, or exponentiation in a formula

When you use addition and subtraction in a formula

Because excel uses hidden decimal places in computation

When you show the results of formulas with different decimal places that the calculated results

Answer: When you use multiplication, division, or exponentiation in a formula

Explanation:

Rounding errors can occur for various reasons, but the most relevant option among the provided choices is (1) When you use multiplication, division, or exponentiation in a formula. Rounding errors can occur in calculations involving multiplication, division, or exponentiation due to the way computers represent and process numbers. Computers use a finite number of bits to represent numbers, which can lead to imprecise representations of certain decimal values. When performing calculations involving multiplication, division, or exponentiation, intermediate results may contain more decimal places than can be accurately represented. As a result, rounding errors can occur when these results are rounded to the desired number of decimal places.