Computer MS Excel Shortcuts

1. Excel uses the …. Function when creating a data table
  • Count
  • Sum
  • Table
  • Average

2. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu
  • Format
  • View
  • Tools
  • Edit

3. In Excel which of the following is not an option in the spelling dialog box
  • Ignore All
  • Change
  • Edit
  • Ignore

4. In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004
  • All of the above
  • Workday
  • Date
  • Networkdays

5. In Excel when you group worksheets
  • You can enter variable data on multiple worksheets at one time
  • You can print more than one worksheet at a time
  • None of these
  • You can enter common data, formats, and formulas on multiple worksheets at one time

6. In Excel the drag and drop method of copying or moving
  • None
  • Can be used between worksheets but not workbooks
  • Can be used between workbooks but not worksheets
  • Can be used between workbooks but not worksheets

7. In Excel you can use drag and drop to embed excel worksheet data in a word document
  • By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
  • By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
  • (A) and (C)
  • By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

8. In Excel you can use the format painter multiple times before you turn it off by
  • Pressing the Ctrl key and clicking the format painter button
  • Pressing Alt key and clicking the format painter button
  • Double clicking the format painter button
  • You can use the format painter button only one time when you click it

9. In Excel you can zoom a worksheet
  • With the zoom button on the Print Preview toolbar
  • All of the above
  • With the Zoom command on the view menu
  • With the mouse pointer in Print Preview

10. In Excel you can copy cell formats from one cell to another by using the
  • Formatting toolbar
  • Default font
  • Backspace key
  • Format painter

11. In Excel….. is a group of cells that form a rectangle on the screen.
  • Formula
  • Calculation
  • Range address
  • Range

12. In Excel default header for a worksheet is
  • The date and time
  • Your name
  • The sheet tab name
  • None

13. In Excel the chart wizard
  • Can only place a chart on new chart sheet
  • Can place a chart on a new chart sheet or on any sheet in the workbook
  • Can only place a chart on a new blank worksheet
  • Can only be used to create embedded charts

14. In Excel accounting style shows negative numbers in
  • Parentheses
  • Bold
  • Quotes
  • Brackets

15. In Excel this type of software is similar to an accountant’s worksheet
  • Graphics
  • Word processing
  • Database
  • Spreadsheets

16. In Excel following term describes explanatory text attached to a cell
  • Callout
  • Comment
  • Extension
  • Dialog

17. You cannot link Excel worksheet data to a Word document
  • With a hyperlink
  • With the right drag method
  • With the copy and paste special commands
  • With the copy and paste buttons on the standard toolbar

18. In Excel which of the following is not an option in the spelling dialog box
  • Edit
  • Ignore
  • Ignore all
  • Change

19. In Excel data marker on a chart are linked to data points in a worksheet, therefore,
  • You can automatically apply formatting to a data series
  • (A) and (B)
  • You can change the position of a data marker and automatically change the data point value in the worksheet
  • You can change a data print value and automatically are draw the chart


20. In Excel default header for a worksheet is
  • None
  • The sheet tab name
  • Your name
  • The date and time

 


(Visited 49 times, 1 visits today)

Comments

comments

Leave a Reply