Deck 17: Introduction to Microsoft Excel

Question 1

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

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

Answer 1

D

Question 2

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

A) workbook
B) library
C) worksheet
D) gridline

Answer 2

C

Question 3

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

Answer 3

B

Question 4

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

Question 5

In Microsoft Excel,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

Question 6

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.

Question 7

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.

Question 8

In Excel,a ________ is a combination of one or more worksheets.

A) dashboard
B) workbook
C) batch
D) datasheet

Question 9

A ________ is a table of data which has rows and columns.

A) spreadsheet
B) cell
C) broadsheet
D) library

Question 10

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

Question 11

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

A) Data
B) Home
C) View
D) Add-ins

Question 12

In Microsoft Excel,the columns are identified by ________.

A) capital letters
B) numbers
C) Roman numerals
D) lowercase letters

Question 13

In Microsoft Excel,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

Question 14

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

A) plus
B) minus
C) dollar
D) equality

Question 15

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

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

Question 16

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.

Question 17

In Excel,the option to change the page orientation is located on the ________ tab.

A) Page Layout
B) View
C) Review
D) Add-ins

Question 18

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

Question 19

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

Question 20

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

Question 21

Explain spreadsheets.

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

Data can be imported to Microsoft Excel from other programs.

Question 27

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

Question 28

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

Question 29

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

Question 30

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 31

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

Question 32

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

Question 33

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

Question 34

An Excel worksheet cannot add data based on a pattern.

Question 35

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

Question 36

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.

Question 37

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

Question 38

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 39

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

Question 40

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