Cluster · MS Office Suite Fundamentals

d
Clusters / #1249
tight score 0.45

MS Office Features and Shortcuts
Questions
1,416
Questions in this cluster
1,416 total
Question Category Subtype Difficulty

Which of the following types of references is used to refer to all cells in columns H through J in a formula in MS-Excel 365? [Executive Assistant]

pipeline-782375
computer intermediate

What is the minimum zoom Percentage in MS-Excel 2010 application? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782313
computer intermediate

What is the purpose of applying shading to a table in Microsoft Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781991
computer intermediate

Which of the following keyboard shortcut keys can be used to insert a hyperlink in an MS-Word 2010 document? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782238
computer intermediate

______ function is used in MS-Excel 2010 for Rounding the number down. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782221
computer intermediate

What is the shortcut command in MS-Word 365 for selecting all the words from the file? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781333
computer intermediate

Which of the following is used to select an entire line or paragraph from the cursor place in MS-Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781825
computer intermediate

Instead of retyping the same text in MS-Word 2010, we can use ______ to reduce time and effort. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782258
computer intermediate

If you are currently in Cell D4 in Microsoft Excel and you press the Enter key, to which cell will you move? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781842
computer intermediate

Which of the following MS-Excel functions will return the factorial of a number? [Executive Assistant]

pipeline-782385
computer intermediate

Choose the wrong option related to cell of MS-Excel 2010: [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782305
computer intermediate

Which of the following is not a function in MS-Excel 2010? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782226
computer intermediate

In MS word 365 Which of the following keyboard shortcut keys is used to open new blank documents? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781622
computer intermediate

Which of the following is the correct order to turn off automatic bullets and numbering in MS-Word 365?

1. Select AutoCorrect Options, and then select the ‘AutoFormat As You Type’ tab.
2. Go to File > Options > Proofing.
3. Select OK.
4. Select or clear Automatic bulleted lists or Automatic numbered lists. [Executive Assistant]

pipeline-782377
computer intermediate

Which of the following options can be used in MS Word 365 if you want to save your document in another location with the same or different name? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781962
computer intermediate

Which of the following tabs of MS-Excel 365 contains cell alignment options like Top Align, Middle Align etc.? [Executive Assistant]

pipeline-782367
computer intermediate

In MS-Excel 2010, to select two or more non-adjacent worksheets, click the tab for first worksheet, then hold down the ______ key on your keyboard while you click the tabs of the other sheets you want to select. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782248
computer intermediate

In MS-Excel 2010 ______ function provides only the current system date. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782007
computer intermediate

Which of the following is an absolute cell reference in an MS Excel spreadsheet? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781846
computer intermediate

In MS Excel 365,to enable the edit mode in MS-Excel worksheet, we should follow: [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781902
computer intermediate

Which of the following MS-Excel formulas counts the number of cells having a string in the range A1 to A20 in a worksheet? [Executive Assistant]

pipeline-782387
computer intermediate

Which action should be taken to copy and paste text within a MS word 365 document? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781952
computer intermediate

In paragraph formatting of MS-Word 2010, Ctrl + Q is used for which of the following purpose? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782268
computer intermediate

The ______ is a name for the lower edge of the worksheet window, which displays various information about an excel worksheet in MS-Excel 2010. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782006
computer intermediate

Bullets and numbering are commonly used in Microsoft Word 365 to: [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781365
computer intermediate

Which button in the Home tab of Microsoft Word 365 can be used to cut selected text? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781847
computer intermediate

In Microsoft Excel 365, what is the cell address of the intersection between column L and row 26? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781960
computer intermediate

Which of the following keyboard shortcut is used to move the cursor up one paragraph in MS-Word 2010? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782249
computer intermediate

In MS Word 365, Ctrl + E key is pressed to perform which of the following tasks? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781873
computer intermediate

Which of the following charts is used in MS Excel 365 to display data as a series of points connected by straight lines and is used for showing trends over time? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781986
computer intermediate

In MS Excel 365, the title bar in Microsoft Excel is used for: [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781837
computer intermediate

In Microsoft Word 365, what does paragraph formatting primarily control? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781850
computer intermediate

Which of the following keyboard shortcut keys is used to copy the selected text in MS-Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781940
computer intermediate

In MS-Excel 2010 ______ is used in finding text within the sheet. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782228
computer intermediate

Where is the Help button located in MS-Word 2010? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781859
computer intermediate

In MS Excel 365, A Contour map is an example of which of the following charts? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781973
computer intermediate

In MS Excel 365, which option in Microsoft Excel allows you to move the selected text or cells to a different worksheet or workbook? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781860
computer intermediate

Among the following, under which tab will you find the Bullets and Numbering in MS-Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781924
computer intermediate

When a document of MS-Word 2010 is already open, which keyboard shortcut is used to open a new document? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782205
computer intermediate

Which of the following options quickly changes the font of the selected text in Microsoft Word 365 without opening the Font dialog box? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781867
computer intermediate

In MS Excel 365 which tab on the Microsoft Excel ribbon allows you to access options related to opening and saving files? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781493
computer intermediate

Which of the following is a function in MS-Excel 2010? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782255
computer intermediate

What does the ‘Search’ or ‘Find’ allow you to do in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781988
computer intermediate

Which option allows you to create a table in MS-Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781981
computer intermediate

In MS Word 365 which of the following menus is used to open a word document? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781929
computer intermediate

Choose the wrong option with respect to MS-Excel 2010: [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782210
computer intermediate

______ shortcut key is used to move to the previous sheet in MS-Excel 2010. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782086
computer intermediate

Which keyboard shortcut is commonly used to create a new blank document in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781920
computer intermediate

Which of the following keyboard shortcuts is used to italicise text or remove italic formatting in MS-Excel 365? [Executive Assistant]

pipeline-782351
computer intermediate

Which of the following keyboard shortcut used to start a new line in the same cell in MS-Excel 2010 worksheet? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782209
computer intermediate
Page 7 of 29