Font size
WorksheetsMIDTERM EXAM 1-2
Total questions: 70
Worksheet time: 1hrs 10mins
What is the purpose of the 'GET & TRANSFORM DATA' function in Excel?
To proofread the document
To import or connect external data and modify it
To draw and write directly on the worksheet
To organize data in the workbook
What is the purpose of the 'SORT & FILTER' project in Excel?
To organize data efficiently and navigate the workbook with ease
To automate tasks
To predict data trends
To protect the document
What does the 'DATA TOOLS' project help with in Excel?
Drawing and writing on the worksheet
Organizing data
Predicting data trends and grouping data
Proofreading the document
What is the focus of the 'PROOFING' tab in Excel?
Proofreading tasks like spelling and grammar checks
Data analysis results
Accessibility considerations
Drawing and writing on the worksheet
What is the 'DEVELOPER' tab in Excel used for?
Accessing advanced features like Visual Basic and Macros
Proofreading tasks
Organizing data
Drawing and writing on the worksheet
What is the purpose of the 'SHARE' feature in Excel?
To share the document with others for collaboration
To automate tasks
To predict data trends
To protect the document
Which command in MS Excel is used to insert a table style to the current selection?
Format as Table
Recommended Charts
Insert
Cell Styles
What does the 'Link' button with drop-down in MS Excel allow you to do?
Insert a hyperlink
Insert an embedded object
Insert a textbox
Insert a note into the active cell
Which command in MS Excel is used to merge cells?
Merge Cells
Split Cells
Combine Cells
Join Cells
What does the 'Sort & Filter' button with drop-down in MS Excel allow you to do?
Apply conditional formatting
Sort and filter data
Insert charts
Change font color
What does the 'Data Validation' feature in MS Excel allow you to do?
Apply custom formatting to cells
Validate data entry based on specific criteria
Insert a new column
Apply conditional formatting
What does the 'Subtotal' feature in MS Excel allow you to do?
Calculate the average of selected cells
Apply conditional formatting
Insert a new row
Calculate subtotals for a range of data
What does the 'Data Bars' option in MS Excel provide?
Insert data bars in cells based on cell values
Change font color
Apply conditional formatting
Insert charts
When did .DOCX became the default file format?
2015
2010
2007
1995
What is the extension for any word file?
.XLS
.DOC
.PPT
He is an American computer programmer and author.
Mark Zuckerberg
Bill Gates
Steve Jobs
Richard Reeves Brodie
He built the first version of Microsoft Office.
Richard Reeves Brodie
Charles Simonyi
Bill Gates
Steve Jobs
Allows you to insert various elements into your document such as pictures, tables, charts, headers, footers, page numbers, and more.
References
Home
Page Layout
Insert
Deals with the layout and formatting of your document, including options for margins, orientation, size, columns, and themes.
References
Page Layout
Insert
Home
Provides tools for adding citations, footnotes, endnotes, and creating tables of contents, indexes, and bibliographies.
References
Page Layout
Insert
Home
Primarily used for creating and managing mail merge documents, envelopes, labels, and performing other mailing-related tasks.
Mailings
Review
View
References
Contains commonly used commands such as font formatting, paragraph styles, and clipboard functions like cut, copy, and paste.
References
Home
Page Layout
Insert
Backstage View can be found under which tab?
File
Home
Insert
Design
Layout
Under which tab can you find commands to print a document?
Backstage View
Home Tab
Review Tab
Page Layout Tab
It shows you how the document will look when printed and lets you use the Ribbon to create and update it.
Print Layout
Web Layout view
Outline view
Draft view
This bar appears at the bottom of the screen and displays information such as the current page, section, total number of pages, inches from the top of the page, current line number, and current column number.
Status bar
Ribbon
Page Views
Tabs
is a resizable toolbar with commands that you will most likely use regularly.
Tabs
Quick Access Toolbar
Ribbon
Title bar
What does the Pages option in the Insert tab allow you to do?
Insert a table
Insert a page break
Insert a blank page
Insert a cover page
What is the purpose of the Styles group in Microsoft Word?
Save the document
Insert hyperlinks
Add illustrations
Create a Table of Contents
What is the purpose of the Symbols option in the Insert tab?
Insert symbols and equations
Add hyperlinks
Add comments
Insert WordArt
What is the purpose of the Clipboard in Microsoft Word?
Temporarily store data like text and pictures
Change font style
Add comments
Insert symbols and equations
What does the Convert function do?
Convert shapes into colors
Convert pages into paragraphs
Convert text into drawings
Convert drawings into specific objects or characters
What is Document Formatting in Design related to?
Adjusting the margins of a document
Adjusting the appearance of a text document
Adding hyphenation to a document
Adding line numbering to a document
What does the Page Background feature include?
Line Numbers, Hyphenation, Left and Right Indents
Position, Wrap Text, Bring Forward/Send Backward
Before and After Paragraph Spacing, Special Indentation, Line Spacing
Watermark, Page Color, Page Borders
What does the Columns option in Page Setup enable?
Creation of multiple columns in a document
Adding line numbering to a document
Adjusting the margins of a document
Adding hyphenation to a document
What does the Breaks feature in Page Setup allow you to insert?
Adding hyphenation to a document
Adding line numbering to a document
Adjusting the margins of a document
Various types of breaks including page breaks
What does the Line Spacing option in Paragraph allow you to adjust?
Height of space between lines within a paragraph
Adjusting the margins of a document
Adding line numbering to a document
Adding hyphenation to a document
What does the Align option in Arrange help you do?
Adding line numbering to a document
Adding hyphenation to a document
Adjusting the margins of a document
Align objects relative to each other or to the page
What does the Rotate or Flip option in Arrange allow you to do?
Rotate or flip the selected object
Adding hyphenation to a document
Adjusting the margins of a document
Adding line numbering to a document
You can insert a special character or symbol into your document using the (a) feature in Microsoft Word.
To quickly select an entire paragraph in Microsoft Word, you can triple-click anywhere within the (a) .
The "Ctrl + Z" keyboard shortcut is used to (a) the most recent action in Microsoft Word.
Microsoft Word is a popular word (a) application developed by Microsoft Corporation.
Microsoft Word is a popular word (a) application developed by Microsoft Corporation.
THE DIRECTION IN WHICH YOUR DOCUMENT IS SHOWN OR PRINTED:
PAGE SIZE
MARGINS
ORIENTATION
What is the shortcut for cut?
Ctrl + C
Ctrl + P
Ctrl + X
Ctrl + M
Where can you find print layout?
Home tab
View tab
Design tab
References tab
Which screen do you see when you start Word?
Backstage
Word editing screen
Backstage View can be found under which tab?
File
Home
Insert
Design
Layout
What is the purpose of using macros in MS Excel?
To make the tasks more complicated
To automate routine tasks
To slow down the procedure
To limit the functionality of Excel
This is one of the options in the Macros command button dropdown menu. This opens the Macro dialog box where you can select a macro to run or edit.
Use Relative References
Record Macro
View Macros
Delete Macro
What does the VLOOKUP function do in MS Excel?
Sorts the data in ascending order
Counts the number of cells in a range
Searches for a value vertically
Searches for a value horizontally
One of the parameters of VlookUp that is value that the function uses to search on.
Range_lookup
lookup_value
Col_index_num
The table_array
What is the purpose of protecting a worksheet in MS Excel?
To restrict access to the workbook
To make it easier to format cells
To prevent accidental deletion of critical data
To allow anyone to modify the data
The following statements are the various ways Excel provide to protect a workbook, EXCEPT one. Which one is it?
Prevents users from changing the size or position of windows
Prevents the users from adding sheets, deleting sheets, hiding sheets, and unhiding sheets.
Requires a password to open the workbook.
Allows users to full access to the sheets.
What is the purpose of a data table in MS Excel?
To create a list of macros
To summarize data in a table format
To send emails from Excel
To protect the workbook
What does the Use Relative References option do in MS Excel?
Sorts the data in ascending order
Counts the number of cells in a range
Uses relative cell addresses when recording a macro
Uses absolute cell addresses when recording a macro
How can you edit a created macro in MS Excel?
By using the VBA programming editor
By using the macro recorder
By sending an email
By protecting the workbook
Microsoft Word is a popular word (a) application developed by Microsoft Corporation.
Which feature in Microsoft Word allows you to add page numbers to your document?
Page Layout
Header and Footer
Word Count
Spell Check
To change the appearance of text such as making it bold or italic, you can use the (a) toolbar.
What tool in Microsoft Word allows you to combine information from a data source with a template to create multiple personalized documents?
Spelling and Grammar Check
ClipArt
Mail Merge
Equation Editor
Which feature in Microsoft Word allows you to apply a consistent set of formatting styles to your document?
Thesaurus
AutoCorrect
SmartArt
Styles
By default, Word is set to print pages in (a) orientation.
Which of the following describes formatting done on the letter "O" in the paragraph shown?
Drop Caps
Drop Character
DropHat
Drop Text
