Deck 16: Introduction to Microsoft Excel 2013

Question 1

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

Answer 1

False

Question 2

To save a worksheet in Excel,the Save option in the Edit menu is used.

Answer 2

False

Question 3

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

A)gridline
B)cell
C)ribbon
D)node

Answer 3

B

Question 4

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

Question 5

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

Question 6

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

A)HOME
B)REVIEW
C)DATA
D)INSERT

Question 7

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

Question 8

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

A)HOME
B)DATA
C)VIEW
D)REVIEW

Question 9

In Excel,the wide bar of tools and selections that appears just under the tabs is called the ________.

A)task pane
B)ribbon
C)gridline
D)menu tab

Question 10

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

A)workbook
B)gridline
C)worksheet
D)balance sheet

Question 11

In Excel,the REVIEW tab is used to format a page for printing.

Question 12

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

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

Question 13

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

Question 14

To add graphs,hyperlinks,or images to an Excel worksheet,the ________ tab is used.

A)VIEW
B)FORMAT
C)INSERT
D)DATA

Question 15

In Excel,the REVIEW tab can be used for ________.

A)configuring the appearance of Excel
B)filtering and sorting data in the spreadsheet
C)tracking changes and making comments
D)creating more complex formulas

Question 16

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

A)VIEW
B)HOME
C)DATA
D)REVIEW

Question 17

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

Question 18

In an Excel spreadsheet,the columns are identified by ________.

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

Question 19

In an Excel spreadsheet,the rows are identified by ________.

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

Question 20

What is a spreadsheet?

Question 21

In Excel,if the user clicks the centre icons in the ________ section of the ribbon,the selected text will be centred both horizontally and vertically in the cell.

A)alignment
B)font
C)styles
D)editing

Question 22

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

Question 23

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

Question 24

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

Question 25

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 the entire formula.
B)The formula will be copied to the clipboard.
C)The formula in the cell will be locked.
D)A graph is created based on the cells that appear in the formula.

Question 26

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

Question 27

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

Question 28

If a user enters "jan" and "feb" in cells E1 and E2,selects those two cells and drags the small black box to three more cells below them,then ________.

A)the three cells display "mar,apr,may" respectively
B)the three cells remain empty
C)Excel displays an error message
D)the three cells display "jan,feb,jan" respectively

Question 29

In Excel,________.

A)only 26 columns are present
B)an entire row cannot be deleted
C)a formula that does not start with an equal sign is considered as plain text
D)only numbers are recognised as patterns and used to fill data

Question 30

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

Question 31

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

Question 32

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 divide the corresponding value in another column by 100 and sequentially display those results in each of those cells.
B)Excel will display the value 100 in all of those cells.
C)All of those cells will remain blank.
D)Excel will display values that progressively increase by 100 in each of those cells.

Question 33

Data can be imported to Excel from other programs.

Question 34

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

Question 35

A user types in a1 and a2 in the cells G1 and G2.If the user selects those two cells and drags the small black box to the four cells below them,then the four cells ________.

A)will remain blank
B)will display a1,a2,a1,and a2
C)will display b1,b2,c1,and c2
D)will display a3,a4,a5,and a6

Question 36

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

Question 37

If the months of a year have been entered in text form,Excel does not recognise it as a pattern.

Question 38

Excel lacks features that can add data based on a pattern.

Question 39

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

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

Question 40

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

A)To add a column,click on the name of the column after which you want to insert new columns.
B)To decrease the height of a row,drag the line between the line numbers up.
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)To increase the size of a column,drag the line between the two columns in the column headings to the left.

Question 41

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

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

Question 42

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

Question 43

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

Question 44

The portion of the spreadsheet to be printed can be specified using Margins.

Question 45

Which of the following is true about printing Excel spreadsheets?

A)An option allows only the highlighted cells to be printed.
B)Gridlines can only be viewed and not printed.
C)Landscape orientation prints a worksheet upright.
D)Print Preview is present in the Review tab.

Question 46

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

Question 47

If a spreadsheet is printed sideways on a page,the orientation is said to be Portrait.

Question 48

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.