Prepare with MCQs
Thousands of verified questions for competitive exams
25K+
MCQs
15+
Categories
500+
Tests
Free
Access
All
๐ General Knowledge
๐ Current Affairs
๐ต๐ฐ Pakistan Affairs
โช Islamic Studies
๐ค English
๐ป Computer
๐งฎ Mathematics
โ Physics
๐งช Chemistry
๐งฌ Biology
๐ฌ Everyday Science
๐ฉโ๐ซ Pedagogy
ุงุฑุฏู Urdu
๐บ World Geography
๐ History
Computer
Which gas is most abundant in Earth's atmosphere?
A
Carbon dioxide
B
Oxygen
C
Nitrogen
D
Hydrogen
Correct Answer
C
Computer
Which formula is used to calculate the sum of cells A1 through A10 in a spreadsheet?
A
SUM(A1:A10)
B
ADD(A1:A10)
C
TOTAL(A1:A10)
D
None of these
Correct Answer
A
Computer
Default name of a newly created MS Excel File is?
A
Book1
B
Document 1
C
File1
D
All of these
Correct Answer
A
Computer
Microsoft Excel 2019 files have a default extension of ______?
A
Xlsx
B
Xls
C
Excel
D
123
Correct Answer
A
Computer
What is MS Excel primarily used for?
A
Creating and editing presentations
B
Creating and editing spreadsheets / Data
C
Creating and editing images
D
None of these
Correct Answer
A
Computer
In MS Excel, which function counts only non-empty cells in a range?
A
COUNTA()
B
COUNT()
C
COUNTIF()
D
None of these
Correct Answer
A
Computer
In MS Excel, 'HLOOKUP' searches for a value in?
A
A pivot table
B
A vertical column
C
A horizontal row
D
None of these
Correct Answer
C
Computer
In MS Excel, the 'IF' function is used to?
A
Short data
B
Calculate average
C
Perform conditional logic
D
None of these
Correct Answer
C
Computer
What is a macro?
A
Astyle set
B
A Large file
C
Automated sequance command
D
None of these
Correct Answer
C
Computer
How do you start numbering from a specific number in MS Excel?
A
By entering the starting number and using the Fill Handle
B
By deleting the worksheet
C
By changing the front size
D
None of these
Correct Answer
A