Document
Document
i. Which view can be used for creating formatting and designing slides?
A. Task pane
B. Slide pane
C. Workspace
D. Work pane
iii. Identify the technique that can be used to allow only date value in cell?
A. Data validation
B. Data filtering
C. Data sorting
D. Data formatting
A. .obj
B. .ods
C. .odd
D. .xls
v. With the use of which shortcut key you can Redo any operation?
A. CTRL+R
B. CTRL+Y
C. CTRL+X
D. CTRL +Z
vi Which of the following is not valid type of data source in mail merge?
A. CSV files.
B. Text files.
C. MySQL.
D. Spreadsheet
vii. What option should be used to to change the word ‘Books’ to the word ‘Copies’ in a document..
A. Spell check.
B. Find and Replace.
C. Find.
D. Spelling and grammar check
A. Shift+I
B. Shift+ U
C. Ctrl+ I
D. Ctrl+ U
A. equal sign(=)
B. semicolon (;)
C. period (.)
D. common (,)
A. Double Click
B. Right Click
C. Middle Click
D. Left click
Q. 3 Cell A1 contains the number 10 and B1 contains 5 .What will be the contents of cell C1,
when the formula= A1+B1*2^3 is entered in cell C1?
Q. 4. Write the syntax and example of any three logical functions in spreadsheet.