Filters
Question type

Study Flashcards

A(n) ____ is a group of cells in a rectangular block.


A) cluster
B) adjunct
C) selection
D) range

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

Correct Answer

verifed

verified

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.


A) semi-colon
B) period
C) colon
D) comma

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

Correct Answer

verifed

verified

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row. 

A) True
B) False

Correct Answer

verifed

verified

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.


A) shrink
B) size
C) scale
D) scroll

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

Correct Answer

verifed

verified

An Excel formula always begins with a(n) ____.


A) parentheses
B) equals sign
C) plus sign
D) colon

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

Correct Answer

verifed

verified

To move the active cell up one row, press ____.


A) Shift + Enter
B) Ctrl + Tab
C) Shift + Tab
D) Ctrl + Enter

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

Correct Answer

verifed

verified

In the formula, =2+6*2, addition would be calculated after multiplication.

A) True
B) False

Correct Answer

verifed

verified

The name of the active workbook appears in the status bar of the Excel window. 

A) True
B) False

Correct Answer

verifed

verified

Numeric data is any number that can be used in a mathematical calculation. 

A) True
B) False

Correct Answer

verifed

verified

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created.

A) True
B) False

Correct Answer

verifed

verified

A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

Correct Answer

verifed

verified

According to the order of operation in Excel:


A) Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
B) Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction.
C) Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition.
D) Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.

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

Correct Answer

verifed

verified

The worksheet is organized into individual cells. 

A) True
B) False

Correct Answer

verifed

verified

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points .

A) True
B) False

Correct Answer

verifed

verified

Which of the following will not change the location of the active cell?


A) drag and drop
B) scrolling
C) clicking another cell
D) clicking a column heading

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

Correct Answer

verifed

verified

____________________ removes the data from the row or column as well as removes the row or column itself.

Correct Answer

verifed

verified

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.


A) KeyTips
B) ScreenTips
C) ShortTips
D) shortcuts

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

Correct Answer

verifed

verified

Whenever you click the Save button on the Quick Access Toolbar or press the ____  keys, the workbook file is updated to reflect the latest content.


A) Ctrl + V
B) Ctrl + G
C) Ctrl + C
D) Ctrl + S

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

Correct Answer

verifed

verified

To switch to ____ mode, you double-click the cell.


A) Insert
B) Copy
C) Edit
D) Paste

E) All of the above
F) None of the above

Correct Answer

verifed

verified

Ctrl + G is used to access the ____.


A) Go to Next worksheet command
B) G column
C) Go to a location in the worksheet command
D) formula view

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

Correct Answer

verifed

verified

Showing 41 - 60 of 66

Related Exams

Show Answer