BIS Chp 5 Extention

14) What is the meaning of the formula SUM (C3:C8)? A) Add all the values starting from the third cell to eighth cell in the third column. B) Add the all the values starting from the third cell to eighth cell in the third row. C) Add the values of third cell in the third column and eighth cell in the third column. D) Add the values of third cell in the third row and eighth cell in the third row.

A) Add all the values starting from the third cell to eighth cell in the third column.

8) In Microsoft Excel 2007, which of the following tabs can be used for filtering and sorting the information in your spreadsheet? A) Data B) Add-ins C) Formula D) Home

A) Data

16) In Excel, the option to change the page orientation is located on the ________ tab. A) Page Layout B) View C) Review D) Add-ins

A) Page Layout

12) You have entered a formula in the cell G9. Which of the following would occur if you press F2 function key after selecting the cell G9? A) The formula in G9 can be edited without retyping. B) The formula will be copied to the clipboard. C) A graph that explains the formula would appear. D) The formula in the cell will be locked.

A) The formula in G9 can be edited without retyping

4) In Microsoft Excel, the columns are identified by ________. A) capital letters B) numbers C) Roman numerals D) lowercase letters

A) capital letters

1) A ________ is a table of data which has rows and columns. A) spreadsheet B) cell C) broadsheet D) library

A) spreadsheet

6) In Microsoft Excel 2007, the wide bar of tools and selections that appears just under the tabs is termed the ________. A) menu tab B) task pane C) office button D) ribbon

D) ribbon

A new row can be inserted at the desired point in an Excel worksheet by selecting the row below which you want to add the new row and clicking insert

false

A portion of the spreadsheet to be printed can be specified using the Print Preview feature

false

After copying a formula to a different cell, the user has to edit the terms of the formula so that each refers to cells in the row to which it was copied

false

An Excel worksheet cannot add data based on a pattern

false

In Microsoft Excel 2007, the wide bar of tools and selections that appears just under the tabs is referred to as the Menu bar

false

In Microsoft Excel, you would use the Review tab to format your page for printing

false

Microsoft Help can be accessed by clicking the question mark located in the ribbon bar below the Review tab

false

The Review tab can be used for filtering and sorting data in a spreadsheet

false

The intersection of a row and a column on a spreadsheet is called a data point

false

The option to disable the grid view of an Excel worksheet appears in the View ribbon

false

The rows in Excel spreadsheet are identified by letters, and the columns are identified by numbers

false

To save a worksheet in Microsoft Excel, you use the Save option in the Edit menu

false

A Microsoft Excel workbook is a collection of one or more spreadsheets

true

Data can be imported to Microsoft Excel from other programs

true

In Excel, the entire row or column can be selected by clicking on the name of the row or column

true

Orientation refers to whether the worksheet is printed upright or sideways on the page

true

The Add-Ins tab contains the nonstandard features that have been added to Excel

true

The Home tab holds the most frequently used tools and selections

true

Using the F2 key is recommended when you have a long value in a cell and need to edit a letter or two without retyping the whole entry

true

7) When adding graphs, hyperlinks, or images to a Microsoft Excel worksheet, you use the ________ tab. A) Data B) Format C) View D) Insert

D) Insert

13) In Excel, every formula must begin with a(n) ________ sign. A) plus B) minus C) dollar D) equality

D) equality

9) In Microsoft Excel 2007, most frequently used tools and selections appear under the ________ tab. A) Data B) Home C) View D) Add-ins

B) Home

15) Which of the following is the correct method for accessing Microsoft Help? A) It can be accessed by clicking the question mark in the office button that appears at the upper left-corner of the Excel window. B) It can be accessed by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window. C) It can be accessed by clicking the question mark in the status bar that appears at the very bottom of the Excel window. D) It can be accessed by clicking the question mark present on the title bar of the Excel window.

B) It can be accessed by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window.

11) Which of the following can be used to move the focus to a different cell in the Excel worksheet? A) arrow keys B) office button C) shift key D) data tab

B) office button

3) In Excel, a ________ is a combination of one or more worksheets. A) dashboard B) workbook C) batch D) datasheet

B) workbook

5) In Microsoft Excel, the intersection of a row and column is called a(n) ________. A) junction B) content point C) cell D) data point

C) cell

10) In Excel, the Review tab can be used for ________. A) creating more complex formulas B) filtering and sorting data in the spreadsheet C) tracking changes and making comments D) formatting the page, often for printing

C) tracking changes and making comments

2) In Excel, the term "________" refers to a single spreadsheet. A) workbook B) library C) worksheet D) gridline

C) worksheet