Font size
WorksheetsMicrosoft Excel Advanced Features
Total questions: 14
Worksheet time: 7mins
What row should we select to freeze the 3th row?
3rd row
4th row
1st row
All row
Which column to select to freeze 2nd column?
1st column
2nd column
3rd column
4th column
What is the main function of conditional formating
To change the cell styles
To change font, font size, and color
Allow user to user to type automatically
Allow user to automatically apply formatting
What is the best way to save our time in setting similar format of a cell from another cell?
Use format painter
Use conditional formatting
Insert a picture
Zoom in the page
Users can define their own cell style or use existing style in Excel
True
False
”A predefined formula that performs calculations using specific values in a particular order”
Operators
Mathematics
Function
Library
To start using formula in Excel, users need to type _____ sign in the beginning of the formula
more than, >
equal sign, =
less than, <
exclamation mark, !
What is the symbol used for multiplication?
+
/
*
-
Which are the three essential elements to enter a function?
Equal sign, cell reference and formula
Equal sign, function name and cell reference
Function name, data and cell reference
Function that used to check and assign 'pass' and 'fail' to group of scores
SUM
VLOOKUP and HLOOKUP
COUNT and COUNTA
IF and IFS
After defining and setting formula, user need to press ____ button
Spacebar
Tab
Enter
Backspace
VLOOKUP function is used to retrieve data and arrange them horizontally
True
False
To define a formula, which parentheses are used?
[ ]
( )
{ }
< >
User can remove conditional formatting for
Selected cell
Other document
Whole document
Entire sheet
