informatic 2nd semester

You should use an electronic spreadsheet if you want to:

• a. Create a presentation for viewing at a kiosk.

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

• c. Track extremely complex data relationships.

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

What is the difference between a workbook and a worksheet?

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

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

  numbers.

• c. A worksheet is a document divided into columns and rows, whereas a workbook is a single

  Excel file containing one or more worksheets.

• d. 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:

• a. Press the Alt or F10 key.

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

• c. Press CTRL+ALT+DEL.

• d. Press the WINDOWS key.

Text, numeric and formula are examples of:

• a. Types of data.

• b. Types of cell formats.

• c. Types of worksheets.

• d. Types of cell addresses.

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?

• a. Save

• b. Save As

• c. Update

• d. Rename

You need to share your Excel workbook that you created in Office 365 with a colleague who uses Excel

2003. What should you do?

• a. 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.

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

  data.

• c. You don’t need to do anything – Excel 2003 can open any Excel workbook regardless of the

  version, with no difficulties.

• d. 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?

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

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

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

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

Which keyboard combination can you use to switch among open workbooks?

• a. CTRL+TAB

• b. SHIFT+TAB

• c. CTRL+N

• d. WINDOWS+S

Which key/combination activates Edit mode in Excel?

• a. F2

• b. ALT+E

• c. WINDOWS key

• d. CTRL+E

What is the difference between pressing DELETE to delete the contents of a cell and using the Delete Cells

command?

• a. Deleting the contents of a cell clears all formatting from the cell. If you use the Delete Cells

  command, the formatting is still applied to the cell.

• b. Deleting the contents of a cell places the deleted contents into the Clipboard. If you use the

  Delete Cells command, the cell contents are not copied to the Clipboard.

• c. Deleting the contents of a cell leaves the structure of the worksheet intact. If you use the Delete

  Cells command, you have the option of shifting the cells after the delete action is complete.

• d. Deleting the contents of a cell leaves any formatting still applied. If you use the Delete Cells

  command, the formatting is also cleared from the cell.