Computer MCQS
600 computer mcq pdf. Computer Most Repeated MCQs PDF For Fpsc, Ppsc, Pms, CSS, Spsc, Bpsc, All Others Exams. . Computer MCQs solved questions with answers in PDF.
Table of Content
In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?
which of the following is not a valid Zoom percentage in Excel?
Here's a breakdown of the valid options:
A. 10: This allows you to see a very small portion of the spreadsheet with high magnification.
B. 100: This represents the default zoom level, showing the data at its actual size.
C. 300: This offers a zoomed-in view with three times the normal size, helpful for examining specific cells.
While there's no technical limitation preventing a zoom percentage beyond 400%, Excel doesn't offer options exceeding that level. It might become impractical to work with the spreadsheet at such high magnifications.
Which of the following is the latest version of MS Excel?
Excel 2011: This is a much older version, released in 2011 for Mac.
Excel 2017: This version was released in 2016 and is no longer the latest.
Excel 2021: This was a one-time release version and is not the most recent offering.
Office 365 (Correct): This is a subscription service that includes the latest version of Excel, along with other productivity applications like Word, PowerPoint, and more. Since Microsoft updates Office 365 regularly, it offers the most up-to-date features and functionality for Excel.
Additional points:
While you can purchase standalone versions of Excel (like Excel 2021), Office 365 provides the benefit of automatic updates, ensuring you have access to the latest features.
Office 365 also offers cloud storage and collaboration features not available in standalone versions.
Which of these keys are used in Ms Excel to copy value from above cell?
Ctrl + E: This keyboard shortcut doesn't have a predefined function for copying in Excel.
Ctrl + C: This is the standard shortcut for copying any selection in Excel, but it wouldn't be specific to the cell above.
Ctrl + D: This shortcut is typically used to fill down the contents of the active cell to the cells below it in the same column.
Therefore, if you want to quickly copy the value from the cell above without its formatting, Ctrl + ” is the most efficient option in Excel.
Which function calculates the largest value in a set of numbers in Excel?
number1: This is the first number or range of cells containing numbers that you want to find the maximum value for.
[number2], …: These are optional arguments representing additional numbers or ranges of cells to include in the calculation.
For example, if you have sales data in cells A1:A10 and want to find the highest value, you can use the formula:
Excel
=MAX(A1:A10)
Use code with caution.content_copy
This formula will return the highest sales figure in the specified range.”]
You can edit existing Excel data by pressing the:________ key?
Here's a breakdown of why the other options aren't used for editing data:
A. F1 Key: This key typically displays the Excel Help menu, which can be helpful for finding information about functions and features, but it's not used for direct data editing.
C. F3 Key: This key can have various functions depending on the context. In some cases, it might cycle through different cell references or paste a named range, but it's not the primary way to enter edit mode.
D. F4 Key: This key can be used to repeat the last action you performed, but it's not directly related to editing data.
So, remember F2 as your go-to key for quickly modifying data within your Excel cells.
Default file name in MS Excel is?
Workbook 1: While technically accurate, "Workbook" isn't the standard default file extension used by Excel.
Worksheet: This refers to a single sheet within a workbook, not the entire workbook itself.
Modern versions of Excel typically use Book1.xlsx as the default filename. The ".xlsx" extension signifies the file format, which is the default for newer Excel files.
To insert chart in MS Excel, which shortcut key used?
While the other options have their uses in Excel, they aren't specifically designed for chart insertion:
B. F2: This key is used to edit the content of the active cell.
C. F3: This key can be used for various purposes depending on the context, such as pasting a named range or finding a specific cell reference.
D. F4: This key can be used to repeat the last action you performed, but it's not directly related to chart insertion.
So, if you want to quickly create a chart from your selected data in Excel, remember the handy shortcut Alt+F1!
Which of these key are used in ms excel to insert current time In workbook.
Here's why the other options aren't used for inserting the current time:
B. Ctrl+!: This keyboard shortcut doesn't have a predefined function in Excel related to time insertion.
C. Ctrl+*: While Ctrl+* is a common keyboard shortcut used for copying formatting in Excel, it's not used for inserting the current time.
For the current date, you can use another helpful shortcut:
Ctrl+;: This inserts the current date in the format defined by your system settings.