Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

A(n)____________________ conveys a visual representation of data.

Correct Answer

verifed

verified

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.


A) semi-colon (;)
B) colon (:)
C) period (.)
D) none of the above

Correct Answer

verifed

verified

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.


A) ALT+B
B) CTRL+B
C) SHIFT+B
D) TAB+B

Correct Answer

verifed

verified

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

Correct Answer

verifed

verified

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Correct Answer

verifed

verified

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

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

A single point is about 1 / 32 of one inch in height.

Correct Answer

verifed

verified

What effect does the Comma Style format have on the selected cells?


A) Converts decimals to commas within a cell
B) Converts decimals to commas within merged cells
C) Displays cell contents with two decimal places and commas as thousands separators
D) Allows for substitution of selected characters

Correct Answer

verifed

verified

The person or persons requesting the worksheet should supply their requirements in a ____ document.


A) blank
B) test issues
C) requirements
D) certified

Correct Answer

verifed

verified

Combining two or more selected cells into one cell is called ____ cells.


A) merging
B) mixing
C) combining
D) spanning

Correct Answer

verifed

verified

How many chart types does Excel offer?


A) 5
B) 15
C) 30
D) 50

Correct Answer

verifed

verified

____ is / are used to place worksheet,column,and row titles on a worksheet.


A) Color
B) Text
C) Links
D) Tabs

Correct Answer

verifed

verified

You should press the SPACEBAR to clear a cell.

Correct Answer

verifed

verified

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Correct Answer

verifed

verified

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

Correct Answer

verifed

verified

Which of the following keys moves the insertion point to the beginning of data in a cell?


A) HOME
B) ENTER
C) INSERT
D) TAB

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

Correct Answer

verifed

verified

The opposite of merging cells is splitting a merged cell._________________________

Correct Answer

verifed

verified

Showing 21 - 40 of 71

Related Exams

Show Answer