Microsoft Office MCQs

Computer

Microsoft Office MCQs

Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.

1199
Total Questions

Practice Questions

Page 44 of 60
Question #861
In Excel, the 'Go To Special' dialog can be opened by:
A. Alt + F5
B. Ctrl + G
C. F5 -> Special button, or Home tab -> Find & Select -> Go To Special
D. Ctrl + Shift + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.
This question belongs to: Computer Microsoft Office
Question #862
In PowerPoint, which of the following can be applied to a slide to define its layout?
A. Slide Transition
B. Slide Layout
C. Slide Animation
D. Slide Theme
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Layout determines placeholder arrangement. Theme defines colors/fonts.
This question belongs to: Computer Microsoft Office
Question #863
In MS Access, to sort records in ascending order in a query, use:
A. Ascending order in the Sort row of the query design grid
B. ORDER BY ASC in SQL
C. Group By
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both design grid sort and SQL ORDER BY ASC work.
This question belongs to: Computer Microsoft Office
Question #864
The 'Ctrl + Shift + 8' shortcut in MS Word does what?
A. Sets line spacing to double
B. Applies double strikethrough
C. Toggles display of paragraph marks and hidden formatting symbols
D. Inserts a page break
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+8 (Ctrl+*) shows/hides formatting marks.
This question belongs to: Computer Microsoft Office
Question #865
In Excel, which function returns the row number of a reference?
A. ROW()
B. COLUMN()
C. ROWS()
D. ROW_NUMBER()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
ROW(reference) returns row number. COLUMN returns column number.
This question belongs to: Computer Microsoft Office
Question #866
What is the default slide layout for a new slide in PowerPoint?
A. Comparison
B. Title Slide
C. Blank
D. Title and Content
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
When you add a new slide (Ctrl+M), the default layout is Title and Content.
This question belongs to: Computer Microsoft Office
Question #867
In MS Access, which data type is used for true/false values?
A. Boolean
B. Yes/No
C. Binary
D. Checkbox
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The data type is called Yes/No (stores -1/0 or True/False).
This question belongs to: Computer Microsoft Office
Question #868
To quickly minimize the ribbon in MS Office, press:
A. F1
B. Alt + F1
C. Shift + F1
D. Ctrl + F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+F1 collapses/expands the ribbon.
This question belongs to: Computer Microsoft Office
Question #869
In MS Word, which key is used to extend a selection?
A. Shift
B. Ctrl
C. Alt
D. F8
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F8 turns on extend selection mode; pressing it repeatedly selects word, sentence, paragraph, etc. Shift+arrow also extends.
This question belongs to: Computer Microsoft Office
Question #870
In Excel, the formula =A1>B1 returns:
A. Yes or No
B. TRUE or FALSE
C. Both A and B
D. 1 or 0
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Logical comparison returns TRUE or FALSE. However, TRUE/FALSE can be coerced to 1/0, but direct result is boolean.
This question belongs to: Computer Microsoft Office
Question #871
In PowerPoint, which shortcut is used to delete a selected slide?
A. Backspace
B. Ctrl + D
C. Delete key
D. Esc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Pressing Delete removes the selected slide. Backspace also works in some contexts but Delete is standard.
This question belongs to: Computer Microsoft Office
Question #872
In MS Access, what is the maximum number of characters in a Short Text field?
A. 256
B. 255
C. 64000
D. 1 GB
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Short Text holds up to 255 characters.
This question belongs to: Computer Microsoft Office
Question #873
Which shortcut key is used to redo the last undone action in MS Word?
A. Ctrl + Y
B. Ctrl + R
C. Ctrl + Shift + Z
D. Ctrl + Z
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Y redoes. Ctrl+Z undoes.
This question belongs to: Computer Microsoft Office
Question #874
In Excel, which of the following is the correct syntax for SUMIF?
A. SUMIF(range, criteria, [sum_range])
B. SUMIF(criteria, sum_range)
C. SUMIF(range, sum_range, criteria)
D. SUMIF(criteria, range, sum_range)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SUMIF(range, criteria, [sum_range]) is correct.
This question belongs to: Computer Microsoft Office
Question #875
In MS Word, what is the purpose of 'Mail Merge'?
A. To combine multiple spreadsheets
B. To create personalized documents by combining a template with a data source
C. To send email directly from Word
D. To merge two documents into one
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Mail Merge generates letters, labels, etc., for many recipients.
This question belongs to: Computer Microsoft Office
Question #876
In PowerPoint, which of the following views displays a small image of each slide with its transition and timing?
A. Normal view
B. Outline view
C. Slide Sorter view
D. Reading view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide Sorter shows thumbnails and can display transition icons and timings below slides.
This question belongs to: Computer Microsoft Office
Question #877
In MS Access, to add a new record in a table, you can use:
A. Datasheet view -> New Record row (asterisk *)
B. Both A and C
C. SQL INSERT command
D. Design view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can add records via Datasheet view or via an INSERT query.
This question belongs to: Computer Microsoft Office
Question #878
The shortcut to open the 'Research' task pane in MS Word is:
A. F7
B. Shift + F7
C. Alt + Click on a word
D. Ctrl + Shift + O
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt+click opens the Research pane with information. Also Right-click > Smart Lookup. Ctrl+Shift+O opens the Organizer. But Alt+click is correct.
This question belongs to: Computer Microsoft Office
Question #879
In Excel, what does the formula =LEN(TRIM(A1)) do if A1 contains leading spaces?
A. Returns the length of the trimmed text
B. Gives error
C. Removes all spaces and counts
D. Counts only visible characters
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TRIM removes extra spaces, LEN counts characters.
This question belongs to: Computer Microsoft Office
Question #880
Which of the following is a valid object in MS Access database?
A. Query
B. All of these
C. Table
D. Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
All are objects.
This question belongs to: Computer Microsoft Office

More Computer Topics

Computer Abbreviations MCQs
Computer Fundamentals MCQs
Computer Hardware MCQs
Computer Networking MCQs
Computer Software MCQs
CPU (Central Processing Unit) MCQs
Cyber Security MCQs
Database Management System (DBMS) MCQs
Internet and Web Technologies MCQs
Memory and Storage Devices MCQs
Operating Systems MCQs
Programming Languages MCQs
Today's Top Topics
Microsoft Office 1199 Computer Fundamentals 326 Internet and Web Technologies 461 CPU (Central Processing Unit) 327 Computer Hardware 430
Explore Subjects
Current Affairs 575 English 15164 Static General Knowledge 6362 History GK 3374 Reasoning 1111
Practice Mix
The Macaulay's Minute dealt with:
Which major port is located on the Malabar Coast?
A census provides data that is:
Which of the following is the primary reason for the high rainfall in Cherrapunji?
Choose the correct active voice of: 'Has the mail been sent by the secretary?'