MS Excel Questions and Answers

Q: Which option allows you to select line, curve, freeform or scribble tools?

Correct answer: Draw custom pathUnder Custom Animation, choosing Motion Paths → Draw Custom Path opens the four drawing tools: Line, Curve, Freeform and Scribble. Each lets you trace the route an object travels across the slide. Insert motion path only offers the ready-made paths, and there is no Create effect command.

Q: Which of the following should be used when you want to add a slide to an existing presentation?

Correct answer: Insert, New slideA slide is added to an open presentation from the Insert menu, choosing New Slide (Ctrl + M). File → New starts a whole new presentation and File → Open loads an existing one; the File menu has no add a new slide command.

Q: The size of the organization chart object

Correct answer: b and cThe organization chart object is placed by the presentation design, which fixes its default size - but that size is not locked: you can drag its handles to resize it, and it also grows or shrinks with the amount of text the chart holds. So both the “determined by the design but can be changed” statement and the “dependent on the amount of text” statement are true, which is why the combined choice is right and the “cannot be changed” option is wrong.

Q: Which of the following is the default page setup orientation of slide in PowerPoint

Correct answer: LandscapePowerPoint slides default to landscape - wider than they are tall (10 × 7.5 inches on the classic 4:3 setting) - because that matches the shape of a projector screen. Portrait is available under File → Page Setup but must be chosen deliberately.

Q: In MS Excel, what does Data Validation allow you to do?

Correct answer: Restrict what may be entered into a cellData Validation, on the Data tab, restricts what may be typed into a cell - a whole number within a range, a date, a text of limited length, a value from a list, or anything matching a custom formula. Its most common use is a drop-down list, created by choosing List and supplying either typed values or a range reference. That both speeds entry and guarantees consistent spelling, which matters greatly if the column will later be used in a lookup or a pivot table. It also supplies an input message shown when the cell is selected and an error alert when an invalid entry is attempted. The alert can be set to Stop, which refuses the entry, or to Warning or Information, which allow it after a prompt. Its limit is worth knowing: validation applies to what is typed, and a value pasted into the cell bypasses it entirely. Circle Invalid Data exists to find such entries afterwards.

Q: What is defined by the handout master?

Correct answer: Layout of audience handout notesThe handout master controls how printed handouts are arranged - how many slide thumbnails appear per page, where they sit, and the header, footer, date and page-number placeholders. It does not touch slide formatting, which belongs to the slide master, nor the Word export formatting.

Q: In notes master view, how do you modify the font size of text for all hte4 notes of a presentation?

Correct answer: Modify the text within the body placeholderNotes Master view shows the notes body as a placeholder. Selecting the text inside that placeholder and changing its font size resets the size for the notes of every slide at once. Changing the slide design affects slides, not notes, and moving the placeholder around alters the layout without touching the type size.

231.

Which option allows you to select line, curve, freeform or scribble tools?

A.Create effect
B.Insert motion path
C.Draw custom path
D.All of the above

Answer: C

Correct answer: Draw custom path

Under Custom Animation, choosing Motion Paths → Draw Custom Path opens the four drawing tools: Line, Curve, Freeform and Scribble. Each lets you trace the route an object travels across the slide. Insert motion path only offers the ready-made paths, and there is no Create effect command.

Discuss in Forum

232.

Which of the following should be used when you want to add a slide to an existing presentation?

A.File, add a new slide
B.Insert, New slide
C.File Open
D.File, New

Answer: B

Correct answer: Insert, New slide

A slide is added to an open presentation from the Insert menu, choosing New Slide (Ctrl + M). File → New starts a whole new presentation and File → Open loads an existing one; the File menu has no add a new slide command.

Discuss in Forum

233.

The size of the organization chart object

A.Is determined by the presentation design and cannot be changed
B.Is determined by the presentation design but can be changed in PowerPoint
C.Is dependent on the amount of text within the organization chart
D.b and c

Answer: D

Correct answer: b and c

The organization chart object is placed by the presentation design, which fixes its default size - but that size is not locked: you can drag its handles to resize it, and it also grows or shrinks with the amount of text the chart holds. So both the “determined by the design but can be changed” statement and the “dependent on the amount of text” statement are true, which is why the combined choice is right and the “cannot be changed” option is wrong.

Discuss in Forum

234.

Which of the following is the default page setup orientation of slide in PowerPoint

A.Vertical
B.Landscape
C.Portrait
D.None of above

Answer: B

Correct answer: Landscape

PowerPoint slides default to landscape - wider than they are tall (10 × 7.5 inches on the classic 4:3 setting) - because that matches the shape of a projector screen. Portrait is available under File → Page Setup but must be chosen deliberately.

Discuss in Forum

235.

In MS Excel, what does Data Validation allow you to do?

A.Restrict what may be entered into a cell
B.Check formulas for errors
C.Remove duplicate rows
D.Sort data alphabetically

