COSC 17101. Midterm
docx
keyboard_arrow_up
School
Algoma University *
*We aren’t endorsed by this school
Course
1701
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by MateMask25089
Answer the following questions by explaining the steps to solve and provide examples to support and
show your work and answers:
Microsoft Word:
1.
How do you create a bulleted or numbered list in Microsoft Word, and what are some formatting
options you can apply to these lists?
2.
Explain the purpose and usage of styles in Microsoft Word. How can they help maintain
consistent formatting in a document?
3.
Describe the steps to insert a table in a Word document, and then explain how to modify the
table's structure and appearance.
4.
What is the "Track Changes" feature in Word, and how can it be used for collaborative editing
and reviewing documents?
5.
How do you create and format a header and footer in a Word document? What kind of
information is typically placed in these areas?
6.
How can you create a multi-level numbered list in Word, and what is the purpose of using multi-
level lists in documents?
7.
Explain the difference between "Find" and "Replace" in Word. How can these features be used
for text editing and formatting?
8.
Describe the steps to insert and format a table of contents in a Word document. How can you
update it when the document structure changes?
9.
What is the "Mail Merge" feature in Word, and how is it used to create personalized letters or
documents for a large recipient list?
10.
How can you password-protect a Word document and restrict editing, formatting, or content
changes for specific users or groups?
Microsoft Excel:
11.
Explain the difference between a cell, a row, and a column in Excel. How are they identified and
addressed in formulas and functions?
12.
What is the purpose of conditional formatting in Excel, and how can you use it to visually
highlight specific data points within a range of cells?
13.
Describe the steps to create a basic pie chart in Excel using a sample data set. What types of data
are suitable for pie charts?
14.
What is a pivot table in Excel, and how can it be used to summarize and analyze large sets of
data? Provide an example scenario where a pivot table is useful.
15.
How do you use the VLOOKUP function in Excel to search for and retrieve data from another
worksheet or table? Explain the syntax and provide an example.
16.
How do you create, and use named ranges in Excel, and what are the advantages of using named
ranges in formulas and functions?
17.
Explain the purpose and use of data validation in Excel. How can data validation rules help
maintain data integrity in a spreadsheet?
18.
Describe the steps to create a line chart in Excel using a set of data. What kind of data is suitable
for representation with a line chart?
19.
What is the difference between relative and absolute cell references in Excel formulas, and how
can you apply them to perform calculations?
20.
How do you use the CONCATENATE or CONCAT function in Excel to combine text from multiple
cells into a single cell? Provide an example.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help