Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following allows you to select more than one slide in a presentation ?

A. Alt + click each slide
B. Shift + drag each slide
C. Shift + click each slide
D. Ctrl + click each slide
E. None of the above
Answer» D. Ctrl + click each slide
Discussion
2.

Which of the following is not a valid formula in Microsoft Excel ?

A. = A2 + A1
B. = A2 + 1
C. = 1 + A2
D. = 1A + 2
E. = A1 + A2
Answer» E. = A1 + A2
Discussion
3.

In a worksheet in MS-Excel what is short-cut key to hide entire row ?

A. Ctrl + 2
B. Ctrl + 9
C. Ctrl + N
D. Ctrl + -
E. Ctrl + N
Answer» B. Ctrl + 9
Discussion
4.

Which of the following is not an example of a document file ?

A. Spreadsheet
B. Memo
C. Letter
D. Term Paper
E. Thesis
Answer» B. Memo
Discussion
5.

A collection of worksheets is called

A. Excel book
B. Worksheets
C. Excel sheets
D. Workbook
E. None of these
Answer» E. None of these
Discussion
6.

Which command is used to calculate total characters in a cell ?

A. Len
B. Length
C. Mid
D. Sid
E. None of these
Answer» B. Length
Discussion
7.

Anything that is typed in a worksheet appears

A. in the formula bar only
B. in the active cell only
C. in both active cell and formula bar
D. All of the above
E. None of the above
Answer» D. All of the above
Discussion
8.

On saving a worksheet, the 'Save As' dialog box

A. is used to open the saved Excel files
B. is used for saving the file for the first time
C. is used for saving the file by some alternative name
D. Both '2' and '3'
E. None of the above
Answer» D. Both '2' and '3'
Discussion
9.

The function TODAY ( ) in Excel, enters the current

A. system time in a cell
B. system date and time in a cell
C. system data only
D. time at which the current file was opened
E. None of the above
Answer» E. None of the above
Discussion
10.

Pie charts are typically created by using which of the following ?

A. Browser software
B. Database software
C. Desktop publishing software
D. Word processing software
E. Spreadsheet software
Answer» F.
Discussion
11.

Ctrl, Shift and Alt are called ........ keys.

A. Modifier
B. Function
C. Alphanumeric
D. Adjustment
E. None of these
Answer» B. Function
Discussion
12.

In Excel, the intersection of a column and a row is called

A. Cell
B. Grid
C. Table
D. Box
E. None of the above
Answer» B. Grid
Discussion
13.

Which of the following characteristics is used to compute dynamically the results from Excel data ?

A. Goto
B. Table
C. Chart
D. Diagram
E. Formula and function
Answer» F.
Discussion
14.

MS-Excel is used for

A. letter writing
B. spreadsheet calculation
C. presentation
D. painting
E. None of the above
Answer» C. presentation
Discussion
15.

Which of the following software applications would be the most appropriate for performing numerical and statistical calculations ?

A. Database
B. Document processor
C. Graphics package
D. Spreadsheet
E. Power Point
Answer» E. Power Point
Discussion
16.

The file responsible for starting MS-Excel is

A. MS.Excel
B. MS.exe
C. Excel.exe
D. Excel.com
E. None of these
Answer» D. Excel.com
Discussion
17.

Which of the following is an active cell in Excel ?

A. Current cell
B. Formula
C. Range
D. Cell address
E. None of these
Answer» B. Formula
Discussion
18.

A worksheet is made of columns and rows, wherein

A. columns run horizontally and rows run vertically
B. columns run vertically and rows run horizontally
C. the run is dependent on the application being used
D. Both '2' and '3'
E. None of the above
Answer» C. the run is dependent on the application being used
Discussion
19.

In Excel, ....... allows users to bring together copies of workbooks that other users gave worked on independently.

A. copying
B. merging
C. pasting
D. compiling
E. None of these
Answer» C. pasting
Discussion
20.

What does an electronic spreadsheet consist of ?

A. Rows
B. Columns
C. Cells
D. All of these
E. None of these
Answer» E. None of these
Discussion
21.

Which software helps you carry out tasks, such as typing a document or creating a spreadsheet ?

A. System
B. Application
C. Utility
D. Operating
E. None of these
Answer» C. Utility
Discussion
22.

How are the data organised in a spreadsheet ?

A. Lines and spaces
B. Layers and planes
C. Height and width
D. Rows and columns
E. None of these
Answer» E. None of these
Discussion
23.

The default view in Excel is ............. view.

A. Work
B. Auto
C. Normal
D. Roman
E. None of these
Answer» D. Roman
Discussion
24.

A ........ is rectangular grid of rows and columns used to enter data.

A. cell
B. workspace
C. Worksheet
D. spreadsheet
E. Both '3' and '4'
Answer» F.
Discussion
25.

Which among the following is not such an operation which can be carried out on objects in graphic program ?

