MS Excel

Correct Answer: B

Referencing means referring to or retrieving data from another cell or worksheet. In Excel, a reference to another sheet can be written as =Sheet2!A1. This allows data from one worksheet to be used in another worksheet. It is especially useful for linking related data across multiple sheets. There are Three types of Cell reference in Excel: Relative, Absolute, and Mixed.

Correct Answer: C

Microsoft Excel is the spreadsheet program in the Microsoft Office Suite. It is used for calculations, data entry, analysis, tables, and charts. Excel organizes data into rows and columns. It supports formulas and functions for performing calculations.

Correct Answer: C

CAD Chart is not a standard MS Excel chart type. Bar Chart, Waterfall Chart, and Scatter Chart are standard Excel chart types available in Excel.

Correct Answer: C

AVERAGE is the built-in Excel function used to calculate the arithmetic mean. It adds the values and divides their sum by the number of values. Example: =AVERAGE(A1:A5) calculates the average of cells A1 through A5.

Correct Answer: B

To add the values in A1 and A2, enter =A1+A2. In Excel, the plus (+) operator is used to add values from cells. Excel calculates the result automatically. The SUM function can also be used: =SUM(A1,A2).

Correct Answer: A

Excel's Fill Handle recognizes common series such as months. When Jan is entered and the Fill Handle is dragged, Excel automatically continues the series. The resulting cells will contain Jan, Feb, Mar, Apr, ... This feature saves time when creating sequential data.

Correct Answer: C

Freeze Panes is available under the View tab in MS Excel. It keeps selected rows or columns visible while scrolling through a worksheet. It is especially useful for large worksheets with headings. You can freeze the top row, first column, or selected rows/columns.

Correct Answer: B

In MS Excel, numbers are right-aligned automatically by default. Text is generally left-aligned automatically. Right alignment makes numerical values easier to compare and calculate. Users can change the alignment using the Alignment options.

Correct Answer: A

AutoCAD Civil 3D is widely used for road and highway geometric design. It can create horizontal and vertical alignments and perform volumetric calculations.

Correct Answer: B

The SUM function in MS Excel is used to add numbers from selected cells or ranges (e.g., =SUM(A1:A5)).

Correct Answer: A

The AVERAGE function in Excel calculates the arithmetic mean of a range of cells (e.g., =AVERAGE(A1:A20)).

Correct Answer: B

The COUNT function in MS Excel counts the number of cells that contain numerical values. COUNTA is used to count all non-empty cells.

Correct Answer: C

The =NOW() function in MS Excel returns the current date and time formatted as a date and time. It updates dynamically.

Correct Answer: C

The dollar sign ($) is prepended to column letters and row numbers (e.g., $A$1) to create absolute cell references in MS Excel formulas.

Correct Answer: C

The small black cross cursor (the Fill Handle pointer) at the bottom-right corner of a cell is used to copy formulas or extend data patterns automatically.

Correct Answer: B

Under the Data menu tab in MS Excel, the 'Sort' command is used to quickly organize selected text or numeric rows in ascending or descending order.

Correct Answer: C

In MS Excel, all user-defined formulas and built-in functions must begin with an equal sign (=) to signal that a calculation is required.

Correct Answer: B

MS Excel is the primary spreadsheet software program within the Microsoft Office Suite used to manage rows and columns of calculated data.

Correct Answer: C

In MS Excel, you can sort data columns in both Ascending order (A-Z, 1-100) or Descending order (Z-A, 100-1) via the Sort command.

Correct Answer: D

Cell Tips are comments or notes placed in an Excel cell to provide additional information, helping users understand or explain the data entered.