Basic Computer MCQs

2872 MCQs  (Page 142 of 288)

Ctrl+Shift+1 shortcut Keys in excel are used to __________?
A. Format number in comma format
B. Format number in currency format
C. Format number in date format
D. Format number in time format
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 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 VLOOKUP function in Excel?
A. To perform a vertical lookup and return a value based on a specified criteria
B. To perform a horizontal lookup and return a value based on a specified criteria
C. To add up a range of cells
D. To find the average of a range of cells