Machine-translated by Google. Questions are authored in English.
Top

MS Excel Questions and Answers

Answer: D

Correct answer: b and c both

An embedded chart is edited either by double-clicking it or by right-clicking and choosing the edit command for that object type - two routes to the same in-place editing.

Please log in or register to report this question.

223.

In MS Excel, which shortcut moves to the last cell containing data in the current region, downwards?

Answer: B

Correct answer: Ctrl + Down Arrow

Ctrl + Down Arrow jumps to the last filled cell of the contiguous block below the cursor, and stops at the edge of any gap. From an empty cell it jumps to the next filled one, or to the bottom of the sheet if there is none. The same works in all four directions, and adding Shift selects everything passed over - so Ctrl + Shift + Down selects a whole column of data in one keystroke, which is the fastest way to select a long range. Ctrl + End, the fourth option, is different: it goes to the last used cell of the whole sheet, the intersection of the last used row and column. That is often further out than the visible data, because Excel remembers cells that once held content - and that stale boundary is what inflates file sizes and can be reset by deleting the surplus rows and columns and saving. Alt + Down opens a drop-down list in the cell.

Please log in or register to report this question.

224.

Which of the following toolbars provide different options in various master views?

Answer: A

Correct answer: Common tasks toolbar

The Common Tasks toolbar changes according to the master being edited, offering the commands relevant to the slide, title, handout or notes master. The other toolbars stay the same in every view.

Please log in or register to report this question.

225.

How can you create a uniform appearance by adding a background image to all slides?

Answer: B

Correct answer: Edit the slide master

A background placed on the slide master appears on every slide that follows it, and any slide added later inherits it too. Applying it slide by slide would leave new slides untouched.

Please log in or register to report this question.

Answer: A

Correct answer: Edit the notes master and add your company logo

Speaker notes pages are governed by the notes master, which holds the slide image, the notes area and anything else to appear on every notes page. The slide master governs the slides themselves.

Please log in or register to report this question.

227.

Which option on the custom animation task pane allows you to apply a preset or custom motion path?

Answer: A

Correct answer: Add effect

Motion paths are applied from Add Effect > Motion Paths in the Custom Animation pane, which offers both the preset paths and a Custom Path tool for drawing one.

Please log in or register to report this question.

228.

What is the term used when a clip art image changes the direction of faces?

Answer: C

Correct answer: Flip

Flip mirrors a picture about its vertical or horizontal axis, so a figure that looked to the left now looks to the right - the direction the face points is reversed. Rotate turns the image about its centre, which tilts or inverts it rather than mirroring it, and Group merely binds several objects together so they move as one.

Please log in or register to report this question.

229.

The slide that is used to introduce a topic and set the tone for the presentation is called the

Answer: D

Correct answer: title slide

The title slide is the opening layout, carrying the presentation title and a subtitle. It names the topic and sets the tone before any content appears. A bullet slide carries the body points, while table and graph slides present data later in the deck.

Please log in or register to report this question.

230.

Which of the following features should you use when typing in the notes text box?

Answer: D

Correct answer: Zoom

The notes text box in Normal view is small, so the text is displayed at a reduced percentage and is hard to read while typing. Raising the Zoom level enlarges the pane on screen without changing the printed size. Slide Show runs the presentation, Insert adds objects, and the Slide Master governs formatting - none of them make the notes pane easier to read.

Please log in or register to report this question.

Loading…
Tags: MS Excel Questions and Answers || MS Excel MCQ Questions and Answers || MS Excel GK Questions and Answers || MS Excel GK MCQ Questions || MS Excel Multiple Choice Questions and Answers || MS Excel GK || GK on MS Excel || Computer Awareness Questions and Answers || Computer Awareness MCQ Questions and Answers || Computer Awareness GK Questions and Answers || GK on Computer Awareness