BCA FY OFFiCe AutOmAtiOn
imP QuestiOns.
1. What are the various text formatting options available in MS
Word?
Answer:
Text formatting options in MS Word allow users to
enhance the appearance of text in a document. Common
formatting options include:
➢ Font Style: Bold, Italic, Underline.
➢ Font Size and Type: Change the size and type of the text.
➢ Text Color: Change the color of the text.
➢ Alignment: Align text to the left, center, right, or justify it.
➢ Line Spacing: Adjust spacing between lines.
➢ Bullet and Numbering: Add lists with bullets or numbers.
➢ Borders and Shading: Add borders and background color to the
text.
1|Page
2. Explain the steps to create and format a table in MS
Word.
Answer:
Steps to create and format a table:
➢ Insert Table:
➢ Go to the Insert tab, click Table, and select the number
of rows and columns.
➢ Add Data: Click inside the table cells and enter the data.
➢ Format Table:
➢ Use the Table Design and Layout tabs to customize the
table.
➢ Change border style, cell colour, or table style.
➢ Adjust row height and column width as needed.
➢ Modify Text in Cells: Apply text formatting like bold,
alignment, or font size.
3. Define formulas and functions in MS Excel. Give
examples of commonly used functions.
Answer:
2|Page
➢ Formula: A formula is an expression used to calculate
values in Excel. It begins with an equals (=) sign. For
example, =A1 + B1.
➢ Function: A predefined formula to perform specific
calculations. Examples include:
➢ SUM: Adds values (=SUM(A1:A10)).
➢ AVERAGE: Calculates average (=AVERAGE(B1:B10)).
➢ IF: Applies a condition (=IF(A1>50, "Pass", "Fail")).
➢ VLOOKUP: Searches for a value in a table
(=VLOOKUP(1001, A1:C10, 2, FALSE)).
4. What is the difference between a worksheet
and a workbook in MS Excel?
Answer:
➢ Worksheet: A single sheet within an Excel file where
data is entered and analyzed.
➢ Workbook: An Excel file containing one or more
worksheets.
3|Page
5. Describe the steps to create a slideshow in MS
PowerPoint.
Answer:
Steps to create a slideshow:
➢ Open MS PowerPoint and create a new presentation.
➢ Use the Home tab to add new slides.
➢ Add content like text, images, and charts to each slide.
➢ Customize slides using the Design tab to select themes.
➢ Add transitions between slides using the Transitions tab.
➢ Use the Animations tab to animate text or objects.
➢ Click Slide Show → From Beginning to view the
slideshow.
6. Explain the use of conditional formatting in
MS Excel with examples.
Answer:
4|Page
➢ Conditional Formatting highlights cells based on specific
criteria. For example:
➢ Highlight cells with values greater than 50 in red.
➢ Steps:
➢ Select the cells to format.
➢ Go to the Home tab → Conditional Formatting → New
Rule.
➢ Set the rule, e.g., "Format cells greater than 50."
➢ Choose a format (like a red fill) and click OK.
7. What is the purpose of the "Header and
Footer" feature in MS Word?
Answer:
➢ Headers and footers are used to include content like
page numbers, titles, or dates that appear
consistently across all pages of a document.
➢ Header: Text appears at the top of every page.
➢ Footer: Text appears at the bottom of every page.
5|Page
Steps to Add:
➢ Go to the Insert tab.
➢ Click Header or Footer and choose a style.
➢ Enter the desired content and save.
6|Page
