computer-Microsoft Excel – SARKARI LIBRARY

science

which one is the example of spreadsheet package

Snowball
visicalc
unity
ada

In MS Excel 2010 ———– is used for hiding columns within the sheet. SSC Delhi Police 10/10/2022 (Morning)

Ctrl + 0
Ctrl +9
Alt + 0
Alt + 9

In MS Excel 2010, we can collapse the ribbon to get extra space on the screen. Right-click anywhere on the ribbon, and then click Collapse the Ribbon or press ——— . SSC Delhi Police 10/10/2022 (Afternoon)

Ctrl + F2
Ctrl + F1
Alt + F1
Alt + F2

Which of the following keyboard shortcuts is used to rename the table in MS-Excel 2010 ? SSC Delhi Police 10/10/2022 (Afternoon)

Ctrl + T
Ctrl + R
Alt + R
Alt + T

Choose the wrong option with respect to MS-Excel 2010. SSC Delhi Police 10/10/2022 (Afternoon)

Alt + Enter shortcut key is used in MS-Excel 2010 to start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell.
In MS-Excel 2010 Home Tab in the ribbon bar contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting, etc.
In MS-Excel 2010, Ctrl + F is used in finding text within the sheet.
In MS Excel 2010, we can save the file by using F3.

——- shortcut key is used in MS-Excel 2010 to go to the view tab. SSC Delhi Police 10/10/2022 (Evening)

Alt + N
Ctrl + W
Alt + W
Alt + T

Choose the wrong option with respect to MS-Excel 2010. SSC Delhi Police 10/10/2022 (Evening)

In MS-Excel 2010, Ctrl+R is used in replacing text within the sheet.
In MS-Excel 2010, Ctrl+H is used in replacing text within the sheet.
In MS-Excel 2010, home tab in ribbon bar contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting, etc
Alt+Enter shortcut key is used in MS-Excel 2010 to enter a new line in the text of a particular cell.

In MS-Excel 2010 ———-is used in replacing text within the sheet. SSC Delhi Police 12/10/2022 (Morning)

Ctrl + N
Ctrl + H
Ctrl + W
Alt + H

In MS Excel 2010 function key ——— is used to edit a cell. SSC Delhi Police 12/10/2022 (Morning) OR Which function key in Excel helps to switch to edit mode? RRB NTPC 8/1/2021 (Evening)

Which of the following key is used to run spell check in MS Word 2010 ? SSC Delhi Police 13/10/2022 (Morning)

Which of the following is a shortcut key used to insert a new worksheet in an existing MS Excel 2010 workbook ? SSC Delhi Police 12/10/2022 (Morning)

Shift + F11
Shift + Ctrl + F10
Shift + F10
Shift + Ctrl + F11

————shortcut key is used to move to the previous sheet in MS Excel 2010. SSC Delhi Police 12/10/2022 (Afternoon)

Alt + pageUp
Alt + page down
Ctrl + page down
Ctrl + Page up

Which of the following shortcut key is used to open the Insert hyperlink dialog box in an MS Excel 2010 worksheet? SSC Delhi Police 12/10/2022 (Evening)

Alt + K
Alt + H
Ctrl + k
Ctrl + H

Which of the following keyboard shortcut used to start a new line in the same cell in MS Excel 2010 worksheet? SSC Delhi Police 13/10/2022 (Morning)

Alt + Enter
Ctrl + Enter
Tab + Enter
Shift + Enter

————–shortcut key is used in MS Excel 2010 to select a row. SSC Delhi Police 13/10/2022 (Evening)

Alt + Spacebar
Ctrl + Spacebar
Tab + Spacebar
Shift + Spacebar

In MS Excel 2010, which shortcut key is used to bold the selected text? SSC Delhi Police 13/10/2022 (Evening)

Alt + B
Ctrl + B
Ctrl + O
Ctrl + V

In MS Excel 2010 ————–is used in finding text within the sheet. SSC Delhi Police 14/10/2022 (Morning)

Alt + F
Ctrl + B
Ctrl + F
Ctrl + V

———–shortcut key is used in MS- Excel 2010 to go to the data tab. SSC Delhi Police 14/10/2022 (Morning)

Alt + A
Alt + D
Alt + F
Alt + V

———-shortcut key is used in MS Excel 2010 to select the entire worksheet. SSC Delhi Police 14/10/2022 (Afternoon)

Alt + A
Ctrl + B
Ctrl + F
Ctrl + A

————-shortcut key is used in MS Excel 2010 to select a column. SSC Delhi Police 14/10/2022 (Evening)

Alt + A
SHIFT + Spacebar
Ctrl + Spacebar
Ctrl + A

