1. ______________ in spreadsheets give us a picture/graphical of given data.
A) Calculations
B) Charts
C) Shape
D) Spreadsheets
Correct Answer: Charts
Explanation : Charts in spreadsheets give us a picture/graphical of Given Data.
2. The shortcut key for print preview in LibreOffice is
A) Ctrl+F2
B) Ctrl+Shift+N
C) Ctrl+Shift+O
D) None of these
Correct Answer: Ctrl+Shift+O
Explanation : The shortcut key for print preview in LibreOffice is Ctrl+Shift+O .
3. What is the output of Round(1745,-2) ?
A) 1700
B) 1600
C) 1800
D) 1740
Correct Answer: 1700
Explanation : Output of Round(1745,-2) is 1700.
4. What is the shortcut key to go to the last edited cell?
A) Ctrl + End
B) Ctrl + Down Arrow
C) Ctrl + Home
D) End
Correct Answer: Ctrl + End
Explanation : Shortcut key to go to the last edited cell is Ctrl + End.
5. Output of Calc expression =1000/10/2 is.
A) 50
B) 60
C) 100
D) 200
Correct Answer: 50
Explanation : Output of Calc expression =1000/10/2 is. - 50
6. A calc sheet has maximum AMJ number of columns.
A) True
B) False
Correct Answer: True
Explanation : A calc sheet has maximum AMJ number of columns. - True
7. In Calc, when you type a number, there is a default alignment inside the cell.
A) Left aligned
B) Right aligned
C) Center aligned
D) Justified
Correct Answer: Right aligned
Explanation : In Calc,, by default number is Right aligned inside the cell.
8. What is another name for tuple in database?
A) Row
B) Column
C) File
D) Table
Correct Answer: Row
Explanation : Row is another name of tuple in database.
9. What is the shortcut to insert function in libreoffice calc?
A) Alt + F2
B) Shift + F2
C) Ctrl + F12
D) Ctrl + F2
Correct Answer: Ctrl + F2
Explanation : The shortcut to insert function in libreoffice calc is Ctrl + F2.
10. ##### comes when the formula error occurs in Calc.
A) True
B) False
Correct Answer: False
11. The shortcut key for Cell Edit Mode is F2.
A) True
B) False
Correct Answer: True
Explanation : The shortcut key for Cell Edit Mode is F2. - True
12. There is maximum row in Calc.
A) 1048
B) 776
C) 1048576
D) 1024
Correct Answer: 1048576
Explanation : There is maximum row in Calc. - 1048576
13. There is a shortcut key to add cells to Calc.
A) Ctrl + Shift + +
B) Ctrl + Shift + -
C) Ctrl + +
D) Ctrl + -
Correct Answer: Ctrl + +
Explanation : The shortcut key Ctrl + + is used to add cells to Calc.
14. What is the shortcut key to insert current date?
A) Ctrl + ;
B) Ctrl + Shift +;
C) Ctrl + F5
D) None
Correct Answer: Ctrl + ;
Explanation : Shortcut key to insert current date is Ctrl + ; Is used.
15. To increase the width of the cell, Ctrl + → is used.
A) True
B) False
Correct Answer: False
Explanation : To increase the width of the cell, Alt + → is used. - True