Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

"AZ" is an example of a ____.

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

The answer of A(n)____________________ is a named operation that replaces...

Question 6

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.

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

An adjacent range is a collection of separate ranges._________________________

Accepted Answer

A) True 
 B)False

Question 10

According to the order of operation in Excel:

Accepted Answer

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. 
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.

Question 11

The worksheet is organized into individual cells._________________________

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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.

Accepted Answer

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 
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

Question 14

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.

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

The answer of A(n)____________________ is a grouping of text and...

Question 17

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

Accepted Answer

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 
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

Question 18

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

Accepted Answer

The answer of ____________________ removes the data from the row...

Question 19

Which of the following takes precedence over multiplication?

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

"AZ" is an example of a ____.

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

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

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.

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

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

An adjacent range is a collection of separate ranges._________________________

According to the order of operation in Excel:

The worksheet is organized into individual cells._________________________

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

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.

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(n)____ is a group of cells in a rectangular block.

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

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

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

Which of the following takes precedence over multiplication?

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 7: Getting Started With Excel

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

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

"AZ" is an example of a ____.

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

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

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.

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

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

An adjacent range is a collection of separate ranges._________________________

According to the order of operation in Excel:

The worksheet is organized into individual cells._________________________

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

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.

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(n)____ is a group of cells in a rectangular block.

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

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

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

Which of the following takes precedence over multiplication?

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters