(A) Join
(B) Link
(C) Simplify
(D) Merge
Category: MS Excel Mcqs
MS Excel Mcqs for NTS, PPSC, FPSC, SPSC, KPPSC, AJKPSC, PMS, PTS, Data Entry Operator, Computer Operator and all computer related exams.
Where is the address of active cell displayed?
(A) Name Box
(B) Row Heading
(C) Formula Bar
(D) Status Bar
Excel would evaluate the formula =2010/58 and return this answer?
(A) 230
(B) 320
(C) 311
(D) 298
Which function automatically totals a column or row of values?
(A) SUM
(B) ADD
(C) AVG
(D) TOTAL
The information inside your table needs to be sorted alphabetically. To do this you go to?
(A) Home tab > paragraph group
(B) Page layout
(C) Table tools design
(D) Table tools layout
Which option displays fill color in alternate in an excel table?
(A) First Row
(B) Filled Rows
(C) Banded Rows
(D) Last Row
Which alignment choice spreads the data across the width of the cell?
(A) Distributed
(B) Indent
(C) Justify
(D) Center
User developed instructions for excel are called?
(A) Macros
(B) Programs
(C) Procedures
(D) None of the above