GuruMCQs.com provides all updated Computer Science MCQs. Most repeated Basic Computer Science MCQs section, frequently encountered in Inspector, ASI, Sub-inspector, Constable, FPSC, PPSC, ETEA, FIA, Police, Army, Navy, Airforce, IB, MOFA, ASF, LHC, Educators, and various other competitive exams, as well as government and private job assessments. In Computer Science MCQs with answers, sections cover topics like Basic Computer MCQs, Computer Fundamental MCQs, MS Office, MS Excel, MS Word, MCQs on the Internet, C Programming MCQs, Computer Networks, Data Structures, Database Management MCQs, Operating System (UNIX, LINUX, Window), Computer Organizations and Architecture, Data Mining –  and much more. Also, check MCQs on English here.

161. In Excel, what symbol is used to denote absolute cell reference? A. &
B. $
C. *
D. %

162. In Excel, what function is used to find the largest value in a range? A. MAX
B. MIN
C. LARGE
D. BIG

163. In Excel, what function is used to calculate the total of a range of cells? A. SUM
B. TOTAL
C. SUMIF
D. RANGE

164. In Excel, what function is used to check whether a condition is true or false? A. TRUE
B. FALSE
C. IF
D. CHECK

165. In Excel, what function is used to find the average value of a range of cells? A. AVG
B. AVERAGE
C. AVERAGEIF
D. MEAN

166. In Excel, what function is used to remove all formatting from a cell or range of cells? A. REMOVE
B. DELETE
C. CLEAR
D. FORMAT

167. In Excel, what function is used to join together the contents of two or more cells? A. MERGE
B. CONCATENATE
C. JOIN
D. COMBINE

168. In Excel, what function is used to round a number up to the nearest integer? A. ROUNDUP
B. CEILING
C. ROUNDDOWN
D. FLOOR

169. In Excel, what function is used to return the current date and time? A. TODAY
B. NOW
C. DATE
D. TIME

170. In Excel, what function is used to find the smallest value in a range? A. MIN
B. SMALL
C. MINIMUM
D. TINY