Answer: A

Correct answer: Restrict what may be entered into a cell

Data Validation, on the Data tab, restricts what may be typed into a cell - a whole number within a range, a date, a text of limited length, a value from a list, or anything matching a custom formula. Its most common use is a drop-down list, created by choosing List and supplying either typed values or a range reference. That both speeds entry and guarantees consistent spelling, which matters greatly if the column will later be used in a lookup or a pivot table. It also supplies an input message shown when the cell is selected and an error alert when an invalid entry is attempted. The alert can be set to Stop, which refuses the entry, or to Warning or Information, which allow it after a prompt. Its limit is worth knowing: validation applies to what is typed, and a value pasted into the cell bypasses it entirely. Circle Invalid Data exists to find such entries afterwards.

Discuss in Forum

236.

What is defined by the handout master?

A.Slide formatting
B.Layout of audience handout notes
C.Handout content formatting for Microsoft word export
D.All of above

Answer: B

Correct answer: Layout of audience handout notes

The handout master controls how printed handouts are arranged - how many slide thumbnails appear per page, where they sit, and the header, footer, date and page-number placeholders. It does not touch slide formatting, which belongs to the slide master, nor the Word export formatting.

Discuss in Forum

237.

In MS Excel, what does the DATEDIF function calculate?

A.The difference between two dates in years, months or days
B.The date a given number of days ahead
C.Whether a value is a valid date
D.The day of the week for a date

Answer: A

Correct answer: The difference between two dates in years, months or days

DATEDIF returns the difference between two dates in the unit given by its third argument: "Y" for complete years, "M" for complete months, "D" for days, and the compound codes "YM", "YD" and "MD" for remainders. Its standard use is age: =DATEDIF(A1,TODAY(),"Y") gives completed years, which is what an age must be - simple subtraction and division by 365 goes wrong across leap years. It is a curiosity of Excel: inherited from Lotus 1-2-3, undocumented in the function list and absent from IntelliSense, but present in every version and fully supported. It must be typed in full. The other date functions are better documented. TODAY and NOW give the current date and time; DATE builds one from parts; EOMONTH finds the end of a month; WEEKDAY gives the day number; and NETWORKDAYS counts working days between two dates, excluding weekends and a supplied holiday list.

Discuss in Forum

238.

In notes master view, how do you modify the font size of text for all hte4 notes of a presentation?

A.Modify the slide design
B.Modify the notes master layout
C.Modify the text within the body placeholder
D.All of the above

Answer: C

Correct answer: Modify the text within the body placeholder

Notes Master view shows the notes body as a placeholder. Selecting the text inside that placeholder and changing its font size resets the size for the notes of every slide at once. Changing the slide design affects slides, not notes, and moving the placeholder around alters the layout without touching the type size.

Discuss in Forum

239.

In MS Excel, what is a macro?

A.A recorded or written sequence of actions that can be replayed
B.A very large number format
C.A cell containing more than 255 characters
D.A chart embedded in a worksheet

Answer: C

Correct answer: A recorded or written sequence of actions that can be replayed

A macro is a stored sequence of actions that can be replayed on demand. It is recorded with the Macro Recorder, which watches what you do and writes the corresponding code, or written directly in VBA - Visual Basic for Applications - in the editor opened with Alt + F11. Its purpose is to automate anything repetitive: formatting a report the same way each month, cleaning an import, or producing a set of sheets from a template. A workbook containing macros must be saved as .xlsm; the ordinary .xlsx format silently discards them, which is a common cause of lost work. That separation exists for security, since macros can do anything the user can, and have historically been a route for malware. Excel therefore disables them by default and shows a warning bar. Recorded macros are literal and brittle - they repeat exact cell addresses - so recording is often used as a starting point and then edited.

Discuss in Forum

240.

In MS Excel, the AutoFilter feature allows you to

A.display only the rows that meet chosen criteria
B.delete rows permanently
C.sort a column alphabetically only
D.protect a range of cells

Answer: A

Correct answer: display only the rows that meet chosen criteria

AutoFilter, applied with Ctrl + Shift + L or from the Data tab, adds a drop-down arrow to each header and lets rows be hidden unless they meet the chosen criteria. It hides rather than deletes: clearing the filter brings everything back, and the row numbers turning blue with gaps in the sequence is the sign that a filter is active. Forgetting that is a common source of confusion, since a filtered sheet can look as though data has been lost. The filter offered depends on the column’s content. Text columns get Text Filters, with options such as begins with and contains; numeric columns get Number Filters, including Top 10 and Above Average; date columns get date-aware options such as Last Month. One caution worth knowing: functions such as SUM include hidden rows, whereas SUBTOTAL and AGGREGATE can be told to ignore them - which is why a filtered total should use SUBTOTAL.

Discuss in Forum

Loading…

Topics

Other Subjects

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

MS Excel Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications