1897. Data can be arranged in a worksheet in a easy to understand manner using
A. Auto formatting
B. Applying styles
C. Changing fonts
D. all of above
✅ The correct answer is option D.
1900. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
✅ The correct answer is option B.
1903. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK1
✅ The correct answer is option C.
1905. You can select a single range of cells by
A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
✅ The correct answer is option D.
1908. A worksheet range is a
A. A command used for data modeling
B. A range of values such as from 23 to 234
C. A group of cells
D. A group of worksheets
✅ The correct answer is option C.
1911. Which of the following is a popular DOS based spreadsheet package?
A. Word
B. Smart cell
C. Excel
D. Lotus 1-2-3
✅ The correct answer is option D.
1914. Which menu option can be used to split windows into two
A. Format > window
B. View > window > split
C. Window > split
D. View > split
✅ The correct answer is option B.
1917. The autofill feature
A. Extends a sequential series of data
B. Automatically adds range of cell values
C. Applies a boarder around the selected cells
D. All of the above
✅ The correct answer is option D.
1920. You can use the drag and drop method to
A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. A and B both
✅ The correct answer is option D.
1922. How can you delete a record?
A. Delete the column from the worksheet
B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
C. Select Data > Delete Record from the menu
D. Click the Delete button on the Standard toolbar
✅ The correct answer is option B.