Deck 16: Introduction to Microsoft Excel 2013

Question 1

In Excel,the PAGE LAYOUT tab is used to format a page,often for printing.

Answer 1

True

Question 2

Each cell in an Excel spreadsheet is identified by the data entered in it.

Answer 2

False

Question 3

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

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

Answer 3

A

Question 4

In an Excel spreadsheet,columns are identified by ________.

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

Question 5

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

Question 6

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

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

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

Question 11

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 12

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

Question 13

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

Question 14

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

A)spreadsheet
B)notepad
C)clip art
D)pie chart

Question 15

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

Question 16

Excel creates multiple worksheets when a new workbook is created.

Question 17

In an Excel spreadsheet,rows are identified by ________.

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

Question 18

In Excel,a single spreadsheet is known as a ________.

A)workbook
B)note
C)worksheet
D)page

Question 19

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

A)node
B)grid
C)cell
D)junction

Question 20

What is a spreadsheet?

Question 21

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.

Question 22

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

Question 23

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.

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

In Excel,the FORMULAS tab is used for creating complex formulas.

Question 30

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

Question 31

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

Question 32

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

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

Question 33

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

Question 34

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.

Question 35

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.

Question 36

Data can be imported to Excel from other programs.

Question 37

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

Question 38

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.

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

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

Question 45

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.

Question 46

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

Question 47

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.

Question 48

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