User developed instruction for excel are called _____ ?
A. Procedured
B. Average
C. Progrms
D. Macros
Microsoft Excel Mcqs
Computer Science MCQs cover topics such as Microsoft Excel MCQs, Microsoft Excel formulas, and Microsoft Excel shortcut keys MCQs. MCQs of computers for test preparation. Microsoft Excel questions and answers for all competitive exams. MS Excel MCQs are very important in the Computer section.
In excel columns are labelled as ______ ?
A. A1, A2, A3, etc.
B. $A$1, $A$2, etc.
C. A, B, C, etc.
D. 1, 2, 3, etc.
Which of following is not an element of computer spreadsheet interface ?
A. Menu bar
B. Workbook
C. Pencil work
D. Active cell
What is the intersection of a column and row called in Excel ?
A. A row header
B. A cell
C. A range
D. A column header
What is the function of the SUM function in Excel ?
A. To find the maximum value in a range of cells
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 IF function in Excel ?
A. To find the average of a range of cells
B. To count the number of cells in a range
C. To perform a logical test and return a value based on the result
D. To add up a range of cells