Font size
WorksheetsBBSKJNDEJDOIE
Total questions: 46
Worksheet time: 27mins
To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.
Currency
Accounting
Percentage
General
Which of the following tabs lets you set worksheet print options?
Page Layout
Home
File
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.
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
The default worksheet text is (a) -point Calibri.
where can you see a preview of how your worksheet will look when printed, included nheaders
print tab in backstage view
page break preview
normal view
To apply a cell style, you would use the Cell Styles command on the (a) 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.
When you double-click a cell's right column border, which of the following occurs?
The column is deleted.
AutoFit resizes the column to 8.43 characters wide.
A column is added to the right of the column's border.
AutoFit resizes the column to the widest cell entry.
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.
Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?
(a)
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
1
2
3
4
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(...)
To enter a range of text based on examples that are already in your worksheet, which of the following can you use?
(a)
Which of the following is not a way to move cell contents?
the Cut and Paste buttons on the Home tab
the fill handle in the lower-right corner of an active cell or range
the CTRL key + the Move pointer
drag-and-drop
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
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?
Hide the column headings.
Change the page orientation to landscape.
Insert a function.
To change the name of a worksheet, you rename the (a) .
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
(a)
Where can you see a brief description of a selected function?
(a)
Which of the following is a built-in formula that helps you perform complex calculations?
clipboard
mode indicator
named range
function
To return cell contents to its default font and style, you can use the _____ command.
Clear Formats
Clear Contents
Clear All
When you underline cell content, you are using _____.
a centering style
an indent setting
an orientation setting
a font style
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
To change the color of cell content, you use the ________ color list arrow.
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?
How can you remove data labels from a chart?
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.
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
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
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.
hide
conditionally format
delete
Which of the following functions would you use to calculate the arithmetic mean of a price list?
(a)
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
Data Callout
Outside End
To accept a suggested spelling for that instance only, which of the following would you click?
Change
Change All
Ignore Once
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.
You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.
deleted
hidden
To delete a worksheet column, you can first select it by _____.
double-clicking anywhere in the column
clicking anywhere in the column
double-clicking the column heading
clicking the column heading
Which of the following is true of the Excel spell checker?
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
Why is it necessary to use care when inserting worksheet cells?
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?
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?
To select a single worksheet cell so you can work with it, which of the following would you do?
What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?
For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?
To compute the results of a function.
To paste all items on the clipboard.
To erase the cell value from the clipboard.
o paste the value's number formatting only.
To which of the following chart types can you not add axis titles?
Which of the following lets you edit the contents of a cell?
Double-click the cell, click in the status bar, or just start typing.
Double-click the cell or click in the formula bar.
lick the cell, click the status bar, and press Enter.
Click the cell and click in the status bar.
