Font size
WorksheetsMicrosoft Excel II
Total questions: 42
Worksheet time: 21mins
To apply formats to data when it meets criteria you specify, you can use conditional formatting.
True
False
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.
True
False
Changing a worksheet window to Normal view changes the contents of the worksheet.
True
False
To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.
True
False
You can apply date formats to cells by using the Date category in the Format Cells dialog box.
True
False
To enter data in a cell using examples already in your workbook, you can use the flash fill feature.
True
False
Currency is an example of a number format.
True
False
When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.
True
False
Jim frequently prints out the same section of a worksheet. To do so, he selects the cells he wants to define as print area, then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.
True
False
In formulas, calculations in square brackets are calculated first.
True
False
To view a worksheet without headers, margins, and rulers, use Page Layout view.
True
False
When you copy and paste a formula to a new location, the formula's relative references do not change.
True
False
To change the background color of a cell, you use the Background color button.
True
False
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.
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)
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
Where can you see a brief description of a selected function?
Formula bar
Insert Function dialog box
Insert dialog box
Insert tab
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
You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _______.
hidden
cut
conditionally formatted
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)
=DCOUNTA(B1:B20)
Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation?
Formulas
Proofing
Language
Advanced
Which of the following inserts a function into a cell?
mode indicator
AutoSum button
argument
formula prefix
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
To help you easily identify sheets in a workbook, you can add ______ to the sheet tab.
Fonts
Color
Styles
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.
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
What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?
Formulas
Proofing
Language
Advanced
What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?
Formulas
Proofing
Language
Advanced
Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?
Calculate Now
Calculate Sheet
Watch Window
Calculation Options
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 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
Clicking the Percentage style in the Number Format list applies ____ decimal places by default.
one
two
three
four
In the formula =A8*$A$1, which of the following describes A8?
Relative cell reference
Absolute cell reference
Function
AutoSum
Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?
F5
F9
F10
F12
The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?
Change All
Change
Ignore Once
Ignore All
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.
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
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 are ways to align cell contents in relation to cell edges? Select all the options that apply.
left
center
bold
underline
Which of the following is true about entering a function using the Insert Function dialog box?
You open the dialog box by typing "function" in the formula bar.
You can search for a function that meets your needs.
You don't need to type an equal sign to begin the formula.
You can select a function you've recently used.
