NEW
Font size
WorksheetsExcel
Total questions: 10
Worksheet time: 4mins
Choose the best description of the IF function
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false
Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false
Returns a value from a list using a given position
The last column name in a worksheet is
XFD
FXD
DFX
FXD
Shortcut key to insert new worksheet is
Ctrl+F10
Shift+F11
Alt+F9
Shift+F10
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
How is the COLUMN in a MS Excel Spreadsheet named?
Numbers
Letters
Cells
Columns
The area within the red box is called_______?
Fill Handle
Active Cell
Cell
Row
This is a_____________?
Column
Row
Cell
Range
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
