Question 1

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

Accepted Answer

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

Question 2

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years. She should create a formula using the NPER function.

Accepted Answer

A) True 
 B)False

Question 3

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

Accepted Answer

A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape. 
A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape.

Question 4

The predefined colors in a workbook are called the cell styles.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data. She can click the Expand button in one row to display both levels of data.

Accepted Answer

A) True 
 B)False

Question 7

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 8

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following form controls provides a way for users to enter data?

Accepted Answer

A)  Check box 
B)  Label 
C)  Rectangle 
D)  Index list 
A)  Check box 
B)  Label 
C)  Rectangle 
D)  Index list

Question 10

Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the SmartArt to group blocks of information in a pyramid. What should he do?

Accepted Answer

A)  Change the layout. 
B)  Apply a SmartArt style. 
C)  Change the color scheme. 
D)  Align the shapes. 
A)  Change the layout. 
B)  Apply a SmartArt style. 
C)  Change the color scheme. 
D)  Align the shapes.

Question 11

Shelley has created a table listing the names of her students and their grades on an exam. She wants to display only the students who received a grade of 60. After clicking the Grade filter list arrow, what should she do?

Accepted Answer

A)  Click Sort A to Z. 
B)  Click Select All to clear the checkmarks then click 60. 
C)  Click Number Filters then click Top 10. 
D)  Click 60. 
A)  Click Sort A to Z. 
B)  Click Select All to clear the checkmarks then click 60. 
C)  Click Number Filters then click Top 10. 
D)  Click 60.

Question 12

Which of the following options can you set to make sure a worksheet will print on one page?

Accepted Answer

A)  Zoom percentage 
B)  Scaling 
C)  Print selection 
D)  Gridlines 
A)  Zoom percentage 
B)  Scaling 
C)  Print selection 
D)  Gridlines

Question 13

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row. Which of the following is an efficient way for her to do this?

Accepted Answer

A)  Change the picture layout. 
B)  Align the pictures. 
C)  Bring each picture forward. 
D)  Apply picture corrections. 
A)  Change the picture layout. 
B)  Align the pictures. 
C)  Bring each picture forward. 
D)  Apply picture corrections.

Question 14

To see how copied contents will look with both values and number formatting, you would use Paste Numbers .

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is true when you copy and paste formulas using the fill handle?

Accepted Answer

A)  The Paste Options button lets you paste only specific elements of the copied selection. 
B)  The AutoFill Options button lets you fill cells with specific elements of the copied cell. 
C)  The formula is placed on the Office clipboard. 
D)  You need to change the cell references to reflect the new formula location. 
A)  The Paste Options button lets you paste only specific elements of the copied selection. 
B)  The AutoFill Options button lets you fill cells with specific elements of the copied cell. 
C)  The formula is placed on the Office clipboard. 
D)  You need to change the cell references to reflect the new formula location.

Question 16

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 17

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.

Question 18

Dawn wants to make a column chart look three dimensional. How can she do so?

Accepted Answer

A)  Apply a chart style. 
B)  Change the Chart Layout. 
C)  Modify the chart data. 
D)  Change the chart type. 
A)  Apply a chart style. 
B)  Change the Chart Layout. 
C)  Modify the chart data. 
D)  Change the chart type.

Question 19

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions?

Accepted Answer

A)  Height and Width under Size group 
B)  Height and Width under Buttons group 
C)  Format cells under Format in Cells group 
D)  Filter under Sort & Filter in Editing group 
A)  Height and Width under Size group 
B)  Height and Width under Buttons group 
C)  Format cells under Format in Cells group 
D)  Filter under Sort & Filter in Editing group

Question 20

You can insert WordArt into a worksheet, but not a chart.

Accepted Answer

A) True 
 B)False

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years. She should create a formula using the NPER function.

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

The predefined colors in a workbook are called the cell styles.

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

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data. She can click the Expand button in one row to display both levels of data.

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

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

Which of the following form controls provides a way for users to enter data?

Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the SmartArt to group blocks of information in a pyramid. What should he do?

Shelley has created a table listing the names of her students and their grades on an exam. She wants to display only the students who received a grade of 60. After clicking the Grade filter list arrow, what should she do?

Which of the following options can you set to make sure a worksheet will print on one page?

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row. Which of the following is an efficient way for her to do this?

To see how copied contents will look with both values and number formatting, you would use Paste Numbers .

Which of the following is true when you copy and paste formulas using the fill handle?

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?

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

Dawn wants to make a column chart look three dimensional. How can she do so?

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions?

You can insert WordArt into a worksheet, but not a chart.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years. She should create a formula using the NPER function.

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

The predefined colors in a workbook are called the cell styles.

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

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data. She can click the Expand button in one row to display both levels of data.

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

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

Which of the following form controls provides a way for users to enter data?

Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the SmartArt to group blocks of information in a pyramid. What should he do?

Shelley has created a table listing the names of her students and their grades on an exam. She wants to display only the students who received a grade of 60. After clicking the Grade filter list arrow, what should she do?

Which of the following options can you set to make sure a worksheet will print on one page?

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row. Which of the following is an efficient way for her to do this?

To see how copied contents will look with both values and number formatting, you would use Paste Numbers .

Which of the following is true when you copy and paste formulas using the fill handle?

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?

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

Dawn wants to make a column chart look three dimensional. How can she do so?

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions?

You can insert WordArt into a worksheet, but not a chart.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters