Question 1

What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the sequence through the number 30 in A30 without having to type in the entire sequence?

Accepted Answer

Auto Fill is a feature in Excel that allows you to complete a sequence or pattern of data without typing in the entire sequence. By selecting cells with the initial values (in this case, 1 and 2 in A1 and A2), you can use the Auto Fill feature to populate the rest of the sequence up to 30.

Question 2

In the formula, =1+(2-3)+5 / 6-6^2, what will Excel evaluate second?

Accepted Answer

D

Question 3

In the formula, =1+(2-3)+5 / 6-6^2, what will Excel evaluate first?

Accepted Answer

Excel will evaluate the parentheses first, so (2-3) will be calculated and simplified to -1.

Question 4

What is the true about an input area?

Accepted Answer

An input area is used when certain values are used repeatedly throughout the worksheet, allowing for easy updates and consistency.

Question 5

What do you adjust if you see ###### displayed in a cell?

Accepted Answer

The ###### display in a cell typically indicates that the column is not wide enough to display the cell's content, so adjusting the column width will resolve the issue.

Question 6

A range is specified by its ________.

Accepted Answer

A range is specified by its top left and bottom right cells. A range is typically specified by its top left cell and bottom right cell, hence indicating the start and end of the range. Therefore, the best choice is D, which mentions the top left and bottom right cells.

Question 7

Which keyboard shortcut puts the user in cell edit mode?

Accepted Answer

Pressing F2 puts the user in cell edit mode, allowing them to edit the content of the current cell. Pressing F2 puts the user in cell edit mode, allowing them to directly edit the contents of the selected cell.

Question 8

What does pressing the Enter key while in a cell, do?

Accepted Answer

Pressing the Enter key in a cell sets the value and moves the active cell to the cell below it. Pressing the Enter key while in a cell sets the value of the cell and moves the active cell down to the next cell. Therefore, the correct choice is C.

Question 9

Which of the following is not true about a Fill color?

Accepted Answer

Fill color can be applied to an entire row or column, so option C is not true.

Question 10

How is text aligned by default?

Accepted Answer

Text is aligned to the left by default in most writing and word processing software. Text is aligned to the left by default in most writing and formatting software.

Question 11

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Accepted Answer

"Please Excuse My Dear Aunt Sally" is commonly used as a mnemonic device to remember the order of operations in math: Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right). "Please Excuse My Dear Aunt Sally" is a mnemonic device to help remember the order of operations in mathematics: Parentheses, Exponents, Multiplication and Division (left to right), Addition and Subtraction (left to right).

Question 12

Which of the following is not true of the Formula bar?

Accepted Answer

The Formula bar does not allow you to pick from an assortment of formulas; it is used to display and edit the contents of the active cell.

Question 13

What does it mean when you see ####### in a cell?

Accepted Answer

####### in a cell indicates that the content in the cell is too wide and it is not fitting within the column. Increasing the width of the column will display the text properly. ####### in a cell usually means that the column is not wide enough to display the data in the cell. Resizing the column will usually solve the issue.

Question 14

Which of the following is not a way to widen a column?

Accepted Answer

Clicking on the column label will sort the data in that column, but it will not widen the column. The other options will widen the column.

Question 15

Which of the following would not be considered text?

Accepted Answer

Text refers to human-readable information, while =2*2 is a formula that requires the software to perform a calculation. Option D is a formula and not a text.

Question 16

New workbooks typically contain how many worksheets?

Accepted Answer

New workbooks typically contain one worksheet by default. However, users can add more worksheets as needed. New workbooks typically contain one worksheet, but additional worksheets can be added as needed.

Question 17

One point is how big?

Accepted Answer

One point is equal to 1/72 of an inch. One point is typically equivalent to 1/72 of an inch in printing and typesetting.

Question 18

Which of the following is not a valid formula?

Accepted Answer

The formula in option D is not valid because it uses an incorrect syntax for date subtraction. In Excel, dates should be enclosed in double quotes and use the DATE function or be formatted as serial numbers for arithmetic operations.

Question 19

What should you do if there are columns you need, but do not want to display?

Accepted Answer

Hiding the columns you do not want to display is the best option because it allows you to temporarily remove them from the viewing area without permanently deleting or moving them. This makes it easy to work with the data you need without disrupting the original layout of the worksheet. You can unhide the columns when you need them again. Hiding the columns you do not want to display is the best option as it keeps the data in the worksheet but just hides it from view. This allows you to easily unhide the columns later if needed.

Question 20

What is the small green square in the bottom right of a cell called?

Accepted Answer

The small green square in the bottom right of a cell in spreadsheet programs like Microsoft Excel is called the Fill Handle. It is used to quickly copy the cell's contents to adjacent cells or to fill a series of cells.

Quiz 6: Excell: Introduction to Excel