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 operations can be performed on a worksheet tab in MS-Excel 2016?

(i) Delete,
(ii) Rename,
(iii) Hide [Executive Assistant]

pipeline-782427
computer intermediate

What is the address of the cell in an MS-Excel worksheet which lies at the intersection of the second row and the third column? [Executive Assistant]

pipeline-782440
computer intermediate

Which of the following statements is/are true about viewing a presentation in MS-PowerPoint 2007?

(i) By default, there are ‘Normal’, ‘Print Layout’, and ‘Web Layout’ views commands in the status bar.
(ii) The Slide Show command may be executed by pressing the ‘F2’ key. [Executive Assistant]

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

In MS-Excel 2010, the______ feature helps us to add the contents of a cluster of adjacent cells. [Executive Assistant]

pipeline-782470
computer intermediate

In desktop versions of Outlook 365, you can check the spelling in your email message at any time manually by going to______. [Executive Assistant]

pipeline-782472
computer spelling intermediate

In MS Excel 365, which of the following options is/are true for naming a worksheet?

i) The worksheet name can contain more than 31 characters.
ii) The worksheet name can contain any of the following characters: / \ ? * : [ ]
iii) The worksheet can be named as ‘History’.
iv) The worksheet can be named as ‘Abcd1001’.
[Head Constable (Ministerial)]

pipeline-782562
computer 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

Which of the following tabs is used to change the styes of a line in a MS-PowerPoint 365 slide? [Executive Assistant]

pipeline-782468
computer intermediate

Which of the following options is NOT available in Text Format options that appear when the cursor hovers over selected text in MS-PowerPoint 365? [Executive Assistant]

pipeline-782481
computer intermediate

Which of the following cell references is used for the cell in column Z and row 20 in MS-Excel 365? [Executive Assistant]

pipeline-782491
computer intermediate

Which of the following Break options inserts a new section break and starts the new section on the same page in MS-Word 365? [Executive Assistant]

pipeline-782488
computer intermediate

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

pipeline-782539
computer intermediate

Which of the following statements related to MS-PowerPoint 2016 is/are FALSE?

(i) You can delete the slides from the Normal view.
(ii) You cannot delete the slides from the Slide Sorter view. [Executive Assistant]

pipeline-782410
computer intermediate

Which of the following statements is/are true about headers and footers in MS-PowerPoint 2007?

(i) By default, the slide number is displayed in the lower right corner of the slide.
(ii) The ‘date and time’ cannot be inserted using a header and footer. [Executive Assistant]

pipeline-782523
computer intermediate

Which of the following keyboard shortcuts is used to save an MS-Word document? [Head Constable (Ministerial)]

pipeline-782547
computer intermediate

What is the keyboard shortcut to invoke ‘Insert Hyperlink’ window in MS-Word 2016? [Executive Assistant]

pipeline-782437
computer intermediate

While entering data in a cell of an MS-Excel worksheet, which of the following keys can be pressed once to cancel all contents of the cell? [Executive Assistant]

pipeline-782449
computer intermediate

What will happen when you press Ctrl+Y while working in MS-Word? [Executive Assistant]

pipeline-782447
computer intermediate

Commands related to presentation views, Master slides, colour settings and window arrangements appear under which of the following menus in MS-PowerPoint 2016? [Executive Assistant]

pipeline-782423
computer intermediate

Which of the following is the keyboard shortcut for saving the content of a currently open Word document in MS-Word 2007? [Executive Assistant]

pipeline-782398
computer intermediate

In MS-PowerPoint 2016, the ______ is located just above the Ribbon and it lets you access common commands no matter which tab/menu is selected. [Executive Assistant]

pipeline-782435
computer intermediate

The Drop Cap feature of MS-Word 365 can be used to create a letter of much bigger size at/in the______ of a paragraph. [Executive Assistant]

pipeline-782511
computer intermediate

