spreadsheet Interview Questions and Answers
Ques:- To do the calculations for different worksheets in a particular sheet, we use
A. 2D formula
B. 3D formula
C. selection
D. function
Ques:- Which keys help us to move around the worksheet?
A. Tab & Home
B. Pageup & Tab
C. Tab, Home, Pageup and Pagedown
D. Home & Pagedown
Ques:- The icon used for presenting data in the worksheet in form of charts is
A. Insert OLE Object icon
B. Insert from Image Editor icon
C. Insert Format icon
D. Insert Chart icon
Ques:- Which option is used to print all sheets in the documents?
A. Page View
B. Print → Print range → All
C. Format
D. Print
Ques:- The option under the File menu used to print the worksheet is
A. Page View
B. Print Range
C. Print Preview
D. Print
Ques:- The command New → Spreadsheet is used to
A. Open New Worksheet
B. Close New Document
C. Open New Document
D. Close New Worksheet
Ques:- The option under the File menu used to quit the StarOffice is
A. save
B. exit
C. open
D. close
Ques:- In order to open attributes dialog box in StarOffice Calc select the option as
A. Format → Rows
B. Format → Cells
C. Format → Table
D. Format → Columns
Ques:- The height of the row can be changed using the command
A. Format → Width → Row
B. Format → Height → Row
C. Format → Row → Height
D. Format → Row → Width
Ques:- The icon used to insert objects from other applications into a worksheet is
A. Insert Formula icon
B. Insert Applet icon
C. Insert OLE Object
D. Insert Plug-in
Ques:- In a Spreadsheet the rows are numbered from _____ in StarCalc.
A. 1 to 16,000
B. 1 to 18,000
C. 1 to 32,000
D. 1 to 36,000
Ques:- Worksheet can be opened by clicking on
A. Format → Open
B. File → Close
C. File → Open
D. File → Edit
Ques:- A continuous group of cells in a worksheet is called as
A. address
B. function
C. range
D. grid
Ques:- _____ option is used to preview a worksheet before printing?
A. Page
B. Page preview
C. Colour
D. All
Ques:- In order to shift the content of a cell to the right and to create an empty cell, select the cell and a click is made on
A. Insert Columns icon
B. Insert Rows icon
C. Insert cells Down icon
D. Insert cells Right icon
Ques:- The key combination used to open print dialog box in StarOffice Impress is
A. Ctrl + P
B. Shift + P
C. Alt + P
D. Ctlr + Shift +P
Ques:- In StarOffice Calc, a Spreadsheet contains
A. multiple cells
B. multiple sheets
C. no sheets
D. a single sheet
Ques:- The formula to add the number in cell A3 with the number in cell A4 is
A. = avg (A3 : A4)
B. sum (A3 : A4)
C. = sum (A3 : A4)
D. sum (A3 + A4)
Ques:- The active cell in StarCalc is identified by the
A. insertion pointer
B. cell address
C. cell pointer
D. cursor