Chapter 1
Key Tips are?
A way to navigate and select commands from the Ribbon by tapping letters or numbers that appear on the Ribbon after tapping the ALT key on the keyboard
Background Command?
Adds a picture behind the cell locations in a worksheet
Which option could be used to share a workbook with someone after saving the workbook on the cloud using OneDrive?
All of the above will allow you to share a workbook with other people using OneDrive
DATA Analytics Framework 4 things are?
Decision, Acquisition, Time, and Analysis
Which of the following is true if you want to save a workbook on the cloud using a OneDrive account?
If you do not have a OneDrive account, click Save As in the Backstage View, click OneDrive, and click the Sign up link to set up an account
How can you change the default font size for everything that is typed into a worksheet?
In the Backstage View, click the Options button and change the font size in the General Settings window
The Status Bar is?
Located below the worksheet tabs on the Excel screen; it displays a variety of information and tools, such as CAPS LOCK, the screen magnification or zoom slider, and view modes such as Normal or Page Layout.
The Spell Check feature can be found in which tab of the Excel Ribbon?
Review
Orientation Command?
Sets the orientation of the printed document to either portrait or landscape
Size Command?
Sets the paper size for the printed document
a cell is a?
Specific location on a worksheet where data is entered and stored (rectangle)
Which of the following is true with respect to printing Excel worksheets?
The Page Layout settings must be set for each worksheet in a workbook
Data Design?
The data that exists in a spreadsheet and the way in which the data is arranged
View Tab?
Used for adjusting the visual appearance of a workbook. Common commands include the Zoom and Page Layout view.
Print Area Command?
Used for printing only a specific area or range of cells on a worksheet
Insert Tab?
Used when inserting objects such as charts, pictures, shapes, PivotTables, Internet links, symbols, or text boxes.
Which of the following responses best defines the notation A1:B15?
a cell range or contiguous group of cells that begin with cell A1 and include all cells up to and including cell B15
When should a data audit be conducted?
before working with a spreadsheet that you did not create or when a dataset has been provided to you by another person
The Quick Access Toolbar is?
found at the upper left side of the Excel screen above the Ribbon which provides access to frequently used commands
What is the purpose of data internal controls?
methods used to decrease or eliminate the risk of an analysis from becoming distorted or corrupted when sharing an Excel workbook with other people
Holding down the CTRL key and tapping the PAGE UP or PAGE DOWN?
switch between worksheets in a workbook
The four components of the working model for data analytics are?
the DATA Analytics Framework, data audit, data design, and data internal controls.
keyboard shortcuts are?
A way to activate Excel commands by holding and or tapping a combination of keys on the keyboard
The DATA Analytics Framework should be used as a guide for:
Data Internal Controls, Data Audit, Data Design
(DATA)Analysis is?
How should the data be analyzed?
Review Tab?
Includes Spelling and Track Changes features. Also contains protection features to password protect worksheets or workbooks.
Formulas tab?
Includes commands for adding mathematical functions to a worksheet. Also contains tools for auditing mathematical formulas.
Data Internal Controls?
Instructions and features added to a spreadsheet that decreases or eliminates the risk of an analysis becoming corrupt or distorted by errors incurred by other users of a shared spreadsheet.
Worksheets?
May also be referred to as a spreadsheet and contains several rectangles called cells for entering numeric and non-numeric data.
(DATA)Time is?
Over what time period, or how long will data be collected?
Margins Command?
Sets the top, bottom, right, and left margin space for the printed document
footers are the?
Space at the bottom of a printed worksheet that can be customized to show information such as the date, page number, file name, company name, and so on.
headers are the?
Space at the top of a printed worksheet that can be customized to show information such as the date, page number, file name, company name, and so on.
Which of the following responses is most accurate with regards to the DATA Analytics Framework?
The framework can be used as a guide when conducting a data audit
Which of the following is a limitation of data analytics?
The outputs of a data analytics project and the resulting decisions will only be as good as the data used for the project
Data Audit?
The process of evaluating the design, scope, and integrity of a dataset to ensure reliable outputs can be produced to inform decisions.
Ribbon is?
The upper area of the Excel screen that contains several tabs running across the top. Each tab provides access to a different set of Excel commands
Data Presentation?
The way in which data is presented or visualized to an audience to explain circumstances and decisions in professional settings
Print Titles Command?
Used when printing large datasets that are several pages long. This command will repeat the column headings at the top of each printed page.
Data Tab?
Used when working with external data sources such as Microsoft Access, text files, or the Internet. Also contains sorting commands and access to scenario tools.
predictive analytics is?
Using data analytics to predict what might happen in the future
Predictive Analytics?
Using data analytics to predict what might happen in the future.
(DATA)Acquisition is?
What data must be acquired?
(DATA)Decision is?
What decisions need to be made?
cell reference is?
When cell locations are used in formulas, Excel will reference the data that is entered into the cell
a cell address is?
A column letter followed by a row number used to identify specific cells on a worksheet. Also referred to as the cell location
Data Analytics?
A comprehensive process to analyze data and produce outputs that can inform decision making.
Breaks Command?
Allows you to manually set the page breaks on a worksheet
File tab?
Also known as the Backstage View of the Excel workbook. Contains all commands for opening, closing, saving, and creating new Excel workbooks. Includes print commands, document properties, emailing options, and help features. The default settings and options are also found in this tab.
A workbook is?
An Excel file that contains one or more worksheets
a cell range is?
Any group of contiguous cell locations; a cell range is noted as two cell locations separated by a colon
Which of the following can be done to see if any headers or footers have been added to an existing worksheet?
Click the Page Layout button in the Status Bar
OneDrive?
Cloud service provided by Microsoft that allows you to store and share Excel workbooks on a common cloud network
OneDrive is?
Cloud service provided by Microsoft that allows you to store and share Excel workbooks on a common cloud network.
Page Layout Tab?
Contains commands used to prepare a worksheet for printing. Also includes commands used to show and print the gridlines on a worksheet
Developer Tab?
Contains features that allow you to record and write Visual Basic macros. Can also add active objects to your worksheet such as list boxes and option buttons.
Home tab?
Contains the most frequently used Excel commands. Formatting commands are found in this tab along with cut, copy, paste, and inserting and deleting rows and columns.
Which of the following commands is used to print the column headings in a worksheet at the top of each printed page for a worksheet that contains 100 rows of data?
the Print Titles command in the Page Layout tab of the Ribbon
Holding down the CTRL key and tapping the F1 key on your keyboard is used to?
toggle between showing only the tabs of the Ribbon and showing both the tabs and commands