Filters
Question type

Study Flashcards

____________________ cells involves creating a single cell by combining two or more selected cells.

Correct Answer

verifed

verified

To use the AutoCalculate area,select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

A) True
B) False

Correct Answer

verifed

verified

Excel's ____________________ function,which adds all of the numbers in a range of cells,provides a convenient means to calculate a total.

Correct Answer

verifed

verified

Pressing the ____ key to complete an entry activates the adjacent cell to the right.


A) RIGHT ARROW
B) LEFT ARROW
C) UP ARROW
D) DOWN ARROW

E) All of the above
F) C) and D)

Correct Answer

verifed

verified

To enter data in a cell,you must first select the ____.


A) row
B) worksheet
C) column
D) cell

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

In a worksheet,columns typically contain information that is similar to a list._________________________

A) True
B) False

Correct Answer

verifed

verified

What effect does the Accounting Number Format have on the selected cells?


A) Converts alphabetic characters to numbers
B) Displays cell contents with two decimal places that align vertically
C) Performs tax calculations
D) Copies the numbers of one cell to another

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.


A) AutoFormat
B) AutoComplete
C) AutoFunction
D) AutoCalculate

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

List and briefly describe six chart types from which you can choose in Excel.Mention how you select the appropriate type of chart.

Correct Answer

verifed

verified

Excel includes 10 chart types from which...

View Answer

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

Correct Answer

verifed

verified

Clicking the ____ box completes an entry.


A) Cancel
B) Formula
C) Enter
D) Tab

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects the cell at the beginning of the row that contains the active cell.


A) ALT+PAGE DOWN
B) ARROW
C) CTRL+HOME
D) HOME
E) CTRL+F
F) END
G) INSERT
H) SHIFT+RIGHT ARROW
I) BACKSPACE
J) SPACEBAR

K) C) and I)
L) A) and D)

Correct Answer

verifed

verified

Showing 101 - 112 of 112

Related Exams

Show Answer