Question 1

The _____ of a command button is used internally to reference it.

Accepted Answer

A)  name 
B)  caption 
C)  font 
D)  ID 
A)  name 
B)  caption 
C)  font 
D)  ID

Question 2

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Accepted Answer

A) True 
 B)False

Question 3

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

Accepted Answer

A) True 
 B)False

Question 4

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

Accepted Answer

A) True 
 B)False

Question 5

When you share a protected workbook, only the data is protected, not the workbook structure.

Accepted Answer

A) True 
 B)False

Question 6

A student's scores in two subjects are inserted in cells B2 and C2.The passing score for each subject is 60.Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

Accepted Answer

A)  =IF(B2>=60, C2>=60) 
B)  =OR(B2>=60, C2>=60) 
C)  =AND(B2>=60, C2>=60) 
D)  =NOT(OR(B2>=60, C2>=60)) 
A)  =IF(B2>=60, C2>=60) 
B)  =OR(B2>=60, C2>=60) 
C)  =AND(B2>=60, C2>=60) 
D)  =NOT(OR(B2>=60, C2>=60))

Question 7

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

Accepted Answer

A) True 
 B)False

Question 8

The _____ function returns the value from a range of data at the intersection of a specified row and column.

Accepted Answer

A)  INDEX 
B)  MATCH 
C)  LOOKUP 
D)  ARRAY 
A)  INDEX 
B)  MATCH 
C)  LOOKUP 
D)  ARRAY

Question 9

Betty wants to display negative percentages in red text with parentheses.What type of number format should she apply?

Accepted Answer

A)  Custom 
B)  Modified Percent 
C)  General 
D)  Negative 
A)  Custom 
B)  Modified Percent 
C)  General 
D)  Negative

Question 10

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Accepted Answer

A)  Normal pointer 
B)  I-beam pointer 
C)  Move pointer 
D)  Copy pointer 
A)  Normal pointer 
B)  I-beam pointer 
C)  Move pointer 
D)  Copy pointer

Question 11

Jesse wants to set up a button shape so that when users click the button, a macro runs.Which of the following should he do?

Accepted Answer

A)  Change the Cell Link property of the button shape. 
B)  Assign a macro to the button shape. 
C)  Assign the same name to the button shape and the macro 
D)  Assign the same shortcut key to the button shape and the macro. 
A)  Change the Cell Link property of the button shape. 
B)  Assign a macro to the button shape. 
C)  Assign the same name to the button shape and the macro 
D)  Assign the same shortcut key to the button shape and the macro.

Question 12

To view a worksheet without headers, margins, and rulers, use Page Layout view.

Accepted Answer

A) True 
 B)False

Question 13

The subtotals in Chastity's PivotTable make the PivotTable too large and difficult to use.Which option can she select to make the PivotTable more compact?

Accepted Answer

A)  Summarize Values By 
B)  Do Not Show Subtotals 
C)  Change Subtotal Style 
D)  Collapse Subtotals 
A)  Summarize Values By 
B)  Do Not Show Subtotals 
C)  Change Subtotal Style 
D)  Collapse Subtotals

Question 14

What is the file extension of macro-enabled workbook?

Accepted Answer

A)  .xls 
B)  .xlx 
C)  .xlsx 
D)  .xlsm 
A)  .xls 
B)  .xlx 
C)  .xlsx 
D)  .xlsm

Question 15

Megan wants to refine the appearance of a column chart, including applying a lighter shade of blue.Which of the following tools can she use to do so? Select all the options that apply.

Accepted Answer

A)  Change Colors button 
B)  Chart Styles gallery 
C)  Select Chart Element button 
D)  Quick Layout button 
A)  Change Colors button 
B)  Chart Styles gallery 
C)  Select Chart Element button 
D)  Quick Layout button

Question 16

You can change the caption of a Check Box form control, but not its internal name.

Accepted Answer

A) True 
 B)False

Question 17

You can change the language used in the Thesaurus and Spelling features.

Accepted Answer

A) True 
 B)False

Question 18

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

Accepted Answer

A)  Running a macro 
B)  Editing Visual Basic code 
C)  Recording a macro 
D)  Inspecting the workbook 
A)  Running a macro 
B)  Editing Visual Basic code 
C)  Recording a macro 
D)  Inspecting the workbook

Question 19

A sequence of VBA statements is called a procedure.

Accepted Answer

A) True 
 B)False

Question 20

The WORKDAY function calculates the day of the week starting from a specified date.

Accepted Answer

A) True 
 B)False

The _____ of a command button is used internally to reference it.

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

When you share a protected workbook, only the data is protected, not the workbook structure.

A student's scores in two subjects are inserted in cells B2 and C2.The passing score for each subject is 60.Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

The _____ function returns the value from a range of data at the intersection of a specified row and column.

Betty wants to display negative percentages in red text with parentheses.What type of number format should she apply?

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Jesse wants to set up a button shape so that when users click the button, a macro runs.Which of the following should he do?

To view a worksheet without headers, margins, and rulers, use Page Layout view.

The subtotals in Chastity's PivotTable make the PivotTable too large and difficult to use.Which option can she select to make the PivotTable more compact?

What is the file extension of macro-enabled workbook?

Megan wants to refine the appearance of a column chart, including applying a lighter shade of blue.Which of the following tools can she use to do so? Select all the options that apply.

You can change the caption of a Check Box form control, but not its internal name.

You can change the language used in the Thesaurus and Spelling features.

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

A sequence of VBA statements is called a procedure.

The WORKDAY function calculates the day of the week starting from a specified date.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

The _____ of a command button is used internally to reference it.

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

When you share a protected workbook, only the data is protected, not the workbook structure.

A student's scores in two subjects are inserted in cells B2 and C2.The passing score for each subject is 60.Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

The _____ function returns the value from a range of data at the intersection of a specified row and column.

Betty wants to display negative percentages in red text with parentheses.What type of number format should she apply?

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Jesse wants to set up a button shape so that when users click the button, a macro runs.Which of the following should he do?

To view a worksheet without headers, margins, and rulers, use Page Layout view.

The subtotals in Chastity's PivotTable make the PivotTable too large and difficult to use.Which option can she select to make the PivotTable more compact?

What is the file extension of macro-enabled workbook?

Megan wants to refine the appearance of a column chart, including applying a lighter shade of blue.Which of the following tools can she use to do so? Select all the options that apply.

You can change the caption of a Check Box form control, but not its internal name.

You can change the language used in the Thesaurus and Spelling features.

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

A sequence of VBA statements is called a procedure.

The WORKDAY function calculates the day of the week starting from a specified date.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters