CIS midterm
Which expression evaluates to 20
(2+3) * 4
What is the standard extension to use for Python source code file
.py
By the default files are saved in the native Microsoft Excel workbook file format with the following file extension
.xlsx
What does this expression evaluate to 5-2*2
1
In the python Terminal, what is printed when running the following line? 5*2+1
11
If you execute the following expression what is the output 3+5*2
13
What does this expression evaluate to 3+2*5
13
What does this expression evaluate to 2*3+2*5
16
Which is an example of a syntax error
2(4*2)
In the python what would this output be... print (18/3**2))
36
All Excel formulas begin with the ____.
= sign
Which of the following is not an arithmetic operator
>=
Which of the following displayed trends over time
A like chart
If you want every one of the comparison criteria that you specify to be true, you would use the ________.
And comparison operator
To tile multiple worksheets on the screen use the ________ command.
Arrange All
Which of the following is not a way to create a formula
By using a Function button on the status bar
An area to position fields that you want to display as columns in the PivotTable is called ________.
COLUMNS Areas
A defined set of formatting characteristics such as font, font size, and font color are known as a ________.
Cell Style
To make comparisons related data use a ___ chart
Column
Why doesn't a python file execute when you double click it
Double clicking does not run the python interpreter on the source code
Which of the following are some frequently and commonly used file formats for excel
Excel Template, Excel 97-2003 Workbook, CSV or tab delimited
Instead of displaying a filtered list you can copy the results of filter to another area of you worksheet for comparison purpose; this action is known as
Extracting
The ____ key is the keyboard shortcut for the spelling command
F7
True of false: A Microsoft access database can contain only one table
False
True or false: A data marker is a value that originated in a worksheet cell and that is represented in a chart
False
True or false: A data marker is a value that originates in a worksheet cell
False
True or false: A major unit value in a line chart determines the range of numbers in the value axis
False
True or false: A series of rows that contains related data is known as a query
False
True or false: Column headings are displayed as an increasing sequence of numbers
False
True or false: General alignment is the default for all text entered into a cell
False
True or false: Standardization means designing a workbook so that individuals cannot enter data into cells
False
True or false: Templates can only be used on the computer on which they are created
False
True or false: Text that is typed in a cell that extends into the next cell only displays if the two cells are merged
False
True or false: Use the F1 key to cancel a moving border after you have copied and pasted
False
True or false: You can format a 3-D Pie PivotChart using the same techniques that you use to format a chart
False
True or false: You can use the switch/row column command to move a chart from a set of rows on one worksheet to a set of columns on another
False
True or false: a chart sheet contains only a chart and the data used to generate that chart
False
True or false: a location chart compares values and shows categories across geographical regions
False
True or false: only one piece of a pie can be exploded
False
True or false: templates can only be used on the computer on which they are created
False
True or false: the chart area is the background and surrounding border of a chart
False
True or false: the first sort level is sometimes referred to as the primary sort
False
What are the two contextual tabs that display under chart tools when a chart is selected?
Format and Design
To move to cells that have special characteristics, are blank, or contain constants, use the ________ command.
Go To Special
___ is an excel tool that finds the input needed to arrive at a desired result
Goal Seek
Which IDE feature allows you to get code suggestions while you are typing?
IntelliSense
Which of the following statements is false about a workbook
It can contain only one worksheet.
Which of the following is not a benefit to organizations of using Power BI
It focusses on one data source
How can you identify the chart elements button when you select a chart
It is a green plus sign.
When you print a chart sheet, how is it automatically formatted?
It is centered on the page.
____functions look up a value in defined range of cells located in another part of the workbook to find a corresponding value
Lookup
If the file to which a hyperlink refers to is moved or renamed, or a webpage to which a hyperlink refers has a new address, which of the following do you need to do to the hyperlink to make it work correctly?
Modify the hyperlink to reflect the change
How would you write the "hello, world!" Program python
Print("hello,world!")
Which of the following SmartAct graphic categories would be best to show a timeline
Process
By default when a non-numeric field is added to a PivotTable it is placed in the ____ area
ROWS area
The _____ visually displays which cells are included in a formula calculation
Range Finder
To save an excel file in another file format use them ____ command
Save as
I'm the data validation dialog box you can create a _____ that will display when the cell is selected and that provides instructions to the person entering data
Screen tip
The code below which is supposed to print the value of the variable x is not working which category does the error fall under X=5 Print("x")
Semantic
The outline bar along the left side of a worksheet enables you to ____ levels of detail with a single mouse click
Show/Hide
Hyperlinks can be attached to which of the following items
Text and graphics
_____ is used to display the contents of a cell on multiple lines
The Wrap Text command
Why do computer instructions need to be sequential
The order in which these instructions are executed is important.
Which of the following is not part of the account number format
Three decimal places
Use the _____ command to locate and resolve an error in a formula
Trace Error
True of false: Normal view maximizes the number of cells visible on your screen
True
True of false: Power BI can display data on prebuilt dashboards
True
True of false: The outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click
True
True of false: the base is considered the starting point
True
True or false: 3-D is short three dimensional
True
True or false: A PivotChart displays data series categories data markers and axes in the same manner as a standard chart
True
True or false: A PivotChart usually has an associated PivotTable and the two are interactive
True
True or false: A cell style often includes font front size front color cell borders and cell shading
True
True or false: A graphical representation of the data in a PivotTable report is a Pivot chart report
True
True or false: A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula
True
True or false: Both the list and the criteria ranges use absolute references
True
True or false: Data can be pulled out of copied from a filtered list and placed below the table of data
True
True or false: From a PivotTable you can double click a total to display the data on a new worksheet
True
True or false: Goal seek is a what if analysis tool
True
True or false: Power BI is designed to be used primarily by organizations
True
True or false: Pyramid is a category of SmartArt graphics that uses a series of pictures to show relationships
True
True or false: Selecting the range before you enter data saves time because it confines the movement of the active cell to the selected range
True
True or false: Slicers are easy to use filtering components that enable you to quickly filter data in a PivotTable report
True
True or false: Sparklines are tiny charts located within a cell that provides a visual trend summary of data
True
True or false: The Show formulas button is a toggle button-it is either on or off
True
True or false: The comma numbering style leaves space at the right to accommodate a parenthesis when negative numbers are present
True
True or false: The formula Bar in excel displays the value or formula in the active cell
True
True or false: The plot area of a chart is bounded by the axes, including all the data series
True
True or false: The show formulas button is a toggle button it is either on or off
True
True or false: To best represent large amounts of data, it is often helpful to filter the PivotTable
True
True or false: Value after increases= base x percent for new value is the formula for calculating the value after an increase by multiplying the original value by the percent for a new value
True
True or false: When outlining a worksheet, if the data is not organized so that excel can outline it automatically you can create an outline manually
True
True or false: When using compound criteria on the same row, all the conditions must be met for the records to be included in the results
True
True or false: You can create data model by getting external data from Microsoft access
True
True or false: You can create your own themes, cell styles, and table styles in excel
True
True or false: You can format a 3-D pie PivotChart using the same techniques that you use to format a chart
True
True or false: You update or refresh PivotTable report data.
True
True or false: a funnel chart is named that way because the values decrease gradually, allowing the bars to resemble a funnel
True
True or false: an advantage to naming a range of cells is that you can use the name in a formula in other parts of your workbook
True
True or false: every excel formula state with an equal sign
True
True or false: formula autocomplete displays a list of function names that match the letter or two that you type
True
True or false: if your worksheet is wider than one page, you will also want to repeat the row titles on each page when you print or view the worksheet
True
True or false: in a map chart each region displays shading to indicate the values in the data series
True
True or false: power BI is a business analytics service that organization use to transform and analyze data
True
True or false: the active area of a worksheet contains data or has contained data and does not contain cells that were not used in the worksheet
True
True or false: the clear filter command removed a filter
True
True or false: the watch window displays the results of specified cells
True
True or false: when two or more cells are merged the individual cells cannot be selected
True
True or false: when you select the chart type the resulting chart will contain elements that you can delete or change
True
True or false: you can change the values on the value axis to increase or decrease the variations among the numbers displayed
True
True or false: you can edit the data or a label in a cell by double clicking the cell and the positioning the insertion point within the cell
True
true or false: the text pane is populated with placeholder text that you can replace with your information
True
Which of the following area of a PivotTable field list enables you to display average values
VALUES area
When preparing a document for printing a_____ indicates that only the columns to the left will be printed on the first page
Vertical dotted line between columns
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as _____
What-if analysis
The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ____
What-if analysis
If you were developing an application for an iPhone which IDE would you use
Xcode
The future value at the end of the time period in excel function is usually ____ for loans
Zero
A(n) _____ refers to a cell by its fixed position in the worksheet
absolute cell reference
Saving an Excel worksheet as a CSV file separates the cells of each row with ________.
commas
A method of incorporating data from multiple, related tables into an Excel worksheet is called a ________.
data model
___ is a group of related data points represented by data markers
data series
A data table is useful for all of the following except for ________.
determining the Future value (Fv)
Pixels are measured in ________ per square inch.
dots
A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________.
embedded
When you open a template from the Custom Office Templates folder, it opens as a(n) ________.
excel workbook
A ____ is a single piece of information that is stored in every record
field
In a PivotTable a single piece of information for every record is called a ____
field
A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.
field buttons
You can limit the display of data to specific information by using ________.
filtering
____ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results
filtering
The default number format for cells is the ___ number format
general
To move to a specific cell or range of cells in a large worksheet use the ________ command.
go to
Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify.
horizontal and vertical
programming can be defined as converting ideas into _______________ that a computer can understand
instructions
A text value in Excel is also referred to as a ________.
label
When you type text in a cell it is ________.
left-aligned
To display trends over time use a _____ chart
line
Which of the following is not one of the default calculations displayed by AutoCalculate
maximum
Fonts are associated with different themes and can be customized by ________.
mixing Colors and Fonts from any of the supplied themes
in this function definition, the variable "name" is_______ def hello(name): print ("Hey," name)
parameter
When you protect a worksheet, you can add an optional ________ to prevent someone from disabling a worksheet's protection.
password
A chart that illustrates the relationship of each part to a whole is called a ________.
pie chart
The area bounded by the axes, including all the data series is called
plot area
What is the correct syntax in python to output something on the screen
print("Hello World")
If you need to make changes to a template after it is protected you must first remove the ____
protection
____ prevents anyone from changing a workbook
protection
An organization chart depicts ____ within an organization
reporting relationships
____ is a procedure that determines which digit to the right of a number will be the last to be displayed
rounding
The ____ is the range of numbers in the data series and that controls the minimum maximum and incremental values on the value axis
scale
A slicer includes a ________ that indicates the category of the slicer items.
slicer header
To delete a box from a SmartArt organization chart, a ________ border must display around the box.
solid line
If you want all of the forms within an organization to have a uniform appearance and have the data organized in the same manner, you should use ________.
standardization
The two main reasons for creating templates for commonly used forms in an organization are _____
standardization and protection
The default calculation in a PivotTable Report is to ________ the numeric data.
sum
Which tool is used to write source code
text editor
If you edit data in a worksheet that is associated with a pie chart ________.
the pie slices will be automatically updated
A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied across all Office 2016 applications is called a ________.
theme
Why are there many programming languages
to address many different computing needs
The __ keyword is used to send back values from a python function
to return
Which python keyword is used to send back values from a function
to return
A ____ is a graphic representation of trends in a data series
trendline
Comma Style format displays a number with ________.
two decimal places
The Select locked cells option enables you to click the locked cell and ________ the formulas.
view
When you open a template from the New tab in the Backstage view, it opens as a(n) ________.
workbook
A field that is being removed from the PivotTable report is indicated by a(n) ________ attached to the pointer as you drag.
x
In a line chart, which of the following resides along the bottom of the chart
x-axis
The percent style button formats selected cells as a percentage with _____
zero decimal places