A. Spell check
B. Change size
C. Move
D. Delete
E. None of these
Answer» F.
Discussion
26.

To find the paste special option, or use the clipboard group on the .......... tab of PowerPoint.

A. Design
B. Slide show
C. Page layout
D. Insert
E. `None of these
Answer» F.
Discussion
27.

Word offers certain ways in which user can move around in a document

A. By scrolling
B. By moving to a specific page
C. Directly to first and last page
D. All '1' , '2' and '3'
E. None of the above
Answer» E. None of the above
Discussion
28.

In PowerPoint, the Header and Footer button can be found on the Insert tab in which group ?

A. Illustration group
B. Object group
C. Insert group
D. Tables group
E. None of the above
Answer» F.
Discussion
29.

Which is the short key to invoke the spell checker in MS-Access ?

A. F2
B. F7
C. Alt+F7
D. F3
E. None of these
Answer» C. Alt+F7
Discussion
30.

Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides ?

A. Slider sorter
B. Slide show
C. Slide master
D. Notes page
E. Slide design
Answer» B. Slide show
Discussion
31.

Which of the following will you use as an option for saving a file ?

A. Save button on Standard toolbar
B. Save option from File menu
C. Pressing Ctrl + S
D. All of the above
E. None of the above
Answer» E. None of the above
Discussion
32.

Alignment buttons are available on which toolbar ?

A. Status
B. Standard
C. Formatting
D. All of these
E. None of these
Answer» E. None of these
Discussion
33.

Alignment buttons are available on which toolbar

A. Status
B. Standard
C. Formatting
D. All of these
E. None of these
Answer» D. All of these
Discussion
34.

We can't make query by insert menu ?

A. True
B. False
C. Can't say
D. Sometimes
E. None of the above
Answer» B. False
Discussion
35.

A template is a

A. pattern of worksheet
B. heading
C. title
D. theme
E. None of the above
Answer» B. heading
Discussion
36.

Which of the following controls the format and placement of the titles and texts you on slides, as well as, background items and graphics you want to appear on every slide ?

A. Slide
B. Copyright
C. Layout
D. Design
E. None of these
Answer» D. Design
Discussion
37.

It is a software tool that lets one enter, calculate, mainpulate set of numbers

A. speedsheet
B. spreadsheet
C. slide sheet
D. All of these
E. None of these
Answer» C. slide sheet
Discussion
38.

Which option will we use to give heading in the form ?

A. Label
B. Text box
C. Option group
D. Insert
E. None of these
Answer» B. Text box
Discussion
39.

Selecting Portrait changes our page from

A. a wide to tall orientation
B. a tall to wide orientation
C. a normal font size to a condensed one
D. a condensed font size to a normal one
E. None of the above
Answer» B. a tall to wide orientation
Discussion
40.

This is to insert an object, which is not miss print to its originating document into a destination document ?

A. Cell
B. Embed
C. Defaults
D. Any of the above
E. None of the above
Answer» C. Defaults
Discussion
41.

Which one is the example of spreadsheet package ?

A. Visicalc
B. Unity
C. Ada
D. Snowball
E. None of these
Answer» E. None of these
Discussion
42.

Insert date, format page number and insert auto text are buttons on the ........ toolbar.

A. formatting
B. header and footer
C. standard
D. edit
E. None of these
Answer» B. header and footer
Discussion
43.

=Sum (B1 : B10) is an example of a

A. function
B. formula
C. cell address
D. value
E. None of these
Answer» C. cell address
Discussion
44.

All of the following terms are related to spreadsheet software except

A. worksheet
B. cell
C. formula
D. virus detection
E. None of these
Answer» E. None of these
Discussion
45.

You can add any picture in your document from which menu ?

A. File
B. Edit
C. Insert
D. Format
E. View
Answer» D. Format
Discussion
46.

Excel worksheet data can be shared with Word document by

A. inserting an Excel file into Word
B. copy and paste Excel worksheet into Word document
C. link Excel data in a Word document
D. All of the above
E. None of the above
Answer» E. None of the above
Discussion
47.

Magnifier button is available on

A. Print Preview Toolbar
B. Standard Toolbar
C. Formatting Toolbar
D. Both '1' and '2'
E. None of the above
Answer» B. Standard Toolbar
Discussion
48.

Which of the following commands in office 2007, can be used to go to the first cell in the current row ?

A. Tab
B. Shift + Tab
C. Esc + Home
D. Shift + Home
E. Home
Answer» E. Home
Discussion
49.

=Sum(B1 :B1) is an example of a

A. Function
B. Cell address
C. Formula
D. Value
E. Other than those given as options
Answer» D. Value
Discussion
50.

When cutting and pasting, the item cut is temporarily stored in the

A. dashboard
B. ROM
C. Hard drive
D. Diskette
E. Clipboard
Answer» F.
Discussion