**1. Which of the following is a valid date format in Excel?**

A. dd/mmm/yyyy

B. mm/dd/yy

C. mmm dd, yyyy

D. All of the above

**2. What will the formula =A1&B1 do?**

A. Add the values in A1 and B1

B. Subtract the values in A1 and B1

C. Concatenate the values in A1 and B1

D. Multiply the values in A1 and B1

**3. In Google Sheets, where can you find the option to freeze rows and columns?**

A. Edit menu

B. View menu

C. Format menu

D. Tools menu

**4. Which function is used to join multiple text strings into one in Excel?**

A. =JOIN()

B. =CONCATENATE()

C. =MERGE()

D. =TEXTJOIN()

**5. Which operator is used to compare values in Excel?**

A. #

B. /

C. &

D. =

**6. Which of the following is an example of an absolute cell reference in Excel?**

A. A1

B. $A$1

C. A$1

D. $A1

**7. What is the purpose of the CONCAT function in Excel?**

A. To calculate the sum of numbers

B. To multiply two numbers

C. To concatenate two or more text strings

D. To compare two values

**8. What will the function =TEXT(A1, “mmm dd, yyyy”) do if A1 contains a date?**

A. Convert the date to text in “MMM DD, YYYY” format

B. Perform a mathematical calculation

C. Return the current date

D. Show the month and year only

**9. In Excel, what is the correct order of operations?**

A. Parentheses, Exponents, Multiplication/Division, Addition/Subtraction

B. Addition/Subtraction, Multiplication/Division, Parentheses, Exponents

C. Exponents, Parentheses, Addition/Subtraction, Multiplication/Division

D. Parentheses, Addition/Subtraction, Multiplication/Division, Exponents

**10. Which of the following data is considered static in Excel?**

A. Date generated by TODAY()

B. Hardcoded text entered by the user

C. SUM formula result

D. Output of VLOOKUP function

**11. What is the result of the formula =A1/B1 if B1 is 0?**

A. 0

B. #DIV/0!

C. #VALUE!

D. #NULL!

**12. Which of the following is an example of dynamic data in Excel?**

A. Manually typed numbers

B. Results of a formula that change based on inputs

C. Text values entered in cells

D. A static chart created from data

**13. What is the primary purpose of the Filter View in Excel?**

A. To create a summary of data

B. To view data in multiple sheets

C. To filter data without changing the original dataset

D. To convert text into numbers

**14. Which of the following is NOT a logical function in Excel?**

A. IF

B. AND

C. OR

D. SUM

**15. Which reference type changes when you copy a formula to another cell?**

A. Relative reference

B. Absolute reference

C. Mixed reference

D. Fixed reference

**16. What is the result of the formula =IF(A1>10, “High”, “Low”) if A1 is 8?**

A. High

B. Error

C. Low

D. TRUE

**17. Which function is used to perform multiple conditions in Excel?**

A. =AND()

B. =OR()

C. =IF()

D. All of the above

**18. How do you format a cell to display a custom date format in Excel?**

A. Home > Format Cells > Custom > Enter date format

B. Data > Data Validation

C. Insert > Date

D. Home > Conditional Formatting

**19. In Excel, how can you quickly apply data formatting (e.g., currency, percentage) to a range of cells?**

A. Use Data Format Painter

B. Use Format Cells dialog

C. Use the Home tab’s Number group

D. Use Conditional Formatting

**20. What is the result of =TEXT(44560, “dd/mm/yyyy”) in Excel?**

A. 16/12/2022

B. 15/12/2022

C. 14/12/2022

D. 12/16/2022

**21. Which of the following is not a valid data type in Excel?**

A. Text

B. Number

C. Currency

D. Script

**22. Which feature allows you to drag down a formula to apply it to multiple cells?**

A. Formula Replicator

B. AutoFill

C. Quick Fill

D. Cell Drag

**23. Which function is used to get the current date in Google Sheets?**

A. TODAY()

B. NOW()

C. DATE()

D. CURRENT()

**24. What is the result of =IF(A1<>10, “Not equal”, “Equal”) if A1 = 8?**

A. Not equal

B. Equal

C. Error

D. True

**25. How can you apply the text format to a cell in Excel?**

A. Format > Cells > Date

B. Format > Cells > Number > Text

C. Data > Data Validation

D. Insert > Text

**26. In Excel, what does the formula =IF(OR(A1=5, A2=10), “Yes”, “No”) return if A1 = 3 and A2 = 10?**

A. Yes

B. No

C. Error

D. Maybe

**27. Which keyboard shortcut can be used to open the Filter feature in Excel?**

A. Ctrl + Shift + L

B. Ctrl + L

C. Ctrl + F

D. Alt + L

**28. What is the shortcut for opening the function menu in Google Sheets?**

A. Ctrl + Shift + F

B. Alt + Shift + F

C. Alt + =

D. Ctrl + F

**29. What does the IF function return if the logical test is TRUE?**

A. The first value in the formula

B. The second value in the formula

C. The sum of both values

D. An error

**30. How do you access conditional formatting in Google Sheets?**

A. Insert > Conditional Format

B. Format > Conditional Formatting

C. View > Conditional Formatting

D. Data > Conditional Formatting

## Leave a Reply