NEW
Font size
WorksheetsMOS Excel Quiz 2
Total questions: 39
Worksheet time: 20mins
Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?
AVERAGE
AutoSum
COUNT
MAX
You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?
MIN
AVERAGE
COUNT
MAX
You want to calculate the number of nonblank cells in your worksheet. Which function should be used?
SUM
COUNTA
MIN
MAX
Which of the following statements accurately describes the default selection for AutoSum?
You must first make the selection before clicking AutoSum.
By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.
By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
AutoSum does not have a default selection.
The COUNT and MIN functions are examples of which category of functions?
Text
Statistical
Financial
Logical
The AVERAGE function returns the mean value in a range of selected cells.
True
False
The COUNT function returns the total number of cells in the selected range that contain both text and numbers.
True
False
The MAX function returns the total of all cells in the selected range of cells.
True
False
The MIN function returns the smallest value in a range of cells.
True
False
You must use the AutoSum button to enter a SUM function - you cannot type it manually in a cell.
True
False
Which of the following commands is used to insert a cell into a worksheet?
The Insert command in the Cells group on the Home tab.
The Format command in the Cells group on the Home tab
The Format Painter command in the Clipboard group on the Home tab
The Format command in the shortcut menu when you right-click a cell
You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which of the following alignment options should be used?
Center
Middle Align
Justify
Top Align
Which of the following can you NOT copy using Format Painter?
Font color
Bold
Font size
Cell content
You don't like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?
Apply another style to the cell.
Use the Undo Command.
Clear the cell's content.
Apply the Normal style to the cell.
Which of the following is NOT useful for changing the font size?
Font Size drop-down list
Increase Font Size button
Decrease Font Size button
Increase Indent button
When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.
True
False
When you point to defined styles in the Cell Styles gallery, you can preview the formatting that will be used when you apply each style.
True
False
Style attributes include fonts and font sizes, number formats, and borders and shading.
True
False
You cannot split a single worksheet cell that has not been merged.
True
False
After you select a color and apply it to a cell's background, the Fill Color button takes on that color.
True
False
Which of the following statements describes how to increase or decrease a column's width?
Right-Click anywhere in the column and select format cells
Use the Page Setup dialog box
Drag the boundary next to the column heading
Select a Width setting in the Scale to Fit group on the Page layout tab.
Which of the following dialog boxes is used to transpose rows and columns?
Page Setup
Paste Special
Column Width
Row Height
Which of the following statements describes how to unhide a hidden row or column?
Select a range of cells in the row or column, right-click, and select Unhide.
Use the Page Setup dialog box
Remove all page breaks
Select the rows/columns before and after the hidden rows/columns and the right-click and select Unhide.
In which of the following locations are check boxes that you can select to view or print gridlines?
in Print Preview
On the home tab, in the Cells group
On the Page Layout tab, in the Sheet Options group
On the Page Layout tab, in the Page Setup group
The _____ is the line between tows or columns.
cells
gridlines
horizontal axis
vertical axis
A(n) ________ is a line of text that appears at the top of each page of a printed worksheet.
Header
Footer
Title
Label
_____ is the top-to-bottom measurement of a row, measured in points.
Row Height
Column Height
Font size
White space
The identifying letter at the top of a column is called the ______.
Row Heading
Column Width
Column Heading
Row Width
_____ refers to shrinking or stretching printed output to a percentage of its actual size.
Customize margins
Page Setup
Autofit
Scaling
A(n) is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.
Theme
Style
Effects
Orientation
Which of the following procedures is NOT a way to delete one or more worksheets from a workbook?
Right-click a worksheet tab and click Delete
Press Ctrl+A to select all cells in the worksheet and then press Delete.
Click the Delete drop-down arrow on the home tab and click the Delete Sheet.
Select a group of worksheets, right-click the group, and click Delete.
Which of following statements about hidden and unhidden worksheets is correct?
Unhidden worksheets cannot contain formulas that refer to hidden worksheets.
When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.
A hidden worksheet cannot be inadvertently deleted.
Excel creates a minimized window for each hidden worksheet.
Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?
It's the easiest way to make a backup before making changes.
It lets you reuse formats and formulas in a new sheet.
It helps Excel learn where your data ranges are located.
You should keep one worksheet hidden in case of an error.
To zoom out of the worksheet and display twice the amount of worksheet data for any given area of the screen, which of the following Zoom settings should you choose?
200%
120%
75%
50%
Which of the following statements describes how to change the color of a worksheet tab?
On the Page Layout tab, in the Themes group, select Colors.
Right-click the tab and select Tab Color.
Use the Fill Color tool on the Home tab.
you cannot change the color of a worksheet tab.
Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?
On the view tab, in the Window group, click Hide.
Select the visible area of the worksheet.
Right-click the worksheet's tab and click Hide.
Enter the name of the worksheet in the Hide dialog box.
Which of the following steps is NOT a method for inserting a worksheet into a workbook?
Click on the New sheet (+) button to the right of the worksheet tabs.
On the home tab, click Insert and then click Insert Sheet.
On the Insert tab, click Worksheet.
Right-click a worksheet tab and click Insert, then click Worksheet and click OK.
In order for you to freeze the first column of a worksheet into a frozen pane:
All the data in the column must be visible.
The first row of the column must be non-blank.
Duplicate worksheets must also be able to have their first columns frozen.
You can click Freeze First Column in the Freeze Panes menu.
When you create a copy of an existing worksheet named August, Excel gives that worksheet which of the following names?
September
August (2)
Sheet2
July