In MS Excel 2010, to select two or more non-adjacent worksheets, click the tab for the first worksheet, then hold down the key on your keyboard. while you click the tabs of the other sheets you want to select. SSC Delhi Police 17/10/2022 (Morning)

Alt
SHIFT
Ctrl
Tab

————–shortcut key is used in MS Excel 2010 to open the review tab. SSC Delhi Police 18/10/2022 (Morning)

Alt + R
SHIFT + R
Ctrl + R
Tab + R

In MS Excel 2010 ———–is used in hiding rows within the sheet. SSC Delhi Police 19/10/2022 (Afternoon)

Alt + 9
Ctrl + 0
Ctrl + 9
Tab + 9

Which of the following shortcut key is used to add an outline to selected cells in a worksheet of MS-Excel 2010? SSC Delhi Police 19/10/2022 (Evening)

Ctrl + Shift + Left Arrow
Ctrl + Shift + Right arrow
Ctrl + Shift + Underscore (_)
Ctrl + Shift + Ampersand sign (&)

————shortcut key is used in MS Excel 2010 to start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell. SSC Delhi Police 20/10/2022 (Afternoon)

ALT + Enter
Ctrl + Shift + + Enter
Ctrl + Enter
Shift + + Enter

——-function key is used to close a workbook in MS Excel 2010. SSC Delhi Police 20/10/2022 (Afternoon)

Ctrl + F2
Ctrl + F3
Ctrl + F1
Ctrl+F4

Choose the wrong option with respect to MS-Excel 2010: SSC Delhi Police 20/10/2022 (Afternoon)

In MS-Excel 2010, Ctrl + 9 is used in hiding the rows within the sheet.
In MS-Excel 2010, Alt + 0 is used in hiding the columns within the sheet.
In MS-Excel 2010, Ctrl + 0 is used in hiding the columns within the sheet.
In MS-Excel 2010, Home Tab in ribbon bar contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting, etc

———shortcut key is used in MS Excel 2010 to go to the insert tab. SSC Delhi Police 20/10/2022 (Evening)

ALT+T
ALT+I
ALT+F
ALT+N

Which keyboard shortcut in Microsoft Excel 2016 should you use to insert a new worksheet for the Windows 10 operating system? SSC CHSL 6/8/2021 (Afternoon)

Shift + F12
Shift + F7
Shift + F5
Shift + F11

What is the keyboard shortcut to add a new row above a given row in Microsoft Excel? SSC CHSL 12/8/2021 (Afternoon)

Alt+I+R
Shift +I+R
Alt + I +C
Shift + I + C

In Excel, what shortcut key is used to fill the selected cells with active cells to the right? RRB NTPC 12/1/2021 (Morning)

Alt+I+R
Ctrl + I
Ctrl + R
Ctrl + I + C

Which of the following key(s) can be used to cancel the editing of a cell in MS-Excel? SSC Delhi Police 28/11/2020 (Morning)

Alt
Ctrl
Esc
Tab

Which of the following shortcuts is used to move the cursor one word right while editing data in a cell in MS-Excel? SSC Delhi Police 7/12/2020 (Afternoon)

Ctrl + →
Ctrl + Shift+→
Ctrl + Shift + ←
Ctrl + ←

Which of the following shortcut keys is used to cut data from a cell in MS-Excel ? SSC Delhi Police 8/12/2020 (Afternoon)

Ctrl + X
Ctrl + Shift+ X
Ctrl + Shift + V
Ctrl + C

Which of the following keyboard shortcuts is used to strike through the contents of a cell in MS Excel 2010? SSC Delhi Police 14/12/2020 (Morning)

Ctrl + 5
Ctrl + 6
Ctrl + S
Ctrl + C

Which of the following statement with reference to MS Excel Is INCORRECT? SSC Delhi Police 9/12/2020 (Morning)

To move the pointer one cell to the left, right, up or down, use the ‘Shift’ key.
A darkened border, called cell pointer, is used to identify an active cell.
An active cell is a cell that receives the data or command you give it.
Each cell has a unique cell address composed of the cell’s column and row.

What is the shortcut to create a new workbook in Excel?

Ctrl + O
Ctrl + S
Ctrl + N
Ctrl + W

Explanation:

Ctrl + N instantly creates a new, blank workbook.
Ctrl + O opens the dialog box to open an existing workbook.
Ctrl + S saves the current workbook.
Ctrl + W closes the current workbook.

Which shortcut key is used to edit the active cell in Excel?

Explanation:

F2 allows you to edit the content of the currently selected cell.
F1 opens the Excel Help pane.
F4 repeats the last command or action, and toggles cell references.
F9 calculates all worksheets in all open workbooks.

