CGS 1060 Exam
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?
Analysis
To copy a cell's formatting to another cell, which of the following can you use?
Format Painter
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
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
Change the Page Orientation to landscape
Which of the following lets you edit the contents of a cell?
Double-click the cell or click in the formula bar
To change a range's conditional formatting from data bars to icon sets, which of the following can you do?
Edit the conditional formatting rule
Which of the following is true about inserting cells in a worksheet?
Excel automatically adjust cell references to reflects new formula locations
Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?
F9
To print more than one copy of your worksheet, which tab would you go to?
File
Which of the following tabs lets you see exactly how your worksheet looks before printing?
File
Which of the following tabs lets you set worksheet print options?
File
On which tab and button are document properties located for editing?
File tab Info button
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
Fill handle
To enter a range of text based on examples that are already in your worksheet, which of the following can you use?
Flash Fill Button
A _______ refers to a collection of characters with a similar, specific design.
Font
When you underline cell content, you are using _____.
Font style
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
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?
Formulas
Which of the following is a built-in formula that helps you perform complex calculations?
Functions
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
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Home
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
Which of the following is true about changing worksheet column width?
In normal view the column width dialog box let you set the exact number if characters that will fit in the column
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MIN function
To combine multiple cells into one combined cell, which of the following do you use?
Merge and Center button
To print your worksheet at its actual size, which of the following would you select?
No Scaling
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?
Number
The Clipboard task pane shows the contents of the _____.
Office clipboards
To change the name of a worksheet, you rename the _____.
Sheet tab
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?
=COUNTA(B1:B20)
The default worksheet text is _____-point Calibri.
11
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)
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$5
How many actions does the Undo button let you reverse?
100
The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59. Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B?
=IF(B2<59,F,IF(B2<69,D,IF(B2<79,C,IF(B2<89,B,A)
The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed?
=IF(B2>60,Pass,Fail)
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
=SUM(B6:B10)
Nathan wants TRUE to be elicited if either of the statements are true, and FALSE if both are true. Which of the following formula can he use to ensure that?
=XOR
Which of the following is true about adding cell borders?
A cell border extends the width of the cell
You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?
A column
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
In the formula =B6*$B$2, which of the following describes $B$2?
Absolute cell reference
When you double-click a cell's right column border, which of the following occurs?
AutoFits resizes the column to the widest cell entry
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
What feature inserts a function that totals the cells above or to the left of the selected cell?
Autosum button
Which of the following inserts a function into a cell?
Autosum button
Which of the following functions would you use to calculate the arithmetic mean of a price list?
Average
When you cut or copy a cell, it is cut or copied to which of the following?
Both the Windows of Office Clipboard
To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.
CTRL
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
To change the color of cell content, you use the ________ color list arrow.
Cell
To accept a suggested spelling for that instance only, which of the following would you click?
Change
To return cell contents to its default font and style, you can use the _____ command.
Clear Formats
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 normal
How can you remove Split panes in a worksheet you are working on?
Click the View tab in the Ribbon then click the Spilt button in the Window group
To select a single worksheet cell so you can work with it, which of the following would you do?
Click the cell.
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
Two
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
Clipboard
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
Color
Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?
Column
To format a range so that all values greater than $500 appear in red, which of the following can you use?
Conditions formatting
You double-click the Format Painter button when you want to _____.
Copy a cell format to more than one cell
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?
Copy pointer
To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.
Currency
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?
Data Callout
Where can you see a brief description of a selected function?
Insert Function dialog box
Which of the following lets you search for a function or select one from a category?
Insert Function dialog box
Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?
Insert Pie or Doughnut Chart
In a complex formula, how does Excel determine which calculation to perform first?
It follows the order of operations
Why is it necessary to use care when inserting worksheet cells?
It may disturb row or column alignment which can affect worksheet accuracy
To rotate cell contents to an exact value, you change its _____.
Orientation
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
Page Break Preview
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
Page Layout
To see a preview of how a pasted value will look, which of the following would you use?
Paste List arrow
Where can you see a preview of how your worksheet will look when printed, including headers?
Print tab in backstage view
What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?
Proofing
In the formula =A8*$A$1, which of the following describes A8?
Relative cell reference
Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet. Which of the following series of clicks will help her do so?
Row 4>View Tab >Windows group>Freeze panes
Which of the following functions inserts the total of a range?
SUM
Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?
Select row 17 and click view tab window group spilt
Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?
Select the column to the right of the page break you want to delete
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?
Style
Which of the following is true when you copy and paste formulas using the fill handle?
The AutoFill Options button lets you fills cells with specific elements of the copied cell
Which of the following statements is true about COUNT functions?
The COUNT function returns the numbers of calls in a range that contain numeric data
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
Which of the following is not a way to move cell contents?
The fill handle in the lower-right corner of an active cell or range
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
Which of the following is true about deleting a worksheet row?
To delete a row you can select the row then use the delete button in the cells group
For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?
To paste the value number formatting only
How can you remove data labels from a chart?
Uncheck the box beside Data labels in Chart elements
Sala wants to unfreeze the first column of his worksheet. Which of the following series of clicks will help him do so?
View tab>Windows group>Freeze Panes>Unfreeze Panes
Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek... from the drop down menu. What is X in the procedure?
What-if Analysis
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
When should you use relative cell references?
When you want to preserve the relationship to the formula location
Helga wants to reset page breaks in a worksheet to display only automatic page breaks. Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?
X-Page Break Preview Y-Breaks
Which of the following is true of the Excel spell checker?
You Can change all instances of a flagged word to selected suggestion
Which of the following is true about moving cell contents?
You can move cells using the Copy command
In the formula =SUM(A6:A9), which of the following best describes A6?
argument