Quiz 1 Csi 1200
By how many levels will Excel allow you to sort?
64
Which of the following is not a valid logical test?
=>
What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the sequence through the number 30 in A30 without having to type in the entire sequence?
Auto Fill
Which chart type displays the data horizontally?
Bar
Which axis in a chart displays the descriptive labels for the data points?
Category
Which chart type displays the data vertically?
Column
To what does the @ symbol refer in a structured reference?
Current row
I.Highlight Cells Rules II.Top/Bottom Rules III.Data bars IV.Color Scales V.Icon Sets A.Formats cells if they fall in the lowest % (% determined by the user) B.Formats cells with gradients of color depending on the cell's value compared to the other values in the range C.Formats cells with colors whose width is proportional to the other values in the range D.Formats cells if a date falls in a certain range E.Uses symbols to represent the comparison of values
D, A, C, B, E
What should you do if there are columns you need, but do not want to display?
Hide the columns you do not want to display, then unhide them when finished.
Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?
Highlight Cells Rules
the _______ function actually changes the number of decimal places in the value.
ROUND
What action changes the actual number of decimal places Excel stores instead of just changing what is displayed?
ROUND function
Which status bar statistic can you not enable?
Range Name
If the annual interest rate is 12% and payments are made monthly, then you would enter .01 in the _______ argument in the PMT function
Rate
What is the default method of referencing cells in formulas?
Relative
What is not a purpose of using an effective chart?
Reveals even subtle errors in formulas
Which Excel function changes the value to a desired number of decimal places?
Round
What is not true about tables in Excel?
Row headings stay on the screen automatically.
Which chart type is a visual "dashboard" of your data?
Sparkline
Which chart type is not listed in the All Charts window?
Sparkline
What data does Excel print by default?
The entire dataset on the active sheet
What would not be a typical item to have in a header or footer?
The file size
When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?
The first unfrozen cell becomes the active cell.
What does it mean when you see ####### in a cell?
Your column is not wide enough.
What is the term for the inputs required in a function?
arguments
an _______ is a line you can put around a cell or range of cells for emphasis.
border
number _________ controls how a value appears in a cell.
formatting
Which axis in a chart displays incremental numbers for the data points?
value
Which axis displays incremental numbers to identify the approximate values of data points?
value axis
If you have too many words in a cell, but you cannot allow them to bleed over into the next cell, you would use the ________ feature in Excel.
wrap text
What error will you get if you type a function name incorrectly?
#NAME?
What will you see if you enter the TODAY function without the parenthesis?
#NAME?
Which of the following is not a valid number format? Select one: A. B. (1,000.00) C. $1,000.00 D.
$-1,000.00
The HLOOKUP function can only be used to find exact matches. T or F
'False'.
New workbooks typically contain how many worksheets?
1
If A7=21, which of the following =IF statements would produce the result of "Much Greater"?
=IF (A7<14,"Greater",IF(A7>20,"Much greater","not greater than 20"))
Which is not a valid range? Select one: A. A1:F1 B. A1:A9 C. A1:A3, B1:B3 D. A1:F9
A1:A3, B1:B3
Which of the following is not a valid test in an =IF statement? Select one: A. A4-B4 B. A4>A4 C. A4<b4 D. B4<=B4
A4-B4
In a structured reference what do you use to indicate a column heading or field name?
Brackets [ ]
Using the data bars conditional formatting, how is the highest value represented?
By the longest bar
Where can you find more alignment options?
Cells dialog box
Which chart type is best when you want to chart two unrelated data types?
Combo chart
Records are individual pieces of information.
False
Which of the following is not a freeze option? Select one: A. Freeze First Column B. Freeze Section C. Freeze Top Row D. Freeze Panes
Freeze Section
The default number format is ________.
General
Functions can be selected by using the ________.
Insert Function dialog box
Which of the following names of worksheet tabs would be best?
January Payroll Information
Which of the following is not a valid lookup function? Select one: A. HLOOKUP B. LLOOKUP C. LOOKUP D. VLOOKUP
LLOOKUP
Which table style option is useful to display aggregated data when it is checked?
Last Column
How is text aligned by default?
Left
What function computes the value in which one-half of the data is above and one-half is below.
MEDIAN
What is the default data table style?
Medium 2
What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?
Order of operations
The filter "Begins With..." option is found on which type of filter?
Text filter
After a table has been named, that name can be used in functions instead of cell references.
True
You can add a row to a data table as long as you put in the row immediately below the table.
True
You can freeze as many columns and rows at the same time as you desire.
True
It is always a good practice to test each formula you enter for accuracy. Select one: True False
True'.
What should you not select when selecting data for a chart?
Worksheet titles
What is true about adding a new field to the right side of an existing data table?
You can add it to the right of the data table and Excel will extend the table to include the new field.
Which axis displays descriptive labels for the data points in a chart?
category axis
You should use ________ in formulas whenever possible instead of simply typing in numbers.
cell references
A chart sheet can hold, at most, two charts.
false
When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.
false
the ______ area is where you store the variable you will be using in the worksheet.
input
the ______ area contains the formulas which are dependent on values found elsewhere in the sheet.
output
A 100% stacked column chart is similar to which other chart in that it converts values to percentages?
pie
Data ________ define how information is stored, organized, and accessed.
structure
What term refers to the necessity of following the rules when it comes to using functions?
syntax
A range is specified by its ________.
top left and bottom right cells
If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell?
$A7
To print row labels on the left side of each page you would select the row(s) that contain the labels in the rows to repeat at left box.
'False
he most used logical function is the IF function.
'True'.
In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
(2-3)
The ROUND function requires how many arguments?
2
In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?
6^2
How many sizing handles are found on embedded charts?
8
Which of the following is not true about a Fill color?
: It cannot be applied to an entire row or column.
Which of the following would not be considered text? A. Phone number (111.111.1111) B. Social Security number (111-11-1111) C. =2*2 D. Part number (PT111)
=2*2
I.Color scale II.Icon set III.Filtering IV.Sorting V.Data bars A.Colors are based on the relative values in the cell. B.Arranging records C.Symbols or signs that classify data D.Various widths represent the cell's value. E.Using conditions to limit the visible data
A, C, E, B, D
Which of the following, when included, distorts the effectiveness of charting data points? Select one: A. Too many series B. Too many data points C. Too much variance in the values of the data D. Aggregates
Aggregates
In the task pane, what does a diagonal black triangle next to a chart category indicate?
All the category's options are displayed.
Where does Excel display the Total row in a table?
Below the last row in the table
Which one of the following filter options is not found on the number filter submenu?
Bottom 10...
Match the following terms with their description: I.Name Box II.Order of operations III.Formula IV.Fill handle V.Pointing A.Always begins with an equals sign (=) B.Small green square used to perform various actions C.Displays the address of the active cell D.Also known as semi-selection E.PEMDAS
C, E, A, B, D
Which of the following is not a characteristic of a table? Select one: A. Can contain multiple ranges B. Helps to manage information C. Contains related data D. Helps to analyze information
Can contain multiple ranges
What icon is not displayed when you select a chart?
Chart Types
Which of the following is not a chart element?
Chart foreground
What punctuation is used to separate the two cell references in a range?
Colon (:)
What do you use to separate arguments in a function?
Comma (,)
If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?
Conditional formatting
Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?
Count
I.Header Row II.Total Row III.First Column IV.Last Column V.Banded Rows A.The formatting of this row/these rows take/takes priority over column formatting. B.Alternate fill colors distinguish one row from another row. C.Makes sure that the row headings stand out D.Displays the field names when checked E.Often used for aggregated data
D, A, C, E, B
Which of the following is not a chart element? Select one: A. Chart area B. Data area C. Legend D. Plot area
Data area
If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?
E$14
Match the following navigation shortcuts with their actions: I.Right arrow II.Page Down III.Home IV.End V.Ctrl + Home A.Moves active cell down one screen B.This does nothing by itself C.Moves active cell to column A, row 1 D.Moves active cell to column A in that row E.Moves right one cell in the same row
E, A, D, B, C
I.Field II.Record III.Table IV.Table style V.Total row A.Includes complimentary fill colors B.Complete set of fields for one entity C.Structured range D.Appears below the last row in a table E.Smallest piece of data collected
E, B, C, A, D
I.Sort Z to A II.Sort Oldest to Newest III.Sort Largest to Smallest IV.Sort A to Z V.Sort Newest to Oldest A.Number; Othniel; Psychology B.11/20/2015; 8/20/2015; 5/25/91 C.58; 29; 27 D.1/16/1957; 12/26/1959; 1/7/87 E.Karen; Doug; Barb
E, D, C, A, B
Which keyboard shortcut puts the user in cell edit mode?
F2
Which keyboard shortcut toggles through the types of reference options?
F4
What keyboard shortcut will automatically update any formulas using =TODAY() or =NOW()?
F9
To look up an exact match, what should you enter in the range_lookup argument?
FALSE
"John Smith" is a good example of a field.
False
A parallel range is one that consists of the same starting point of another range, but can have a different end point.
False
Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.
False
Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.
False
Excel uses dashed blue lines to indicate manual page breaks.
False
Filter arrows are always displayed in data tables.
False
In Excel, columns are identified by numbers and rows by letters. Select one: True False
False
It is very important to sort the first column in a table lookup array in descending order. T or F
False
Locking is the process of making sure that certain rows or columns are visible at all times.
False
Selecting a range automatically makes it a data table.
False
The COUNTA function only counts text entries. It does not count calculable values or blank cells.
False
The COUNTBLANK function will count cells that contain formulas that compute to a value of zero (0).
False
The contents of a cell can be seen in the Name box. Select one: True False
False
The two optional arguments in the PMT function allows the function to be used with variable loans.
False
When entering functions, the square brackets, [ ], indicate required values.
False
You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.
False
The cell at row 4 and column B, would be identified as 4B. Select one: True False
False'.
Which chart element cannot be chosen from the Chart Elements dialog box?
Format Back Wall
________ is the process of keeping rows and/or columns visible onscreen at all times even when you scroll through a large dataset.
Freezing
Which of the following is not a category of functions? Select one: A. Logical B. Statistical C. Financial D. Graphing
Graphing
What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?
January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015
What is a disadvantage of a stacked column chart?
Segments do not start at the same point.
What can you not do from the Page Setup, Sheet tab?
Set margins
By default, what is the first table on a worksheet named?
Table 1
Which of the following is not a conditional formatting option?
Table format
In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?
The COUNT function
In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?
The range to be included in the calculation
What does pressing the Enter key while in a cell, do?
The value is set, and the cell below becomes the active cell
Which of the following is not true about sizing handles? Select one: A. There are 8 of them for any object. B. They allow you to make objects larger or smaller. C. They appear as circles. D. They always maintain the proper aspect ratio for the object.
They always maintain the proper aspect ratio for the object.
Which of the following is not true about trendlines? Select one: A. They are added to existing charts. B. The line indicates possible future values. C. They can be added to all chart types. D. They help forecast future data.
They can be added to all chart types.
By default, Excel prints page in what order?
Top-left section, bottom-left section, top-right section, and bottom-right section
Which Paste option would you choose if you wanted to flip the rows and columns?
Transpose
If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.
True
In a data table calculated columns will copy down the table automatically.
True
When you use the Freeze Panes option you freezing both columns and rows.
True
You could use both A3>b9 or B9<A3 as the test in an IF function and get the same results. You would just switch the second and third arguments.
True'
Which of the following is not an argument associated with the IF function? Select one: A. Value if false B. Value if true C. Test D. Value if neither true nor false
Value if neither true nor false
_______ can be used in calculations, whereas text cannot.
Values
In a bar chart, which axis displays the categories?
Vertical
When would you not need to use a fully qualified structured reference?
When referring to a cell within the table
Which of the following is not a chart type? Select one: A. Pie B. Bar C. Line D. Circle
circle
In a lookup table, the number of the column which contains the return values is called the __________
column index number
What chart type can display two different chart types at the same time?
combo
When you do not need the data on a worksheet you should ________ it to make the file smaller.
delete
A chart style effects the formatting of the chart itself, but not the chart data
false
A stacked column chart displays multiple columns for each category.
false
The PMT function uses three required arguments and no optional arguments. T or F
false
The VLOOKUP function has four required arguments. t or f
false
You can enter data or formulas on a chart sheet.
false
the _______ color is what is visible behind the value in a cell.
fill
Shifting a cell's contents to the right or left to help it stand out from the row above or below is known as
indenting
When you use the VLOOKUP function, the ________ column in the array is used to look up the value.
left, first
In the PMT function, the PV argument refers to the ________ of the loan
present value
the ________ feature allows you to see how a document would print before you actually print it.
print preview
an _______ is a group of cells which have been selected at the same time.
range
Data ________ is the organization method used to manage multiple data points within a dataset.
structure
The range that contains the lookup table is called the ________
table array
A good practice when entering function names is to type them in lowercase and see if Excel converts them to upper case.
true
Displaying cell formulas can help find errors in formulas more easily. Select one: True False
true
Effective charts never overwhelm an audience.
true
Excel assigns date number 1 to January 1, 1900.
true
Pie charts can only display one data series.
true
Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column. Select one: True False
true
The Chart Styles gallery displays style options for the selected chart only.
true
The default calculation using the PMT function will produce a negative number.
true
The fill handle allows you to copy and paste formulas to adjacent cells. Select one: True False
true
The test in an IF function must evaluate to either a True or a False.
true
This is a valid way to use the MAX function: =MAX(a4:d11, f1:f2)
true
When you want to chart two related types of data, the Combo chart is perfect.
true
You can link to a cell as the title of a chart.
true
You can move a range by using the cut and paste commands. Select one: True False
true
You can sort cells by their fill color.
true
The wrap text feature will automatically move any text that does not fit in a cell to the cell directly below it.
'False'.
Which of the following is not a valid =IF statement? Select one: A. =IF(A5>19,1,9) B. =IF(A5>19,Greater,Not Greater) C. =IF(A5>19,"Greater","Not Greater") D. =IF(A5>19,b7,b9)
=IF(A5>19,Greater,Not Greater)
Which of the following does not comply with the preferred way of using the SUM function?
=SUM(A4/A11)
Match the following terms with their description: I.AutoComplete II.Auto Fill III.Column heading IV.Row heading V.Alignment A.The letter in the cell reference "F4" B.Helps complete a logical sequence C.The number in the cell reference "F4" D.Refers to how data are positioned in the boundaries of a cell. E.Matches the letters you type to another value in the column if the letters match
E, B, A, C, D
When you insert rows or columns all relative references are updated but not any absolute references. Select one: True False
False'.
What is the small green square in the bottom right of a cell called?
Fill handle
What Paste option would you choose if you wanted to maintain the formatting of the copied cell, but not its contents?
Formatting
Which of the following is not true of the Formula bar? Select one: A. It displays the contents stored in the active cell. B. It allows you to pick from an assortment of formulas. C. It is to the right of the Insert Function command. D. You can edit cell contents there.
It allows you to pick from an assortment of formulas.
What is the true about an input area?
It is used when certain values are used repeatedly throughout the worksheet.
What describes a function's purpose? Select one: A. Category B. Arguments C. Name D. Variables
Name
Where does Excel automatically display statistics like count, average, and sum when a range of values is selected?
Status bar
Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?
Values & Source Formatting
Make sure to enter all cell reference in upper case when putting them in formulas. Select one: True False
false
Which of the following is not a valid formula? Select one: A. =D3 B. =2*2 C. =sum(1,2,3,4,5) D. =#12/31/2018#-#12/31/2019#
=#12/31/2018#-#12/31/2019#
If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?
=$B$14
Match the following terms with their description: I.Paste Special II.Transpose III.Flash Fill IV.Accounting number format V.Currency number format A.Opens a gallery of options for pasting B.Puts the $ at the left margin of the cell C.Flips rows and columns when pasted D.Puts the $ next to the leftmost number E.Fills in data based on previous column's data
A, C, E, B, D
Match the following terms with their description: I.Zoom control II.Workbook III.Worksheet IV.Sheet tab V.Cell A.Makes the text on the screen smaller or larger B.Contain labels, values and formulas C.The intersection of a column and a row D.Shows the name of the worksheet E.The same as a spreadsheet
A, E, B, D, C
What two functions compute the central tendency of values?
AVERAGE and MEDIAN
If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?
Absolute
The current cell is also known as the _________ cell.
Active
Which of the following is not a way to widen a column?
Click on the Column label and drag it to the right.
What is the best practice to switch the columns and rows in a range?
Cut the range, then use the Paste Special option called Transpose
What does Excel use to indicate optional arguments in a function?
Square brackets []
What is the best practice for centering a title over multiple columns?
Use the Merge and Center alignment
hat do you adjust if you see ###### displayed in a cell?
column width
For the fill handle to work you need to have two cells selected. Select one: True False
false
