MS Excel mcq Questions and Answer | Microsoft Excel-9

Last updated on December 8, 2021
1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-9

excel-9

Question 1
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in...............
A
(1) ascending order
B
(2) descending order
C
(3) alphabetical order
D
(4) random order
Question 2
. In order to perfo rm a calculation in a spreadsheet, youneed to use a:
A
(1) table
B
(2) formula
C
(3) field
D
(4) variable
Question 3
The box on the chart that contains the name of each Individual record Is called the__.
A
(1) cell
B
(2) title
C
(3) axis
D
4) legend
Question 4
. If you want all of the white cats grouped together In the database, you need to sort by__.
A
(1) Color, then Gender
B
(2) Pet Type, then Col or
C
(3) Pet Type, then Gender
D
(4) Color, then Pet Name
Question 5
You accidentally erased a record In the sheet, What command can be used to restore It Immediately?
A
(1) Insert
B
(2) Copy
C
(3) Undo
D
(4) Replace
Question 6
Where a row and a column meet, what do you call that?
A
(1) A eel I
B
(2) A block
C
(3) A box
D
(4) None of the above
Question 7
How do you tell one cell from another?
A
1) By numbers
B
(2) By letters
C
(3) By its address
D
(4) by color
Question 8
. Give me an example of a cell address.
A
(1) 1125
B
(2) 911
C
(3) 41A
D
(4) A21
Question 9
Which Is an example of a formula?
A
(1) =A1+A2
B
(2) =add(AI:A2)
C
(3) A1+A2
D
(4) SUM{A1:A2)
Question 10
Which is an example of a function?
A
(1) =add(AI:A2)
B
(2) =A1+A2
C
(3) »SUM(A1:A2)
D
(4) A1+A2
Question 11
What la the symbol for multiplying?
A
(1) >
B
(2) /
C
(3) !
D
(4) *
Question 12
What Is the symbol for dividing?
A
(1) /
B
(2)=%
C
(3) &
D
(4) fl
Question 13
All formula In Excel start with
A
(1) .>
B
(2) +
C
(3) =
D
(4)
Question 14
You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?
A
(1) & (ampersand)
B
(2) = (equal sign)
C
(3) (space)
D
(4) All of the above
Question 15
Two common wildcard characters that Excel recognizes are
A
(1) * and?
B
(2) < and >
C
(3) * and /
D
(4) + and –
Question 16
The divide symbol is
A
(1) /
B
(2) D
C
(3) \
D
(4) )
Question 17
The multiplication arithmetic operator Is represented by which of the following symbols?
A
(1) a
B
(2) *
C
(3) /
D
(4) X
Question 18
To add two cells (Al and A(2) together you use the following formula
A
(1) =A1 + A2
B
2) =Add(AI+A(2)
C
(3) together (A 1:A(2)
D
(4) AlplusA2
Question 19
To make a number In cell Cl 10% smaller than the number In C3 you enter
A
(1) -03*1.10
B
(2) +C3*110
C
(3) -C3%10
D
(4) -C3*.90
Question 20
On an excel sheet the active cell In Indicated by...
A
(1) A dark wide boarder
B
(2) A dotted border
C
(3) A blinking border
D
(4) None of above
Question 21
On an Excel sheet the active cell in indicated by
A
(1) A dark wide border
B
(2) A dotted border
C
(3) A blinking border
D
(4) None of above
Question 22
Using the Fl 1 shortcut key to create a chart on chart sheet creates
A
(1) A default chart
B
(2) A 2-dimensional column chart
C
(3) A 2-dimensional bar chart
D
(4) A 3-dimensional line chart
Question 23
You can print
A
(1) A range of cells by range name
B
(2) An entire worksheet
C
(3) A single worksheet
D
(4) All of the above
Question 24
. You can create only a horizontal page break by first selecting
A
(1) A row below the row where you want the page break to occure
B
(2) A cell in row 1
C
(3) A cell in column A
D
(4) a and c
Question 25
You can create hyperlinks from the Excel workbook to
A
(1) A webpage on company internet
B
(2) A web page on the internet
C
(3) Other Office 97 application documents
D
(4) All
Question 26
The cell reference fro a range of cells that starts in cell Bl and goes over to column G and down to row lOis......
A
(1) DB1-G10
B
(2) B1.G10
C
(3) B1;G10
D
(4) B1:G10
Question 27
The advantage of using a spreadsheet is :
A
(1) calculations can be done automatically
B
(2) changing data automatically updates calculations
C
(3) more flexibility
D
(4) all of the above
Question 28
The intersection of a row and column is called :
A
(1) data
B
(2) afield
C
(3) a cell
D
(4) an equation
Question 29
There are three types of data found in a spreadsheet
A
(1) data, words, numbers
B
(2) equations, data, numbers
C
(3) words, numbers, labels
D
(4) numbers formulas, labels
Question 30
To select a column the easiest method is to........
A
(1) Double click any cell in the column
B
(2) Drag from the top cell in the column to the last cell in the column
C
(3) click the column heading
D
(4) click the column label
Question 31
To select a column the easiest method is to........
A
(1) Double click any cell in the column
B
(2) Drag from the top cell in the column to the last cell in the column
C
(3) click the column heading
D
(4) click the column label
Question 32
If you press...... the cell accepts your typing as its contents.
A
(1) Enter
B
(2) Ctrl+Enter
C
(3) Tab
D
(4) Insert
Question 33
which of the following special function keys allow the content in cell
A
(1) esc
B
(2) shift
C
(3) return
D
(4) Tab
Question 34
Which is not an advantage of using computerized spread sheets?
A
(1) flexibility of moving entries
B
(2) speed of calculation
C
(3) ability of generate tables
D
(4) cost of initial setup
Question 35
To select several cells or ranges that are not touching each other, you would ... while selecting
A
(1) hold down the Ctrl key
B
(2) hold down the Shift key
C
(3) hold down the Alt key
D
(4) hold down Ctrl + Shin key
Question 36
A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button......
A
(1) nothing will print because some cells with data have been omitted
B
2) only the cells with gray back-ground will print
C
4) only the cells with white background will print
Question 37
. A constant is another name for this type of data:
A
(1) number
B
(2) equation
C
(3) formula
D
(4) description
Question 38
The view that puts a blue a blue line around each page that would be printed is the......
A
(1) Print Preview
B
(2) Normal View
C
(3) Page Break Preview
D
(4) Split View
Question 39
Auto Calculate will quickly add selected cells if you.......
A
(1) right click on the status bar and select Sum
B
(2) click the AutoCalculate but-ton on the toolbar
C
(3) use the key combination Ctrl+$
D
(4) Double click the selection
Question 40
The cell labeled 23. 54 the cell labeled F5 refers to
A
(1) row F column 5
B
(2) column F row 5
C
(3) function available in cells
D
(4) function key F4
There are 40 questions to complete.

Computer Gk Latest posts

Computergk.net is India's Largest Computer MCQ website where you will get about 8000+ computer MCQ objective questions for all competitive exam.

  1. Computer gk questions Class pdf, Objective questions pdf download
  2. Computer Class PDF Download
  3. Input Device of Computer GK Free PDF | Multiple Choice Questions Answer PDF, IBPS, SSC, Exam 2023
  4. Computer Languages – Example, Types, details notes with free pdf 2023

Leave a Reply

Latest Posts

Previous Story

MS Excel mcq Questions and Answer | Microsoft Excel-8

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-10

Latest from Blog

Computer Class PDF Download

In this Post we share some Important Questions that Help to your exam The _ may also be called the screen or monitor.(a) scanner(b) printer(c) hard disk(d) software(e) display The primary purpose
computer architecture

computer architecture

Computer architecture refers to the fundamental design and organization of a computer system, including the instruction set architecture (ISA), the memory architecture, and the microarchitecture. It encompasses both the hardware and software
Go toTop