KEMBAR78
Excel Questions Answers | PDF | Microsoft Excel | Worksheet
Scribd
Upload
30 views3 pages

Excel Questions Answers

The document provides a comprehensive overview of Microsoft Excel functions, including examples of key functions like SUM, AVERAGE, and VLOOKUP. It discusses the efficiency of calculations, the use of AutoFill, and clarifies differences between worksheets and workbooks, formulas and functions, as well as relative and absolute references. Additionally, it covers data types, components of the Excel window, application areas, and practical steps for creating named ranges and freezing headings.

Uploaded by

Horen Nyaga
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
30 views3 pages

Excel Questions Answers

The document provides a comprehensive overview of Microsoft Excel functions, including examples of key functions like SUM, AVERAGE, and VLOOKUP. It discusses the efficiency of calculations, the use of AutoFill, and clarifies differences between worksheets and workbooks, formulas and functions, as well as relative and absolute references. Additionally, it covers data types, components of the Excel window, application areas, and practical steps for creating named ranges and freezing headings.

Uploaded by

Horen Nyaga
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Microsoft Excel Questions and Answers

QUESTION ONE

1. Five Excel Functions with Examples:


• SUM: =SUM(A1:A5) (Adds values in A1 to A5)

• AVERAGE: =AVERAGE(B1:B5) (Finds average of values in B1 to B5)

• IF: =IF(A1>50, "Pass", "Fail") (Checks if A1 is greater than 50)

• VLOOKUP: =VLOOKUP(1001, A2:B10, 2, FALSE) (Finds a value in a table)

• COUNT: =COUNT(A1:A10) (Counts numeric values in A1 to A10)

2. Efficiency of Calculations in Excel:


• Automates complex calculations

• Reduces human error

• Uses functions for quick results

• Allows formula copying using AutoFill

• Supports real-time updates with linked data

3. AutoFill and Its Use:


• AutoFill automatically extends sequences, formulas, and patterns.

• Example: Dragging a number downward (1, 2, 3…).

4. Differences:
• Worksheet vs. Workbook: A worksheet is a single spreadsheet; a workbook is a file
containing multiple worksheets.

• Formula vs. Function: A formula is a user-created equation (=A1+B1); a function is a built-


in operation (=SUM(A1:A5)).

• Relative vs. Absolute Reference: Relative (A1) changes when copied; absolute ($A$1)
remains fixed.

5. Steps to Add and Rename a Worksheet:


• Click + at the bottom to add.

• Right-click the sheet tab, select Rename, type a new name, and press Enter.

6. Save vs. Save As:


• Save: Updates the current file.

• Save As: Creates a new copy with a different name/location.

QUESTION TWO

1. Formulas:
• Total Marks: =SUM(B2:G2) (Placed in H2 and dragged down)

• Average Marks: =AVERAGE(B2:G2) (Placed in I2 and dragged down)

• Highest Total Mark: =MAX(H2:H7) (Placed in H8)

• Lowest Total Mark: =MIN(H2:H7) (Placed in H9)

• Pass/Fail Formula: =IF(I2>=60, "Pass", "Fail") (Placed in J2 and dragged down)

2. Data Types in Excel:


• Text: Letters, symbols, and numbers (John, A123).

• Numbers: Numeric values (123, 45.6).

• Date/Time: 12/03/2025, 15:30:00.

• Boolean: TRUE or FALSE.

• Error Values: #DIV/0!, #VALUE!.

QUESTION THREE

1. Components of Excel Window:


• Title Bar: Displays file name.

• Ribbon: Contains tabs and tools.

• Formula Bar: Shows cell contents/formulas.

• Name Box: Displays selected cell reference.

• Worksheet Are oka: Where data is entered.

• Status Bar: Displays current mode and info.

2. Application Areas of Spreadsheets:


• Finance: Budgeting, expense tracking.

• Education: Grading, student records.

• Business: Inventory, payroll management.


3. Steps to Create a Named Range:
• Select the cell range.

• Click the Name Box, type a name.

• Press Enter.

4. Purpose of Freezing Headings:


• Keeps column/row headers visible while scrolling.

5. Three Character Formatting Tools in Word:


• Bold (B): Makes text thicker.

• Italic (I): Slants text for emphasis.

• Underline (U): Adds a line below text.

You might also like