MS Excel
430 questions available
FILTER BY SUBTOPIC
Q281.How can you sum up a range of cells in Excel?
Correct Answer: A
The SUM function is used to add together all numerical values within a specified range of cells (e.g., =SUM(A1:A10)).
Q282.What is a cell in MS Excel?
Correct Answer: B
An Excel cell represents the rectangular intersection of a single vertical column and a single horizontal row on a worksheet.
Q283.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.
Q284.Which of the following is an example of a multimedia application?
Correct Answer: C
Adobe Photoshop is a professional digital image design, graphics creation, and editing multimedia application.
Q285.Which of the following symbol denotes auto sum in MS Excel?
Correct Answer: C
MS Excel uses the Greek capital letter Sigma (Σ) as the standard symbol on the Ribbon to represent AutoSum.
Q286.What acts as an interface/bridge between the computer user and the computer hardware?
Correct Answer: A
The Operating System (OS) is the essential system software that acts as an interface bridge between the user/apps and the computer hardware.
Q287.We can add charts in an Excel worksheet by using _____?
Correct Answer: C
Excel allows users to insert data visualization charts directly through the Insert Tab on the Ribbon.
Q288.Which of the following functions of Excel would you use to extract the substring 'Pak' from the word 'Pakistan'?
Correct Answer: A
The LEFT function extracts a specified number of characters starting from the left of a string (e.g., =LEFT("Pakistan",3) returns 'Pak').
Q289.The correct syntax of using the COUNTIF() function in MS Excel 2016 is ______?
Correct Answer: B
The correct Excel COUNTIF syntax is =COUNTIF(range, criteria), counting cells that meet the specified conditional test.
Q290.In Microsoft Excel, the file you create and edit is called?
Correct Answer: C
In Microsoft Excel, the files created are called workbooks, which can contain multiple individual worksheets.
Q291.Help in excel Short cut key?
Correct Answer: A
F1 is the shortcut key used to open Microsoft Excel help.
Q292.In MS Excel, by pressing Shift and Space keys at a time from the keyboard you can select?
Correct Answer: A
Pressing Shift + Space selects the entire row of the currently active cell in MS Excel.
Q293.In MS Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?
Correct Answer: A
The Ampersand (&) operator is used to concatenate text from two or more cells in Excel.
Q294.The freezing row and column in Excel is in which pane?
Correct Answer: A
Freezing rows and columns in Excel is done under the View tab using the Freeze Panes command.
Q295.In MS Excel if a numeric value start with ____ then this value can be treated as a formula?
Correct Answer: A
In Excel, any cell value starting with an equal sign (=) is evaluated as a formula.
Q296.MS Excel is a ______?
Correct Answer: A
Microsoft Excel is a spreadsheet application used to input, format, and analyze tabular data.
Q297.Name AI powered tool which can be used in Excel?
Correct Answer: A
Tableau has integrated AI features that help analyze and visualize data imported from Excel workbooks.
Q298.Which tab helps rearrange data in MS Excel?
Correct Answer: A
The Data tab in MS Excel contains the Sort and Filter tools used to rearrange and organize data.
Q299.Tool used for graphics designing or drawing is ______?
Correct Answer: C
Paint is a basic system application used for simple graphic designing, drawing, and editing images.
Q300.A spreadsheet is created using _____?
Correct Answer: B
MS Excel is the spreadsheet program used to organize data into rows and columns, support formulas, and perform calculations.