NEW
Font size
WorksheetsMS Excel
Total questions: 70
Worksheet time: 35mins
An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?
A dialog box or task pane
An additional workbook
A list of worksheets
An additional part of the current range
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
Page Layout
Print Layout
Synchronous Scrolling
Screen Tips
When you split a window, the window is divided into how many panes?
two
three
four
two or four
Which of the following is the intersection of a row and column?
range
tab
bar chart
cell
Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently?
A worksheet
The Help window
The Quick Access Toolbar
The ribbon
How many worksheets does a new Excel 2016 workbook open with?
one
two
three
four
Which of the following consists of details that describe or identify a file, including the author?
Paste
Document properties
Copy
Range
Which command is used to insert a cut or copied selection to a cell or range of cells?
Paste
Document properties
Copy
Range
If you want to use a workbook in another kind of document, you have the option to save using which of the following?
File format
Worksheet
File sheet
File range
Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?
Cell pointer
Column marker
Fill handle
Formula bar
Which of the following can you drag or double-click to change the width of a column?
Cell pointer
Column marker
Fill handle
Formula bar
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
Backstage
Edit
Windows
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
Info
Options
Open
Which of the following can be customized for quicker access to your most commonly used commands?
Print Preview
Quick Access Toolbar
Printer setup
Workbook
When you modify the ribbon, which of the following is created?
command
tab
button
worksheet
Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text file
Template
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
Info
Options
Open
3. Which of the following can be customized for quicker access to your most commonly used commands?
Print Preview
Quick Access Toolbar
Printer setup
Workbook
Which of the following is not an arithmetic operator?
+
-
*
]
Per the order of operations, which of the following is calculated first?
Addition (+) and subtraction (−) (left to right)
Exponentiation (ˆ)
Percent (%)
Negative number (−)
Which of the following is an acceptable name for a named range?
C7
subtotal_west
subtotal west
subtotal/west
Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
Which of the following is an example of a mixed cell reference?
A9
A$9
$A$9
A9:E9
Which of the following calculates the total from the adjacent cell through the first non-numeric 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 non-blank 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 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 non-numeric content.
By default, AutoSum calculates the total from the adjacent cell through the first non-numeric cell.
AutoSum does not have a default selection.
The COUNT and MIN functions are examples of which category of functions?
text
statistical
financial
logical
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
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
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
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 then rightclick and select Unhide.
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 down arrow on the Home tab and click Delete Sheet.
Select a group of worksheets, right-click the group, and click Delete.
Which of the 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 render twice the normal amount of worksheet displayed for any given area of the screen, which of the following settings would you need to change the Zoom to?
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 the Insert 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.
In the Insert dialog box, click Worksheet and then click OK.
In order for you to freeze the first column of a worksheet into a frozen pane:
The entire contents of 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 a worksheet named August, Excel gives that worksheet which of the following names?
September
August (2)
Sheet2
July
When you click the New sheet (+) button on the tabs bar, where is a worksheet always inserted?
At the beginning of the tabs sequence
Before the active worksheet
After the active worksheet
At the end of the tabs sequence
Which of the following procedures is not a way to sort a table by the contents of one column?
Click the Sort button in the Sort & Filter group of the Data tab.
Click an AutoFilter button in the total row.
Click an AutoFilter button in the field names row.
Click the Filter button in the Sort & Filter group of the Data tab.
Which of the following is a valid reason for converting a table to a range?
To clear the sorting criteria and start over.
To prepare for deleting a column.
To prepare for importing new data from a non-Excel file.
To prepare to change its conditional formatting.
Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?
There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.
Only an Auto Outlined worksheet may contain total rows.
An Auto Outlined worksheet contains only one button for collapsing and expanding.
Only a multi-grouped worksheet can cluster rows and columns.
Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?
Table[Auction Items(Total Sale)]
Auction Items(Total Sale)
Auction Items[#Totals]
#Totals[Total Sale]
Which of the following procedures is not a way to filter a table by the contents of one column?
Click the criterion button on the slicer.
Right-click the cell whose contents you want for the criterion and click Filter in the menu.
Click the Filter button in the Sort & Filter group of the Data tab.
Click the AutoFilter button in the total row at the bottom.
Which of the following attributes is not a potential criterion for an AutoFilter sort?
Font color
Font style
Cell color
Cell icon
Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?
There is no difference between an AutoFiltered range of records in a list and a table.
A table maintains its sort order after you close and then open it again.
A table given a title enables its field names to be used in formulas in place of cell references.
A table enables special subtotal functions for total rows.
Which of the following characters would not appear on an outline symbol or control for grouped or outlined data?
+
@
2
-
Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?
You want to preserve the integrity of any cells referenced by formulas in the macro.
You want the values of any cells copied to the macro to be accurate.
You want the results of any formulas produced by the macro to be accurate.
You want the macro to reproduce its results in the same place each time.
Which of the following does Excel not provide features for importing data?
An active database
A Web page
A Web search
An XML file
Which of the following functions automatically counts cells that meet multiple conditions?
COUNTIF
COUNT
COUNTIFS
SUMIFS
Which of the following functions automatically counts cells that meet a specific condition?
COUNTIF
COUNT
COUNTIFS
SUMIFS
In the formula =SUMIFS(C5:C16, F5:F16, “<=60”, B5:B16, “>200000”), which of the following is the range of cells to be added?
=C5:C16
=F5:F16
=B5:B16
=C5:F16
In the formula =SUMIFS(C5:C16, F5:F16,”<=60”, B5:B16, “>200000”), what does “<=60” mean?
If the value in C5:C16 is greater than or equal to 60, the value in C5:C16 will be included in the total.
If the value in F5:F16 is greater than or equal to 60, the value in C5:C16 will be included in the total.
If the value in B5:B16 is less than or equal to 60, the value in C5:C16 will be included in the total.
If the value in F5:F16 is less than or equal to 60, the value in C5:C16 will be included in the total.
What does criteria range in a formula refer to?
The worksheet data to be included in the formula’s results
The range containing a condition that must be met in order for data to be included in the result
The type of formula being used for the calculation
The type of data contained in the cells to be included in the formula
Which of the following functions returns one value if a condition is true and a different value when the condition is not true?
AND
OR
IF
SUM
Which of the following functions returns a value if all conditions are met?
AND
OR
IF
SUM
Which of the following functions searches for a value in the first column of Table_array and returns a value in the same row from Col_index_num?
AVERAGEIF
VLOOKUP
MID
HLOOKUP
Which of the following functions converts text from uppercase to title case?
UPPER
PROPER
LOWER
TRIM
Which of the following functions joins two or more text strings into a single text string?
AND
MID
TRIM
CONCATENATE
Which chart type shows values as parts of a whole?
Column
Bar
Area
Pie
Which part of a chart do you click when you want to select the entire chart?
Chart area
Plot area
Chart title
Legend
Which of the following happens to a chart when the source data is deleted?
Nothing.
The chart will move to the area where the data was located.
The data in the chart is deleted.
You will be asked if you want the chart deleted.
