NEW
Font size
WorksheetsMicrosoft Excel® 2019 Basics - Review
Total questions: 40
Worksheet time: 10hrs 0mins
Backstage View can be reached by clicking on which tab of the Ribbon?
File
Home
Insert
Page Design
Which of the following can be used to copy the formatting applied to a cell?
Format bar
Format handle
Format painter
Format cell
Which of the following functions finds the lowest value in a range of cells?
=AVG()
=MAX()
=LOW()
=MIN()
Which of the following is the correct formula to add cells A1 and B2?
A1+B2
=A1+B2
SUM(A1:B2)
=$A1,$B2
Which of the following is NOT a viewing option for a worksheet?
Normal
Page Layout
Page Break Preview
Gridline
Which group on the Formulas tab holds the command to show the formulas in formula view?
Function Library
Defined names
Formula Auditing
Calculation
Which of the following are composed of a grid system of rows and columns which cross to make cells?
Worksheets
Table guides
Graphs
Formulas
Which of the following is NOT a comparison operator?
> greater than arrow
< less than arrow
/ slash
= equals sign
Which of the following cell references is read as "cell A1 and D6?"
A1,D6
A1!D6
A1:D6
A1-D6
Which of the following CANNOT be used as a math operator in a formula?
asterisk
+ plus sign
: colon
/ slash
Which of the following cell references is read as "cell A1 through D6?"
A1,D6
A1!D6
A1$D6
A1:D6
Which group on the Home tab contains the command for adding a filter?
Cells
Editing
Styles
Number
Which of the following is NOT a type of conditional formatting?
Data bar
Icon set
Highlight
Comment
The IF Function is an example of which type of function?
Financial
Text
Date & Time
Logical
Which of the following formulas returns the current date and time?
=DATE()
=TIME()
= NOW()
=TODAY()
Which group on the Page Layout tab contains the commands to adjust the margins and page orientation of a worksheet?
Themes
Page Setup
Scale to Fit
Sheet Options
Which of the following shows the location of the cell which has been selected?
Formula bar
Cell name box
Worksheet tab
Dialog box
Which tab and group on the Ribbon contains the option to add header to a worksheet?
Home tab, Styles group
Home tab, Editing group
Page Layout tab, Page Setup group
Insert tab, Text group
Which of the following error messages would appear if the cell reference is not valid?
Railroad Tracks Error, #####
#REF!
#NAME?
#CELL?
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, Paragraph group
Home tab, Font group
Home tab, Editing group
Page Layout tab, Paragraph group
Which of the following types is the CONCATENATE function?
Text
Numerical
Categorical
Summarizing
Which of the following is an absolute cell reference?
A1
A$1
$A1
$A$1
Which tab and group in the Chart Tools section of the Ribbon contains the command to switch row and column data?
Design tab, Type group
Design tab, Chart Layouts group
Design tab, Data group
Layout tab, Analysis group
Which of the following finishes an entry based on previous entries made in the column containing the active cell?
AutoFinish
FillComplete
Conditional formatting
AutoComplete
Which tab and group contains the option for adding conditional formatting?
Home tab, Font group
Insert tab, Illustrations group
Data tab, Data Tools group
Home tab, Styles group
Which of the following is a series of commands and instructions grouped together as a single command to accomplish a task automatically?
Macro
Sort
Filter
Icon Set
Which tab on the Ribbon contains the command to record a macro?
File
Insert
Macro
View
Which of the following contains the location where you can name a macro?
File Tab
Record Macro Dialog Box
Macro Menu
Data Tab
Which of the following should be clicked to view the macros in the workbook?
Stop Recording Option
Analyze Macros Option
View Macros Option
Record Macros Option
Which of the following locations contains the command to delete a macro?
Record macro dialog box
Delete macro dialog box
Analyze macro dialog box
Macro dialog box
Which of the following should be applied if you want to display only rows which meet a certain specified criteria?
Filter
Sort
Data Bar
Icon Set
Which group on the Home tab contains the commands to apply a filter or a sort?
Clipboard
Editing
Font
Alignment
Other than the Home tab, which tab on the Ribbon contains the commands for applying a filter or a sort?
File
Review
View
Data
Which of the following is NOT true about sorting?
Data is arranged in a certain order such as alphabetically or numerically
Data is hidden if it does not meet the sorting criteria
Data can be sorted by cell color
Date and time data can be sorted chronologically
Which of the following applies formatting to cells depending upon the contents of the cells?
. Conditional sorting
Filters
Style sets
Conditional formatting
Which of the following tabs contains the command for adding a chart to an Excel® worksheet?
File
Insert
Home
Formulas
In order to create a chart, which of the following must be selected?
Data tools
Data source
Worksheet tab
Table styles
Brandon wants to add a legend to his chart. Which of the following should he click to add this item?
Add Chart Element
Quick Style
Shape Styles
WordArt Styles
Which group on the Chart Tools Design tab holds the command for switching row and column data?
Chart Layouts
Data
Chart Styles
Location
Javier would like to print his chart along with the data in the worksheet. Which of the following should he do?
Right-click on the chart and choose Print from the menu
Make sure the chart is selected in the worksheet and press Control P and click the Print button
Make sure the chart is NOT selected in the worksheet and press Control P and click the Print button
Right-click on the worksheet and choose Print from the menu
