Question 1

What feature will allow you to repeat steps automatically in a worksheet?

Accepted Answer

A)  Formula 
B)  Pivot table 
C)  Macro 
D)  Conditional formatting 
A)  Formula 
B)  Pivot table 
C)  Macro 
D)  Conditional formatting

Question 2

How can you connect a portable keyboard with a smartphone?

Accepted Answer

A)  Wi-Fi 
B)  Bluetooth 
C)  Internet 
D)  USB cable 
A)  Wi-Fi 
B)  Bluetooth 
C)  Internet 
D)  USB cable

Question 3

Lexie just bought a new smartphone and is looking through the pre-installed apps.She sees several apps she recognizes and some that are new to her.One of the apps is named for the manufacturer of her phone.What kind of app is this?

Accepted Answer

A)  Web app 
B)  App store 
C)  Native app 
D)  Portable app 
A)  Web app 
B)  App store 
C)  Native app 
D)  Portable app

Question 4

Ruthie needs to buy a new laptop for her college courses she's beginning in the fall.One course is a computer class that requires her to use the full,installed version of Microsoft Office.Which operating systems will work for her? Choose two.

Accepted Answer

A)  ChromeOS 
B)  macOS 
C)  Windows 
D)  iOS 
A)  ChromeOS 
B)  macOS 
C)  Windows 
D)  iOS

Question 5

Which kind of chart or graph would be best suited to illustrate how many students in a class made an A on their test?

Accepted Answer

A)  Pie chart 
B)  Line graph 
C)  Column chart 
D)  Bar graph 
A)  Pie chart 
B)  Line graph 
C)  Column chart 
D)  Bar graph

What feature will allow you to repeat steps automatically in a worksheet?

How can you connect a portable keyboard with a smartphone?

Lexie just bought a new smartphone and is looking through the pre-installed apps.She sees several apps she recognizes and some that are new to her.One of the apps is named for the manufacturer of her phone.What kind of app is this?

Ruthie needs to buy a new laptop for her college courses she's beginning in the fall.One course is a computer class that requires her to use the full,installed version of Microsoft Office.Which operating systems will work for her? Choose two.

Which kind of chart or graph would be best suited to illustrate how many students in a class made an A on their test?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Filters

Exam 5: Generating Reports From Multiple Worksheets and Workbooks

What feature will allow you to repeat steps automatically in a worksheet?

How can you connect a portable keyboard with a smartphone?

Lexie just bought a new smartphone and is looking through the pre-installed apps.She sees several apps she recognizes and some that are new to her.One of the apps is named for the manufacturer of her phone.What kind of app is this?

Ruthie needs to buy a new laptop for her college courses she's beginning in the fall.One course is a computer class that requires her to use the full,installed version of Microsoft Office.Which operating systems will work for her? Choose two.

Which kind of chart or graph would be best suited to illustrate how many students in a class made an A on their test?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Filters