Table of Contents

    MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet

    Rumman Ansari July 13, 2026 32 views Subject Details
    🔒 Please log in to unlock this course.

    Home & Online Tuition

    Learn from an experienced tutor with personalized guidance.

    Enquire on WhatsApp Call Now
    📞 +91 8641874911

    📧 rummanansari6@gmail.com
    Available Locations
    Hatiara Baguiati Noapara Chinar Park Others - Online

    Expert Home & Online Tuition

    Personalized one-to-one tuition that focuses on concept building, practical learning, problem-solving skills, and excellent academic performance. Suitable for school students looking for structured, interactive, and result-oriented learning.

    Subjects We Teach

    Computer Science Programming Java Python HTML CSS JavaScript PHP MySQL SQL

    Why Choose Our Tuition?

    ✅ One-to-One Attention
    ✅ Concept-Based Learning
    ✅ Practical Examples
    ✅ Weekly Tests
    ✅ Doubt Solving Sessions
    ✅ Printed & PDF Notes
    ✅ Practice Worksheets
    ✅ MCQ & Assignments
    ✅ Exam Preparation
    ✅ Flexible Class Timings

    1:1

    Personal Guidance

    100%

    Concept Clarity

    Weekly

    Assessments

    Online + Home

    Learning Modes

    MCQ Section

    MCQ 1
    What is a spreadsheet?
    Locked. Enroll to open this MCQ.
    MCQ 2
    Which is a spreadsheet program?
    Locked. Enroll to open this MCQ.
    MCQ 3
    Spreadsheet files are commonly saved with which extension?
    Locked. Enroll to open this MCQ.
    MCQ 4
    Which is a free online spreadsheet?
    Locked. Enroll to open this MCQ.
    MCQ 5
    A spreadsheet is best used for:
    Locked. Enroll to open this MCQ.
    MCQ 6
    The top strip with tabs like Home, Insert is called:
    Locked. Enroll to open this MCQ.
    MCQ 7
    The bar showing the address of the selected cell is:
    Locked. Enroll to open this MCQ.
    MCQ 8
    The bar where you can see or edit cell content is:
    Locked. Enroll to open this MCQ.
    MCQ 9
    A single Excel file is called a:
    Locked. Enroll to open this MCQ.
    MCQ 10
    Each tab at the bottom of Excel represents a:
    Locked. Enroll to open this MCQ.
    MCQ 11
    Copilot in Excel is:
    Locked. Enroll to open this MCQ.
    MCQ 12
    Copilot can help you:
    Locked. Enroll to open this MCQ.
    MCQ 13
    Copilot in Excel uses:
    Locked. Enroll to open this MCQ.
    MCQ 14
    Which of these can Copilot suggest?
    Locked. Enroll to open this MCQ.
    MCQ 15
    Copilot in Excel is developed by:
    Locked. Enroll to open this MCQ.
    MCQ 16
    In Excel, rows are labeled with:
    Locked. Enroll to open this MCQ.
    MCQ 17
    In Excel, columns are labeled with:
    Locked. Enroll to open this MCQ.
    MCQ 18
    The intersection of a row and column is called a:
    Locked. Enroll to open this MCQ.
    MCQ 19
    What is the cell address at column B, row 3?
    Locked. Enroll to open this MCQ.
    MCQ 20
    How many columns are there in modern Excel (2016 onwards)?
    Locked. Enroll to open this MCQ.
    MCQ 21
    To select an entire row, click on:
    Locked. Enroll to open this MCQ.
    MCQ 22
    To select an entire column, click on:
    Locked. Enroll to open this MCQ.
    MCQ 23
    To select the entire worksheet, click on:
    Locked. Enroll to open this MCQ.
    MCQ 24
    Which shortcut selects the entire worksheet?
    Locked. Enroll to open this MCQ.
    MCQ 25
    Which key is held to select non-adjacent cells?
    Locked. Enroll to open this MCQ.
    MCQ 26
    The cell address is also called:
    Locked. Enroll to open this MCQ.
    MCQ 27
    A cell reference like C5 refers to:
    Locked. Enroll to open this MCQ.
    MCQ 28
    How many types of cell references are there?
    Locked. Enroll to open this MCQ.
    MCQ 29
    A range of cells from A1 to A5 is written as:
    Locked. Enroll to open this MCQ.
    MCQ 30
    The reference A1:B3 refers to:
    Locked. Enroll to open this MCQ.
    MCQ 31
    A relative reference changes when the formula is:
    Locked. Enroll to open this MCQ.
    MCQ 32
    Which is a relative reference?
    Locked. Enroll to open this MCQ.
    MCQ 33
    If B2 has =A2 and you copy it to B3, it becomes:
    Locked. Enroll to open this MCQ.
    MCQ 34
    Relative reference is default in:
    Locked. Enroll to open this MCQ.
    MCQ 35
    Relative references are useful for:
    Locked. Enroll to open this MCQ.
    MCQ 36
    An absolute reference is written using:
    Locked. Enroll to open this MCQ.
    MCQ 37
    $A$1 is an example of:
    Locked. Enroll to open this MCQ.
    MCQ 38
    An absolute reference does NOT change when:
    Locked. Enroll to open this MCQ.
    MCQ 39
    Which key toggles reference types in Excel?
    Locked. Enroll to open this MCQ.
    MCQ 40
    Absolute references are useful when:
    Locked. Enroll to open this MCQ.
    MCQ 41
    A mixed reference has:
    Locked. Enroll to open this MCQ.
    MCQ 42
    $A1 is:
    Locked. Enroll to open this MCQ.
    MCQ 43
    A$1 is:
    Locked. Enroll to open this MCQ.
    MCQ 44
    Mixed references are useful when:
    Locked. Enroll to open this MCQ.
    MCQ 45
    Toggle F4 twice from A1 gives:
    Locked. Enroll to open this MCQ.
    MCQ 46
    Every formula in Excel starts with:
    Locked. Enroll to open this MCQ.
    MCQ 47
    The result of =10+5*2 is:
    Locked. Enroll to open this MCQ.
    MCQ 48
    Which symbol is used for multiplication in a formula?
    Locked. Enroll to open this MCQ.
    MCQ 49
    Formulas make Excel:
    Locked. Enroll to open this MCQ.
    MCQ 50
    Which is an arithmetic operator?
    Locked. Enroll to open this MCQ.
    MCQ 51
    The operator ^ is used for:
    Locked. Enroll to open this MCQ.
    MCQ 52
    Which operator gives the remainder?
    Locked. Enroll to open this MCQ.
    MCQ 53
    Which of these calculates =6/3?
    Locked. Enroll to open this MCQ.
    MCQ 54
    Which operator is used for subtraction?
    Locked. Enroll to open this MCQ.
    MCQ 55
    The SUM function is used to:
    Locked. Enroll to open this MCQ.
    MCQ 56
    The result of =SUM(1,2,3) is:
    Locked. Enroll to open this MCQ.
    MCQ 57
    SUM can accept:
    Locked. Enroll to open this MCQ.
    MCQ 58
    The AVERAGE function returns:
    Locked. Enroll to open this MCQ.
    MCQ 59
    Correct syntax of AVERAGE is:
    Locked. Enroll to open this MCQ.
    MCQ 60
    AVERAGE ignores:
    Locked. Enroll to open this MCQ.
    MCQ 61
    The MAX function returns:
    Locked. Enroll to open this MCQ.
    MCQ 62
    Correct syntax of MAX is:
    Locked. Enroll to open this MCQ.
    MCQ 63
    MAX works with:
    Locked. Enroll to open this MCQ.
    MCQ 64
    The MIN function returns:
    Locked. Enroll to open this MCQ.
    MCQ 65
    MIN considers empty cells as:
    Locked. Enroll to open this MCQ.
    MCQ 66
    The COUNT function counts:
    Locked. Enroll to open this MCQ.
    MCQ 67
    To count all non-empty cells, use:
    Locked. Enroll to open this MCQ.
    MCQ 68
    COUNT function ignores:
    Locked. Enroll to open this MCQ.
    MCQ 69
    To find total marks in a range, use:
    Locked. Enroll to open this MCQ.
    MCQ 70
    To find average marks, use:
    Locked. Enroll to open this MCQ.
    MCQ 71
    To find highest marks, use:
    Locked. Enroll to open this MCQ.
    MCQ 72
    To count number of students, use:
    Locked. Enroll to open this MCQ.
    MCQ 73
    To lock a discount rate cell for multiple items, use:
    Locked. Enroll to open this MCQ.
    MCQ 74
    Which of the following is a spreadsheet application?
    Locked. Enroll to open this MCQ.
    MCQ 75
    Which formula finds average of A1 to A10?
    Locked. Enroll to open this MCQ.
    MCQ 76
    Formula =A1*$B$1 uses:
    Locked. Enroll to open this MCQ.
    MCQ 77
    Which key toggles between reference types?
    Locked. Enroll to open this MCQ.
    MCQ 78
    Which extension is used for Excel 2016 files?
    Locked. Enroll to open this MCQ.
    MCQ 79
    In Excel, cells are arranged in:
    Locked. Enroll to open this MCQ.
    MCQ 80
    Which function counts numeric entries?
    Locked. Enroll to open this MCQ.
    MCQ 81
    Which function counts all non-empty cells?
    Locked. Enroll to open this MCQ.
    MCQ 82
    The order of operators in =2+3*2 gives:
    Locked. Enroll to open this MCQ.
    MCQ 83
    Reference $A1 means:
    Locked. Enroll to open this MCQ.
    MCQ 84
    What is a workbook in Excel?
    Locked. Enroll to open this MCQ.
    MCQ 85
    What is a formula?
    Locked. Enroll to open this MCQ.
    MCQ 86
    Name any statistical function.
    Locked. Enroll to open this MCQ.
    MCQ 87
    What is a cell reference?
    Locked. Enroll to open this MCQ.
    MCQ 88
    Purpose of MIN function?
    Locked. Enroll to open this MCQ.
    MCQ 89
    A spreadsheet consists of:
    Locked. Enroll to open this MCQ.
    MCQ 90
    Excel workbook default extension:
    Locked. Enroll to open this MCQ.
    MCQ 91
    Aggregate functions include:
    Locked. Enroll to open this MCQ.
    MCQ 92
    F4 in Excel is used for:
    Locked. Enroll to open this MCQ.
    MCQ 93
    Cell A5 refers to:
    Locked. Enroll to open this MCQ.