Deck 15: Introduction to Microsoft Excel 2010

Question 1

In Excel,which of the following tabs can be used for filtering and sorting the data in your spreadsheet?

A)Data
B)Review
C)Insert
D)Home

Answer 1

A

Question 2

In Excel,every formula must begin with a(n)________ sign.

A)plus
B)minus
C)percent
D)equal

Answer 2

D

Question 3

In Excel,the columns are identified by ________.

A)letters
B)numbers
C)Roman numerals
D)symbols

Answer 3

A

Question 4

An Excel workbook is a collection of one or more spreadsheets.

Question 5

If a user types the value 100 into cell G1,presses Enter,and then clicks cell G1,a rectangle will be drawn around the cell with a little black box in the lower right-hand corner.Which of the following occurs if the user drags that little black box down to cell G7?

A)Excel will fill in the value 100 multiplied by the number of cells in each of those cells.
B)All of those cells will remain blank.
C)Excel will fill in the value 100 into all of those cells.
D)Excel will divide the corresponding value sequentially in each of those cells.

Question 6

You have entered a formula in the cell G9.Which of the following would occur if you press the 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.

Question 7

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

Question 8

In Excel,the intersection of a row and a column is called a(n)________.

A)junction
B)gridline
C)cell
D)data point

Question 9

The ________ tab is used for configuring the appearance of Excel.

A)View
B)Review
C)Data
D)Home

Question 10

In Excel,________ refers to whether the worksheet is printed normally or sideways on the page.

A)layout
B)orientation
C)alignment
D)gridline

Question 11

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

Question 12

In Excel,the rows are identified by ________.

A)letters
B)numbers
C)Roman numerals
D)symbols

Question 13

Which of the following is true of rows and columns in Excel?

A)To add a column,click the name of the column after which you want to insert columns.
B)The cursor is moved to the left to increase the size of the column.
C)To insert new rows,click the number of the row below which you want new rows,and select as many rows as you want to insert.
D)The cursor is dragged up to decrease the height of the row.

Question 14

In Excel,if you click the center icons in the ________ section of the ribbon,the labels will appear centered both horizontally and vertically in the cell.

A)Number
B)Alignment
C)Styles
D)Editing

Question 15

When adding graphs,hyperlinks,or images to an Excel worksheet,you use the ________ tab.

A)Data
B)Format
C)View
D)Insert

Question 16

In Excel,the most frequently used tools and selections appear under the ________ tab.

A)Data
B)Home
C)View
D)Review

Question 17

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

Question 18

In Excel,the term ________ refers to a single spreadsheet.

A)datasheet
B)matrix
C)worksheet
D)gridline

Question 19

A ________ is a table of data having rows and columns.

A)spreadsheet
B)matrix
C)gridline
D)library

Question 20

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)configuring the appearance of Excel

Question 21

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

Question 22

What is a spreadsheet in Excel?

Question 23

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

Question 24

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.

Question 25

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

Question 26

In Excel,every formula must begin with an equal sign.

Question 27

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.

Question 28

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

Question 29

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

Question 30

An Excel worksheet cannot add data based on a pattern.

Question 31

Data can be imported to Excel from other programs.

Question 32

The View tab is used to configure the appearance of Excel.

Question 33

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

Question 34

In Excel,the Insert tab is used to add pictures,graphs,and hyperlinks.

Question 35

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

Question 36

The Home tab holds the most frequently used tools and selections.

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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