Font size
WorksheetsSpring 24 BIM I Final Exam Review
Total questions: 100
Worksheet time: 50mins
How many actions does the Undo button let you reverse?
24
50
75
100
If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?
The Undo button on the Quick Access toolbar
The Cancel button on the Formula bar
The Enter button on the Formula bar
The Save button on the Quick Access toolbar
In the formula =SUM(A6:A9), which of the following best describes A6?
argument
function
label
active cell
On which tab and button are document properties located for editing?
File tab, Info Button
View tab, Show button
Review tab, Changes button
Home tab, Alignment button
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Layout
Insert
View
Home
To combine multiple cells into one combined cell, which of the following do you use?
Column Width command
Center button
Merge and Center button
Increase Indent button
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MAX function
COUNT function
MIN function
COUNTA function
To print more than one copy of your worksheet, which tab would you go to?
View
Page Layout
Insert
File
To print your worksheet at its actual size, which of the following would you select?
Fit to
No scaling
Fit sheet to one page
Scale to fit
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
Home
Page Layout
Insert
View
To see a preview of how a pasted value will look, which of the following would you use?
Fill button
AutoFill Options button
Paste button
Paste List arrow
To select a single worksheet cell so you can work with it, which of the following would you do?
Click the cell.
Move the cell pointer over the cell.
Click the status bar.
Click the Name box.
When you cut or copy a cell, it is cut or copied to which of the following?
Neither the Windows or Office Clipboard
Both the Windows and Office Clipboard
Only the Office Clipboard
Only the Windows Clipboard
Where can you see a preview of how your worksheet will look when printed, including headers?
Print tab in Backstage view
Page Break preview
Normal view
File preview
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
The formula =B6+B7+B8+B9+B10
The formula =TOTAL(B6:B10)
The formula =SUM(B6:B10)
The formula =SUM(B6-B10)
Which of the following functions inserts the total of a range?
ROUND
AUTOSUM
AVERAGE
SUM
Which of the following would you use to calculate the arithmetic mean of a price list?
MAX
COUNT
SUM
AVERAGE
Which of the following is a built-in formula that helps you perform complex calculations?
clipboard
mode indicator
named range
function
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
Clipboard
Backstage
Name box
Worksheet window
Which of the following lets you search for a function or select one from a category?
Function Arguments dialog box
clipboard
formula bar
Insert Function dialog box
Which of the following tabs lets you see exactly how your worksheet looks before printing?
Insert
View
Formulas
File
Which of the following tabs lets you set worksheet print options?
File
Home
Page Layout
View
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?
Normal pointer
I-beam pointer
Move pointer
Copy pointer
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
mode indicator
Page Break Preview
scroll bar
Fill handle
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
Hide the column headings.
Insert a function.
Copy columns to the next page.
Change the page orientation to landscape.
A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?
=COUNT(B1:B20)
=COUNTIF(B1:B20)
=COUNTA(B1:B20)
=DCOUNT(A1:B20)
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
one
two
three
four
In a complex formula, how does Excel determine which calculation to perform first?
It calculates the leftmost formulas first.
It calculates operations outside parentheses first.
It follows the order of operations.
It calculates functions first.
In the formula =A8* A 1, which of the following describes A8?
A. Relative cell reference
B. Absolute cell reference
C. Function
D. AutoSum
Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?
=COUNT(B1:B20)
=COUNTIF(B1:B20)
=SUM(B1:B20)
=CALCULATE(B1:B20)
Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?
Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.
Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.
Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.
To accept a suggested spelling for that instance only, which of the following would you click?
Change
Change All
Ignore Once
Add to Dictionary
To change a range's conditional formatting from data bars to icon sets, which of the following can you do?
Delete the conditional formatting rule.
Edit the conditional formatting rule.
Format the range in the Font dialog box.
Format the range as a table.
To enter a range of text based on examples that are already in your worksheet, which of the following can you use?
Business Intelligence
Flash fill
Quick Analysis tools
What-if analysis
To format a range so that all values greater than $500 appear in red, which of the following can you use?
conditional formatting
cell formatting
cell styles
Quick Access toolbar
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
Alignment
Fonts
Color
Styles
What feature inserts a function that totals the cells above or to the left of the selected cell?
AutoSum button
absolute reference
reference operator
mode indicator
When should you use relative cell references?
When you want to preserve the exact cell address in a formula.
When you want to preserve the relationship to the formula location.
When you want to insert a function.
When you want to enter sequential values in a range of cells.
Where can you see a brief description of a selected function?
Formula bar
Insert Function dialog box
Insert dialog box
Insert tab
Which of the following inserts a function into a cell?
mode indicator
AutoSum button
argument
formula prefix
Which of the following is true about adding cell borders?
You cannot apply borders to all worksheet cells.
A cell border underlines the cell text, not the entire cell.
A cell border extends the width of the cell.
You can only apply a border to the bottom of a cell.
Which of the following is true of the Excel spell checker?
You can change all instances of a flagged word to a selected suggestion.
You cannot add words to the spell checker dictionary.
You must accept all spell checker suggested replacement words.
For multiple instances of a misspelled word, you must change each one individually.
Which of the following statements is true about COUNT functions?
The COUNT function returns the number of calls in a range that are not blank.
The COUNT function returns the number of calls in a range that contain any data at all.
Using the COUNT function is useful for computing the average of a cell range.
The COUNT function returns the number of calls in a range that contain numeric data.
You receive a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is _____.
deleted
hidden
cut
conditionally formatted
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
Normal view
Page Layout view
Page Break Preview
Print Preview
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can ____ column C.
delete
conditionally format
edit
hide
Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?
Best Fit
Inside End
Outside End
Data Callout
For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?
To erase the cell value from the clipboard.
To paste the value’s number formatting only.
To paste all items on the clipboard.
To compute the results of a function.
How can you distinguish between a manually added page break and an automatic page break in a worksheet?
Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.
Automatic page breaks appear as curved lines while manual page breaks appear as jagged lines.
Automatic page breaks appear as dashed lines while manual page breaks appear as wavy lines.
Automatic page breaks appear as zigzag lines while manual page breaks appear as solid lines.
How can you remove data labels from a chart?
Uncheck the box beside Data Labels in Chart Elements.
Click on Remove on the options on the right side of Data Labels.
Click on Delete on the options on the right side of Data Labels.
Click to select the Data labels, then click on Edit and then Delete.
How can you remove Split panes in a worksheet you are working on?
Click the View tab in the Ribbon, then click the Split button in the Window group.
Click the Page Layout tab in the Ribbon, then click the Bring Forward button in the Arrange group.
Click the View tab in the Ribbon, then click the Split button and then the Hide button in the Window group.
Click the Page layout tab in the Ribbon, then click the Insert Breaks button and choose from the drop down menu in the Page Setup group.
In the formula =B6* B 2, which of the following describes B 2?
Relative cell reference
Absolute cell reference
Function
Average
To which of the following chart types can you not add axis titles?
Pie chart
Line chart
Area chart
Column chart
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
The Paste Options button then lets you paste specific elements of the copied cells.
The formula is copied with cell references you must adjust to avoid worksheet errors.
The Auto Fill Options button appears.
Pointing to the destination cell causes a preview of the cell contents to appear.
Which of the following is not a way to move cell contents?
The Cut and Paste buttons on the Home tab
the fill handle in the lower-right corner of an active cell or range
the CTRL key + the Move pointer
drag-and-drop
Which of the following is true about inserting cells in a worksheet?
Excel automatically adjusts cell references to reflect new formula locations.
You need to adjust cell references in all formulas that have moved.
You cannot insert cells in a worksheet.
Cells below the inserted cells are always moved downward.
Which of the following is true about moving cell contents?
You can move cells using the Copy command.
You cannot move cells from one worksheet to another.
When you move cell contents, they remain in their original location.
You can move cells using the drag-and-drop feature.
Which of the following is true when you copy and paste formulas using the fill handle?
The Paste Options button lets you paste only specific elements of the copied selection.
The AutoFill Options button lets you fill cells with specific elements of the copied cell.
The formula is placed on the Office clipboard.
You need to change the cell references to reflect the new formula location.
Which of the following is true when you delete a cell?
When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells.
Row and column alignment will not be affected.
You need to manually adjust cell references in surrounding formulas.
You can use the Delete command on the Insert tab.
Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+) sign > Arrow next to Chart title > X?
Above Chart
Over Chart
Below Chart
Centered Overlay
Is it necessary to use care when inserting worksheet cells?
It might automatically change the functions you are using.
It can change relative references to absolute references in formulas.
You will have to manually correct cell references in formulas.
It may disturb row or column alignment, which can affect worksheet accuracy.
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
A. A5
B. A 5
C. $A5
D. A$5
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?
If it needs an absolute cell reference.
If it needs a relative cell reference.
If it needs landscape orientation.
If it needs a function.
A student wants to round the number 24.7835 entered in cell A2 to two decimal places. Which of these formulas can she use to do so?
=ROUND(A5,2)
=MROUND(A5,2)
=ROUND(A5,20)
=MROUND(A5,0.2)
Boris wants to remove a workbook window from his workplace. What series of clicks can he use to hide it?
View tab > Window group > Hide
View tab > Window group > Split
View tab > Window group > View Side by Side
View tab > Window group > Switch Windows > Select a file
Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so?
View tab > Window group > Unhide
View tab > Window group > Uncheck box beside Hide > Check box beside Unhide
File > Options > Display > Check Show all windows in the Taskbar box
Home > Format > Visibility > Hide & Unhide > Hide Sheet
Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do to set up X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?
Click on the select button in Rows to repeat at top area and select a title row.
Click on the select button in Columns to repeat at left area and select a title row.
Click the check box before Row and column headings under Print.
Click the check box before Gridlines under Print.
Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her do so?
Sheet tab > Window group > Hide
Sheet tab > Window group > Freeze Panes > Hide
Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet
Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Rows
To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?
Icon sets
Themes
Top/Bottom Rules
Highlight Cells Rules
To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?
Leave the workbook closed.
Open the workbook, change the first worksheet, and save it using the Save command.
Open the workbook, make changes, and then save it using the same name.
Open the workbook, make changes, and then save it using a different name.
Where do you rename a workbook and adjust its save location?
Save As dialog box
Home tab
Name box
Active cell
Which of the following will you select as X in series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?
Icon Sets
Color Scales
Top/Bottom Rules
Highlight Cells Rules
Which of the following would you use to print only one page of a multipage worksheet?
Page Layout tab
Formulas tab
Backstage view
Page Setup dialog box
A worksheet named Income (2) is most likely which of the following?
a deleted worksheet
a worksheet with no calculations
a repositioned worksheet
a copy of another worksheet named Income
Ariana wants to view data from two workbooks at the same time so that one of them opens in a new window. What can she click to display one workbook in a new window?
View tab > Window group > New Window
View tab > Window group > Arrange All
View tab > Window group > Reset Window Position
View tab > Window group > Switch Windows > Select a file
Ian needs to extract the day from the date 5/31/2017 entered in cell A1. Which formula can he use to do this?
=DAY(A1)
=DAY("A1")
=DATE(DAY(A1))
=DATE(DAY("A1"))
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?
=HOUR(A1)
=HOUR("A1")
=HOUR("12:00:56")
=HOUR('12:00:56')
To enter your name in the lower right corner of a worksheet page, you can _____.
Use a button on the Header and Footer Tools Design tab.
Type your name in the Header and Footer Elements group.
Type your name in the lower right cell of the worksheet.
Select the right footer text box and type your name.
What is the correct formula to insert the date January 12, 1998 into a cell?
=DATE(1998,1,12)
=DATE(1998,12,1)
=DATE(12,1,1998)
=DATE(1/12/1998)
What will you do to explode a pie chart slice?
Right-click the pie chart, then click Change Series Chart Type, click Pie, and then click Pie of Pie.
Right-click the pie-chart, then click Change Series Chart Type, click Pie, and then click Bar of Pie.
Click the pie chart, then double-click the slice you want to explode, and drag it away from the center of the chart.
Click the pie chart, then double-click the slice you want to explode, and drag it away from the center of the chart.
Which formula can be applied for the given data in a cell A2: 01/01/2017 to get the serial number of the date as text?
=DATEVALUE(1-Jan-2017)
=DATEVALUE(01/01/2017)
=DATEVALUE(1st Jan, 2017)
=DATEVALUE("01/01/2017")
Which formula can you use to extract the month from the date in cell F5: 2016 July 8th?
=MONTH(F5)
=MONTH("F5")
=MONTH(DATE(2016,7,0))
=MONTH(DAY(2016,7,0))
Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?
=MINUTE(G5)
=MINUTE(G5)
=MINUTE("10:00:56")
=MINUTE('10:00:56')
Which of the following lets you fill a cell with only specific elements of a copied cell?
relative cell reference
Auto Fill Options button
argument
mode indicator
Which of the following methods copies an existing worksheet within the same workbook?
Drag its sheet tab to a new location.
Press and hold CTRL and drag its sheet tab to a new location.
Press and hold SHIFT and drag its sheet tab to a new location.
Press and hold ALT and drag its sheet tab to a new location.
Which of these combination of keys will you press to switch between two workbook windows?
Ctrl + Alt
Alt + Tab
Ctrl + Alt + Tab
Ctrl + Shift + Alt
Which worksheet view shows headers, footers, and rulers?
Normal view
Page Break Preview
Page Layout view
Formula view
You can edit a worksheet footer in _____
Page Layout view
Normal view
Page Break Preview
Print Preview
If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.
themes
icon sets
data bars
cell styles
To illustrate different data levels using small graphics representing values, which of the following can you use?
icon sets
data bars
Highlight Cells Rules
color scales
What will you select as X in the following series of clicks/entries/selections to apply a table style: Select cell to format as table > X > Format as table > Desired table style?
Data tab
Insert tab
Home tab
Review tab
Which dialog box opens after selecting a cell in the list of prepared data, clicking the Insert tab on Ribbon and then clicking the Table command in the Tables group?
New Table
Insert Table
Create Table
Include Table
Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?
Total Row
Header Row
Footer Row
Banded Rows
Which of the following can help you quickly format a cell range with labels in the left column and top row, and totals in the bottom row?
table style
cell style
font style
number format
Which of the following keys will you press when the cell cursor is in the last cell of the last record (row) to add new data for the next record?
Esc
Ctrl
Tab
Shift
Which of the following will you do to manually turn off autofilter in a table between the steps: Clicking any cell in the filtered range and clicking the Filter button?
Clicking the Data tab on the Excel Ribbon
Clicking the Insert tab on the Excel Ribbon
Clicking the Review tab on the Excel Ribbon
Clicking the Formulas tab on the Excel Ribbon
Which of the following will you do to reapply a filter to a table after the steps: Selecting any cell in the filtered table and clicking the Data tab?
Clicking Subtotal in the Outline group
Clicking Reapply in the Sort & Filter group
Clicking Consolidate in the Data Tools group
Clicking Refresh All in the Connections group
Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?
Tools group
Themes group
Page Setup group
Background group
Which of the following will you select as X in the following series of clicks to format a range as a table: Home tab > Styles group > X > Table Styles?
Cell Style
Cell Effects
Format as Table
Conditional Formatting
A workbook template has which of the following file extensions?
.xltx
.xls
.xlsx
.xlt
