A) * and ?
B) < and >
C) and /
D) All of these
CLUBBBED CASE CANAL PATWARI FIRST PHASE (MORNING) 29-10-2023
In Excel, cell referencing that doesn’t change when copied is:
A) Absolute
B) Comparative
C) Reference
D) Relative cell addressing
Which menu allows formatting behind text like “Confidential” in MS Word?
A) Insert clipart
B) Watermark
C) Embedded text formatting
D) Both (A) & (C)
In MS Excel, the function that returns one value if condition is true and another if false is:
A) If function
B) Ifx function
C) And function
D) Decimal function
In MS Excel, the function that returns one value if condition is true and another if false is:
A) If function
B) Decimal function
C) And function
D) None of these
To add A1 and A2 cells in MS Excel, which formula is used?
A) A1 + A2
B) Add(A1 + A2)
C) together(A1:A2)
D) None of these
In Microsoft Word, which option hides all elements except the reading document?
A) Print layout
B) Web layout view
C) Full Screen reading view
D) None of these
Which spreadsheet application comes with MS Office?
A) MS Access
B) MS Excel
C) MS Word
D) MS PowerPoint
Microsoft Excel functions arguments are always written in:
A) Cells
B) Rows
C) Columns
D) Parentheses
What key combination is used to undo the last action in MS Word?
A) Ctrl+A
B) Ctrl+Z
C) Ctrl+Y
D) Ctrl+ G