Chapter Extension 4 (MIS)

In an Excel spreadsheet, rows are identified by________. A. Letters B. Numbers C. Roman Numerals D. Symbols

B. Numbers

In Excel, the intersection of a row and a column is called a_________. A. Node B. Grid C. Cell D. Junction

C. Cell

If a user enters the value 100 into cell G1, presses Enter, and then clicks the cell G1, a rectangle will be drawn around the cell with a little black box down to cell G7? Which of the following occurs if the user drags that little black box down to sell G7? A. Excel will display the values that progressively increase by 100 in each of those cells B. All of those cells will remain blank C. Excel will display the value 100 in all of those cells D. All of those cells' values will be multiplied by 100

C. Excel will display the value 100 in all of those cells

In Excel, the Review tab is used for_____________. A. Creating more complex formulas B. Filtering and Sorting Data C. Tracking Changes and Making Comments D. Configuring the appearance of Excel

C. Tracking changes and making comments

In Excel, a single spreadsheet is known as a ________. A. Workbook B. Note C. Worksheet D. Page

C. Worksheet

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

D. Equal

What is a Spreadsheet?

A spreadsheet is a table of data having rows and columns. The rows are identified by numbers, and the columns are identified by letters. The term spreadsheet almost always refers to an electronic spreadsheet, and most frequently to a spreadsheet that is processed by Microsoft Excel. Electronic spreadsheets provide incredible labor savings over paper spreadsheets and were a major factor in the early adoption of personal computers. In Excel, the term worksheet refers to a spreadsheet. One or more worksheets are combined to form a workbook.

In an Excel sheet, 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 all the values starting from the third cell to eighth cell in the third row. C) Add the value of the third cell in the third column to the eighth cell in the third column. D) Add the value of the third cell in the third row to the eighth cell in the third row.

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

In Excel, which of the following tabs is used for filtering and sorting information in a spreadsheet? A. Data B. Review C. Insert D. Home

A. Data

To add graphs, hyperlinks, or images to an Excel worksheet, the __________ tab is used. A. Data B. Format C. View D. Insert

A. Data

In an Excel spreadsheet, columns are identified by_______. A. Letters B. Numbers C. Roman Numerals D. Symbols

A. Letters

A ____________ is a table of data having rows and columns. A. Spreadsheet B. Notepad C. Clip Art D. Pie Chart

A. Spreadsheet

A user enters a formula into cell G9. Which of the following would be possible if the user presses the F2 function key after selecting the cell G9? A. The formula in G9 can be edited without retyping the entire formula. B. The formula can be copied to the clipboard C. A graph can be created based on the cells that appear in the formula D. The formula in the cell can be locked

A. The formula in G9 can be edited without retyping the entire formula

Which of the following is true of the options for modifying rows and columns in Excel? A) To add a column, click the name of the column before which new columns are needed and select as many columns to the right as required. B) To increase the size of a column, drag the line between the two columns in the column headings to the left. C) To insert new rows, click the number of the row below which new rows are needed and select as many rows below as required. D) To decrease the height of a row, drag the line between the line numbers down.

A. To add a column, click the name of the column before which new columns are needed and select as many columns to the right as required.

The________________ tab is used for configuring the appearance of Excel. A. View B. Review C. Data D. Home

A. View

A user enters a1 and a2 into cells G1 and G2, respectively. If the user selects those two cells and drags the small black box to the four cells below them, then the four cells will display A. a3, a4, a5, and a6 B. b1, b2,c1, and c2 C. A1,A2,A1, and A2 D. a1, a2,a1, and a2

A. a3, a4, a5, and a6

What are the different ways of entering data into an Excel worksheet?

Answer: Data can be entered into an Excel worksheet in three ways: 1. Key in the required data - to key in the required data, click on the cell in which the data is to be added, type the data, and press Enter. 2. Let Excel add data based on a pattern - to add data based on a pattern, enter values based on the pattern in one or more cells, select the cell(s), and drag the mouse to the required number of cells. 3. Import data from another program - data can be entered into an Excel worksheet by importing data from another program such as Microsoft Access.

The ________ section of the ribbon in Excel enables selected text to be centered both horizontally and vertically in a cell. A) font B) alignment C) styles D) editing

B. Alignment

In Excel, the most frequently used tools and selections appear under the___________________ tab. A. Data B. Home C. View D. Review

B. Home

In Excel, ________ refers to whether a worksheet is printed normally or sideways on a page. A) layout B) orientation C) alignment D) setup

B. Orientation

