What is the function of the IF function in Excel?
A. To perform a logical test and return a value based on the result
B. To add up a range of cells
C. To find the average of a range of cells
D. To count the number of cells in a range
What is the function of the SUM function in Excel?
A. To add up a range of cells
B. To find the average of a range of cells
C. To count the number of cells in a range
D. To find the maximum value in a range of cells
What is the intersection of a column and row called in Excel?
A. A cell
B. A range
C. A column header
D. A row header
Title bar in MS-Excel displays name of the __________ ?
A. Worksheet
B. Workbook
C. Formula
D. Location
in MS-Excel__________ short cut key is used for hiding rows.
A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above
Which of following is not an element of computer spreadsheet interface?
A. Pencil work
B. Active cell
C. Menu bar
D. Workbook
Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?
A. Decoration
B. Data appearance
C. Functions
D. Charting
In excel columns are labelled as____________?
A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.