Computer — All MCQs

Correct Answer: A

“Monthly Wages” and “Final Approval Rating” are descriptive text entries. In a spreadsheet, such text is called a Label. Labels are used to identify or describe data in cells. A value is usually a number, and a formula performs a calculation.

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: A

The Excel SORT function has 4 arguments in its full syntax. Syntax: SORT(array, [sort_index], [sort_order], [by_col]). Only the array argument is required. The other three arguments are optional.

Correct Answer: C

Ctrl + 1 opens the Format Cells dialog box in MS Excel. It provides options for Number, Alignment, Font, Border, Fill, and Protection. It is a useful shortcut for quickly formatting selected cells. Additional information: • Ctrl + 5 — Strikethrough • Ctrl + 6 — Show/Hide objects • Ctrl + F10 — Maximize/restore active window

Correct Answer: B

A word processor is software used to create, edit, format, and print text documents. Common uses include typing letters, reports, applications, and other documents. Examples include Microsoft Word, Google Docs, and LibreOffice Writer.

Correct Answer: D

.pptx is the standard file format for saving a Microsoft PowerPoint presentation. It is the default presentation format in modern versions of PowerPoint. The X in .pptx indicates the XML-based Office Open XML format.

Correct Answer: B

An animation scheme is a predefined set of visual effects applied to text or objects on PowerPoint slides. It controls how text or objects appear, move, or disappear. Additional information: • Transitions are effects used when moving from one slide to another. • Layout determines the arrangement of content placeholders on a slide.

Correct Answer: A

The slide that is used to introduce a topic and set the tone for the presentation is called the Title Slide. The title slide is the first slide of a presentation. It usually contains a title and a subtitle.

Correct Answer: C

In MS PowerPoint, Ctrl + Home takes you to the first slide of the presentation. It is useful when working with a presentation containing many slides. Ctrl + End takes you to the last slide. These shortcuts help navigate quickly through a presentation. Additional information: • Page Up — Previous slide • Page Down — Next slide • Home — Go to first slide during Slide Show

Correct Answer: D

In MS Excel, double-clicking a chart object opens the chart for editing. You can then modify its data, design, layout, titles, and formatting. A single click generally selects the chart, and clicking and dragging is mainly used to move the chart.

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: A

The SUM function adds all numerical values in a specified range. =SUM(A1:A5) adds the values in cells A1, A2, A3, A4, and A5. Additional information: • SUM — Calculates total • AVERAGE — Calculates average • MAX — Finds maximum value • MIN — Finds minimum value • COUNT — Counts numerical cells

Correct Answer: A

In MS Word, pictures can be inserted through the Insert tab/menu. The Pictures option is available under the Insert tab. You can insert pictures from your device or other available sources. Clip Art was available in older versions of Microsoft Office.

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

To add a new row, right-click the row number where you want the new row. Select Insert from the context menu. Excel inserts a new row above the selected row. You can also use Home → Insert → Insert Sheet Rows.

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: C

In MS Excel, hold the Ctrl key while selecting cells to select multiple nonadjacent cells or ranges. This allows you to select separate cells without selecting the cells between them. Additional information: Shift is generally used to select a continuous range.