WorksheetsExcel Functions Quiz
Total questions: 54
Worksheet time: 2hrs 54mins
To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.
True
False
Penina wants to insert markers into a sparkline chart. To do so, she can click on the following: Sparkline chart > Design > Line > Markers check box.
True
False
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.
True
False
To move a worksheet, you can drag its sheet tab to the left or right.
True
False
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then select Insert, select Line Sparkline from the Sparklines group and then OK.
True
False
To paste only a copied cell's formats, use the Paste Special command.
True
False
Jose inserts the formula '=DATE(2000, 2, 2)' in cell A15. Upon pressing ENTER, 2/2/2000 will appear in A15.
True
False
You can repeatedly paste an item from the Office Clipboard as many times as you like.
True
False
Arrow keys can be used to move any chart element.
True
False
Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.
True
False
Decreasing a cell's indent moves its contents to the right one space.
True
False
Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style).
True
False
Jack wants to insert a Win/Loss sparkline in Excel. To do this, he can click on the cell he wants to insert a Sparkline in, then click Apps tab, select Win/Loss Sparkline from the Sparklines group and then click OK.
True
False
There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.
True
False
To edit placeholder text in a chart element, select the cell whose placeholder text you want to edit, on Ribbon, click Data > Data Validation > Data Validation > Input Message tab and edit the text in the box.
True
False
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
View tab > Windows group > Freeze Panes > Freeze Top Column > Arrange All
View tab > Windows group > Freeze Panes > Unfreeze Panes> Arrange All
View tab > Windows group > Freeze Panes > Freeze First Column > Unfreeze Panes
Which of the following is true about deleting a worksheet row?
After you delete a row, the rows below it shift down one row.
To delete a row, you can select the row, then press the DELETE key on the keyboard.
To delete a row, you can select the row, then use the Delete button in the Cells group.
If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.
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.
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
True
False
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.
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.
To rotate cell contents to an exact value, you change its (a) .
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?
Axes
Labels
Analysis
Background
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")
=OR(B2>=60, "Pass", "Fail")
=AND(B2>=60, "Pass", "Fail")
=NOT(OR(B2>=60, "Pass", "Fail"))
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 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 left of the page break you want to delete.
Select the column to the right of the page break you want to delete.
Select the row above the page break you want to delete.
Select the row below the page break you want to delete.
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 > Freeze Top Row
Row 3 > View tab > Windows group > Freeze Panes > Freeze Panes
Row 4 > View tab > Windows group > Freeze Panes > Freeze Top Row > Arrange All
Row 3 > View tab > Windows group > Freeze Panes > Freeze First Column > View Side by Side
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
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?
=IFNA(...)
=XOR(...)
=IFERROR(...)
=TRUE OR FALSE(...)
Which chart is not an option in MS Excel?
Pie chart
Line chart
Area chart
Column chart
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 > Split.
Select rows 2 to 16 and click View tab > Window group > Split.
Select rows 2 to 16 and click View tab > Window group > New Window > Split.
Select row 16 and click View tab > Window group > Split > Arrange All.
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.
Helga wants to reset page breaks in a worksheet to display only automatic page breaks. Which of these can she select and X 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: Normal, Y: Print Area
X: Page Layout, Y: Print Tiles
X: Page Break Preview, Y: Breaks
X: Custom Views, Y: Background
To select nonadjacent cells or ranges on a worksheet, you can press and hold ______ while selecting each one.
CTRL
ALT
SHIFT
ESC
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
Why 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.
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.
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 update.
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?
Pie
Bar
Line
Column
Which of the following is true about changing worksheet column width?
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 Normal view, a ScreenTip displays the exact width in inches.
When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels.
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?
A5
$A$5
$A5
A$5
To remove the Data Labels in Chart Elements, which of the following steps is correct?
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.
To copy a cell's formatting to another cell, which of the following can you use?
Format Cells dialog box
Format Painter
Quick Analysis Tool
Format as Table
Arla wants to use goal seek to answer "what if" questions in a file. To do this, she clicks the cell in the spreadsheet that she 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
Data Validation
Consolidate
Relationships
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 row
a column
a button
conditional formatting
The basic unit of a worksheet into which you enter data in Excel is called a
cell
table
box
column
SHORT CUT FOR CUT
CTRL+C
CTRL+V
CTRL+D
CTRL+X
In Excel, all formulae must begin with ___________sign.
#
$
=
&
Which of these icons will increase decimal places?
A
B
C
D
A row is identified by which of the following?
Number
Letter
Symbol
None of the above
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
In Excel, Rows are labelled as ______
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
What are your strengths and weakness?
Tell us something about yourself?
