NEW
Font size
WorksheetsExcel Exam
Total questions: 25
Worksheet time: 13mins
Which of the following shows the location of the cell which has been selected?
Formula bar
Cell name box
Worksheet tab
Dialog box
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 viewing option for a worksheet?
Normal
Page Layout
Page Break Preview
Gridline
Backstage View can be reached by clicking on which tab of the Ribbon?
File
Home
Insert
Page Design
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 is the correct formula to add cells A1 and B2?
A. A1+B2
B. =A1+B2
C. SUM(A1:B2)
D. = A1, B2
Which of the following is an absolute cell reference?
A. A1
B. A$1
C. $A$1
D. A 1
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 of the following is NOT a type of conditional formatting?
Data bar
Icon set
Highlight
Comment
Which of the following can be used to copy the formatting applied to a cell?
Format bar
Format handle
Format painter
Format cell
Which group on the Home tab contains the command for adding a filter?
Cells
Editing
Styles
Number
Which tab and group on the Ribbon contains the option to add a header to a worksheet?
Home tab, Styles group
Home tab, Editing group
Page Layout tab, Page Setup group
Insert tab, Text group
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 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 types is the CONCATENATE function?
Text
Numerical
Categorical
Summarizing
Which of the following functions finds the lowest value in a range of cells?
=AVG( )
=MAX( )
=LOW( )
=MIN( )
Which of the following cell references is read as “cell A1 through D6?”
A. A1,D6
B. A1!D6
C. A1$D6
D. A1:D6
Which of the following cell references is read as “cell A1 and D6?”
A. A1,D6
B. A1!D6
C. A1:D6
D. 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 formulas returns the current date and time?
=DATE( )
=TIME( )
=NOW( )
=TODAY( )
Which of the following error messages would appear if the cell reference is not valid?
Railroad Tracks Error, #####
#REF!
#NAME?
#CELL?
Which group on the Formulas tab holds the command to show the formulas in formula view?
Function Library
Defined names
Formula Auditing
Calculation
The IF Function is an example of which type of function?
Financial
Text
Date & Time
Logical
Which of the following is NOT a comparison operator?
> greater than arrow
< less than arrow
/ slash
= equals sign
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
