MS Excel
12 questions available
FILTER BY SUBTOPIC
Q1.In Ms Excel, Dollar sign is used to-----------data.
Correct Answer: A
Q2.Filtering is a useful way to see only the data that you want displayed in databases?
Correct Answer: C
Q3.Which is used for arranging data in ascending/descending order in MS Excel?
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.
Q4.In MS Excel, you can sort data in?
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.
Q5.Which Excel feature allows filtering data based on specific criteria without deleting rows?
Correct Answer: B
The Filter feature in Excel displays only rows that meet specific criteria, temporarily hiding the rest without deleting any data.
Q6.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.
Q7.In the context of ChatGPT and its underlying models like GPT-3 and GPT-4, what is a Transformer
Correct Answer: B
The Transformer is a deep learning architecture launched by Google in 2017 that uses self-attention mechanisms to analyze sequential data.
Q8.Microsoft Excel can ______ text so it appears on multiple lines in a cell.
Correct Answer: C
Text wrapping automatically adjusts cell content to span across multiple vertical lines within the same column width, ensuring text remains visible.
Q9.Which Microsoft Excel feature is used to selectively display only rows that satisfy a specified condition while hiding the rest?
Correct Answer: C
Filtering isolates specific rows based on custom conditions (e.g., showing only values > 100) while temporarily hiding irrelevant rows.
Q10.In spreadsheet programs like Excel, sorting can be executed based on which criteria?
Correct Answer: D
Excel supports sorting data rows based on multiple field types, including alphabetical text, numeric values, and chronologically by dates.
Q11.In Microsoft Excel, what term describes the process of transferring or pulling active data from one worksheet to another worksheet?
Correct Answer: B
Linking or Referencing (e.g., using formulas like =Sheet1!A1) allows data to be dynamically pulled and updated across worksheets.
Q12.In Microsoft Excel, what utility should be used to sort or fill in a user-defined custom order?
Correct Answer: C
A Custom List allows Excel users to populate or sort ranges of cells using customized, user-defined progressions.