(A) Rows
(B) Index
(C) Hyperlink
(D) Traspose
Tag: Excel Mcq Questions with Answers
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