What does the Excel shortcut Ctrl + Z do?

Redo the last action
Copy the selection
Undo the last action
Paste the selection

Explanation:

Ctrl + Z is the universal shortcut for undoing the last action performed.
Ctrl + Y is used to redo the last undone action.
Ctrl + C copies the selected cells.
Ctrl + V pastes the copied content.

Which key combination applies the Currency format in Excel?

Ctrl + Shift + #
Ctrl + Shift + %
Ctrl + Shift + $
Ctrl + Shift + @

Explanation:

Ctrl + Shift + $ applies the Currency format with two decimal places.
Ctrl + Shift + # applies the Date format.
Ctrl + Shift + % applies the Percentage format.
Ctrl + Shift + @ applies the Time format.

What is the function of the F4 key in Excel?

Opens the Find and Replace dialog box
Repeats the last command and toggles cell references
Creates a chart
Inserts a new worksheet

Explanation:

F4 is a multi-use key; it repeats your last action and cycles through absolute and relative cell references (e.g., A1, $A$1, A$1, $A1) when editing a formula.
Ctrl + H opens the Find and Replace dialog box.
F11 creates a chart from selected data.
Shift + F11 inserts a new worksheet.

Which shortcut selects the entire worksheet in Excel?

Ctrl + A (once)
Ctrl + S
Ctrl + A (twice) or Ctrl + A + A
Alt + A

Explanation:

Pressing Ctrl + A once selects the current data region. Pressing it a second time selects the entire worksheet.
Ctrl + S saves the workbook.
Alt + A opens the Data tab on the ribbon.

What does the shortcut Alt + = perform in Excel?

Opens the Function Arguments dialog
Inserts the current time
Automatically sums the selected cells (AutoSum)
Opens the Format Cells dialog

Explanation:

Alt + = is a quick way to insert the SUM function for the adjacent cells.
Shift + F3 opens the Insert Function dialog box.
Ctrl + Shift + : inserts the current time.
Ctrl + 1 opens the Format Cells dialog box.

Which key is used to open the ‘Go To’ dialog box in Excel?

F2
F5
Ctrl + G or F5
Ctrl + F

Explanation:

Both Ctrl + G and F5 will open the ‘Go To’ dialog box, allowing you to jump to a specific cell reference.
F2 is for editing the active cell.
Ctrl + F opens the ‘Find’ tab of the Find and Replace dialog.

What is the action of Ctrl + ; in Excel?

Inserts the current time
Inserts the current date
Applies the General format
Hides the selected columns

Explanation:

Ctrl + ; inserts the current static date into the active cell.
Ctrl + Shift + : inserts the current static time.
Ctrl + Shift + ~ applies the General number format.
Ctrl + 0 hides the selected columns.

Which shortcut opens the ‘Format Cells’ dialog box?

Ctrl + F
Ctrl + T
Ctrl + 1
Ctrl + 2

Explanation:

Ctrl + 1 is the key to quickly open the Format Cells dialog for the selected cells.
Ctrl + F opens the Find dialog.
Ctrl + T creates a table from the selected data.
Ctrl + 2 applies or removes bold formatting.

What does Ctrl + Page Down do in Excel?

Saves the workbook
Moves to the next cell
Moves to the next worksheet
Moves to the last cell

Explanation:

Ctrl + Page Down moves to the next sheet in the workbook.
Ctrl + S saves the workbook.
The Tab key moves to the next cell.
Ctrl + End moves to the last cell on a worksheet.

Which key combination is used to insert a hyperlink?

Ctrl + H
Ctrl + I
Ctrl + K
Ctrl + L

Explanation:

Ctrl + K opens the Insert Hyperlink dialog box for the selected cell or object.
Ctrl + H opens the Find and Replace dialog (Replace tab).
Ctrl + I applies or removes italic formatting.
Ctrl + L opens the Create Table dialog box.

What is the function of Shift + F10 in Excel?

Opens the Help menu
Displays the right-click (context) menu
Calculates the workbook
Inserts a new comment

Explanation:

Shift + F10 displays the context menu for the selected item, just like right-clicking.
F1 opens the Help menu.
F9 calculates all worksheets.
Shift + F2 inserts or edits a cell comment.

Which shortcut fills the selected cell(s) with the content from the cell above?

Ctrl + R
Ctrl + D
Ctrl + ‘
Ctrl + U

Explanation:

Ctrl + D uses the ‘Fill Down’ command to copy the content and format of the topmost cell to the cells below.
Ctrl + R fills the selected cell(s) with the content from the cell to the left (Fill Right).
Ctrl + ‘ copies a formula from the cell above.
Ctrl + U applies or removes underline formatting.

