Excel module 1, 2, 3 complete exam
You can use the I-beam pointer to copy cell contents into adjacent cells. - ANSWER-False
Where do you rename a workbook and adjust its save location? - ANSWER-Save As dialog box
Which of the following lets you edit the contents of a cell? - ANSWER-Double-click the cell or click in
the formula bar.
When you enter a value in a worksheet cell, it is automatically left-aligned. - ANSWER-False
Which of the following is true about deleting a worksheet? Select all the options that apply. -
ANSWER-You can use the Delete list arrow in the Cells group on the Home tab.
You can right-click a sheet tab and click Delete.
Luis wants to unhide and view all rows and columns in a worksheet. Which of the following series of
clicks/entries/selections can he use to create a custom view of the worksheet? - ANSWER-
Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name ) >
Include in view (Tick check box- Hidden rows, columns and filter settings ) > OK
A worksheet named Income (2) is most likely which of the following? - ANSWER-A copy of another
worksheet named Income
Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her
do so? - ANSWER-Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide
Sheet
Changing a worksheet window to Normal view changes the contents of the worksheet. - ANSWER-
False
How many actions does the Undo button let you reverse? - ANSWER-100
Which of the following would you use to print only one page of a multipage worksheet? - ANSWER-
Backstage view
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is
pressed? - ANSWER-Copy pointer
To add a worksheet to a workbook, you would use the New formula tab below the worksheet. -
ANSWER-False
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
- ANSWER-Clipboard
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop. -
ANSWER-True
To paste a copied cell range, you only need to specify the upper right of the range where you want to
paste it. - ANSWER-False
Which of the following is true when you delete a cell? - ANSWER-When you delete cells using the
Delete list arrow, you can choose which way to move adjacent cells.
, To enter a range of text based on examples that are already in your worksheet, which of the following
can you use? - ANSWER-Flash fill
When you double-click a cell's right column border, which of the following occurs? - ANSWER-AutoFit
resizes the column to the widest cell entry
To print more than one copy of your worksheet, which tab would you go to? - ANSWER-File
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. - ANSWER-True
Which of the following is true about moving cell contents? - ANSWER-You can move cells using the
drag-and-drop feature.
Why is it necessary to use care when inserting worksheet cells? - ANSWER-It may disturb row or
column alignment, which can affect worksheet accuracy.
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? - ANSWER-COUNTA(B1:B20)
To view a worksheet without headers, margins, and rulers, use Page Layout view. - ANSWER-Normal
You can create conditional cell formats using either the Home tab or the _____. - ANSWER-Quick
Analysis tool
You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the _____
feature. - ANSWER-Find and Replace
Betty wants to choose the list to create a custom number format. To do so, what should she choose
after the following series of clicks? Home tab < Number group < Number Format list < More Number
Formats < Format Cells dialog box < Category < Custom - ANSWER-Type
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? - ANSWER-Select the column to the right of the page break you want to delete.
To align currency symbols and decimal points in a column of numbers, you can apply the ____
number format. - ANSWER-Accounting
To paste copied cell contents with values only, not including formatting, which of the following can
you use? - ANSWER-Paste list arrow
Paste option icon
Paste Preview
To paste a data range so that column data appears in rows and row data appears in columns, you can
_____ the data using the Paste list arrow. - ANSWER-Transpose
To apply a cell style, you would use the Cell Styles command on the _____ tab. - ANSWER-Home
Igor wants to set margins for a worksheet he has created per his choice. Which of these will he select
as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list >
Y > Specify choice for Top, Header, Left, Right, Bottom and Footer text boxes > OK? - ANSWER-X-
Margins, Y-Custom Margins
To combine multiple cells into one combined cell, which of the following do you use? - ANSWER-
Merge and Center button
You can use the I-beam pointer to copy cell contents into adjacent cells. - ANSWER-False
Where do you rename a workbook and adjust its save location? - ANSWER-Save As dialog box
Which of the following lets you edit the contents of a cell? - ANSWER-Double-click the cell or click in
the formula bar.
When you enter a value in a worksheet cell, it is automatically left-aligned. - ANSWER-False
Which of the following is true about deleting a worksheet? Select all the options that apply. -
ANSWER-You can use the Delete list arrow in the Cells group on the Home tab.
You can right-click a sheet tab and click Delete.
Luis wants to unhide and view all rows and columns in a worksheet. Which of the following series of
clicks/entries/selections can he use to create a custom view of the worksheet? - ANSWER-
Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name ) >
Include in view (Tick check box- Hidden rows, columns and filter settings ) > OK
A worksheet named Income (2) is most likely which of the following? - ANSWER-A copy of another
worksheet named Income
Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her
do so? - ANSWER-Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide
Sheet
Changing a worksheet window to Normal view changes the contents of the worksheet. - ANSWER-
False
How many actions does the Undo button let you reverse? - ANSWER-100
Which of the following would you use to print only one page of a multipage worksheet? - ANSWER-
Backstage view
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is
pressed? - ANSWER-Copy pointer
To add a worksheet to a workbook, you would use the New formula tab below the worksheet. -
ANSWER-False
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
- ANSWER-Clipboard
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop. -
ANSWER-True
To paste a copied cell range, you only need to specify the upper right of the range where you want to
paste it. - ANSWER-False
Which of the following is true when you delete a cell? - ANSWER-When you delete cells using the
Delete list arrow, you can choose which way to move adjacent cells.
, To enter a range of text based on examples that are already in your worksheet, which of the following
can you use? - ANSWER-Flash fill
When you double-click a cell's right column border, which of the following occurs? - ANSWER-AutoFit
resizes the column to the widest cell entry
To print more than one copy of your worksheet, which tab would you go to? - ANSWER-File
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. - ANSWER-True
Which of the following is true about moving cell contents? - ANSWER-You can move cells using the
drag-and-drop feature.
Why is it necessary to use care when inserting worksheet cells? - ANSWER-It may disturb row or
column alignment, which can affect worksheet accuracy.
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? - ANSWER-COUNTA(B1:B20)
To view a worksheet without headers, margins, and rulers, use Page Layout view. - ANSWER-Normal
You can create conditional cell formats using either the Home tab or the _____. - ANSWER-Quick
Analysis tool
You want to change all worksheet occurrences of "Radio" to "TV"; to do this, you can use the _____
feature. - ANSWER-Find and Replace
Betty wants to choose the list to create a custom number format. To do so, what should she choose
after the following series of clicks? Home tab < Number group < Number Format list < More Number
Formats < Format Cells dialog box < Category < Custom - ANSWER-Type
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? - ANSWER-Select the column to the right of the page break you want to delete.
To align currency symbols and decimal points in a column of numbers, you can apply the ____
number format. - ANSWER-Accounting
To paste copied cell contents with values only, not including formatting, which of the following can
you use? - ANSWER-Paste list arrow
Paste option icon
Paste Preview
To paste a data range so that column data appears in rows and row data appears in columns, you can
_____ the data using the Paste list arrow. - ANSWER-Transpose
To apply a cell style, you would use the Cell Styles command on the _____ tab. - ANSWER-Home
Igor wants to set margins for a worksheet he has created per his choice. Which of these will he select
as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list >
Y > Specify choice for Top, Header, Left, Right, Bottom and Footer text boxes > OK? - ANSWER-X-
Margins, Y-Custom Margins
To combine multiple cells into one combined cell, which of the following do you use? - ANSWER-
Merge and Center button
