Deck 16: Introduction to Microsoft Excel 2016

Question 1

Joe is working on a business presentation on his company's sales figures for the previous quarter. He needs to add a graph to his Excel worksheet showing the difference in sales figures of different quarters. Which of the following tabs will Joe use to add the graph?

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

Answer 1

D

Question 2

In an Excel spreadsheet, columns are identified by ________.

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

Answer 2

A

Question 3

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

Answer 3

D

Question 4

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

Question 5

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

Question 6

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

Question 7

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

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

Question 8

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

Question 9

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

Question 10

Excel creates multiple worksheets when a new workbook is created.

Question 11

In an Excel spreadsheet, rows are identified by ________.

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

Question 12

What is a spreadsheet?

Question 13

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

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

Question 14

Nancy, a teacher, creates a table using Excel to list the number of students in her class. She uses rows and columns to add subject names and the grades received by each student. Nancy's table is also called a ________.

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

Question 15

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 16

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

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

Question 17

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

Question 18

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 19

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

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

Question 20

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

Question 21

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

Question 22

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 23

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 24

Data can be imported to Excel from other programs.

Question 25

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 26

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

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

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 29

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 30

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

Question 31

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

Question 32

Rachel is working on a spreadsheet to calculate financial ratios. She tabulates the values and begins creating a formula to calculate the ratios. Which of the following signs should Rachel remember to use at the beginning of her formula?

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

Question 33

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

Question 34

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

Question 35

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 36

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

Question 37

Which of the following keys is used to edit the value in a cell without retyping the whole entry?

A) F2
B) F1
C) F5
D) F3

Question 38

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 39

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 40

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

Question 41

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

Question 42

Excel has a few ways to format the spreadsheet.

Question 43

If you want to use a formula in a different cell you have to input it again.

Question 44

John is working in Excel and notices that his rows are numbering past 2000. What would be the best action in this situation?

A) Break the sheet into different workbooks.
B) Delete the data even if it is necessary.
C) Begin using a database instead.
D) Just keep adding data, Excel is limitless.

Question 45

If you are learning Excel it is best to begin with the previous version.

Question 46

Which tab holds the most frequently used tools and selections?

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

Question 47

Which of the following is an incorrect formula in Excel?

A) =A3+B4+G9
B) =1*9*3-100
C) K9/L10
D) =SUM(C3:C8)

Question 48

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

Question 49

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

Question 50

Angelo's spreadsheet has more columns than rows therefore he wants a sideways or Landscape print of the sheet. His secretary, however, gets an upright print. Angelo asks his secretary to take another print because he was unhappy with the ________.

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

Question 51

Excel can only locate patterns within numbers.

Question 52

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

Question 53

Excel spreadsheets can only be printed with gridlines visible.

Question 54

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 55

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

Question 56

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 57

You can not add a row or column to excel if there is data in the cell.