CSC final
Studied by 1 person
Learn
Practice Test
Spaced Repetition
Match
Flashcards1/119
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
120 Terms
Which of the following functions inserts the total of a range?
Group of answer choices
SUM
ROUND
AVERAGE
AUTOSUM
SUM
To combine multiple cells into one and center its content, you change the cells' style.
Group of answer choices
True
False
false
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
Group of answer choices
The formula =TOTAL(B6-B10)
The formula +SUM(B6-B10)
The formula =B6+B7+B8+B9+B10.
The formula =SUM(B6:B10)
The formula =SUM(B6:B10)
When you cut or copy a cell, it is cut or copied to which of the following?
Group of answer choices
Only the Office Clipboard
Only the Windows Clipboard
Both the Windows and Office Clipboard
Neither the Windows or Office Clipboard
Both the Windows and Office Clipboard
1
How many actions does the Undo button let you reverse?
Group of answer choices
75
50
100
24
100
A predesigned combination of formats, such as font size and color, is called a cell default.
Group of answer choices
True
False
false
The default worksheet text is _____-point Calibri.
Group of answer choices
11
10
12
14
11
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
Group of answer choices
Clipboard
Name box
Worksheet window
Backstage
Clipboard
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
Group of answer choices
Page Break Preview
mode indicator
Fill handle
scroll bar
Fill handle
To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.
Group of answer choices
General
Percentage
Accounting
Currency
Accounting
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
Group of answer choices
True
False
True
Which of the following tabs lets you set worksheet print options?
Group of answer choices
Home
View
File
Page Layout
file
Which of the following can you use to insert a formula using a function?
Group of answer choices
Copy and paste a cell containing a function
AutoSum button on the Ribbon
Insert Function dialog box
AutoSum list arrow on the Ribbon
Copy and paste a cell containing a function
AutoSum button on the Ribbon
Insert Function dialog box
AutoSum list arrow on the Ribbon
To change the color of cell content, you use the ________ color list arrow.
Group of answer choices
Pattern
Text
Cell
Font
font
Where can you see a preview of how your worksheet will look when printed, including headers?
Group of answer choices
File preview
Page Break preview
Print tab in Backstage view
Normal view
Print tab in Backstage view
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
Group of answer choices
Page Layout
View
Home
Insert
Page Layout
To customize the status bar, right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.
Group of answer choices
False
True
true
Which of the following lets you search for a function or select one from a category?
Group of answer choices
formula bar
clipboard
Insert Function dialog box
Function Arguments dialog box
Insert Function dialog box
When you double-click a cell's right column border, which of the following occurs?
Group of answer choices
AutoFit resizes the column to the widest cell entry.
AutoFit resizes the column to 8.43 characters wide.
The column is deleted.
A column is added to the right of the column's border.
AutoFit resizes the column to the widest cell entry.
Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.
Group of answer choices
Insert tab
Format Cells dialog box
Home tab
Mini toolbar
Format Cells dialog box
Home tab
Mini toolbar
To apply formats to data when it meets criteria you specify, you can use conditional formatting.
Group of answer choices
True
False
well yes
Which of the following is true of the Excel spell checker?
Group of answer choices
You can change all instances of a flagged word to a selected suggestion.
For multiple instances of a misspelled word, you must change each one individually.
You must accept all spell checker suggested replacement words.
You cannot add words to the spell checker dictionary.
You can change all instances of a flagged word to a selected suggestion.
Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation: File < Options < X < Manual?
Group of answer choices
Proofing
Language
Formulas
Advanced
Formulas
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.
Group of answer choices
False
True
well no
Which of the following is true about entering a function using the Insert Function dialog box?
Group of answer choices
You can select a function you've recently used.
You can search for a function that meets your needs.
You don't need to type an equal sign to begin the formula.
You open the dialog box by typing "function" in the formula bar.
You can select a function you've recently used.
You can search for a function that meets your needs.
You don't need to type an equal sign to begin the formula.
You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.
Group of answer choices
cut
deleted
conditionally formatted
hidden
hidden
Which of the following is true about adding cell borders?
Group of answer choices
You can only apply a border to the bottom of a cell.
You cannot apply borders to all worksheet cells.
A cell border extends the width of the cell.
A cell border underlines the cell text, not the entire cell.
A cell border extends the width of the cell.
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?
Group of answer choices
Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.
Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.
Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.
Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.
Group of answer choices
False
True
well yes
To enter a range of text based on examples that are already in your worksheet, which of the following can you use?
Group of answer choices
What-if analysis
Flash fill
Quick Analysis tools
Business Intelligence
Flash fill
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
Group of answer choices
one
three
four
two
2
Which of the following statements is true about COUNT functions?
Group of answer choices
The COUNT function returns the number of calls in a range that contain numeric da
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 any data at all.
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 numeric da
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?
Group of answer choices
Change
Ignore All
Ignore Once
Change All
Ignore All
Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.
Group of answer choices
center
left
bold
underline
left
To change a range's conditional formatting from data bars to icon sets, which of the following can you do?
Group of answer choices
Edit the conditional formatting rule.
Delete the conditional formatting rule.
Format the range as a table.
Format the range in the Font dialog box.
Edit the conditional formatting rule.
What feature inserts a function that totals the cells above or to the left of the selected cell?
Group of answer choices
mode indicator
AutoSum button
absolute reference
reference operator
AutoSum button
In formulas, calculations in square brackets are calculated first.
Group of answer choices
True
False
well no
Where can you see a brief description of a selected function?
Group of answer choices
Insert Function dialog box
Formula bar
Insert tab
Insert dialog box
Insert Function dialog box
In a complex formula, how does Excel determine which calculation to perform first?
Group of answer choices
It calculates the leftmost formulas first.
It calculates operations outside parentheses first.
It follows the order of operations.
It calculates functions first.
It follows the order of operations.
When you change cell contents to italics, you are changing the cell's alignment.
Group of answer choices
True
False
well no
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?
Group of answer choices
If it needs an absolute cell reference.
If it needs a relative cell reference.
If it needs landscape orientation.
If it needs a function.
If it needs an absolute cell reference.
Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change?
Group of answer choices
Axes
Analysis
Background
Labels
Analysis
To make your workbooks usable by people with disabilities, you can add alternative text to worksheet images.
Group of answer choices
True
False
well yes!
Which of the following is true about changing worksheet column width?
Group of answer choices
In Normal view, the Column Width dialog box lets you set column width to an exact value in inches.
In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels.
When you drag the right column border in Normal view, a ScreenTip displays the exact width in inches.
In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
Which of the following is not a way to move cell contents?
Group of answer choices
drag-and-drop
the fill handle in the lower-right corner of an active cell or range
the CTRL key + the Move pointer
the Cut and Paste buttons on the Home tab
the fill handle in the lower-right corner of an active cell or range
To copy a cell's formatting to another cell, which of the following can you use?
Group of answer choices
Format as Table
Format Painter
Quick Analysis Tool
Format Cells dialog box
Format Painter
You double-click the Format Painter button when you want to _____.
Group of answer choices
clear a cell's formatting
use conditional formatting
copy a cell's format to more than one cell
copy a cell's format to only one cell
copy a cell's format to more than one cell
Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click) Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?
Group of answer choices
Labels
Number
Tick Marks
Text Options
Number
To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.
Group of answer choices
True
False
well yes
Which of the following is true when you copy and paste formulas using the fill handle?
Group of answer choices
The Paste Options button lets you paste only specific elements of the copied selection.
You need to change the cell references to reflect the new formula location.
The formula is placed on the Office clipboard.
The AutoFill Options button lets you fill cells with specific elements of the copied cell.
The AutoFill Options button lets you fill cells with specific elements of the copied cell.
To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.
Group of answer choices
False
True
well yes
Why is it necessary to use care when inserting worksheet cells?
Group of answer choices
It may disturb row or column alignment, which can affect worksheet accuracy.
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.
Which of the following is true about moving cell contents?
Group of answer choices
You can move cells using the Copy command.
You can move cells using the drag-and-drop feature.
When you move cell contents, they remain in their original location.
You cannot move cells from one worksheet to another.
You can move cells using the drag-and-drop feature.
You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true?
Group of answer choices
After you paste it, the information is deleted from the original location.
Before you paste it, you need to select C1:C5.
Before you paste it, you only need to select cell C1.
After you paste it, the information is deleted from the Clipboard.
After you paste it, the information is deleted from the original location.
Before you paste it, you only need to select cell C1.
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?
Group of answer choices
Over Chart
Below Chart
Centered Overlay
Above Chart
Centered Overlay
When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.
Group of answer choices
False
True
well yes
Which of the following is true about deleting a worksheet row?
Group of answer choices
To delete a row, you can select the row, then press the DELETE key on the keyboard.
If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.
After you delete a row, the rows below it shift down one row.
To delete a row, you can select the row, then use the Delete button in the Cells group.
To delete a row, you can select the row, then use the Delete button in the Cells group.
To preserve an exact cell address in a copied formula, you can use a relative cell reference.
Group of answer choices
True
False
well no
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
Group of answer choices
Page Layout
View
Home
Insert
Page Layout
If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?
Group of answer choices
The Enter button on the Formula bar
The Undo button on the Quick Access toolbar
The Cancel button on the Formula bar
The Save button on the Quick Access toolbar
The Undo button on the Quick Access toolbar
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
Group of answer choices
True
False
well yes
When you underline cell content, you are using _____.
Group of answer choices
a centering style
an orientation setting
a font style
an indent setting
a font style
Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer. He can do so by clicking on Page Layout > Save As > (Enter name in ) File name box > Save As type list > PDF > Minimum Size (publishing online) > Options > OK > Save.
Group of answer choices
True
False
well no
The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.
Group of answer choices
False
True
well yes
A _______ refers to a collection of characters with a similar, specific design.
Group of answer choices
symbol
font
point
keyword
font
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
Group of answer choices
Change the page orientation to landscape.
Hide the column headings.
Copy columns to the next page.
Insert a function.
Change the page orientation to landscape.
To find the largest value in a cell range, use the MIN function.
Group of answer choices
False
True
well no
To have Excel enter the lowest price from a range of prices, which of the following would you use?
Group of answer choices
COUNT function
COUNTA function
MAX function
MIN function
MIN function
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
Group of answer choices
Clipboard
Backstage
Worksheet window
Name box
Clipboard
Which of the following tabs lets you set worksheet print options?
Group of answer choices
Home
Page Layout
File
View
File
To fit all worksheet content on one page, you can set page scaling in Backstage view.
Group of answer choices
True
False
well yes
Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?
Group of answer choices
Color
Shape
Style
Border
Style
Which of the following functions would you use to calculate the arithmetic mean of a price list?
Group of answer choices
AVERAGE
COUNT
MAX
SUM
AVERAGE
To customize the status bar, right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.
Group of answer choices
True
False
well yes
In the formula =SUM(A6:A9), which of the following best describes A6?
Group of answer choices
argument
function
label
active cell
argument
Which of the following lets you edit the contents of a cell?
Group of answer choices
Double-click the cell, click in the status bar, or just start typing.
Click the cell and click in the status bar.
Double-click the cell or click in the formula bar.
Click the cell, click the status bar, and press Enter.
Double-click the cell or click in the formula bar.
To print a worksheet, you begin by going to Backstage view.
Group of answer choices
False
True
well yes
When you copy and paste a formula to a new location, the formula's relative references do not change.
well no
Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?
F9
When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.
well no
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.
well yes
You can apply date formats to cells by using the Date category in the Format Cells dialog box.
well yes
To enter a range of text based on examples that are already in your worksheet, which of the following can you use?
Flash fill
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
2
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
color
To accept a suggested spelling for that instance only, which of the following would you click?
Change
Changing a worksheet window to Normal view changes the contents of the worksheet.
no
Which of the following is true about entering a function using the Insert Function dialog box?
You can search for a function that meets your needs.
You can select a function you've recently used.
You don't need to type an equal sign to begin the formula.
To view a worksheet without headers, margins, and rulers, use Page Layout view.
no
To enter data in a cell using examples already in your workbook, you can use the flash fill feature.
yes
You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.
hidden
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.
hide
Which of the following statements is true about COUNT functions?
The COUNT function returns the number of calls in a range that contain numeric da
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
Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.
left
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)
In the formula =A8*$A$1, which of the following describes A8?
Relative cell reference