Question 1

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she do?

Accepted Answer

A)  Mark as the workbook as final. 
B)  Encrypt the workbook with a password. 
C)  Protect the current sheet. 
D)  Protect the workbook structure. 
A)  Mark as the workbook as final. 
B)  Encrypt the workbook with a password. 
C)  Protect the current sheet. 
D)  Protect the workbook structure.

Question 2

Ina wants to protect a worksheet with a password, but still provide a data entry area where users can change data.Before protecting the worksheet, she should unlock the cells she wants to allow users to edit.

Accepted Answer

A) True 
 B)False

Question 3

A table formula can use a table reference to refer to column names instead of cell addresses.

Accepted Answer

A) True 
 B)False

Question 4

Lucinda's small business earned $15,000 in profit in August.She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month.Which of the following can she do to make the calculation?

Accepted Answer

A)  Use Flash Fill. 
B)  Fill a series with a growth trend. 
C)  Create a custom AutoFill list. 
D)  Use the Consolidate tool. 
A)  Use Flash Fill. 
B)  Fill a series with a growth trend. 
C)  Create a custom AutoFill list. 
D)  Use the Consolidate tool.

Question 5

When you lock a cell, it is hidden in the worksheet.

Accepted Answer

A) True 
 B)False

Question 6

When you unprotect a workbook, you allow anyone to insert, delete, and rename its worksheets.

Accepted Answer

A) True 
 B)False

Question 7

When you click the Show Comments button to display all comments, they appear in the Comments pane.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following keys should you press to have Excel calculate all open workbooks manually?

Accepted Answer

A)  F5 
B)  F9 
C)  F10 
D)  F12 
A)  F5 
B)  F9 
C)  F10 
D)  F12

Question 9

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Accepted Answer

A) True 
 B)False

Question 10

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders.He also wants a picture he inserted to fit the worksheet design.Which of the following should he do?

Accepted Answer

A)  Resize the picture. 
B)  Align the picture in the center of the worksheet. 
C)  Apply a reflection effect. 
D)  Add a blue border. 
A)  Resize the picture. 
B)  Align the picture in the center of the worksheet. 
C)  Apply a reflection effect. 
D)  Add a blue border.

Question 11

To select the chart title in a PivotChart, click the Chart Title check box in the PivotrChart Fields pane.

Accepted Answer

A) True 
 B)False

Question 12

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu.What is the result

Accepted Answer

A)  The Benefits worksheet is hidden 
B)  The workbook window is hidden 
C)  All the worksheets are password-protected 
D)  The Benefits worksheet is locked 
A)  The Benefits worksheet is hidden 
B)  The workbook window is hidden 
C)  All the worksheets are password-protected 
D)  The Benefits worksheet is locked

Question 13

The value in cell B2 cell is 65.In cell C2, the value is 75.Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Accepted Answer

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

Question 14

Which of the following lets you fill a cell with only specific elements of a copied cell?

Accepted Answer

A)  relative cell reference 
B)  Auto Fill Options button 
C)  argument 
D)  mode indicator 
E)  SHEET 
A)  relative cell reference 
B)  Auto Fill Options button 
C)  argument 
D)  mode indicator 
E)  SHEET

Question 15

You can use the I-beam pointer to move cell contents into adjacent cells.

Accepted Answer

A) True 
 B)False

Question 16

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following functions can you use to combine two or more strings into one text string? Select all the options that apply.

Accepted Answer

A)  SUBSTITUTE 
B)  CONCAT 
C)  TOGETHER 
D)  TEXTJOIN 
A)  SUBSTITUTE 
B)  CONCAT 
C)  TOGETHER 
D)  TEXTJOIN

Question 18

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

Accepted Answer

A)  AutoLoad 
B)  Enabled 
C)  Boxname 
D)  (Name) 
A)  AutoLoad 
B)  Enabled 
C)  Boxname 
D)  (Name)

Question 19

Ben moved a chart to a chart sheet, but now the axis labels are too small.What can he do to make them easier to read?

Accepted Answer

A)  Add a border. 
B)  Apply a shape effect. 
C)  Decrease the decimal places shown on each axis. 
D)  Increase the font size. 
A)  Add a border. 
B)  Apply a shape effect. 
C)  Decrease the decimal places shown on each axis. 
D)  Increase the font size.

Question 20

Alex recorded a macro but needs to change a detail.What can he do instead of recording the macro again?

Accepted Answer

A)  Step into the macro. 
B)  Display formulas instead of data in the macro worksheet. 
C)  Open the Visual Basic Editor to edit the macro code. 
D)  Turn on relative referencing. 
A)  Step into the macro. 
B)  Display formulas instead of data in the macro worksheet. 
C)  Open the Visual Basic Editor to edit the macro code. 
D)  Turn on relative referencing.

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she do?

Ina wants to protect a worksheet with a password, but still provide a data entry area where users can change data.Before protecting the worksheet, she should unlock the cells she wants to allow users to edit.

A table formula can use a table reference to refer to column names instead of cell addresses.

Lucinda's small business earned $15,000 in profit in August.She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month.Which of the following can she do to make the calculation?

When you lock a cell, it is hidden in the worksheet.

When you unprotect a workbook, you allow anyone to insert, delete, and rename its worksheets.

When you click the Show Comments button to display all comments, they appear in the Comments pane.

Which of the following keys should you press to have Excel calculate all open workbooks manually?

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders.He also wants a picture he inserted to fit the worksheet design.Which of the following should he do?

To select the chart title in a PivotChart, click the Chart Title check box in the PivotrChart Fields pane.

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu.What is the result

The value in cell B2 cell is 65.In cell C2, the value is 75.Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Which of the following lets you fill a cell with only specific elements of a copied cell?

You can use the I-beam pointer to move cell contents into adjacent cells.

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

Which of the following functions can you use to combine two or more strings into one text string? Select all the options that apply.

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

Ben moved a chart to a chart sheet, but now the axis labels are too small.What can he do to make them easier to read?

Alex recorded a macro but needs to change a detail.What can he do instead of recording the macro again?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she do?

Ina wants to protect a worksheet with a password, but still provide a data entry area where users can change data.Before protecting the worksheet, she should unlock the cells she wants to allow users to edit.

A table formula can use a table reference to refer to column names instead of cell addresses.

Lucinda's small business earned $15,000 in profit in August.She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month.Which of the following can she do to make the calculation?

When you lock a cell, it is hidden in the worksheet.

When you unprotect a workbook, you allow anyone to insert, delete, and rename its worksheets.

When you click the Show Comments button to display all comments, they appear in the Comments pane.

Which of the following keys should you press to have Excel calculate all open workbooks manually?

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders.He also wants a picture he inserted to fit the worksheet design.Which of the following should he do?

To select the chart title in a PivotChart, click the Chart Title check box in the PivotrChart Fields pane.

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu.What is the result

The value in cell B2 cell is 65.In cell C2, the value is 75.Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Which of the following lets you fill a cell with only specific elements of a copied cell?

You can use the I-beam pointer to move cell contents into adjacent cells.

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

Which of the following functions can you use to combine two or more strings into one text string? Select all the options that apply.

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

Ben moved a chart to a chart sheet, but now the axis labels are too small.What can he do to make them easier to read?

Alex recorded a macro but needs to change a detail.What can he do instead of recording the macro again?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters