NEW
Font size
WorksheetsIntro to MOffc Excel 2016 Unit 3 (icev)
Total questions: 10
Worksheet time: 10mins
Which of the following shows the location of the cell which has been selected? A. B. C. D.
Cell name box
Dialog box
Formula bar
Worksheet tab
Which of the following are composed of a grid system of rows and columns which cross to make cells?
Formulas
Graphs
Table guides
Worksheets
Which of the following allows data to fit the column width?
Gridlines
Page Break Preview
Page Layout
Text Wrapping
Which of the following is the correct formula to add cells A1 and B2? A. B. C. D.
A1+B2
=A1+B2
SUM(A1:B2)
=$A1,$B2
The data types appear in which group on the Home tab?
Illustrations
Insert
Numbers
Text
Which of the following cell references is read as “cell A1 through D6?"
A1,D6
A1!D6
A1$D6
A1:D6
Which of the following automatically applies formatting to one or more cells based on a specific condition?
Conditional Formatting
Criterion
Filtering
Sorting
Which of the following CANNOT be used as a math operator in a formula? A. B. C. D.
* asterisk
: colon
+ plus sign
/ slash
An IF Function is an example of which type of function?
Date & Time
Financial
Logical
Text
After inserting a table, a _____________ tab will appear in the ribbon with a Table Tools label.
Design
Format
Insert
Layout
