ITM Midterm 1 Excel
Which of the following codes is inserted in a header or footer to include the date on each page?
&[Date]
Which of the following has an answer of 14?
2+4*3
How many items can the Office Clipboard hold?
24
Which of the following shows the correct syntax for the AND function?
=AND(LogicalN)
Which of the following does not apply to adding and removing chart elements?
All charts have the same elements
Which of the following methods inserts a manual line break in a cell?
Alt + Enter
Which of the following features displays a suggested label in a column when the first character or two that you type matches a label already in the column?
AutoComplete
Which of the following is not a basic rule for naming a cell range?
Begin a range name with a number
Which of the following histogram output options creates the histogram chart?
Chart Output
Which of the following terms is a restriction or limitation when creating a solver problem?
Constraint
Which of the following statements is not true for data visualization?
Data Visualization commands are applied from the Cell Styles Button
Which of the following statements about data consolidation by category is true?
Data consolidation by category can be either static or dynamic
Which of the following statements does not describe data labels?
Data labels are positioned at the same location for each chart type
Which of the following should you use when data on a source worksheet might be edited after you have created the consolidation worksheet?
Dynamic Data Consolidation
Which of the following statements is not true for applying chart style?
Each chart type has the same number of styles.
Which dialog box is used to update links in a workbook?
Edit Links dialog box
In Excel, which of the following keys opens the Save As dialog box?
F12
Which of the following activates edit mode?
F2
Which of the following opens the Paste Name dialog box?
F3
Which of the following is not true when working with the Format Task Pane?
Formats are applied after you close the Format task pane
Which of the following statements is not true about the Highlight Cells Rule?
Formatting is applied to the cells that do not meet the criteria
Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?
Formulas
Which of the following cannot b e performed when worksheets are grouped?
Insert a graphic
Apply the Colored Fill - Green, Accent 6 Quick Style to the shape. It is the last option in the second row of the gallery
On the Drawing Tools Format Tab, in the Shape Styles Group, click the More button to display the gallery. Click the Colored Fill _Green, Accent 6 Quick Style.
Which of the following Page Setup dialog box tabs are used to change the orientation of a worksheet?
Page
Which of the following options on the info tab of the Backstage view is used to encrypt a workbook with a password?
Protect Workbook
Which of the following tools listed command groups you would be likely to use for the selected source
Quick Analysis tool
Which of the following is a color coded editing tool that applies different colors to each cell or cell range within a formula?
Range Finder
Which of the following statements is not true for ranges?
Range names can be a single character
Which of the following functions adds or totals cells only if they meet the criteria?
SUMIFS function
To select part of a window for a screenshot, which of the following options should you select from the Illustrations group?
Screen Clipping?
Which of the following is an Excel add-in that finds the lowest, the highest or a specific result for a formula by changing values in other cells within limitations that you set?
Solver
What of the following about the Insert Slicer command is not true?
The Insert Slicer command opens a stationary window
Which of the following statements is not true about using the SmartArt Tools tabs?
The SmartArt Tools tabs do not include an option to change to a different image
Which of the following statements about WordArt is not true?
WordArt is a text box with preset font style, fill, and effects.
Which of the following does not describe a print area?
You can select nonadjacent ranges to print on one page
Which of the following does not describe the fill handle and creating a series?
a series can only be vertical
Consider the function = INDEX(array, row_number ,column_num). Which of the arguments is a cell range to be searched?
array
By default, how does Excel align labels in a cell?
bottom left of a cell
Which of the following occurs when a formula includes the cell address of a formula?
circular reference
If values are edited in source worksheets used in a static consolidation, which of the following commands will update the results?
consolidate command
Which of the following is a separate summary sheet in a workbook?
consolidation worksheet
Which of the following commands can you apply to grouped sheets that are not identical?
header or footer command
Which of the following in an Excel Add-in that plots geographic and time data on a world map or a custom map? map chart microsoft 3D map atlas map new scene map
not map chart don't know answer?
What should you do before creating a new scenario in Excel?
save the current data in a worksheet as a scenario
Which of the following statements related to scenario summary report is not true?
you cannot edit a scenario after creating a summary report
