WorksheetsKiến thức về MS Office
Total questions: 77
Worksheet time: 44mins
In MS PowerPoint, to create a new slide from a slide in another presentation, which command do you use?
Copy text from a Word file and paste into PowerPoint.
Insert tab → New Slide → Slides from Outline...
Insert tab → New Slide → Duplicate Selected Slides.
Insert tab → New Slide → Reuse Slides.
In MS Word, to create a table of contents for the document, what action do you perform?
References tab → Footnotes group → Insert Endnote command.
References tab → Footnotes group → Insert Footnote command.
References tab → Captions group → Insert Caption command.
References tab → Table of Contents group → Custom Table of Contents command.
In MS Word, when applying formatting using Styles, what is the biggest benefit?
Helps save documents faster.
Helps apply color effects to each word.
Helps format uniformly and easily edit the entire text.
Helps make text bold and italic faster.
In MS Word, what is the effect of the Gutter command in the Page Setup dialog?
Creates a right margin on the page.
Creates a top margin on the page.
Creates a left margin on the page.
Creates space at the edge of the page for binding documents or books.
In MS Excel, when using Protect Sheet, which option allows you to still edit the specified cells?
Format as Table.
Unlock Cells before Protect.
Add-ins.
Protect Workbook.
In MS Word, to change the orientation of the paper, which command do you use in which tab?
Insert tab.
Design tab.
Layout tab.
Home tab.
In MS Word, to keep the current paragraph and the paragraph immediately after it always on the same page, which option do you use in the Paragraph dialog → Line and Page Breaks tab?
Windows/Orphan control.
Page break before.
Keep lines together.
Keep with next.
In MS Excel, which operation does the Subtotal function not support?
Summarizing multiple fields at once.
Inserting subtotal rows.
Automatically updating when data changes.
Grouping data by category.
In MS Word, to remove the background color of the selected shape, which command do you use?
Home tab → Font → Clear All Formatting
Picture Format tab → Size → Crop
Shape Format tab → Shape Styles → Shape Fill → No Fill
Picture Format tab → Adjust → Remove Background
In MS PowerPoint, what is the Animation Pane used for?
Creating transition effects.
Changing the background color for the entire slide.
Managing the order.
In MS PowerPoint, what is the Animation Pane used for?
Create transition effects.
Change the background color for the entire slide.
Manage the order and timing of animation effects.
Preview the entire slide.
In MS Excel, when setting up Data Validation to prevent users from entering incorrect rules, which error alert style do we choose in the Data tab → Data Tools group → Data Validation command → Error Alert dialog?
Style: Warning
Style: Stop
Style: Information
Clear All
In MS PowerPoint, what does the Loop until Stopped option in sound effects mean?
Repeat the sound until a new sound is encountered.
Repeat the sound until manually stopped.
Repeat the sound after each slide.
The sound only plays once.
In MS PowerPoint, what does a numbered animation effect mean?
The effect only runs when clicked or Enter is pressed.
The effect runs simultaneously with the previous effect.
The effect automatically runs after the previous effect ends.
The effect runs after a delay from the previous effect.
In MS Word, what shortcut key is used to create a new blank page?
Shift + Enter
Alt + Enter
Ctrl + Enter
Shift + Ctrl + Enter
In MS Excel, to prevent others from changing the content of a worksheet, which function do we use?
Conditional Formatting.
Hide Sheet.
Protect Sheet.
Data Validation.
In MS Excel, when using the Advanced Filter, where do we need to set the filter conditions?
In the formula bar.
In the Advanced Filter dialog box.
Directly on the original table.
In a separate data range with the same header as the original table.
In MS PowerPoint, to create a new slide containing text content from an MS Word file, which command do we use?
Copy text from the Word file and paste into PowerPoint.
Insert tab → New Slide → Reuse Slides.
Insert tab → New Slide → Slides from Outline...
Insert tab → New Slide → Duplicate Selected Slides.
In MS Word, which command is used to create a 'Draft' watermark for internal documents?
Design tab → Style Set.
Design tab → Watermark.
Insert tab → Signature Line.
Insert tab → Text Box.
In MS Word, which option allows limiting a document to be read-only and not editable?
Enable Editing.
Save As Read-Only.
Mark as Final.
Insert Lock.
In MS PowerPoint, to set the automatic slide transition time, what do we use?
In MS PowerPoint, to set the automatic slide transition time, which option do we use in the Transitions tab?
Advance Slide → After:...
Transition to This Slide.
Sound:...
Duration:...
In MS Word, to change the left margin position for the first line of a paragraph, which command do we use?
Left Indent
First Line Indent
Hanging Indent
Right Indent
In MS PowerPoint, to make the animation effect run automatically at the same time as the previous effect, which command do you use in the Animations tab?
Start: On Click
Start: After Previous
Start: With Previous
Start: Animation
In MS Word, the Special → First Line in the Paragraph dialog box is used for what?
Align the left margin for the paragraph.
Indent the first line of the paragraph.
Spacing between the first line characters.
Indent the first line of the paragraph.
In MS PowerPoint, to create a background for a heart shape, which command do we use?
Design tab → Format Background command.
Drawing Tools tab → Shape Fill → Picture...
Insert tab → Pictures command.
Drawing Tools tab → Text Fill → Picture...
In MS Excel, if we enter the value 200 in cell A2, then enter the formula =A2/0 in cell B2, what is the result returned in cell B2?
#N/A
#DIV/0!
#VALUE!
#NAME!
In MS Excel, to create a summary table of total revenue by region and product type, which tool should we use?
Subtotal.
Sort.
Filter.
Pivot Table.
In MS PowerPoint, to ensure the video always displays full screen when played, which option do we need to select in Video Options?
Loop until Stopped.
Rewind after Playing.
Play Full Screen.
Hide While Not Playing.
In MS PowerPoint, to hide the sound icon during the presentation, which command do you use?
Slide Show tab → Set Up → Hide Slide
Play Back tab → Audio Options → Hide During Show
Slide Show tab → Set Up → Show Media Controls
Home tab → New Slides → Duplicate
In MS Excel, a continuous range of data selected in a spreadsheet is called what?
Range
Table
Database
Field
In MS Excel, to repeat the first header row on each printed page, where do we set the command?
Page Layout tab → Print Area command.
Page Layout tab → Print Titles command.
View tab → Freeze Panes group → Freeze Panes command.
Where do we set the command for the first title to be repeated on each printed page?
Page Layout → Print Area.
Page Layout → Print Titles.
View → Freeze Panes → Freeze Panes.
View → Freeze Panes → Freeze Top Row.
In MS Word, when there is a paragraph separated by tabs or commas, which command do we use to convert it into a table?
Insert Table.
Convert Text to Table...
Convert Table to Text...
Draw Table.
In MS Excel, to grant permission for others to edit a protected worksheet, which command do we use in the Review tab → Protect group?
Protect Sheet
Protect Workbook
Allow Users to Edit Range
Share Workbook
In MS PowerPoint, when inserting a transition effect for a slide, which command do you use in the Transition tab to change the direction of the effect?
On Mouse Click
After
Duration
Effect Options
In MS Excel, what is the Defined Name command used for?
To name a data range for easier formula use.
To assign a password to a cell.
To create a note in a cell.
To name a chart.
In MS Word, to have a different header on the first page than the others, which command do we choose in the Header & Footer tab?
Header from Top:
Footer from Bottom
Different Odd & Even Pages
Different First Page
In MS PowerPoint, to set sound to play throughout the presentation, which command do we use in the Playback tab?
Loop Until Stopped
Start → On Click
Start → Automatically
Start → Play across slides
In MS PowerPoint, to remove the background color from the selected image, which command do we use?
Home → Font → Clear All Formatting
Picture Format → Size → Crop
Shape Format → Shape Styles → Shape Fill → No Fill
Picture Format → Adjust → Remove Background
In MS Excel, after converting a data range into a table, which of the following options is not supported?
Advanced sorting.
Fixed header.
Automatically expand the range when adding data.
Calculate total at the end of the table.
In MS Word, to quickly navigate through sections of text formatted with styles, which command do we use?
Navigation Pane
Selection Pane
Accessibility Assistant Pane
Format Shape Pane
In MS Excel, to filter out duplicate data rows, which command do we use Remove Duplicates in which tab?
Home.
Page Layout.
Data.
Formulas.
In MS Excel, to filter out duplicate data rows, which command do we use?
Home
Page Layout
Data
Formulas
In MS PowerPoint, when changing Theme Effects, which object is not affected?
Chart
Shape
Picture
SmartArt
In MS Word, to adjust the spacing between lines in a paragraph without changing the spacing between paragraphs, which option do we use?
Spacing Before
Paragraph Indent
Spacing After
Line Spacing
In MS Excel, which function helps create dynamic summary reports from the original data table?
Pivot Table
Format as Table
Subtotal
Goal Seek
In MS PowerPoint, to create multiple presentations from the same file, which command do we use?
Slide Show
Review
Design
Insert
In MS PowerPoint, to set a solid background color for a slide, which command do you use?
Design → Format Background → Fill → Solid
Home → Font → Font Color → Solid
Drawing Tools → Shape Styles → Shape Fill → Solid
Drawing Tools → WordArt Styles → Text Fill → Solid
In MS Word, to keep lines in the same paragraph on the same page, which option do we use in the Paragraph dialog box under Line and Page Breaks?
Keep lines together
Keep with next
Windows/Orphan control
Page break before
In MS Excel, if you want to color cells with values less than 0, which command do you select in the Conditional Formatting group?
Highlight Cells Rules
Data Bars
Color Scales
Top/Bottom Rules
In MS PowerPoint, to set an effect that only runs when you click on a specific object, which feature do you need to use?
Transition Effect
Trigger
Morph
Animation Pane
In MS Word, to restrict others from editing the content of a document, which feature should you use?
Watermark
Track Changes
Comments
Restrict Editing
In MS Excel, what is the Data Validation feature used for?
Create automatic summary tables
Format cells based on conditions
Limit the type of data entered into a cell
Automatically calculate data
In MS Excel, the Filter feature will not work correctly if:
Data has negative numbers
Table has no column headers
File is not saved
Data is not formatted
In MS Word, to create a footnote for a word, which option do you use?
What will happen if the Filter feature does not work correctly?
Negative numbers in data.
Table without column headers.
File not saved.
Data not formatted.
In MS Word, what action is taken to create a footnote for a word?
References tab → Captions group → Insert Caption command.
References tab → Footnotes group → Insert Endnote command.
References tab → Table of Contents group → Custom Table of Contents command.
References tab → Footnotes group → Insert Footnote command.
In MS Word, which button is used to insert a cover page for a document?
Page Number.
Cover Page.
Page Break.
Blank Page.
In MS Excel, which function is used to sort a table by multiple criteria?
Subtotal.
Advanced Filter.
Sort with 'Add Level' option.
AutoFilter.
In MS PowerPoint, which key/combination is used to start the presentation from the current slide?
F5.
Alt + F5.
Ctrl + F5.
Shift + F5.
In MS Excel, which command is used to freeze the first two fields in the data area when scrolling horizontally?
Freeze Panes.
Print Titles.
Freeze First Column.
Freeze Top Row.
In MS Excel, what is the effect of dragging a field into the Values area when creating a Pivot Table?
Filter data.
Display product names.
Calculate totals, counts, averages...
Merge data.
In MS PowerPoint, what format should an audio file inserted into a slide have?
.mp3 or .wav
.mp4 or .wmv
.pdf or .xps
.pptx or .ppsx
In MS Word, what is the purpose of the Comments command during group work?
Automatically check spelling errors of each member.
Add comments or suggestions without changing the main content.
Record all edits for others to view, accept, or reject.
Send private messages to each group member.
In MS PowerPoint, which command automatically rewinds the audio after it finishes playing?
Hide During Sound.
Play Across Slides.
Loop until Stopped.
Rewind after Playing.
In MS Excel, to set Data Validation for a data range that only allows entry of one of the values: TP, PP, NV, BV, which option is selected in the Data tab → Data Tools group → Data Validation command → Settings dialog → Validation Criteria → Allow?
Whole Number
Decimal
List
Text Length
In MS PowerPoint, what is the purpose of the Compress Media feature?
Reduce the size of audio and video files.
Reduce the size.
Trong MS PowerPoint, tính năng Compress Media dùng để làm gì?
Giảm dung lượng tập tin âm thanh và video.
Giảm dung lượng tập tin hình ảnh.
Nén nội dung văn bản.
Nén toàn bộ tập tin PowerPoint.
Trong MS Word, để cập nhật bảng mục lục, ta chọn lệnh Update Table trong nhóm nào của thẻ References?
Captions.
Table of Contents.
Index.
Table of Authorities.
Trong MS Excel, tùy chọn 'Sort left to right' trong Thẻ Data → nhóm Sort & Filter → lệnh Sort → hộp thoại Sort Options có ý nghĩa gì?
Sắp xếp danh sách theo cột
Sắp xếp danh sách theo dòng
Sắp xếp danh sách tăng dần
Sắp xếp danh sách giảm dần
Trong MS PowerPoint, muốn tạo liên kết đến một slide khác trong cùng bài, ta dùng lệnh gì trong thẻ Insert → nhóm Links?
Zoom → Slide Zoom.
Link → Insert Link... → Place in This Document → Next Slide.
Link → Insert Link... → Place in This Document → Last Slide.
Action → Hyperlink to: → Slide...
Trong MS Excel, tùy chọn nào không có trong hộp thoại Filter?
Sort A to Z.
Add Level.
Search box.
Filter by Color.
Trong MS Word, lệnh Track Changes được sử dụng để làm gì trong quá trình làm việc nhóm?
Tự động kiểm tra lỗi chính tả của từng thành viên.
Ghi lại mọi chỉnh sửa để người khác xem, chấp nhận hoặc từ chối.
Thêm nhận xét hoặc góp ý mà không làm thay đổi nội dung chính.
Gửi tin nhắn riêng cho từng thành viên trong nhóm.
Trong MS Excel, công cụ nào cho phép ta định dạng nổi bật giá trị lớn nhất trong một cột?
Thẻ Conditional Formatting → lệnh Color Scales.
Thẻ Conditional Formatting → lệnh Top/Bottom Rules.
Thẻ Conditional Formatting → lệnh Data Bars.
Thẻ Conditional Formatting → lệnh Highlight Cells Rules.
Trong MS Word, để căn giữa một đoạn văn bản, ta chọn nút lệnh nào trong nhóm Paragraph?
Justify.
Centered.
Justified.
Center.
Trong MS Word, để đặt mật khẩu mở tài liệu, ta thực hiện thao tác nào?
Review → Restrict Editing → Add Password.
File → Info → Protect Document → Encrypt with Password.
File → Options → Save As Password.
Insert → Security → Lock File.
