ICF 9 LESSON 1 Introducing Excel

You should use an electronic spreadsheet if you want to:

• Create a presentation for viewing at a kiosk.

• Perform a large number of mathematical calculations and display charts and graphs.

• Track extremely complex data relationships.

• Create and print a full-color brochure for investment brokers.

What is the difference between a workbook and a worksheet?

• A worksheet is a document created in Access, while a workbook is created in Excel.

• A worksheet can contain numbers, text and formulas, whereas a workbook can contain only numbers.

• A worksheet is a document divided into columns and rows, whereas a workbook is a single Excel file containing one or more worksheets.

• A worksheet contains data for viewing onscreen only, whereas a workbook can be printed.

If you want to access the Ribbon using the keyboard, you should:

• Press the Alt or F10 key.

• Turn on Excel’s built-in accessibility features.

• Press CTRL+ALT+DEL.

• Press the WINDOWS key.

The Auto-hide Ribbon, Show Tabs, and Show Tabs and Commands options are available when you click which button?

• Formula bar

• Ribbon display options

• Quick access toolbar

• Dialog button

Text, numeric and formula are examples of:

• Types of data.

• Types of cell formats.

• Types of worksheets.

• Types of cell addresses.

Which of the following entries will NOT be recognized as a date by Excel?

• 9//1

• 9/15-1

• 9/15

• 9-15

Amanda has just updated her Budget 2019 workbook with new values for 2020. She wants to save her revised file as Budget 2020. Which command should she use?

• Save

• Save As

• Update

• Rename

You should create a new workbook using a template when:

• You want to enter information using your own layout.

• You want to use a design and layout previously created, either to enter data or to use as a base for your own reports.

• You want to create a workbook that is automatically password-protected.

• You want to start out with one blank worksheet.

You need to share your Excel workbook that you created in Office 365 with a colleague who uses Excel 2003. What should you do?

• Use the Check Compatibility tool to inspect the workbook for any compatibility issues with Excel 2003, then save your workbook in Excel 97-2003 format.

• Encourage your colleague to upgrade to the latest version of Excel so he can work with your data.

• You don’t need to do anything – Excel 2003 can open any Excel workbook regardless of the version, with no difficulties.

• Allow your colleague to use your computer when working on the file.

How do you select different areas of a worksheet at the same time?

• Use the ALT key as you click to select other cells.

• Use the WINDOWS key as you click to select other cells.

• Use the F1 key as you click to select other cells.

• Use the CTRL key as you click to select other cells.