Which of the following MS-Word features identifies words that do not appear in a standard dictionary? [Executive Assistant]

pipeline-782404
computer intermediate

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

pipeline-782503
computer intermediate

Identify whether the given statements with reference to MS-Word 365 are true or false.

(I) The Shading option is used to colour the background behind the selected text or paragraph.
(II) Multi-level list is not supported in an MS-Word document. [Executive Assistant]

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

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

=CEILING(34, 10) [Executive Assistant]

pipeline-782405
computer intermediate

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

pipeline-782499
computer intermediate

In MS-PowerPoint 2019, which of the following is used to display a group of related commands within tabs? [Executive Assistant]

pipeline-782502
computer intermediate

Which of the following can be used to edit the content of a cell in MS-Excel 2016 worksheet?

(i) F2,
(ii) Double click [Executive Assistant]

pipeline-782436
computer intermediate

Which of the following statements is INCORRECT about cell reference in MS-Excel 2007? [Executive Assistant]

pipeline-782400
computer intermediate

Cells that are on other worksheets in the same workbook can be referred by prepending the name of the worksheet followed by a/an______ symbol to the start of the cell reference in MS-Excel 365. [Executive Assistant]

pipeline-782457
computer intermediate

Which of the following texts in MS-Word is an example of superscript? [Executive Assistant]

pipeline-782542
computer intermediate

Which of the following functions in MS-Excel 365 is used to search for an item in a range of cells, and then return the relative position of that item in the range? [Executive Assistant]

pipeline-782495
computer intermediate

In an MS-Word 2010 document, an email address text string is automatically shown as a hyperlink. To remove this link which of the following options must be selected after right-clicking on it? [Head Constable (Ministerial)]

pipeline-782549
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.0 cm in each direction.
(ii) The size of A3 papers is 21 cm × 20.7 cm. [Executive Assistant]

pipeline-782534
computer intermediate

What will be the output of the following MS-Excel 365 formula?
=50+20/5-3 [Executive Assistant]

pipeline-782497
computer intermediate

Which of the following keyboard shortcuts is used to enter a new line in the same cell in an MS-Excel 2010 worksheet? [Head Constable (Ministerial)]

pipeline-782546
computer intermediate

Which of the following MS-Excel functions returns a number rounded up, away from zero, to the nearest multiple of significance? [Executive Assistant]

pipeline-782433
computer intermediate

Push, Fade, Wipe, etc. are options of which tab in MS-PowerPoint 365? [Executive Assistant]

pipeline-782489
computer intermediate

In MS-Excel 365, to enter the same data into several cells at the same time, select the cells into which you want to enter the data (the cells do not have to be adjacent). In the active cell, type the data and then press______. [Executive Assistant]

pipeline-782455
computer intermediate

What will be the output of the following MS-Excel 365 formula?

=20/10*7+4-1 [Executive Assistant]

pipeline-782467
computer intermediate

MS-PowerPoint 2016 includes several tools to help organise and arrange content on your slides. Which of the following is/are such tools?

(i) Ruler, (ii) Gridlines [Executive Assistant]

pipeline-782443
computer intermediate

Which of the following MS-PowerPoint 365 views is used to easily rearrange the slides? [Executive Assistant]

pipeline-782465
computer intermediate

Which of the following MS-Excel functions returns the binary number equivalent to a decimal number? [Executive Assistant]

pipeline-782524
computer intermediate

Which of the following features of a word processor automatically allows you to move to the next line when you have filled one line with text? [Executive Assistant]

pipeline-782417
computer intermediate

Cell B1 has the

“=IF(A1>=80,"AB",IF(A1<=60,"BC",IF(A1>=70,"CD","DE")))” formula, where cell A1 stores 55. Which of the following should be the output in cell B1? [Executive Assistant]

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

A footnote in an MS-Word 365 document appears at the______. [Executive Assistant]

pipeline-782506
computer intermediate
Page 2 of 29