Question 1

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

Accepted Answer

A)  Cell references are not affected. 
B)  The user must insert new cell references. 
C)  The user is prompted to enter new cell references. 
D)  Cell references are automatically adjusted. 
A)  Cell references are not affected. 
B)  The user must insert new cell references. 
C)  The user is prompted to enter new cell references. 
D)  Cell references are automatically adjusted.

Question 2

All functions begin with the formula prefix ____.

Accepted Answer

A)  @ (at symbol) 
B)  = (equals sign) 
C)  # (number symbol) 
D)  + (plus sign) 
A)  @ (at symbol) 
B)  = (equals sign) 
C)  # (number symbol) 
D)  + (plus sign)

Question 3

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

Accepted Answer

A) True 
 B)False

Question 4

In the formula =D1+C1/F3, which calculation will be performed first?

Accepted Answer

A)  C1/F3 
B)  D1+C1 
C)  D1/F3 
D)  D1+F3 
A)  C1/F3 
B)  D1+C1 
C)  D1/F3 
D)  D1+F3

Question 5

In the formula =ROUND(D4:F4,0), what does the zero indicate?

Accepted Answer

A)  The number of decimal places in the rounded number. 
B)  The number of times the formula should be repeated. 
C)  A null value. 
D)  The value for cell F4. 
A)  The number of decimal places in the rounded number. 
B)  The number of times the formula should be repeated. 
C)  A null value. 
D)  The value for cell F4.

Question 6

In Excel, MAX and AVERAGE are examples of ____.

Accepted Answer

A)  functions 
B)  arguments 
C)  lists 
D)  buttons 
A)  functions 
B)  arguments 
C)  lists 
D)  buttons

Question 7

Functions can be entered for formulas using all of the following methods except ____.

Accepted Answer

A)  the Insert Function dialog box 
B)  the AutoSum button 
C)  typing the function 
D)  typing the function argument 
A)  the Insert Function dialog box 
B)  the AutoSum button 
C)  typing the function 
D)  typing the function argument

Question 8

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

Accepted Answer

A)  The user sees a "clipboard full" message. 
B)  The clipboard automatically deletes all items and starts over with the new item. 
C)  The clipboard prompts the user to delete items. 
D)  The clipboard automatically deletes the oldest item on the clipboard. 
A)  The user sees a "clipboard full" message. 
B)  The clipboard automatically deletes all items and starts over with the new item. 
C)  The clipboard prompts the user to delete items. 
D)  The clipboard automatically deletes the oldest item on the clipboard.

Question 9

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

Accepted Answer

The answer of When copying or moving formulas in an...

Question 10

Which tab and group will allow the insertion of rows and columns in a worksheet?

Accepted Answer

A)  Home tab, Styles group 
B)  Page Layout tab, Page Format group 
C)  Home tab, Cells group 
D)  Page Layout tab, Cells group 
A)  Home tab, Styles group 
B)  Page Layout tab, Page Format group 
C)  Home tab, Cells group 
D)  Page Layout tab, Cells group

Question 11

Which formula contains a mixed cell reference?

Accepted Answer

A)  =(A6+A7)*0.20 
B)  =($A$6+A7)*0.20 
C)  =($A$6+$A$7)*0.20 
D)  =($A6+$A$7)*0.20 
A)  =(A6+A7)*0.20 
B)  =($A$6+A7)*0.20 
C)  =($A$6+$A$7)*0.20 
D)  =($A6+$A$7)*0.20

Question 12

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Accepted Answer

A)  SUM function 
B)  redo 
C)  fill handle 
D)  copy/paste 
A)  SUM function 
B)  redo 
C)  fill handle 
D)  copy/paste

Question 13

Excel templates include which of these common documents?

Accepted Answer

A)  budgets 
B)  balance sheets 
C)  time cards 
D)  All of the above. 
A)  budgets 
B)  balance sheets 
C)  time cards 
D)  All of the above.

Question 14

Match between columns
                        Premises: The type of cell reference used to preserve the relationship to the formula location.

Accepted Answer

The Answer of template and COUNT and relative and AVERAGE is...

Question 15

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

Accepted Answer

The order of precedence in Excel is that

Question 16

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

Accepted Answer

A) True 
 B)False

Question 17

Which method of entering a function requires the user to know the name and initial characters of a function?

Accepted Answer

A)  manually typing the function 
B)  using the Insert Function button 
C)  using the Sum button 
D)  using the Sum list arrow 
A)  manually typing the function 
B)  using the Insert Function button 
C)  using the Sum button 
D)  using the Sum list arrow

Question 18

Excel Module 2 demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

Accepted Answer

After the Excel user selects a range of

Question 19

Match between columns
                        Premises: Mixed cell reference.

Accepted Answer

The Answer of $G6 and $G$6 and COUNT and AVERAGE is...

Question 20

To complete the days of the week sequence that begins with the days Monday, Tuesday; the Excel user would select the cells containing Monday and Tuesday and use the ____________________ to complete the sequence.

Accepted Answer

The answer of To complete the days of the week...

Exam 7: Excel 2: Working With Formulas and Functions

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

All functions begin with the formula prefix ____.

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

In the formula =D1+C1/F3, which calculation will be performed first?

In the formula =ROUND(D4:F4,0), what does the zero indicate?

In Excel, MAX and AVERAGE are examples of ____.

Functions can be entered for formulas using all of the following methods except ____.

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

Which tab and group will allow the insertion of rows and columns in a worksheet?

Which formula contains a mixed cell reference?

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Excel templates include which of these common documents?

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

Which method of entering a function requires the user to know the name and initial characters of a function?

Excel Module 2 demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

To complete the days of the week sequence that begins with the days Monday, Tuesday; the Excel user would select the cells containing Monday and Tuesday and use the ____________________ to complete the sequence.

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 3: Using Forms

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 1: Integrating Word and Excel

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters