ACIS 1504 Practise Questions and Answers 2024
The F1 key is used to:
open the Save As dialog box
open a cell for editing
add a blank worksheet to a workbook
open a blank workbook
open the Help window ** Answ** open the Help window
Which of the following is found in the Data Analytics Model?
PivotCharts
Worksheets
multi-level sorting
Treemap charts
Data design ** Answ** Data Design
Which of the following is the last step of the DATA Analytics framework?
Acquisition
Analysis
Automate
Time
Decision ** Answ** Analysis
Assume we are in cell address G9 within an excel worksheet. The "G" refers to the row and the "9" refers
to the column within the worksheet.
False
True ** Answ** False
For assistance with assignments contact
,Placing ____________________________ into a spreadsheet decreases or eliminates the risk of your
analysis becoming corrupt or distorted.
worksheets
data design
shortcuts
data internal controls ** Answ** Data internal controls
To save a workbook, hold the CTRL key and tap which of the following key(s)?
S
S and then the letter A
A and then the letter S
A
1 ** Answ** S
Using data analytics to predict what might happen in the future is called:
predictive analytics
data audit
data visualization
data design
concatenate ** Answ** Predictive Analytics
Holding the CTRL key and tapping the N key on your keyboard will do which of the following?
Add a blank Chart sheet to a workbook.
Open the Save As dialog box.
Add a blank worksheet to an existing workbook.
Open a new workbook.
Add a PivotTable to a worksheet. ** Answ** Open a new workbook
For assistance with assignments contact
,Which tab of the Ribbon contains commands to change the color of cells or text on a worksheet?
File
Formula
Page Layout
Insert
Home ** Answ** Home
Assume we have the following:
B2:E8
This would be referred to as:
cell
cell range
cell address
cell reference ** Answ** Cell Range
Which of the following represents a contiguous range of cells?
Sheet1:Sheet2
Sheet1:A5,Sheet1:D15
A5,D15
A5:D15 ** Answ** A5:D15
Which of the following Ribbon tabs would be used to add a header or footer to a worksheet?
Home
Insert
For assistance with assignments contact
, Formula
Developer
Review ** Answ** Insert
When creating a PivotTable, you would click which of the following Ribbon tabs?
Home
Insert
Page Layout
Formula
File ** Answ** insert
Which of the following is the first step of the DATA Analytics framework?
Data design
Decisions
Time
Data audit
Data internal control ** Answ** Decisions
Which of the following Ribbon tabs contains a command used to sort the data on a worksheet?
Formula
Data
Home
Review
Developer
Page Layout ** Answ** Data
For assistance with assignments contact
The F1 key is used to:
open the Save As dialog box
open a cell for editing
add a blank worksheet to a workbook
open a blank workbook
open the Help window ** Answ** open the Help window
Which of the following is found in the Data Analytics Model?
PivotCharts
Worksheets
multi-level sorting
Treemap charts
Data design ** Answ** Data Design
Which of the following is the last step of the DATA Analytics framework?
Acquisition
Analysis
Automate
Time
Decision ** Answ** Analysis
Assume we are in cell address G9 within an excel worksheet. The "G" refers to the row and the "9" refers
to the column within the worksheet.
False
True ** Answ** False
For assistance with assignments contact
,Placing ____________________________ into a spreadsheet decreases or eliminates the risk of your
analysis becoming corrupt or distorted.
worksheets
data design
shortcuts
data internal controls ** Answ** Data internal controls
To save a workbook, hold the CTRL key and tap which of the following key(s)?
S
S and then the letter A
A and then the letter S
A
1 ** Answ** S
Using data analytics to predict what might happen in the future is called:
predictive analytics
data audit
data visualization
data design
concatenate ** Answ** Predictive Analytics
Holding the CTRL key and tapping the N key on your keyboard will do which of the following?
Add a blank Chart sheet to a workbook.
Open the Save As dialog box.
Add a blank worksheet to an existing workbook.
Open a new workbook.
Add a PivotTable to a worksheet. ** Answ** Open a new workbook
For assistance with assignments contact
,Which tab of the Ribbon contains commands to change the color of cells or text on a worksheet?
File
Formula
Page Layout
Insert
Home ** Answ** Home
Assume we have the following:
B2:E8
This would be referred to as:
cell
cell range
cell address
cell reference ** Answ** Cell Range
Which of the following represents a contiguous range of cells?
Sheet1:Sheet2
Sheet1:A5,Sheet1:D15
A5,D15
A5:D15 ** Answ** A5:D15
Which of the following Ribbon tabs would be used to add a header or footer to a worksheet?
Home
Insert
For assistance with assignments contact
, Formula
Developer
Review ** Answ** Insert
When creating a PivotTable, you would click which of the following Ribbon tabs?
Home
Insert
Page Layout
Formula
File ** Answ** insert
Which of the following is the first step of the DATA Analytics framework?
Data design
Decisions
Time
Data audit
Data internal control ** Answ** Decisions
Which of the following Ribbon tabs contains a command used to sort the data on a worksheet?
Formula
Data
Home
Review
Developer
Page Layout ** Answ** Data
For assistance with assignments contact
