Q. In Excel, what does the VLOOKUP function do? (2023)
-
A.
Looks up a value vertically
-
B.
Calculates the average
-
C.
Counts the number of cells
-
D.
Finds the maximum value
Solution
The VLOOKUP function in Excel is used to look up a value vertically in a table.
Correct Answer: A — Looks up a value vertically
Learn More →
Q. In Excel, which symbol is used to start a formula? (2023)
Solution
In Excel, the '=' symbol is used to start a formula.
Correct Answer: B — =
Learn More →
Q. In Microsoft Word, which shortcut key is used to save a document? (2023)
-
A.
Ctrl + S
-
B.
Ctrl + P
-
C.
Ctrl + C
-
D.
Ctrl + V
Solution
The shortcut key 'Ctrl + S' is used to save a document in Microsoft Word.
Correct Answer: A — Ctrl + S
Learn More →
Q. In PowerPoint, what is the purpose of a slide master? (2023)
-
A.
To create animations
-
B.
To manage slide layouts
-
C.
To insert images
-
D.
To add audio
Solution
A slide master is used to manage slide layouts and design elements across multiple slides.
Correct Answer: B — To manage slide layouts
Learn More →
Q. In PowerPoint, which view is used to see the presentation as it will appear to the audience? (2023)
-
A.
Slide Sorter
-
B.
Normal View
-
C.
Slide Show
-
D.
Outline View
Solution
The 'Slide Show' view is used to see the presentation as it will appear to the audience.
Correct Answer: C — Slide Show
Learn More →
Q. In Word, which tab would you use to insert a table? (2023)
-
A.
Home
-
B.
Insert
-
C.
Design
-
D.
Layout
Solution
You would use the 'Insert' tab to insert a table in Word.
Correct Answer: B — Insert
Learn More →
Q. What feature in Excel allows you to automatically fill a series of cells? (2023)
-
A.
AutoFill
-
B.
Fill Handle
-
C.
Series Fill
-
D.
Cell Fill
Solution
The Fill Handle is a feature in Excel that allows you to automatically fill a series of cells.
Correct Answer: B — Fill Handle
Learn More →
Q. What is the default file extension for a PowerPoint presentation? (2023)
-
A.
.ppt
-
B.
.pptx
-
C.
.docx
-
D.
.xlsx
Solution
The default file extension for a PowerPoint presentation is '.pptx'.
Correct Answer: B — .pptx
Learn More →
Q. What is the default file extension for a Word document? (2023)
-
A.
.doc
-
B.
.docx
-
C.
.txt
-
D.
.pdf
Solution
The default file extension for a Word document is .docx since Word 2007.
Correct Answer: B — .docx
Learn More →
Q. What is the maximum number of rows in a single Excel worksheet? (2023)
-
A.
65,536
-
B.
1,048,576
-
C.
32,768
-
D.
256
Solution
The maximum number of rows in a single Excel worksheet is 1,048,576.
Correct Answer: B — 1,048,576
Learn More →
Q. What is the maximum number of rows in an Excel worksheet? (2023)
-
A.
65,536
-
B.
1,048,576
-
C.
32,768
-
D.
256
Solution
The maximum number of rows in an Excel worksheet is 1,048,576.
Correct Answer: B — 1,048,576
Learn More →
Q. What is the purpose of the 'Slide Show' tab in PowerPoint? (2023)
-
A.
To edit slides
-
B.
To add transitions
-
C.
To present the slides
-
D.
To insert images
Solution
The Slide Show tab in PowerPoint is used to present the slides.
Correct Answer: C — To present the slides
Learn More →
Q. What is the shortcut key to create a new presentation in PowerPoint? (2023)
-
A.
Ctrl + N
-
B.
Ctrl + M
-
C.
Ctrl + P
-
D.
Ctrl + O
Solution
The shortcut key 'Ctrl + N' is used to create a new presentation in PowerPoint.
Correct Answer: A — Ctrl + N
Learn More →
Q. Which feature in Word allows you to check the spelling and grammar of your document? (2023)
-
A.
Thesaurus
-
B.
Spell Check
-
C.
Grammar Check
-
D.
AutoCorrect
Solution
The 'Spell Check' feature in Word allows you to check the spelling and grammar of your document.
Correct Answer: B — Spell Check
Learn More →
Q. Which of the following is a function in Excel? (2023)
-
A.
SUM
-
B.
ADD
-
C.
TOTAL
-
D.
CALCULATE
Solution
SUM is a built-in function in Excel used to add numbers.
Correct Answer: A — SUM
Learn More →
Q. Which of the following is a function in Microsoft Excel? (2023)
-
A.
SUM
-
B.
PRINT
-
C.
SAVE
-
D.
OPEN
Solution
The function 'SUM' is used in Microsoft Excel to add numbers.
Correct Answer: A — SUM
Learn More →
Q. Which of the following is NOT a valid data type in Excel? (2023)
-
A.
Text
-
B.
Number
-
C.
Date
-
D.
Image
Solution
Image is not a valid data type in Excel; valid types include Text, Number, and Date.
Correct Answer: D — Image
Learn More →
Q. Which of the following is NOT a view option in PowerPoint? (2023)
-
A.
Normal
-
B.
Slide Sorter
-
C.
Reading
-
D.
Outline
Solution
Reading is not a standard view option in PowerPoint; the correct options are Normal, Slide Sorter, and Outline.
Correct Answer: C — Reading
Learn More →
Q. Which shortcut key is used to save a document in Word? (2023)
-
A.
Ctrl + S
-
B.
Ctrl + P
-
C.
Ctrl + C
-
D.
Ctrl + V
Solution
The shortcut key to save a document in Word is Ctrl + S.
Correct Answer: A — Ctrl + S
Learn More →
Q. Which tab in Word would you use to change the font style? (2023)
-
A.
Home
-
B.
Insert
-
C.
Layout
-
D.
Review
Solution
The Home tab in Word is where you can change the font style.
Correct Answer: A — Home
Learn More →
Showing 1 to 20 of 20 (1 Pages)
