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

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

The thesaurus tool in MS word 365 is used for ________. [Constable Executive Male and Female in Delhi Police Examination 2023]

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

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

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

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 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 tabs in MS-Excel 365 has the option to remove duplicate rows in a worksheet? [Executive Assistant]

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

Which of the following features in MS Excel 365 involves setting the system to adjust cells to fit their contents automatically so that all the information is visible? [Constable Executive Male and Female in Delhi Police Examination 2023]

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

Which of the following is the default value of decimal places in ‘Number’ type formatting of a cell in MS-Excel 2007? [Executive Assistant]

pipeline-782381
computer intermediate

______ is used in MS-Excel 2010 to open an already existing file. [Head Constable Ministerial in Delhi Police Examination 2022]

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

In MS Excel 365, which of the following functions can be used to display the formula applied to a specific cell? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781897
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 tabs in the MS Word 365, ribbon has the Spelling and Grammar option? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781862
computer spelling intermediate

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

pipeline-782317
computer intermediate

Which of the following is true with reference to 'Styles' in MS-Word 2010?
(i) Styles are nothing more than a named definition of how text should appear.
(ii) Styles allow for quick formatting modifications throughout the document. [Head Constable Ministerial in Delhi Police Examination 2022]

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

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

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

After finishing the table in MS-Word 2010, in case you want to insert a new row at the bottom of a particular row in a table, which of the following options can be used? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782326
computer intermediate

Which of the following is the result of applying toggle case option to the word ‘Online Test’ in MS-Word 365? [Executive Assistant]

pipeline-782336
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 commands does NOT belong to the ‘Page Setup’ menu in MS-Word 2007? [Executive Assistant]

pipeline-782394
computer intermediate

In MS-Excel 2010 ribbon ______ contains tools for inserting functions, defining names and controlling the calculation options. [Head Constable Ministerial in Delhi Police Examination 2022]

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

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

एमएस-एक्‍सेल 2010 में ______ फंक्शन यह गणना करता है कि लिस्‍ट ऑफ आर्ग्‍यूमेंट्स (list of arguments) में कितनी वैल्‍यू हैं। [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782277
computer intermediate

How do you change the font style and size of selected text in MS-Excel 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781863
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 an absolute cell reference in an MS Excel spreadsheet? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781846
computer intermediate

Which of the following is NOT a valid option for inserting rows and columns in an MS-Word 365 table? [Executive Assistant]

pipeline-782363
computer intermediate

In Microsoft Word 2019, which of the following settings is NOT found in the 'Indents and Spacing' tab of the 'Paragraph' dialog box? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781331
computer intermediate

The shortcut key used to save the document in MS-Word 365 is: [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-782001
computer intermediate

Which of the following is NOT a Change Case option in MS word 365? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781866
computer intermediate

In MS Excel 365 how can you add a specific number of days to a date in Excel? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781936
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 ______ are named from A onwards and ______ are named from 1 onwards. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782010
computer intermediate

In MS Excel 365, which of the following is the correct option to open an existing spread sheet in MS-Excel? [Constable Executive Male and Female in Delhi Police Examination 2023]

pipeline-781885
computer intermediate

Which of the following statements is/are true about Page Setup in MS-Word 2007?

(i) In ‘Normal’ the value of margins is 2.54 cm in each direction.
(ii) The size of A4 papers is 21 cm × 29.7 cm. [Executive Assistant]

pipeline-782384
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 MS-Excel 2010 ______ function provides only the current system date. [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782007
computer intermediate

In MS-Word 2010, which shortcut key is used to delete a character to the right side? [Head Constable Ministerial in Delhi Police Examination 2022]

pipeline-782208
computer intermediate

Which of the following function keys repeats the last command or action, if possible, in MS-Word 365? [Executive Assistant]

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

What will be the output of the following MS-Excel 365 formula:=12/8*6+4-2 [Executive Assistant]

pipeline-782370
computer intermediate
Page 5 of 29