Question 1

You can insert an ActiveX text box in a worksheet to let users select from a set of possible options.

Accepted Answer

A) True 
 B)False

Question 2

To remove a field from a PivotTable, clear its check box in the field list.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is true about moving cell contents?

Accepted Answer

A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature. 
A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature.

Question 4

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

Accepted Answer

A) True 
 B)False

Question 5

Sparklines can be small, simple column charts that show data trends for adjacent cells.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Tanya wants to insert a form control and then assign a macro to it. Which of the following objects should she insert?

Accepted Answer

A)  ActiveX command button 
B)  WordArt object 
C)  Icon object 
D)  Button form control 
A)  ActiveX command button 
B)  WordArt object 
C)  Icon object 
D)  Button form control

Question 8

Aaron has a column chart that displays data in the range B3:D7. When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

Accepted Answer

A) True 
 B)False

Question 9

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

Accepted Answer

A) True 
 B)False

Question 10

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?

Accepted Answer

A)  Table filters 
B)  VLOOKUP function 
C)  Multilevel sort 
D)  Data validation 
A)  Table filters 
B)  VLOOKUP function 
C)  Multilevel sort 
D)  Data validation

Question 11

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

Accepted Answer

A)  themes 
B)  icon sets 
C)  data bars 
D)  cell styles 
A)  themes 
B)  icon sets 
C)  data bars 
D)  cell styles

Question 12

You can add a calculated field to a PivotTable to use formulas to analyze the PivotTable data.

Accepted Answer

A) True 
 B)False

Question 13

You can use the Auto Outline feature to group worksheet data into an outline.

Accepted Answer

A) True 
 B)False

Question 14

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

Accepted Answer

A) True 
 B)False

Question 15

A _____ is a preset combination of fill color, borders, and font color.

Accepted Answer

A)  record 
B)  table theme 
C)  table style 
D)  filter set 
A)  record 
B)  table theme 
C)  table style 
D)  filter set

Question 16

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

Accepted Answer

A)  Select row 17 and click View tab > Window group > Split. 
B)  Select rows 2 to 16 and click View tab > Window group > Split. 
C)  Select rows 2 to 16 and click View tab > Window group > New Window > Split. 
D)  Select row 16 and click View tab > Window group > Split > Arrange All. 
A)  Select row 17 and click View tab > Window group > Split. 
B)  Select rows 2 to 16 and click View tab > Window group > Split. 
C)  Select rows 2 to 16 and click View tab > Window group > New Window > Split. 
D)  Select row 16 and click View tab > Window group > Split > Arrange All.

Question 17

Banded Rows applies banding to table rows to fill alternating rows with color.

Accepted Answer

A) True 
 B)False

Question 18

In the formula =A8*$A$1, which of the following describes A8?

Accepted Answer

A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum

Question 19

Brielle wants to increase the width of SmartArt but not its height. Which of the following should she do?

Accepted Answer

A)  Drag the middle sizing handle on the right. 
B)  Drag a corner sizing handle. 
C)  Click the Larger button in the Shapes group. 
D)  Click the Reset Graphic button in the Reset group. 
A)  Drag the middle sizing handle on the right. 
B)  Drag a corner sizing handle. 
C)  Click the Larger button in the Shapes group. 
D)  Click the Reset Graphic button in the Reset group.

Question 20

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

Accepted Answer

A)  Page Layout view 
B)  Normal view 
C)  Web Preview 
D)  Backstage view 
A)  Page Layout view 
B)  Normal view 
C)  Web Preview 
D)  Backstage view

You can insert an ActiveX text box in a worksheet to let users select from a set of possible options.

To remove a field from a PivotTable, clear its check box in the field list.

Which of the following is true about moving cell contents?

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

Sparklines can be small, simple column charts that show data trends for adjacent cells.

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

Tanya wants to insert a form control and then assign a macro to it. Which of the following objects should she insert?

Aaron has a column chart that displays data in the range B3:D7. When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

You can add a calculated field to a PivotTable to use formulas to analyze the PivotTable data.

You can use the Auto Outline feature to group worksheet data into an outline.

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

A _____ is a preset combination of fill color, borders, and font color.

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

Banded Rows applies banding to table rows to fill alternating rows with color.

In the formula =A8*$A$1, which of the following describes A8?

Brielle wants to increase the width of SmartArt but not its height. Which of the following should she do?

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 2: Excel 2019

You can insert an ActiveX text box in a worksheet to let users select from a set of possible options.

To remove a field from a PivotTable, clear its check box in the field list.

Which of the following is true about moving cell contents?

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

Sparklines can be small, simple column charts that show data trends for adjacent cells.

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

Tanya wants to insert a form control and then assign a macro to it. Which of the following objects should she insert?

Aaron has a column chart that displays data in the range B3:D7. When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

You can add a calculated field to a PivotTable to use formulas to analyze the PivotTable data.

You can use the Auto Outline feature to group worksheet data into an outline.

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

A _____ is a preset combination of fill color, borders, and font color.

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

Banded Rows applies banding to table rows to fill alternating rows with color.

In the formula =A8*$A$1, which of the following describes A8?

Brielle wants to increase the width of SmartArt but not its height. Which of the following should she do?

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters