Excel 2016 Flashcards
*Which of the following functions finds the lowest value in a range of cell?
=MIN( )
*Which of the following are composed of a grid system of rows and columns which cross to make cells?
Worksheets
*Which tab and group contains the option for adding conditional formatting?
Home tab, Styles group
*Which tab and group on the Ribbon holds the command to change the font of the text of the cells of a worksheet?
Home tab, Font group
*The IF Function is an Example of which type of function?
Logical
*Which of the following is NOT a type of conditional formatting?
Comment
*Which of the following is an absolute cell reference?
$A$1
*Which of the following error messages would appear if the cell reference is not valid?
REF!
*Which of the following shows the location of the cell which you have selected?
Cell name box
*Which tab and group in the Chart Tools section of the Ribbon contains the command to switch row and column data?
Design tab, Data group
*Which of the following CANNOT be used as a math operator in a formula?
: colon
*Which of the following is the correct formula to add cels A1 and B2
=A1+B2
*Which tab and group on the Ribbon contains the option to add a header to a worksheet?
Insert tab, Text group
*Which of the following formulas returns the current data and time?
=NOW( )
*Which group on the Home tab contains the command for adding a filter?
Editing
*Which of the following cell references is read as “cell A1 through D6?”
A1:D6
*Which group on the Formulas tab holds the command to show the formulas in formula view?
Formula Auditing
*Which of the following is NOT a viewing option for a worksheet?
Gridlines
*Which of the following types is the CONCATENATE function?
Text
*Which of the following is NOT a comparison operator?
/ slash
*Which of the following finishes an entry based on previous entries made in the column containing the active cell?
AutoComplete
*Which of the following can be used to copy the formatting applied to a cell?
Format painter
*Which group on the Page Layout tab contains the commands to adjust the margins and page orientation of a worksheet?
Page Setup
*Which of the following cell references is read as “cell A1 and D6?”
A1,D6
*Backstage View can be reached by clicking on which tab of the Ribbon?
File
