AnswersComputer Applications - Office 2019Office 365 AForecasting Data

Forecasting Data Answers

6 verified answers3 views
1
Free Preview

What are the steps for locating the Data Validation dialog box?

A
File
B
Data
C
Insert
D
Review
2
Free Preview

What are the steps for locating the Data Validation dialog box?

A
Forecast
B
Data Tools
C
Connections
D
Get & Transform
3

What is a scenario in Excel 2019?

A
a collection of unrelated data
B
a formula that was built-in with Excel
C
a set of input values that produce a result
D
a group of operators that can be applied to values
4

Where does a forecast worksheet appear once it has been created?

A
in a separate workbook
B
inside the same worksheet
C
inside one cell in the data table
D
in a separate worksheet within the workbook
5

A data table is a range that displays what?

A
the condensed summary of a large amount of data
B
the results of combining two or more standard tables
C
the raw source data that is imported from another workbook
D
the results of changing certain values in one or more formulas
6

Which type of data table can predict projected growth using both projected increases in sales and expenses?

A
a projected sales table
B
a what-if analysis table
C
a one-variable data table
D
a two-variable data table

Did you find these answers helpful?

More from this Course

Instruction
11 verified answers

Instruction

Assignment
10 verified answers

Forecasting Data

Assignment
11 verified answers

Lookup Functions and Formula Auditing