Computer MCQs

Latest MCQs

What is the function of the SUM function in Excel...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find the maximum value in a range of cells

Comments
Latest MCQs

How do you freeze panes in Excel...?

(A) Home tab and go to freeze panes
(B) View he tab and go to freeze panes

(C) Review tab and go to Freeze Panes
(D) Page layout tab and go to Freeze panes

Comments
Latest MCQs

What is the keyboard shortcut to insert a SUM formula in MS Excel...?

(A) CRTL+ =
(B) ALT + =

(C) ALT + S
(D) CTRL + ALT+ =

Comments
Latest MCQs

Ctrl + D in MS Excel is used for...?

(A) Fill down in the selection
(B) Open the font dialog box

(C) Both A and B
(D) None of these

Comments
Latest MCQs

In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed Enter key ...?

(A) you will be in the cell A1
(B) you will be in the cell B5

(C) you will be in the cell B3
(D) you will be in the cell B6

Comments
Latest MCQs

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words...?

(A) TRIM
(B) SUBSTITUTE

(C) CLEAN
(D) REPT

Comments
Latest MCQs

Cell entry "July 16, 2016" will be considered a _____ by Excel sheet....?

(A) Label
(B) Value

(C) Formula
(D) Text string

Comments
Latest MCQs

The valid data type in MS Excel is _____...?

(A) Boolean
(B) Tupal

(C) Dictionary
(D) None of these

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___________...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

Which of following is not true regarding conditional formatting...?

(A) You can set condition to look for Bold and apply Italics on them
(B) You can add more than one condition to check

(C) You can apply Font, border and pattern formats that meets the specified conditions
(D) None of these

Comments

Best of Luck

From ShineGk.com

Share our website's link

Shine Test Preparation Academy

  • Profession Image

Which Profession Suits You

  • Profession Image

    Your Profession

    Only one work at a time can be best, here we provide best profession that will suit you.

Latest 1000 G.K MCQ'S

  • Gun Image

    1000+ Latest MCQS

    We are providing best mcqs for CSS exams and other compitative exams preparations


If You Are President

  • President Image

    You President

    As a president which Country suits you, MR. President.

Animal That's Match You

  • Animal Image

    Your Hero Animal

    You can check your animal qualities like bravry honesty, integrity, courage, self-awareness, and wholeheartedness.



Calculate Love With Family

  • Love Calculator Image

    Love Calculator

    You can calculate love with your life partner, family members, friends and other relitives.

If You Have A Government

  • Govt Image

    Your Government

    Check your Government team and You Can Rule On the World With this Squid.


Which Car Suits You

  • Car Image

    Your Car

    Different cars available in the world but Which car suits your Personality.