Computer — All MCQs
4795 questions available
Q2441.What type of chart is useful for showing trends or changes over time in Excel?
Correct Answer: C
A Line Chart displays data points connected by straight lines, making it perfect for representing continuous trends over time.
Q2442.What type of chart is useful for comparing values over categories in MS Excel?
Correct Answer: C
A Column Chart uses vertical bars to clearly represent and compare numerical values across different categories.
Q2443.Which of the following uniquely identifies a cell in MS Excel 2016?
Correct Answer: A
Each cell in Excel has a unique cell address consisting of its column letter followed by its row number (e.g., A1).
Q2444.Which of the following is NOT available on the Home Tab of MS Word 2016?
Correct Answer: B
The Columns layout tool is located under the Layout tab, not on the Home tab of MS Word.
Q2445.Which of the following is NOT a type of page margin in MS Word 2016?
Correct Answer: B
Standard margins are Top, Bottom, Left, and Right. Center is an alignment option, not a margin type.
Q2446.In mail merge, which of the following might represent the main document?
Correct Answer: A
In a Mail Merge, the main document holds the static layout and template text (e.g., a form letter) that is combined with a dynamic data source.
Q2447.In MS Excel 2016, which function returns the number (code point) corresponding to the first character of the text?
Correct Answer: A
The UNICODE() function returns the numeric Unicode value (code point) of the first character of a given text string.
Q2448.In MS Excel 2016, which function returns the number of days between two dates based on a 360-day year?
Correct Answer: C
The DAYS360 function computes the interval between two dates assuming a 30-day month / 360-day year standard, widely used in financial accounting.
Q2449.In MS Excel 2016, which option is used to quickly calculate rows of related data by inserting subtotals and totals?
Correct Answer: A
The Subtotal feature automatically groups rows of related data and adds subtotals and grand totals to summarize tables.
Q2450.In MS Excel 2016, which feature easily spots trends and patterns in your data using bars, colors, and icons to visually highlight important values?
Correct Answer: C
Conditional Formatting dynamically applies styles (like data bars, colors, or icons) to cells based on their values, emphasizing critical trends.
Q2451.In MS Word 2016, which feature is used to refer to specific places such as sections, tables, and figures in your documents?
Correct Answer: C
A Cross Reference links to specific items within the same document (like sections, tables, or numbered lists), updating automatically if those items move.
Q2452.In MS Word 2016, we create documents. A document consists of one or many ______?
Correct Answer: A
A Microsoft Word text document consists structurally of one or multiple pages where text, graphics, and elements are formatted.
Q2453.Which of the following is an example of a processing device?
Correct Answer: B
A computer processor (CPU) is the primary processing device that executes instructions, performs calculations, and coordinates hardware.
Q2454.Which of the following is an example of a hardcopy output device?
Correct Answer: B
A Printer is a hardcopy output device because it produces a physical, tangible copy of digital documents on paper.
Q2455.Which key combination is used in MS Excel 2016 to insert the current date as a static value in a workbook?
Correct Answer: C
The shortcut Ctrl + ; inserts the current system date as a static, unupdating value directly into the active cell.
Q2456.Which of the following provides a means of printing out speaker notes with a miniature slide on a printed page?
Correct Answer: A
Audience Handouts allow printing presentation materials with small miniature slides alongside notes or blank lines for the audience to take notes.
Q2457.What is the slide-title master pair in MS PowerPoint 2016?
Correct Answer: B
A slide-title master pair represents the combination of a Slide Master (for content slides) and a Title Master (specifically for the title slide layout) of a particular design theme.
Q2458.The arrangement of elements such as Title and Subtitle text, pictures, tables, etc., on a slide is called _____?
Correct Answer: A
A Slide Layout defines the placeholders and arrangement of content elements like titles, body text, lists, charts, tables, and images on a slide.
Q2459.Which MS-Excel 2016 feature can you use if you want to work with one database record at a time?
Correct Answer: C
The Data Form feature provides a simple dialog box interface to view, enter, edit, or delete single records in a table one at a time.
Q2460.Which function returns the average of all the cells in a range that meet a given criteria in MS Excel 2016?
Correct Answer: A
The AVERAGEIF function calculates the arithmetic mean of cells in a specified range that satisfy a given conditional criteria.