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

In MS-Word 365, which function key is used to open the ‘Save As’ window? [Executive Assistant]

pipeline-782503
computer intermediate

Which of the following keyboard shortcuts is used to insert a duplicate slide of the selected slide in MS-PowerPoint 2007? [Executive Assistant]

pipeline-782525
computer intermediate

Which of the following sequence of steps is used for manually setting a picture object to a specific proportion in MS-PowerPoint365?

1. On the shortcut menu, click on Format Picture
2. Right-click the picture
3. Under Scale, enter the percentage of the original height or width
4. In the dialog box, click the Size tab [Executive Assistant]

pipeline-782469
computer percentage intermediate

Which of the following main menus may be used to insert a picture (image) in a slide in MS-PowerPoint 2007? [Executive Assistant]

pipeline-782530
computer intermediate

The ‘Ctrl + W’ keyboard shortcut is used for which of the following purposes in MS-Word 365? [Executive Assistant]

pipeline-782485
computer intermediate

In MS-PowerPoint 2016, the ______ group on the ______ menu contains commands for formatting text in your document. [Executive Assistant]

pipeline-782430
computer intermediate

What will be the output of the following MS-Excel function?

=CEILING(34, 10) [Executive Assistant]

pipeline-782405
computer intermediate

Appear, Fade, Fly in, etc., are the options of which tab in MS-PowerPoint 365? [Executive Assistant]

pipeline-782459
computer intermediate

In MS-Word 365, the keyboard shortcut to open the ‘Print Preview’ window is______. [Executive Assistant]

pipeline-782499
computer intermediate

Which of the following signs is always the first part of the formula followed by an expression that calculates a value in MS-Excel 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781852
computer intermediate

Which of the following logical functions in MS-Excel 365 returns TRUE if all its arguments are TRUE? [Executive Assistant]

pipeline-782350
computer intermediate

In MS Excel 365, which of the following is the correct way to address the cell located in the third row and fifth column? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781965
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

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

Which of the following charts is ideal for showing trends in data at equal intervals, like months, quarters, or fiscal years in MS-Excel 365? [Executive Assistant]

pipeline-782348
computer intermediate

A ______ is a tool used in MS-Excel 2010 to calculate, summarize and analyze data and lets you see comparisons, patterns and trends in your

data. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782283
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 option in the context menu allows you to paste the copied text with formatting removed in Microsoft Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781918
computer intermediate

Which of the following alignment option will distribute your text evenly between the margins in MS-Word 2010? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782213
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

______function in MS-Excel 2010 capitalizes the first letter in each word of a text value. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782273
computer intermediate

Which of the following does the ‘Bold’ formatting option typically do to text in an MS Word 365, document? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781626
computer intermediate

Which of the following keyboard shortcuts is used to start a slide show from the first slide in MS-PowerPoint 365? [Executive Assistant]

pipeline-782359
computer intermediate

In Microsoft Excel 365, what is a function? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781972
computer intermediate

Which of the following options allows you to choose whether to keep or discard the formatting of pasted text in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781880
computer intermediate

Which of the following is the default font when a new blank document is created in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781882
computer intermediate

Which of the following effects is not available in the MS-Word 2010 font dialog box? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782224
computer intermediate

State whether following statements related to MS-Word 2010 are True or False?

(i) In Landscape orientation, the height of a page is larger than its width.
(ii) In Portrait orientation, the width of a page is larger than its height.
[Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782330
computer intermediate

Which of the following is the shortcut key to Paste text in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781903
computer intermediate

Which of the following options allows you to change page orientation in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781935
computer intermediate

What is the address of the cell at the intersection of fifth row and fifth column in MS-Excel 2010? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782259
computer intermediate

A table in MS-Word 2010 can have unlimited rows and a maximum of ______ columns. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782264
computer intermediate

In MS Excel 365 which of the following will be used to print a spreadsheet? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781633
computer intermediate

In Microsoft Excel 365, which of the following functions is used for displaying the current date? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781907
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 2010, which shortcut key is used to bold the selected text? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782223
computer intermediate

In MS Excel, which of the following is the correct cell address of the second column and third row? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781620
computer intermediate

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

pipeline-782210
computer intermediate

What is the primary purpose of creating a table in a word processing document? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781814
computer intermediate

Which of the following shortcut key is used to increase the font size to the next larger point size available in the Font Size list box of MS-Word 2010? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782244
computer intermediate

Header and Footer option is present in ______ tab in MS-Excel 2010 ribbon bar. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782261
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

In MS-Word 365, which option allows you to customize various aspects of a document's layout, such as paper size, margins, orientation, and page numbering? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781905
computer intermediate

How many options are available in the Alignment group for aligning text in a table in MS-Word 365? [Executive Assistant]

pipeline-782353
computer intermediate

______ is one of the most popular functions in MS-Excel 2010, and it allows you to make logical comparisons between a value and what you expect. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782308
computer intermediate

Consider the following statement about EXACT() function of MS-Excel 2010:
P: It compares two text strings and returns TRUE if they are exactly the same.
Q: It compares two text strings and returns 1 if they are not exactly the same.
R: It compares two text strings and returns FALSE if they are not exactly the same.
Which of the following statement(s) is/are true [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782041
computer intermediate

Which of the following shortcut key is used to open the Insert hyperlink dialog box in a MS-Excel 2010 worksheet? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782200
computer intermediate

In MS Word 365, which of the following is the default font style and size in the Font style and size dropdown list when a new document is opened in Windows 10? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781987
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

Which of the following is the correct option to draw a line through the middle of text in MS Word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781328
computer intermediate
Page 4 of 29