Question 1

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.

Accepted Answer

The answer of Which of the following is true of...

Question 2

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

Accepted Answer

The alignment section of the ribbon in Excel includes options for aligning text within cells, including horizontally (left, center, right) and vertically (top, center, bottom).

Question 3

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.

Accepted Answer

The formula =SUM(C3:C8) is asking Excel to add all the values in the range of cells C3 to C8, which are located in the third column. Therefore, option A is the correct answer.

Question 4

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

Accepted Answer

The user is dragging the formula from cells G1 and G2 to the four cells below them. The formula will be copied to each of the four cells, and the cell references will be updated accordingly. So, the four cells will display a3, a4, a5, and a6.

Question 5

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

Accepted Answer

The answer of Explain the process of inserting rows and...

Question 6

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

Accepted Answer

Excel recognizes "jan" and "feb" as the abbreviated forms of January and February, respectively, and when these cells are dragged down, it automatically fills in the subsequent months, thus "mar," "apr," and "may" will appear in the three new cells.

Question 7

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.

Accepted Answer

Dragging the little black box (fill handle) from cell G1 down to G7 copies the value in G1 (100) into all selected cells, resulting in all those cells displaying the value 100.

Question 8

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

Accepted Answer

The statement is false. Excel has features such as Fill Series, Flash Fill and AutoFill that can add data into a spreadsheet based on a pattern.

Question 9

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

Accepted Answer

The FORMULAS tab in Excel is indeed used for creating complex formulas, as it contains various functions and tools to help users create and manage their formulas.

Question 10

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

Accepted Answer

The answer of What are the different ways of entering...

Question 11

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

Accepted Answer

Formulas in Excel must start with an equal sign (=) to be recognized as formulas. If a formula does not start with an equal sign, Excel treats it as a text string rather than executing the formula.

Question 12

In Excel,every formula must begin with a(n)________ sign.
A)plus
B)minus
C)percentage
D)equal

Accepted Answer

Every formula in Excel must begin with an equal sign. This tells Excel that the cell contains a formula rather than just text. Without the equal sign, Excel will interpret the contents of the cell as text and will not perform any calculations.

Question 13

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

Accepted Answer

The $ English (U.S.) option does indeed display numbers with a dollar sign and two decimal places.

Question 14

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.

Accepted Answer

The F2 function key allows a user to edit the contents of a cell without retyping the entire entry, which is useful for long values.

Question 15

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.

Accepted Answer

This is the correct way to insert new rows in Excel.

Question 16

Data can be imported to Excel from other programs.

Accepted Answer

Excel allows importing data from various sources such as CSV files, text files, Microsoft Access databases, other Excel files, web pages, and more.

Question 17

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

Accepted Answer

For general work in Excel, tools under the HOME tab are most useful as they include basic functionalities like formatting, editing, and managing cells and sheets. The DATA tab is more specialized for tasks related to sorting, filtering, and data analysis.

Question 18

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.

Accepted Answer

Pressing the F2 function key in a selected cell allows the user to edit the formula without retyping it. This puts the cell into edit mode, where the cursor is placed at the end of the formula, allowing the user to make edits or corrections. Option B is incorrect, as copying to the clipboard requires a different function key (Ctrl+C or Ctrl+X). Option C is also incorrect, as creating a graph based on the cells in the formula would require a different process altogether. Option D is also incorrect, as locking a formula in a cell requires a different process as well.

Question 19

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

Accepted Answer

Excel recognizes months entered in text form and can autofill the remaining months by identifying the pattern.

Question 20

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

Accepted Answer

This statement is true. By clicking the name of the row or column, the entire row or column will be highlighted or selected.

Quiz 16: Introduction to Microsoft Excel 2013

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

The ________ section of the ribbon in Excel enables selected text to be centered both horizontally and vertically in a cell.

In an Excel sheet,what is the meaning of the formula =SUM(C3:C8) ?

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

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

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

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?