In Excel, ________.A) only 26 columns are present B) an entire row cannot be deleted, but an entire column can be deleted C) only numbers are recognized as patterns used to fill data D) a formula that does not start with an equal sign is considered as a text value

D. A formula that does not start with an equal sign is considered as a text value

Which of the following is true of the printing option in Excel spreadsheets? A) Gridlines can only be viewed in the print preview and cannot be printed. B) Print Preview is present in the Review tab. C) Landscape orientation prints a worksheet upright. D) Print area can be used to specify the portion of the spreadsheet to be printed

D. Print area can be used to specify the portion of the spreadsheet to be printed

In Excel, the wide bar of tools and selections that appears just under the tabs is called the__________. A. Menu Tab B. Task Pane C. Gridline D. Ribbon

D. Ribbon

If a user enters "jan" and "feb" in cells E1 and E2, respectively, selects those two cells and drags the small black box to three more cells below them, then___________. A. The three cells will remain empty B. Excel will display an error message C. The three cells will display "jan" "feb" and "jan," respectively D. The three cells will display "mar," "apr" and "may," respectively

D. The three cells will display, "mar," "apr" and "may," respectively

The real power of Excel lies in its amazing computational capability. Explain.

Excel can be used to work with a number of built-in and user-created formulas. It has a system in place to highlight areas that need to be corrected and to assign color codes to the cells so that a user can easily see which cells are being used in a given formula. Excel also has the capability to copy formulas and adjust the terms of the formula so that each would refer to cells in the row to which it was copied. Finally, it has a number of preprogrammed activities that allow users to sum figures, average figures, and perform many other calculations by selecting a choice from the Formulas tab.

Explain the process of naming the rows, columns, and cells in Microsoft Excel.

Excel spreadsheets have rows and columns. The rows are identified by numbers, and the columns are identified by letters. Because there are only 26 letters in the alphabet the following scheme is used to label columns: The letters A through Z identify the first 26 columns; the letters AA through AZ identify the next 26; BA through BZ the next 26; and so forth. The intersection of a row and column is called a cell. Each cell is identified by the name of its row and column. For example, cell K5 is situated in the Column K and row number 5.

Each cell in an Excel spreadsheet is identified by the date entered in it True or False?

FALSE

Excel creates multiple worksheets when a new workbook is created True or False?

FALSE

If the months of a year are entered in the text form, then Excel does not recognize them as a pattern. True or False

FALSE

Excel lacks features that can add data into a spreadsheet based on a pattern. True or False

False

For general work in Excel spreadsheets, the tools and selection under the DATA tab are most useful. True or False

False

If a spreadsheet is printed sideways on a page, the orientation is said to be portrait. True or False?

False

In Excel, when the HOME tab is selected, the contents of the ribbon concern charts, filter, tables, and so forth. True or False?

False

The portion of the spreadsheet to be printed can be specified using margins. True or False?

False

To save a worksheet in Excel, the Save option in the Edit Menu is used. True or False?

False

An Excel workbook is a collection of one or more workbooks. True or False?

TRUE

Data can be imported to Excel from other programs. True or False?

TRUE

In Excel, an entire row or column can be selected by clicking the name of the row or column. True or False?

TRUE

In Excel, to insert new rows, click the number of the row above which new rows need to be added, and then select the number of rows to be added. True of False?

TRUE

Selecting the $ English (U.S.) option displays numbers with a dollar sign and two decimal places. True or False?

TRUE

The tools and selections in the PAGE LAYOUT ribbon determine how a document will be arranged as a printed document. True or False?

TRUE

Using the F2 function key is recommended when a user has a long value in a cell and wants to edit a letter or two without retyping the whole entry. True or False?

TRUE

Whenever users have a problem with a calculation in Excel, they can press F2 to highlight the cells involved in that calculation. True or False?

TRUE

While copying a formula, Excel can adjust the terms of the formula to refer to the cells, in the row to which it is copied. True or False?

TRUE

Explain the process of inserting rows and columns in Microsoft Excel.

To insert new rows in Microsoft Excel, click the number of the row above which new rows are to be inserted and select as many rows as required, left-click, and then select Insert. The new rows would be inserted above the selected row. To add columns in Microsoft Excel, click the name of the column before which new columns are to be inserted, select as many columns to the right as required, right-click, and then select Insert.

In Excel, a sequence of tabs that appear in a horizontal line, just below the Excel icon, controls the contents of the ribbon. True or False?

True

In Excel, the Page Layout tab is used to format a page, often for printing. True or False

True

In excel, the Formulas tab is used for creating complex formulas True or False

True