Deck 16: Introduction to Microsoft Excel 2013

Question 1

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 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) Excel will divide the corresponding value in another column by 100 and sequentially display those results in each of those cells.

Answer 1

C

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 term ________ refers to a single spreadsheet.

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

Answer 3

C

Question 4

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

Question 5

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

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

Question 6

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 7

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 8

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 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 you want new rows, and select as many rows as you want to insert.
D) To decrease the height of a row, drag the line between the line numbers up.

Question 9

In Excel,________.

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

Question 10

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 display a3, a4, a5, and a6
B) will display b1, b2, c1, and c2
C) will remain blank
D) will display a1, a2, a1, and a2

Question 11

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

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

Question 12

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

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

Question 13

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 remain empty
B) Excel displays an error message
C) the three cells display "jan, feb, jan" respectively
D) the three cells display "mar, apr, may" respectively

Question 14

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

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

Question 15

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 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

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

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

Question 21

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

Question 22

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

Question 23

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 24

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 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

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

Question 31

Data can be imported to Excel from other programs.

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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 38

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

Question 39

Which of the following is true about printing Excel spreadsheets?

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

Question 40

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

Question 41

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

Question 42

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

Question 43

What is a spreadsheet?

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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