Chapter 5: Getting Started with Calc (OpenOffice Calc)
1. Which application is used to create spreadsheets in OpenOffice?
A) Writer B) Impress C) Calc D) Draw
Answer: C) Calc
2. A spreadsheet consists of multiple ________.
A) Slides B) Worksheets C) Pages D) Frames
Answer: B) Worksheets
3. By default, a new Calc spreadsheet contains how many worksheets?
A) 1 B) 2 C) 3 D) 5
Answer: C) 3
4. What is another name for a worksheet in Calc?
A) Record B) Sheet C) Cell D) Table
Answer: B) Sheet
5. Which menu sequence opens Calc in OpenOffice?
A) Applications → Office → [Link] Spreadsheet
B) Applications → Graphics → Calc C) Places → Office → Spreadsheet
D) System → Office → Calc
Answer: A) Applications → Office → [Link] Spreadsheet
6. The topmost bar of the Calc window is called the:
A) Formula Bar B) Status Bar C) Title Bar D) Tool Bar
Answer: C) Title Bar
7. Which bar contains commands such as File, Edit, View and Insert?
A) Formula Bar B) Menu Bar C) Status Bar D) Scroll Bar
Answer: B) Menu Bar
8. Toolbars contain:
A) Worksheets B) Charts C) Command buttons D) Databases
Answer: C) Command buttons
9. The row headers are displayed:
A) At the top B) On the left side C) At the bottom D) On the right side
Answer: B) On the left side
10. Column headers are identified by:
A) Numbers B) Symbols C) Letters D) Dates
Answer: C) Letters
11. The intersection of a row and a column is called a:
A) Record B) Field C) Cell D) Sheet
Answer: C) Cell
12. The currently selected cell is known as the:
A) Main Cell B) Active Cell C) Current Sheet D) Formula Cell
Answer: B) Active Cell
13. The Formula Bar is used to:
A) Save files B) Enter and edit data C) Print sheets D) Close documents
Answer: B) Enter and edit data
14. Which bar shows information about the selected cell address?
A) Formula Bar B) Name Box C) Status Bar D) Title Bar
Answer: B) Name Box
15. The main working area of Calc is called the:
A) Workspace B) Sheet Tab C) Menu Area D) Control Box
Answer: A) Workspace
16. Which bar displays information about the current status of the worksheet?
A) Menu Bar B) Formula Bar C) Status Bar D) Title Bar
Answer: C) Status Bar
17. The Zoom Tool is used to:
A) Insert pictures B) Change worksheet size on screen C) Delete data D) Create formulas
Answer: B) Change worksheet size on screen
18. Sheet tabs are used to:
A) Switch between worksheets B) Save documents C) Print worksheets D) Create charts
Answer: A) Switch between worksheets
19. Which menu is used to save a spreadsheet?
A) Edit B) Insert C) File D) Tools
Answer: C) File
20. The shortcut key for Save is:
A) Ctrl + N B) Ctrl + S C) Ctrl + P D) Ctrl + O
Answer: B) Ctrl + S
21. Which option creates a new spreadsheet document?
A) Save B) Export C) New D) Print
Answer: C) New
22. The Save dialog box asks for:
A) Filename and location B) Password only C) Printer settings D) Chart type
Answer: A) Filename and location
23. Which option is used to print a worksheet?
A) Save B) Export C) Print D) Close
Answer: C) Print
24. The dots (…) after a menu command indicate:
A) Immediate action B) A dialog box will appear C) The command is disabled D) A shortcut key exists
Answer: B) A dialog box will appear
25. Toolbars can be turned on or off from:
A) File Menu B) Edit Menu C) View Menu D) Insert Menu
Answer: C) View Menu
26. Rows in Calc are numbered:
A) 1, 2, 3, … B) A, B, C, … C) I, II, III, … D) a, b, c, …
Answer: A) 1, 2, 3, …
27. Columns in Calc are labeled:
A) Numbers only B) Letters only C) Symbols only D) Dates only
Answer: B) Letters only
28. Cell A1 refers to:
A) Row A Column 1 B) Column A Row 1 C) Worksheet A1 D) Formula A1
Answer: B) Column A Row 1
29. Which component displays the document name?
A) Status Bar B) Formula Bar C) Title Bar D) Scroll Bar
Answer: C) Title Bar
30. A spreadsheet is mainly used for:
A) Drawing images B) Calculations and data analysis C) Audio editing D) Video editing
Answer: B) Calculations and data analysis
31. Which toolbar contains frequently used commands?
A) Standard Toolbar B) Status Bar C) Sheet Bar D) Scroll Bar
Answer: A) Standard Toolbar
32. Which command opens an existing spreadsheet?
A) New B) Save C) Open D) Export
Answer: C) Open
33. Which command closes the current document?
A) Exit B) Close C) Save D) Print
Answer: B) Close
34. Which command exits the application completely?
A) Close B) Save As C) Exit D) Print Preview
Answer: C) Exit
35. The active cell is highlighted by:
A) A border B) A symbol C) A chart D) A tab
Answer: A) A border
36. Data entered in a cell can be seen in the:
A) Formula Bar B) Title Bar C) Status Bar D) Menu Bar
Answer: A) Formula Bar
37. Which of the following is not a part of Calc interface?
A) Worksheet B) Formula Bar C) Column Header D) Slide Pane
Answer: D) Slide Pane
38. The bottom area containing worksheet names is called:
A) Sheet Tab Bar B) Menu Bar C) Formula Bar D) Title Bar
Answer: A) Sheet Tab Bar
39. What is the default document type in Calc?
A) Presentation B) Spreadsheet C) Drawing D) Database
Answer: B) Spreadsheet
40. Which option allows saving a file with a different name?
A) Save B) Open C) Save As D) Export
Answer: C) Save As
41. Which menu contains the Print option?
A) File B) Edit C) View D) Insert
Answer: A) File
42. The workspace contains:
A) Menus only B) Cells arranged in rows and columns C) Toolbars only D) Charts only
Answer: B) Cells arranged in rows and columns
43. Which feature helps enlarge the worksheet view?
A) Zoom Tool B) Sheet Tab C) Menu Bar D) Name Box
Answer: A) Zoom Tool
44. A spreadsheet document may contain:
A) One worksheet only B) Multiple worksheets C) No worksheets D) Only charts
Answer: B) Multiple worksheets
45. Which component helps identify a cell location?
A) Name Box B) Status Bar C) Menu Bar D) Zoom Tool
Answer: A) Name Box
46. The Formula Bar is located:
A) Above the worksheet area B) Below the status bar C) Inside the title bar D) On the sheet tab
Answer: A) Above the worksheet area
47. Which option is used before printing to check page layout?
A) Save As B) Page Preview C) Open D) Exit
Answer: B) Page Preview
48. Calc is a type of:
A) Word Processor B) Spreadsheet Software C) Presentation Software D) Graphics Software
Answer: B) Spreadsheet Software
49. The status bar is generally located at the:
A) Top of the window B) Left side C) Bottom of the window D) Center of the window
Answer: C) Bottom of the window
50. Which OpenOffice component is discussed in Chapter 5?
A) Writer B) Impress C) Draw D) Calc
Answer: D) Calc