Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

You can change a table to a worksheet range by click the Change to Range button.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

Accepted Answer

A)  SUM 
B)  COUNT 
C)  MIN 
D)  VAR 
A)  SUM 
B)  COUNT 
C)  MIN 
D)  VAR

Question 6

Jerome inserted a Check Box form control and set cell A10 as the cell link. When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

Accepted Answer

A) True 
 B)False

Question 7

An Excel table contains columns named Salary and Commission. Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

Accepted Answer

A)  '=[Salary]+[Commission] 
B)  =[Salary+Commission] 
C)  =(Salary)+(Commission) 
D)  ="Salary" + "Commission" 
A)  '=[Salary]+[Commission] 
B)  =[Salary+Commission] 
C)  =(Salary)+(Commission) 
D)  ="Salary" + "Commission"

Question 8

In SmartArt, you can enter text directly in the placeholders or you can use the _____.

Accepted Answer

A)  SmartArt Property dialog box 
B)  Text pane 
C)  Layout pane 
D)  Add Label dialog box 
A)  SmartArt Property dialog box 
B)  Text pane 
C)  Layout pane 
D)  Add Label dialog box

Question 9

Martha created a table where employees can enter customer data. She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?

Accepted Answer

A)  Header row 
B)  Table alert 
C)  Input message 
D)  Insert message 
A)  Header row 
B)  Table alert 
C)  Input message 
D)  Insert message

Question 10

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?

Accepted Answer

A)  '=COUNT(B1:B20) 
B)  =COUNTA(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20) 
A)  '=COUNT(B1:B20) 
B)  =COUNTA(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20)

Question 11

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Accepted Answer

A)  Delete the conditional formatting rule. 
B)  Edit the conditional formatting rule. 
C)  Format the range in the Font dialog box. 
D)  Format the range as a table. 
A)  Delete the conditional formatting rule. 
B)  Edit the conditional formatting rule. 
C)  Format the range in the Font dialog box. 
D)  Format the range as a table.

Question 12

Henry imported text data, which appeared in all lowercase. To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

Accepted Answer

A) True 
 B)False

Question 13

What can you do to share a workbook with other Office 365 users only?

Accepted Answer

A)  Post the workbook on your website. 
B)  Email the name of the workbook to other users. 
C)  Encrypt the workbook. 
D)  Upload the workbook to OneDrive. 
A)  Post the workbook on your website. 
B)  Email the name of the workbook to other users. 
C)  Encrypt the workbook. 
D)  Upload the workbook to OneDrive.

Question 14

When you group worksheet data, you can use the Hide Outline button to hide details in grouped columns or rows.

Accepted Answer

A) True 
 B)False

Question 15

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Accepted Answer

A) True 
 B)False

Question 16

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

Accepted Answer

A)  switch 
B)  relate 
C)  refresh 
D)  group 
A)  switch 
B)  relate 
C)  refresh 
D)  group

Question 17

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

Accepted Answer

A) True 
 B)False

Question 18

The _____ is displayed as the label for a Command Button (ActiveX Control).

Accepted Answer

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

Question 19

After you delete a worksheet column, _____.

Accepted Answer

A)  the columns to its right shift left 
B)  the columns to its left shift right 
C)  the row remains but its contents are deleted 
D)  only its formats are deleted 
A)  the columns to its right shift left 
B)  the columns to its left shift right 
C)  the row remains but its contents are deleted 
D)  only its formats are deleted

Question 20

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Accepted Answer

A) True 
 B)False

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

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

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

You can change a table to a worksheet range by click the Change to Range button.

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

Jerome inserted a Check Box form control and set cell A10 as the cell link. When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

An Excel table contains columns named Salary and Commission. Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

In SmartArt, you can enter text directly in the placeholders or you can use the _____.

Martha created a table where employees can enter customer data. She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Henry imported text data, which appeared in all lowercase. To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

What can you do to share a workbook with other Office 365 users only?

When you group worksheet data, you can use the Hide Outline button to hide details in grouped columns or rows.

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

The _____ is displayed as the label for a Command Button (ActiveX Control).

After you delete a worksheet column, _____.

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

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

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

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

You can change a table to a worksheet range by click the Change to Range button.

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

Jerome inserted a Check Box form control and set cell A10 as the cell link. When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

An Excel table contains columns named Salary and Commission. Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

In SmartArt, you can enter text directly in the placeholders or you can use the _____.

Martha created a table where employees can enter customer data. She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Henry imported text data, which appeared in all lowercase. To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

What can you do to share a workbook with other Office 365 users only?

When you group worksheet data, you can use the Hide Outline button to hide details in grouped columns or rows.

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

The _____ is displayed as the label for a Command Button (ActiveX Control).

After you delete a worksheet column, _____.

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters