Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

A(n)____________________ is a named operation that replaces the arithmetic expression in a formula.

Correct Answer

verifed

verified

An adjacent range is a collection of separate ranges._________________________

Correct Answer

verifed

verified

To go to column A of the current row,press ____.


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

Correct Answer

verifed

verified

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

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

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window._________________________

Correct Answer

verifed

verified

To change a column width,you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.


A) QuickFit
B) AutoFit
C) Full Column
D) Longest

Correct Answer

verifed

verified

Which of the following takes precedence over multiplication?


A) division
B) exponentiation
C) addition
D) subtraction

Correct Answer

verifed

verified

The worksheet is organized into individual cells._________________________

Correct Answer

verifed

verified

"AZ" is an example of a ____.


A) column heading
B) row heading
C) cell reference
D) Name box

Correct Answer

verifed

verified

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


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

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.

Correct Answer

verifed

verified

Every function follows a set of rules,or syntax,which specifies how the function should be written._________________________

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

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition. -Displays the name of the sheets in the workbook.


A) function
B) Name box
C) worksheet
D) range
E) order of operations
F) sheet tabs
G) Ctrl
H) Normal view
I) minimize button
J) template

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition. -Contains a grid of rows and columns into which you can enter text,numbers,dates,and formulas,and display charts.


A) function
B) Name box
C) worksheet
D) range
E) order of operations
F) sheet tabs
G) Ctrl
H) Normal view
I) minimize button
J) template

Correct Answer

verifed

verified

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

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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

Showing 21 - 40 of 75

Related Exams

Show Answer