Question 1

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

A(n) _____ is an electronic attachment that verifies the authenticity of the author.

Accepted Answer

A)  electronic certificate 
B)  security mark 
C)  digital signature 
D)  password 
A)  electronic certificate 
B)  security mark 
C)  digital signature 
D)  password

Question 4

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 5

Which tab and button do you use to edit document properties ?

Accepted Answer

A)  File tab, Info Button 
B)  View tab, Show button 
C)  Review tab, Changes button 
D)  Home tab, Alignment button 
A)  File tab, Info Button 
B)  View tab, Show button 
C)  Review tab, Changes button 
D)  Home tab, Alignment button

Question 6

Which of the following can you apply to a data series to change its appearance?

Accepted Answer

A)  Series layout 
B)  Data callouts 
C)  Shape highlighting 
D)  Shape style 
A)  Series layout 
B)  Data callouts 
C)  Shape highlighting 
D)  Shape style

Question 7

Lauren wants to share a workbook via email.Which Share pane option should she use to do so?

Accepted Answer

A)  Get a sharing link, 
B)  Send now 
C)  Send as attachment 
D)  Start email program 
A)  Get a sharing link, 
B)  Send now 
C)  Send as attachment 
D)  Start email program

Question 8

To rotate cell contents to an exact value, you change its _____.

Accepted Answer

A)  Font 
B)  Width 
C)  Indent 
D)  Orientation 
A)  Font 
B)  Width 
C)  Indent 
D)  Orientation

Question 9

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Accepted Answer

A)  Bold button 
B)  CTRL+B 
C)  CTRL+D 
D)  Clear button 
A)  Bold button 
B)  CTRL+B 
C)  CTRL+D 
D)  Clear button

Question 11

Jack wants to show sparklines with symbols for positive and negative values in a range.He should insert Win/Loss sparklines.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following chart elements identifies the purpose of a chart?

Accepted Answer

A)  Legend 
B)  Gridlines 
C)  Vertical axis 
D)  Chart title 
A)  Legend 
B)  Gridlines 
C)  Vertical axis 
D)  Chart title

Question 13

Where calculated columns summarize data in each row of a table, a constraint creates an overall summary.

Accepted Answer

A) True 
 B)False

Question 14

When you want to know the position of an item in a range, you can use the _____ function.

Accepted Answer

A)  HLOOKUP 
B)  MATCH 
C)  ROW 
D)  TABLE 
A)  HLOOKUP 
B)  MATCH 
C)  ROW 
D)  TABLE

Question 15

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

Accepted Answer

A) True 
 B)False

Question 16

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Accepted Answer

A)  conditional formatting 
B)  cell formatting 
C)  cell styles 
D)  Quick Access toolbar 
A)  conditional formatting 
B)  cell formatting 
C)  cell styles 
D)  Quick Access toolbar

Question 17

To edit placeholder text, such as in a chart title, you click the object and then type the new text.

Accepted Answer

A) True 
 B)False

Question 18

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text.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 19

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise.Which of the following functions should he use?

Accepted Answer

A)  AND 
B)  IF 
C)  NOT 
D)  ROUND 
A)  AND 
B)  IF 
C)  NOT 
D)  ROUND

Question 20

Filtering a PivotChart does not affect the corresponding PivotTable.

Accepted Answer

A) True 
 B)False

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

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

A(n) _____ is an electronic attachment that verifies the authenticity of the author.

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?

Which tab and button do you use to edit document properties ?

Which of the following can you apply to a data series to change its appearance?

Lauren wants to share a workbook via email.Which Share pane option should she use to do so?

To rotate cell contents to an exact value, you change its _____.

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Jack wants to show sparklines with symbols for positive and negative values in a range.He should insert Win/Loss sparklines.

Which of the following chart elements identifies the purpose of a chart?

Where calculated columns summarize data in each row of a table, a constraint creates an overall summary.

When you want to know the position of an item in a range, you can use the _____ function.

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

To format a range so that all values greater than $500 appear in red, which of the following can you use?

To edit placeholder text, such as in a chart title, you click the object and then type the new text.

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text.Which of the following formulas should he use?

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise.Which of the following functions should he use?

Filtering a PivotChart does not affect the corresponding PivotTable.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

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

A(n) _____ is an electronic attachment that verifies the authenticity of the author.

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?

Which tab and button do you use to edit document properties ?

Which of the following can you apply to a data series to change its appearance?

Lauren wants to share a workbook via email.Which Share pane option should she use to do so?

To rotate cell contents to an exact value, you change its _____.

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

Jack wants to show sparklines with symbols for positive and negative values in a range.He should insert Win/Loss sparklines.

Which of the following chart elements identifies the purpose of a chart?

Where calculated columns summarize data in each row of a table, a constraint creates an overall summary.

When you want to know the position of an item in a range, you can use the _____ function.

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

To format a range so that all values greater than $500 appear in red, which of the following can you use?

To edit placeholder text, such as in a chart title, you click the object and then type the new text.

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text.Which of the following formulas should he use?

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise.Which of the following functions should he use?

Filtering a PivotChart does not affect the corresponding PivotTable.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters