Microsoft Excel final
To hyperlink to a saved workbook, which category should the hyperlink be created under in the Insert Hyperlink window? A. Existing File or Web Page B. Place in This Document C. Create New Document D. E-mail Address
A.
Under which tab is the Axes section found? A. Design B. Layout C. Format
A.
What are the steps to editing text inside a shape? A. Select shape --> Right-click --> Edit Text B. Select shape --> File --> New Text C. Select shape - -> Home tab --> Wrap Text
A.
When using the New Table Quick Style window to format cells in a table, which of the following font styles is available? A. Regular Bold B. Bold Italic C. Underline D. All of the above
B.
Which keyboard shortcut moves the cursor to the bottom-right of the data? A. Shift+Arrow B. Ctrl+End C. Alt+Shift+F1
B.
Which of the buttons pictured below should you click on to paste a copied cell's formula and number formatting
B.
Which of the following is NOT a way to display worksheet errors, based on the options in the Page Setup dialog? А. B. ERROR IN WORKSHEET C. #N/A D. --
B.
From which pull-down above can you select a custom sort list? A. Column B. Sort On C. Order
C.
In the Header & Footer group, what is the purpose of this tool? (Clock saying current time) A. To display the total number of pages B. To display the present date C. To display the present time
C.
When inserting a new cell, the user does not have control over what happens to data in existing cells. True or false?
False
In the file tab what is the icon for the tool to protect the current worksheet?
A.
Once the external data is in a worksheet, what are the steps to finding a table format? A. Home tab --> Styles group --> Format as Table B. File tab --> New Table Format C. Page Layout tab --> Format group --> Table Format
A.
The keyboard shortcut to fill data down from one cell to the selected cells below is Ctrl+ A. D B. R C. L
A.
To accept the selected value in the formula prompt, press the_____key A. Tab B. Enter
A.
A subtotal is a partial total for A. A file name B. Related data in a worksheet.
B.
In PowerPoint, which tab in the ribbon above the slide contains the 'Object' tool, which is used to insert a workbook? A. Home B. Insert C. Design D. Transitions
B.
In the 'Share Workbook' dialog, the tool to decide when to update changes to the workbook is located under which tab? A. Editing B. Advanced
B.
True or False: A worksheet template is the same thing as a workbook template.
False
True or false: The keyboard shortcut ctrl+PageDown moves to the first worksheet in the workbook.
False
The pick from list functionality, allows you to enter the value in a cell choosing the value from a set of values already entered in the column. True or False?
True
True or False: Clicking the minus sign under a section will make the details for that section disappear.
True
True or False: For cells containing dates, some formats while other show all four digits of the year formats only show the last two digits of the year.
True
True or False: In the Value Field Settings dialog box, it is possible to give a custom name to the summary field in the PivotTable.
True
True or False: The vlookup function requires a primary key column, while the hlookup function requires a primary key row.
True
True or False: When creating a PivotTable, it is possible to import data from an external data source.
True
True or False: When creating a new PivotTable style, it is possible to set the new style to be the default PivotTable style for that workbook.
True
True or False: You can change the cell style of multiple cells at the same time.
True
Using a color scale, you can use colors to visually show what's happening with data. your True or False?
True
When working with tables, relative references can be created using defined names rather than cell references. True or False?
True
A column is all of the data on the same vertical line within a worksheet. True or False?
True
A what-if analysis is used to determine the impact that specific changes have on your calculations. True or false?
True
A worksheet tab is an indicator at the bottom of the workbook window, for navigating between worksheets. True or False?
True
Auto calculate is a tool that displays the sum, average, and count of selected cells. True or false
True
One way to adjust the height of a selected row is to use the "Row Height" option on the right-click menu. True or false?
True
Pivot means to reorganize the contents of a PivotTable. True or False?
True
Relative references change. True or false?
True
The Document Panel is used to view and edit basic Document Properties for your Excel file. True or false?
True
The Excel Options dialog allows more than just the ribbon to be customized. True or False?
True
The dialog box is accessed by right-clicking on the worksheet tab. True or False?
True
The formula bar is the area just above the worksheet grid that displays the active cell's formula -- and within which you can edit the formula. True or False?
True
What is the location of the button that toggles the PivotTable Field List dialog? A. Home tab --> Show section --> Field List B. Design tab --> Show section --> Field List C. Options tab --> Show section --> Field List
C.
of the What is the purpose RANDBETWEEN function? A. It produces a random number between 0 and 100. B. It produces a random number between 0 and 10. C. It produces a random number between 0 and 1. D. It produces a random number between any two numbers.
D.
What is the function of the "shift+arrow key" shortcut? A. To select adjacent cells. B. To display the Insert Function dialogue box. C. To switch to the next worksheet.
A.
What is the purpose of the "Create links to source data" button? A. It generates a link to the contributing worksheets. B. It generates a link to an index of the formulas available with Excel. C. It generates a link to the top row of the worksheet.
A.
What is the purpose of the following shortcut: Ctrl+Arrow A. Selects the cells to the bottom-right edge of the current data region. B. Selects the cells to the edge of the current data region. C. Moves to the edge of the current data region.
C.
When working with alternative data sets, what is the largest number of cells that can be changed at one time? A 1 В. 10 С. 32 D. 100
C.
Where is the location of the tool that removes all filters in the PivotTable? A. Filters tab --> PivotTable -> Clear Filters B. Home tab --> Clear --> Clear Filters C. Options tab --> Clear --> Clear Filters
C.
What are the steps to only printing certain cells from a worksheet? A. Select cells --> Page Layout tab --> Print Area --> Set Print Area B. Select cells --> Developer tab --> Print Area --> Print Selected Cells C. Data tab --> Print cells --> Select cells
A.
What are the steps to paste a chart into a PowerPoint slide? A. Right click --> Paste Options --> Picture B. Right click --> Insert Chart C. Right click --> New --> New Chart
A.
What are the steps to recording a new macro? A. View tab --> Macros --> Record Macro B. File tab --> Macros --> Record Macro C. Insert tab --> Macros --> Record Macro
A.
What can you use to center text in a cell? A. Alignment B. Ctrl C C. A validation rule
A.
What is a column? A. The cells on the same vertical line of a worksheet. B. Any range of cells. C. Data consolidation.
A.
What is a template? A. A pattern used to create other workbooks and worksheets. B. A formula that has content from other worksheets. C. Data consolidation.
A.
What is the term for saving a file as part of another file (as opposed to linking one file to another file)? A. Embed B. Attachment C. Hypersave D. None of the Above
A.
Which keyboard shortcut completes a cell entry and selects the cell above? A. Shift+Enter B. Ctrl+Spacebar C. Ctrl+0 D. Shift+Spacebar
A.
Which keyboard shortcut starts a new line in the same cell? A. Alt+Enter B. Ctrl+Enter C. Shift+Enter D. Ctrl+Shift+Enter
A.
Which of the following categories does this SmartArt graphic belong to?
A.
Which shortcut toggles strikethrough on and off? A. ctrl+5 В. F5 C. shift+5 D. ctrl+shift+5
A.
A sparkline is a very chart showing compact data in a single________ A. Template В. Cell C. Column
B.
The keyboard shortcut to fill data from one cell to the selected cells to the right is Ctrl+ A. D B. R C. L
B.
The keyboard shortcut to open the Spelling dialog is A. F3 B. F7 C. F10
B.
To add another row of data to an existing table A. remove the table formatting, add the data, then format as a table again B. simply start typing in the first empty row below the table
B.
Under which tab is the Data Validation tool found? A. Insert B. Data C. Formulas D. Review
B.
What does printing in Landscape Orientation look like? A. The short side of the page is on the top and bottom. B. The short side of the page is on the left and right sides. C. None of the Above.
B.
What is a sparkline? A. A type of file extension B. A small chart that fits into a single cell C. A text used in tables
B.
What is the fill handle? A. A button that appears after you paste. B. The square at the corner of a cell that can be dragged to indicate the values of other cells. C. A button used to access layout options.
B.
When a new workspace is created, which workbooks are included in the new workspace? A. Every workbook on the computer B. Only the workbooks that are currently open C. Only the one workbook currently displayed on the screen
B.
When an image is selected in a worksheet, what is the title of the tab that appears in the ribbon above the worksheet? A. Picture B. Format C. Image D. None of the Above
B.
A new named range can be created by selecting the desired cells then A. typing the name directly in the Name box to the left of the formula bar B. right-clicking and selecting Define Name from the dialog that comes up C. using either of the techniques above
C.
PivotCharts have four contextual tabs. Which tab contains the Shape Styles section? A. Design B. Layout C. Format D. Analyze
C.
The keyboard shortcut to copy data to be pasted in another spot is Ctrl+ A. A B. B C. C
C.
To put a database into your worksheet, what type of Office document would you link to? A. Microsoft PowerPoint B. Microsoft Word C. Microsoft Access D. None of the Above
C.
What are the steps to opening Solver after the Add-In has been installed? A. Home tab --> Number section --> Solver B. Insert tab -> Tools -> Solver C. Data tab -> Analysis section --> Solver
C.
What is the icon for the tool that marks a workbook as final?
C.
What is the keyboard shortcut to create italicized text? A. ctrl+shift+I B. shift+I C. ctrl+I D. alt+I
C.
Which button would you click on to see more Find options? A. Find All B. Find Next C. Options >>
C.
Which keyboard shortcut creates a chart of the data in the current range in a separate chart sheet? A. F9 B. F10 C. F11 D. F12
C.
Which of the following commands will find the sum of cells A1:A10 (ignoring nothing)? A. =AGGREGATE(9,A1:A10) B. =AGGREGATE(9,1,A1:A10) C. =AGGREGATE(9,4,A1:A10) D. =AGGREGATE(9,7,A1:A10)
C.
Which ribbon tab can the Changes group be found on? A. File B. Formulas C. Review
C.
template file What is the file extension for a without macros? A. xlsx B. .xlsm C. xltx D. xltm
C.
If you delete the worksheet or workbook a cell is linked to, what error code appears? that A. #ERROR! B. REF C. ERROR D. #REF!
D.
In the Macros dialog, which tool creates a new macro? A. Run B. Step Into C. Edit D. Create
D.
Which keyboard shortcut opens the Print Preview dialog? A. Ctrl+U B. Ctrl+O C. Ctrl+H D. Ctrl+P
D.
Which keyboard shortcut toggles between displaying cell values and cell formulas in the worksheet? A. Ctrl+shift+accent B. Ctrl+Alt+accent Shift+ accent D. Ctrl+accent
D.
Which of the following are Data Analysis tools that Excel offers? A. Covariance B. Exponential Smoothing C. Histogram D. All of the Above
D.
