1. How to remove borders applied in Cells?
1.Select None on the Border tab of Format cells
2.Open the list on the Border tool in the Format Cell toolbar then choose the first tool (none)
3.Both of above
4.None of above
Answer: Option D
2. _____ is not a valid data type in MS Excel.
1.Number
2.Character
3.Label
4.Date/ Time
Answer: Option B Character
3. What is MS Excel?
1.Spreadsheet
2.Database Management
3.Presentation
4.Workbook
Answer: Option A Spreadsheet
4. What is the row limit of MS Excel 2019?
1.4,81,0576
2.1,048,576
3.1,57,648
4.1,63, 84
Answer: Option B 1,048,576
5. In Microsoft Excel spreadsheets, rows are designated as _______.
A. 1, 2, 3,...
B. A, B, C,...
C. A1, B1, C1, ....
D. I, II, III,...
Answer: Option A. 1, 2, 3, ....
6._____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise.
A) OR
B) AND
C) IF
D) ANDIF
Answer: Option B AND
7. The intersection of a column and a row in a worksheet is called____
1.Column
2.Address
3.Value
4.Cell
Answer: Option D Cel
8. The Greater Than sign (>) exemplifies a/an _____ operator.
1.Arithmetic
2.Conditional
3.Logical
4.Greater
Answer: Option C Logical
9. ____ is the correct syntax of IF() Function.
1.=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
2.=IF (logical_test, [value_if_true], [value_if_false])
3.=IF (logical_test, {[value_if_true]}, {[value_if_false]})
4.=IF (logical_test: [value_if_true], [value_if_false])
Answer: Option B =IF (logical_test, [value_if_true], [value_if_false])
10. ___is the function used to match multiple values and returns the first match in Windows/ MAC(if you have Office 2019, or if you have a Microsoft 365 subscription).
A)IF()
B)IFS()
C)IIF()
D)SWITCH()
Answer: Option D SWITCH()
Tags:
Computer