General MCQs
1372 questions available
FILTER BY SUBTOPIC
Q461.Which key is used for right alignment in MS Word:
Correct Answer: A
CTRL+R is used for right alignment in MS Word.
Q462.In MS Excel =Now () is used:
Correct Answer: C
The =NOW() function in Excel displays the current date and time.
Q463.What is the function of F11 in MS Excel:
Correct Answer: C
F11 creates a chart on a new sheet from the selected data in Excel.
Q464.Which key is used to open new tab in internet explorer:
Correct Answer: B
CTRL+T opens a new tab in Internet Explorer and most browsers.
Q465.Which one is not a function in MS Excel:
Correct Answer: C
AVG' is not a valid Excel function name (the correct function is AVERAGE), unlike MAX and MIN which are valid.
Q466.Which is the default alignment In MS Word:
Correct Answer: B
Left-Align is the default text alignment in MS Word.
Q467.Which key is use for excel colum highlight
Correct Answer: B
CTRL+Space selects/highlights an entire column in Excel.
Q468.Which key is used for left alignment in MS Word:
Correct Answer: C
CTRL+L is used for left alignment in MS Word.
Q469.Which symbol is used for excel cell reference:
Correct Answer: B
The dollar sign ($) is used to fix/lock a cell reference in Excel.
Q470._________is ued to tell excel to include all cell between the two end point cell reference.
Correct Answer: C
A colon (:) is used in Excel to specify a range including all cells between two endpoint references (e.g., A1:A10).
Q471.Format painter in Powerpoint relates to:
Correct Answer: B
Format Painter copies formatting from one object or text and applies it to another location.
Q472.To verify that the note text is positioned correctly on the page, switch to _____ view or display the document in print preview.
Correct Answer: A
Print Layout view shows the document as it will appear when printed. It helps verify the positioning and formatting of text on the page. Print Preview also displays the document's expected printed appearance. It is useful for checking margins, page arrangement, and text placement.
Q473.Computer spreadsheet cell that is highlighted with a heavy border is a ______?
Correct Answer: A
The active cell is the currently selected cell in a spreadsheet. It is usually highlighted with a heavy/thick border. Data entered from the keyboard is placed into the active cell. Only one cell is normally active at a time.
Q474.In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed Enter key?
Correct Answer: B
In Excel, pressing Enter normally moves the active cell down one row. If the current cell is B4, pressing Enter moves the selection to B5. This is the default behavior unless the Enter key direction has been changed in Excel settings.
Q475.CD stands for?
Correct Answer: A
"CD" most commonly stands for Compact Disc. It is used for storing digital audio, software programs, documents, and videos. It was co-developed by Philips and Sony and introduced in the early 1980s.
Q476.Which of the following is NOT an element of spreadsheet interface?
Correct Answer: A
Pencil work is not an element of the spreadsheet interface. Active Cell, Menu Bar, and Workbook are associated with a spreadsheet environment. The Active Cell is the currently selected cell where data can be entered or edited. A Workbook is an Excel file containing one or more worksheets.
Q477.An entry in a spreadsheet cell like "Monthly Wages" or "Final Approval Rating" would most likely be a?
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.
Q478.No. of arguments in SORT function is/are?
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.
Q479.In order to edit a chart, you can _______?
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.
Q480.What does =SUM(A1:A5) formula calculates?
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