(A) Rows
(B) Index
(C) Hyperlink
(D) Traspose
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.
To move to the previous cell in a table inserted in a document press?
(A) Shift+Tab
(B) The Tab Key
(C) Backspace
(D) Alt+Tab
When inserting a graphic into a worksheet you could go to cell A1 by pressing?
(A) Ctrl+Home
(B) Alt+Home
(C) Shift+Home
(D) Enter+Home
When typing character search criteria, excel matches fields based on?
(A) Capitalization
(B) Alphabetical order
(C) Spelling
(D) Primary records
Why might you hide worksheets in a workbook?
(A) The file is larger
(B) The file is smaller
(C) Some data is private
(D) Some data is formatted
Sort command of the data menu provides which capability?
(A) Multiple-Field
(B) Multiple-Table
(C) Multiple-Column
(D) Multiple-Row
In MS Excel which function automatically totals a column or row of values?
(A) AVG
(B) ADD
(C) TOTAL
(D) SUM
To create table in Ms excel which key is used?
(A) Shift+T
(B) Ctrl+Shift+T
(C) Ctrl+T
(D) Alt+T