What action is performed by Ctrl + ` (grave accent) in Excel?

Hides formulas
Toggles the display of formulas and values
Opens the Macro dialog box
Inserts an array formula

Explanation:

Ctrl + ` (the key to the left of ‘1’) toggles the worksheet view to display formulas instead of their calculated results.
Hiding formulas is done via the Format Cells > Protection tab.
Alt + F8 opens the Macro dialog box.

Which key is used to open the ‘Create Table’ dialog box?

Ctrl + N
Ctrl + F2
Ctrl + T or Ctrl + L
Ctrl + F12

Explanation:

Both Ctrl + T and Ctrl + L will open the ‘Create Table’ dialog box to convert a data range into a formatted table.
Ctrl + N creates a new workbook.
Ctrl + F2 displays the Print Preview area.
Ctrl + F12 opens the Open dialog box.

What does the shortcut Alt + Enter do inside a cell?

Opens the cell for editing
Selects the entire column
Starts a new line within the same cell
Completes the cell entry

Explanation:

Alt + Enter adds a line break within a cell, allowing for multiple lines of text.
F2 opens the cell for editing.
Ctrl + Spacebar selects the entire column.
Enter completes the cell entry and moves down.

Which shortcut applies the Outline border to the selected cells?

Ctrl + Shift + &
Ctrl + Shift + &
Ctrl + Shift + _
Ctrl + B

Explanation:

Ctrl + Shift + & (ampersand) applies an outline border to the selected cells.
Ctrl + Shift + _ (underscore) removes all borders from the selected cells.
Ctrl + B applies or removes bold formatting.

What is the action of Ctrl + Arrow Key (e.g., ↓) in Excel?

Moves one screen down
Selects the entire row
Moves to the edge of the data region
Inserts an arrow symbol

Explanation:

Ctrl + Arrow Key navigates to the last non-empty cell in the direction of the arrow key, which is the edge of the current data region.
Page Down moves one screen down.
Shift + Spacebar selects the entire row.

Which key combination opens the ‘Insert Function’ dialog box?

Alt + =
F4
Shift + F3
Ctrl + F3

Explanation:

Shift + F3 opens the ‘Insert Function’ dialog box, helping you search for and insert a function.
Alt + = inserts the AutoSum function.
F4 repeats the last action.
Ctrl + F3 opens the Name Manager dialog box.

What does Ctrl + 0 (zero) do in Excel?

Hides the selected rows
Inserts a new row
Hides the selected columns
Applies the General format

Explanation:

Ctrl + 0 hides the columns that are currently selected.
Ctrl + 9 hides the selected rows.
Ctrl + Shift + + (plus) opens the Insert dialog for rows/columns.
Ctrl + Shift + ~ applies the General format.

Which shortcut is used to open the ‘Save As’ dialog box?

Ctrl + S
F2
F12
Alt + F4

Explanation:

F12 is the dedicated key to open the ‘Save As’ dialog box for saving the workbook with a new name or location.
Ctrl + S saves the workbook using its existing name and location.
F2 edits the active cell.
Alt + F4 closes Excel.

What is the function of Ctrl + F3 in Excel?

Opens the Find dialog
Pastes a name into a formula
Opens the Name Manager dialog box
Defines a name based on selection

Explanation:

Ctrl + F3 opens the Name Manager, where you can create, edit, and delete defined names.
Ctrl + F opens the Find dialog.
F3 opens the Paste Name dialog if names exist.
Ctrl + Shift + F3 creates names from row and column labels.

Which key combination applies the Percentage format with no decimal places?

Ctrl + Shift + %
Ctrl + Shift + % (It applies the format, decimal places depend on original data)
Ctrl + Shift + ^
Alt + H + P

Explanation:

Ctrl + Shift + % applies the Percentage format. The number of decimal places shown will match the original data’s decimal places (e.g., 0.1 becomes 10%, 0.123 becomes 12%). To control decimals, use the Increase/Decrease Decimal buttons after.
Ctrl + Shift + ^ applies the Scientific number format.
Alt + H + P is a ribbon shortcut for Percentage style.

What does Alt + H + O + I do in Excel?

Opens the Format Cells dialog
Inserts a new column
Auto-fits the column width
Hides the selected columns

Explanation:

Alt + H + O + I is a ribbon shortcut that AutoFits the width of the selected column(s) based on the longest entry.
Ctrl + 1 opens the Format Cells dialog.
Ctrl + Shift + + (plus) opens the Insert dialog for columns.
Ctrl + 0 hides the selected columns.