NEW
Font size
Worksheetsinformatic 2nd semester
Total questions: 25
Worksheet time: 13mins
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.
Ruby wants all the entries in Column D in her worksheet to display fully. What is the best method for
ensuring Column D is wide enough?
a. Dragging the right border of Column D to the right edge of the Excel window
b. Using the AutoFit command
c. Using the Resize command
d. Entering a very large number in the Column Width dialog box
In which figure can you drag the AutoFill handle to create a series with 7 days between dates?
5-Apr
12-Apr
5-Apr
12-Apr
5-Apr
12-Apr
What is the maximum length of a worksheet tab name?
a. 8 characters
b. 31 characters
c. 250 characters
d. 255 characters
How many new worksheets can you add to an Excel workbook?
a. Three
b. One hundred
c. As many as the available memory of your system will permit
d. One thousand
When you insert a new worksheet using Insert, Insert Sheet on the Home tab, the new worksheet tab
appears:
a. To the left of the current worksheet tab.
b. To the far left of all worksheet tabs.
c. To the far right of all worksheet tabs.
d. To the right of the current worksheet tab.
Which of the following is the keyboard shortcut key combination for pasting data?
a. CTRL+A
b. CTRL+P
c. CTRL+V
d. CTRL+X
Which key should you press in order to copy cells using drag-and-drop?
a. CTRL
b. ALT
c. F4
d. You cannot copy cells using drag-and-drop.
How many worksheets can you hide in a workbook?
a. All of them
b. All except one
c. Up to ten
d. You cannot hide worksheets in a workbook.
Which sequence of steps will allow you to change the color of a worksheet tab?
a. Right-click the worksheet tab, then click Tab, Set color.
b. Click the Insert tab, then in the Text group click Tab Color.
c. Click the Page Layout tab, then in the Sheet Options group, click Tab Color.
d. Right-click the worksheet tab, then click Tab Color.
Which statement about inserting rows or columns into a worksheet is TRUE?
a. You can insert only one row or column at a time.
b. You can insert multiple rows or columns at the same time.
c. If you insert more than one row, the rows must be next to each other.
d. When you insert a row, it affects only the data visible on the screen.
What should you enter in a cell to find the difference between 9 and 5?
a. DIFF(9,5)
b. VAL(9-5)
c. =9-5
d. 9-5
Which of the following is the correct order of precedence for standard math operators?
a. Division, subtraction, multiplication, addition
b. Multiplication, division, addition, subtraction
c. Addition, subtraction, multiplication, division
d. Division, subtraction, addition, multiplication
Which of the following is not a valid formula for calculating a total value using the data in several
cells?
a. =SUM(C6:C18)
b. =SUM(C6:C18,D6:D18,F6:F18)
c. =SUM(C6:C18,C20)
d. None – all are valid formulas
Which of the following formulas says: if the value in cell B6 is greater than 500, then display a value equal
to B6*20; otherwise, display a zero?
a. =(B6>500,B6*20,0)
b. =SUM(B6>500,B6*20,0)
c. =MULT(B6>500,B6*20,0)
d. =IF(B6>500,B6*20,0)
Monty needs to count the number of empty cells in a 35,000-cell range. Which function should he use?
a. COUNTBLANK
b. COUNT
c. COUNTA
d. COUNTNULL
