MS Excel Shortcuts Keys

 Computer General

1. Files created with Lotus 1-2-3 have an extension
  • WK1
  • DOC
  • 123
  • XLS

2. In Excel 3-D reference in a formula
  • Limits the formatting options
  • Only appears on summary worksheets
  • Cannot be modified
  • Spans worksheets

3. In Excel Documentation should include
  • Source of input data
  • Information on the purpose of the workbook
  • Destination and users of the output data
  • All of the above

4. In Excel how can you delete a record?
  • Delete the column from the worksheet
  • Select Data > Form from the menu to open the Data dialog box, find record and Click the Delete button
  • Select Data > Delete Record from the menu
  • Click the Delete button on the Standard toolbar

5. In Excel which of the following is not a worksheet design criterion
  • Auditability
  • Description
  • Efficiency
  • Clarity Correct Answer:

6. In Excel the auto fill feature
  • Automatically adds a range of cell values
  • Extends a sequential series of data
  • Applies a boarder around selected cells
  • None of above

7. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu
  • Tools
  • Data
  • Format
  • Edit

8. In Excel value used in a formula that does not change is called a
  • Function
  • Constant
  • Cell address
  • Range

9. In Excel the auto calculate feature
  • Can only add values in a range of cells
  • None of the above
  • Provides a quick way to view the results of an arithmetic operation on a range of cells
  • Automatically creates formulas and adds them to a worksheet

10. In Excel which elements of worksheet can be protected from accidental modification ?
  • Scenarios
  • Contents
  • Objects
  • All of above

11. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
  • Data will be entered in the adjacent cells
  • There is nt suitable abbreviation of the text
  • No data will be entered in the adjacent cells
  • There is not time to format the next

12. In Excel you can use the formula palette to
  • Format cells containing numbers
  • Entered assumptions data
  • Copy a range of cells
  • Create and edit formulas containing functions

13. In Excel you can use the drag and drop method to
  • (A) and (B)
  • Add cell contents
  • Copy cell contents
  • Move cell contents

14. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
  • Format
  • Insert
  • Tools
  • Edit

15. In Excel if you press …….., the cell accepts your typing as its contents.
  • TAB
  • Enter
  • Ctrl + Enter
  • Insert

16. What excel feature can you use if you want to work with one record at a time?
  • Auto Filter
  • Sub Totals
  • Auto Complete
  • Data Form

17. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells
  • F7
  • F11
  • F5
  • F3

18. In Excel to copy cell contents using drag and drop, press the
  • Esc key
  • None of above
  • End key
  • Shift key

19. Right clicking something in Excel
  • Selects the object
  • Nothing the right mouse button is there for left handed people
  • Opens a shortcut menu listing everything you can do to the object
  • Deletes the object

20. In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?
  • Gridline
  • Category axis
  • Data point
  • Data marker

 

 
(Visited 29 times, 1 visits today)

Comments

comments

Leave a Reply