Pre- Data Gathering

1. Excel is a ____ program developed by Microsoft.

• Word processing
• Data Management

• Video editing
• Spreadsheet

2. What is the extension of a Microsoft Excel file?

• .docx
• .xlsx
• .pptx
• .txt

3. Microsoft Excel is used for?

• formula

• Photo editing
• Spreadsheets and data analysis
• Information gathering

4. What is the collection of worksheets called?

• Workbook
• Spreadsheet
• Database
• File

5.The intersection of a column and a row in a worksheet is called ____.

• Cell
• Block
• Matrix
• Grid

6.What is the correct syntax of IF() function?

• 1. =IF (logical_test, {[value_if_true]}, {[value_if_false]})

• 1. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

• 1. =IF (logical_test: [value_if_true], [value_if_false])

• IF (logical_test, [value_if_true], [value_if_false])

7.In MS Excel, 'Merge and Center' is used to ____.

• Combine cells and align the content in the center
• Split cells and align the content to the left
• Combine cells and align the content to the right
• Split cells and align the content in the center

8. 8. select the correct parenthesis

• { }
• [ ]
• ( )
• < >

9.In Excel, Columns are labelled as ___

• Numbers
• Letters
• Symbols
• Words

10.Microsoft Excel was first time launched in ______ by the Microsoft Corporation

• 1985
• 1990
• 1987
• 1995