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